Skip to Content
0

FMS Auto populate

Jul 12, 2017 at 09:43 AM

177

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Balaji Selvaraj Jul 12, 2017 at 11:24 AM
0

Hi

Try this set auto refresh based on quantity

SELECT $[$38.11.0]

Regards:

Balaji.S

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi

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

Quantity option is not there

0

Follow the above image

fms.jpg (9.2 kB)
0
Danilo Kasparian Jul 12, 2017 at 03:35 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Johan Hakkesteegt Jul 13, 2017 at 06:14 AM
0

Hi Vinoth,

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

Regards,

Johan

Show 7 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

0

Hi,

Please find the attachment of screenshot for reference.

capture.png (71.5 kB)
0

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

0

Hi

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

1.png (27.4 kB)
0

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

0

Hi

Thanks,

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

0
Nagarajan K Jul 14, 2017 at 01:02 PM
0

Hi,

UDF created in sales order row level or header level?

Do you want to display stock in that UDF?

Regards,

Nagarajan

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Johan Hakkesteegt Jul 18, 2017 at 06:17 AM
0

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

Show 9 Share
10 |10000 characters needed characters left characters exceeded

Hi,

Thanks for providing query

Its not updating the quantity in UDF fields.

I did all the changes what u have mentioned.

0

Hi,

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

Regards,

Johan

0

Hi,

I have assigned FMS in UDF field

0

Hi

can u please provide the solution if any possible

Thanks

vinoth

0

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

0

Hi Johan,

Thanks for the steps

I did all the steps.Its not working.

Thanks

vinoth

0

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

0
Show more comments

Hi Vinoth,

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

Regards,

Johan

1