I am importing about 600 Purchase Orders with about 1500 line items from GP. These are POs that have been received in GP with Landed Costs.
While I am able to import the Purchase Header and Purchase Line records, I am unable to successfully import the related Item Charge Assignments for the Landed Costs. The data looks correct before import, but the Config Package throws errors and appears to ignore the assignment and allocation of the Charge (Item) Purchase Lines.
When I review the records in the Config Package, they all look correct. There are no errors detected. But after I apply the package, I get this error:
Applies-to Doc. Line No. must have a value in Item Charge Assignment (Purch): Document Type=Order, Document No.=PO009978, Document Line No.=20000, Line No.=10000. It cannot be zero or empty.
The Applies-to Doc. Line No. field has the correct value in the Excel file (and also is there when I review the imported Config Package records, but somehow disappears when applying.
What am I missing with importing these Item Charge Assignments? Is it possible to import them, or do I have to manually assign 600 POs?