Prepare CSV File
Enter the minimum required fields on your file
Invoice Internal ID
Location Internal ID
Item Line ID
Note: We should use Line/Order Line as a key field. Because transactions may include multiple lines with the same Item value, using an Item as the key may cause errors resulting from duplicate Item values.
Perform CSV import
Navigation: Setup> Import/Export> Import CSV Records
Import Type: Transaction
Record Type: Invoice
Select the CSV File
Then click on Next
Import Option
Update (Because of reassigning the location of an existing invoice)
Field Mapping
Invoice Internal ID- Invoice: Internal ID
Location Internal ID- Invoice-Items: Location
Item Line ID: Invoice- Items: Order Line
Save
Note: In the case, the invoice is in the closed accounting period then the G/L impact of a transaction in a closed period cannot be changed