Show Qty group by unit of measure in report

sharadsharad Member Posts: 112
Hi Friends
I am making a Report in classic client and i want to show qty group by unit of measure like "1 Nos. , 10 Kgs." from sales invoice line. please help me how can i achieve this.


Thanks
Sharad Gupta
Navision Technical Consultant & .Net Developer

Comments

  • BernardJBernardJ Member Posts: 57
    For this you'll need to create a key with "Unit of Measure Code" right after the "Document No.".
    Then on the report make use of the GroupTotalFields (Unit of Measure) and TotalFields (i.e. Amount) properties. Use a global variable to keep track of the count if needed.
    Read the online help on GroupTotalFields for more info

    Regards
Sign In or Register to comment.