import error

Error in Field Mapping while import.

Our attempt to update Item CBM via CSV import of item record encountered difficulties. We are currently unable to execute the import successfully. Specifically, on the fourth step of the import procedure, a page resembling the image below appears, and I am unable to expand it to perform the mapping. Despite trying different files for… Continue reading Error in Field Mapping while import.

Please select member items before submitting

When member items are created in a separate CSV file, there needs to be a linking column: Assembly Item: External ID, Internal ID or Name. When performing the import, ensure that the following options are specified: Import Type – enter Item Record Type – enter Assembly/BOM Item Click Multiple Files to Upload For Primary File – Item,… Continue reading Please select member items before submitting

‘Invalid parent reference key’ on Item Record Import

The error occurs when the parent item being referenced is of a different item type (for example, Inventory, Description, and so on) than the item being imported. The parent item must be the same type (for example, Inventory, Non-Inventory, Description, and so on) as the items being imported. There are two ways to resolve this… Continue reading ‘Invalid parent reference key’ on Item Record Import

Error in Advanced Intercompany Journal Import

Issue – The user is doing a CSV import for intercompany journal entries but encounters this error: “Transaction was not complete. An intercompany journal entry must have at least four lines: one debit line and one credit line for each subsidiary. Debits and credits must balance within each subsidiary.” Solution – Remove zeros from the Debit and Credit columns of… Continue reading Error in Advanced Intercompany Journal Import

Solving Import Error

Error:- “Invalid item reference key 504 for subsidiary 10.” Solution:- check the item record. In the subsidiary field, add the subsidiary that you want to add for the item. Add the subsidiary under the item. Then import the file again.

When importing the files there is an error is showing. “DATE. Value : 01-01-2022. Error : Date field not in your preferred date format for field “Date”” But in the file the date format is correct. Solution:- Delete the date and reenter the same date again and save the file. The client’s account has a… Continue reading Import Error

CSV Import error – “This record has been locked by a user defined workflow”

This article summarizes the CSV import error which shows that it is the result of a workflow and also includes the reason for the error.