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.