Skip to Content
0
Jul 16, 2019 at 05:47 PM

FMS in the Qty field for a BOM in AR Invoice

104 Views

Dear SAP B1 forumers,

I want to implement the following issue. Automatically let the parent quantity equals the child quantity in the field Qty in AR invoice for a production BOM.

Parent items A (10) B (5)

Childs items A1 (10) B1 (5)

A2 (10) B2 (5)

A3 (10) B3 (5)

In parenthesis, the quantity of each item. I want those quantities to be displayed automatically in the qty field in the AR invoice form when the user inserts a parent item.

I tried the following:

  • Create a header UDF in AR invoice form.
  • With the FSM, display the qty of a parent item into that UDF

SELECT $[$38.11.Number]

FROM INV1

WHERE LineNum=0

  • Link the Qty field to that FMS in order to display the parent qty into the child item qty: work perfectly.

SELECT $[$U_QTE_ASUP.0.Number]

FROM OINV

The problem is that the method works perfectly if the invoice has one parent tem (1 BOM) but failed to insert the values of several BOM (it repeats the line0 qty).

Hope my explanations are understandable. Please how can I achieve this issue? Any help would be highly appreciated. Thanks in advance.