Skip to Content
0
Former Member
Jan 12, 2012 at 05:19 AM

Query Help.

24 Views

Dear Expert,

I need one query help from you.

I have Item group is Packing Material (Group code is118)

Now I want I query base report receipts and issue qty (Document covered-GRPo/Issue to Production & Goods issue)

Exp: in One GRN if I received two or there packing material item (Group u2013Packing material) so need sum of qty of packing material qty.

And in goods issue same sum of packing material sum qty.

Query column as follows.

Date of receipts/Supplier name /doc num/ Receipts qty/date of issue /Doc Num /issue qty.

Regards

MANGESH PAGDHARE