FMS Auto populate

[former_member229757]

Hi Friends

I have created UDF fields in SAles order screen.

Sales order quantity have to Auto populate in that UDF field through FMS

How to acheive that.

Thanks

vinoth

[Johan_H]

Hi Vinoth,

Please use this query in your FMS:

SELECT ISNULL(SUM(r.Quantity), 0)
FROM RDR1 r
     INNER JOIN ORDR h ON r.DocEntry = h.DocEntry
     INNER JOIN OITM i ON r.ItemCode = r.ItemCode
WHERE h.DocNum = $[ORDR.DocNum]
  AND ISNULL(i.InvntItem, 'N') = 'Y'

I recommend using Auto Refresh When Field Changes, with Document Total, and Refresh regularly

Regards,
Johan

[former_member229757]

Hi,

Thanks for providing query

Its not updating the quantity in UDF fields.

I did all the changes what u have mentioned.

[Johan_H]

Hi,

Did you set the FMS in the UDF or in the quantity field?

Regards,

Johan

[former_member229757]

Hi,

I have assigned FMS in UDF field

[former_member229757]

Hi

can u please provide the solution if any possible

Thanks

vinoth

[Johan_H]

Hi Vinoth,

Please perform the following test:

1. Create a new sales order, but do not add it.
2. Add some items and quantities. Make sure at least one of the items is a stock item.
3. Go to tools > queries > user queries > where you saved the query, and run the FMS query from there.
4. Does the query show the sum of the quantities of the stock items?

Regards,

Johan

[former_member229757]

Hi Johan,

Thanks for the steps

I did all the steps.Its not working.

Thanks

vinoth

[Johan_H]

Hi Vinoth,

I am sorry, I just realized that you can't show line data in the header with FMS.

You can take a look at Boyum's B1UP addon, it contains a lot of features, and maybe it allows this kind of FMS.

Otherwise you will have to look into building your own addon, or you may have to consider an entirely different solution.

Regards,

Johan

[former_member229757]

Hi John

We are using Boyum add-on. Please guide me how it helps.

Thanks

Vinoth

[Johan_H]

Hi Vinoth,

I am not very familiar with the B1UP addon. You better contact Boyum directly.

Regards,

Johan

[kothandaraman_nagarajan]

Hi,

UDF created in sales order row level or header level?

Do you want to display stock in that UDF?

Regards,

Nagarajan

[former_member229757]

Hi

UDF Created in header level.

Few of the item groups i don't want to calculate the qty field

eg:

t6.ItmsGrpCod NOT IN (100,108,109,110,116,131,132,133,134,136,137,139,140,141)

Is it clear if not please tell me

[Johan_H]

Hi Vinoth,

What value do you want to populate the quantity column with?

Regards,

Johan

[former_member229757]

Hi

In RDR1 table 3 to 4 line we are entering line items

we need specifically stock item quantity has to populate in that particular UDF

[Johan_H]

Hi,

I am still not entirely sure what you mean. Could you please post a screenshot of your UDF, and a screenshot of the specific stock item quantity that you want to populate the UDF with?

Regards,

Johan

[former_member229757]

Hi,

Please find the attachment of screenshot for reference.

[Johan_H]

Hi,

Okay, so the UDF is on the header level, and in that UDF you want to show the quantity from the row level?

In your example there are 4 lines. How should the formatted search determine which line's quantity to show in the UDF? Or do you mean that it should add up the quantities of all the lines?

Regards,

Johan

[former_member229757]

Hi

My item if i selected a stock item it has to fetch in my UDF.

[Johan_H]

Okay, that is possible. What should happen when multiple lines have a stock item?

[former_member229757]

Hi

Thanks,

It has to sum of the Qty and get the result in UDF

[former_member233854]

You either put your FMS on a matrix column or you will need to save the record first than use a query in your FMS.

[former_member229757]

Hi

I have created UDF fields in sales order

my quantity fields in sales order have to come automatically in the UDF.

In my UDF i have set that particular FMS but its not triggering

[former_member312729]

Hi

Try this set auto refresh based on quantity

SELECT $[$38.11.0]

Regards:

Balaji.S

[former_member229757]

Hi

I can't able to choose auto refresh based on quantity.

Quantity option is not there

[former_member312729]

Follow the above image