Skip to Content
0
Former Member
Jul 31, 2012 at 09:34 AM

Query report field update with code

85 Views

I'm working on a report with table join VBRP & VBRK where main table is VBRP.

My goal to build a report to check Sales Order Item Qty compare with that SO/Item's billed Qty.

I can get billed qty from VBRP-FKLMG and also that Sales order's item qty available in VBRP-LMENG field.

Now the problem is, VBRP-FKLMG as increasing more than single line because of multiple billing, VBRP-LMENG also duplicates for what my report getting incorrect.

Now what can I do for not to repeat the Sales Order Item line Qty in VBRP-LMENG.

Please advice. Many thanks in advance.