I have tried countless times to use Simply's Import feature (I'm running Canada 2012 premium) for inventory records from a file formatted for Simply Accounting. The problem is, whenever I try to import a service record, it will not let me add an associated revenue account.
My test file for import is as follows:
I receive the error,
The item 1 Test 1 cannot be added because its associated revenue account is invalid.
Import item(s) completed.
When I go to my chart of accounts, account 41100 is set up as a Group account (also tried Subgroup)- Class is revenue (I also tried operating revenue).
Any help would be much appreciated - what am I doing wrong?
Note that I've also tried changing 'Service' to 'Activity', putting an inventory account number in between the preferred price and the revenue account number, as well as changing the revenue account number position to right after the preferred price number.