Calc Consumption

Soumyadip

In consumption journal form there is a function calc. consumption. Its opening a report.
In the second tab of the report (Prod.Order Componnent) we select itmes to be consumed.
but here list of all item is coming rather than list of items under that prod order order(means item that are in BOM should come here).
how can i make it happen.

thank you
soumya

ebrahma

Hi,

This you can acheive through coding. Simply change the lookup to Prod.BOM component lines. That's all!

Good luck

Soumyadip

hi
but hw to change the look up. means where to write the code & what code to write
soumya

NaviTools.com

Following TableRelation for "Prod. Order Component".Item could solve your request:

"Prod. Order Line"."Item No." WHERE (Status=FIELD(Status),Prod. Order No.=FIELD(Prod. Order No.))

but a change to primary key in "Prod. Order Line" would be needed. This is not possible.

You could add code to 'OnLookup' trigger. Do you have access to "Prod. Order Component".Item OnLookup trigger? You could use 'Prod. Order Line List' form for selecting items.