Nav 2013 - Grouping Purchase Invoices

Hi Team,

I have a requirement to group their line Item types together in the Purchase Invoice.

The example is that there are 2 days of Sales Orders from a Customer.

We have a vendor (Supplier) provide the items. SO’s Posted, PO’s Posted, SI’s Posted. For each individual day.

But in the Purchase Invoice to the vendor (supplier) they basically want a combined Invoice. If I create the PI and then use get receipt lines, it populates individual entries per PO. We don’t need the PO number just grouped line items by type.

Example.



Date



Purchase Order



Item Type



Volume



















20/01/2016



PO1



MBLA



120



20/01/2016



PO1



MBLA+



360



21/01/2016



PO2



MBLA



120



21/01/2016



PO2



MBLA+



240

On their Purchase Invoice they need the following reported.



Description



Quantity



Unit Price



Amount



MBLA



240



15



3600



MBLA+



600



20



12000

Appreciate your help.