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.