Cannot get VI import into PO ROG to consolidate multiple line records for the same item code into a single matching item code record per item number.

I.E. There are 5 detail line records for item code 301061 with a quantity received total of 450.  The original PO has one line record for item 301061 with a quantity ordered total of 450.  We would like the PO ROG import to add the 5 records together and apply 450 received (5 lines at 90 received each) against this item code on the PO.

This is the VI import job:

This is what records imported into PO ROG look like before updating:

This is what PO looks like after import into PO ROG has been updated:

Cannot get VI import into PO ROG to consolidate multiple line records for the same item code into a single matching item code record per item number.

I.E. There are 5 detail line records for item code 301061 with a quantity received total of 450.  The original PO has one line record for item 301061 with a quantity ordered total of 450.  We would like the PO ROG import to add the 5 records together and apply 450 received (5 lines at 90 received each) against this item code on the PO.

This is the VI import job:

This is what records imported into PO ROG look like before updating:

This is what PO looks like after import into PO ROG has been updated:

Remove ItemCode and LineKey from the import.

Your source data has to have the PO line key, which you import into the "OrderLineKey" field in the receipt.  This will match your receipt line to the PO line.

There is no "add" function for imports.  The latest value wins.  Your source data has to do the math.  VI can't do a total like you're suggesting.

Watch for PO lines not referenced in the file / receipt.  Backorder quantities for those lines will not be set properly after posting.

You need to have the fields on the right in the same order as the fields on the left which you do not.