I have been asked by the Finance team to import budget data into X3 from several CSV files they have created. I am using a slightly modified BUD import template and am able to verify that it is matching all of the data to the right fields using the Test function on the import screen. When I run the import for real, I receive the error below.
Record No. 1 (Line Number 1)
1 Error 1 P18 C01 18 1 3001 110 11 => ACC 3001 : Accounts : 3001\Record does not exist
I have verified that the account numbers exist in the system by successfully creating an individual entry using the account number with the Budget Entry Screen.
I have tried putting the account number in double quotes ("3001"), putting the account number in single quotes ('3001') and leaving it plain (3001).
I have checked the setup of P18 in the Budget Setup Screen and have checked the account setup for 3001.
I you need any more information, let me know and thank you for your help.
Paul