I am trying to import a few thousand invoices - some of the items on these invoices have nominal codes in the Assets and Liabilities range (0001 - 2999) i.e. deposits from customers, charity contributions. These are being rejected by the wizard [ 0001 is not a valid nominal code]. Also, some are refunds and hence have a negative gross total amount (i.e. a credit) - these too are being rejected [Total gross amount should be a positive value].
Hello @samppatel
Has this nominal code been enabled for a sales invoice? For example, if you manually create a sales invoice, can you select this nominal there?
If you can’t, then it would need to be enabled in the Chart of Accounts by clicking on the little cog next to it.
How is 0001 being saved in the CSV file? Some spreadsheet packages will remove the preceding zeros. If it has removed them, try adding them in so you have the full number. If it hasn’t removed them, maybe try just 1
Credit notes are a little more complex as there are more variables - what should happen to the refunded amount? What bank account should it be refunded to? For this reason, they’re not currently supported by the importer.
Are you simply importing historic data? If so, it’s likely to be easier to set up opening balances instead.
Yes the nominal code been enabled for a sales invoices as we use these codes for new invoices.
With regards to the nominal code - i have tried both ‘0001’ and ‘1’ on the csv file. I check these using a text editor (notepad++) to ensure the values are exactly as I require.
Yes importing historic data as we require a historic log of client invoices for queries also.
With the 0001 nominal, how is this saved in the CSV file - 1 or 0001?
Where did the previous data come from? If it was another system for example, it’s likely to be easier to leave these as they are and use the opening balances in QuickFile.
With regards to the nominal code - i have tried both ‘0001’ and ‘1’ in the csv file. I check these using a text editor (notepad++) to ensure the values are exactly as I require. Both fail.
I’ll send you a private message to take a look into this for you. Please look for a green notification in the top right hand corner.
@samppatel - This should now be resolved. Please let us know if you have any further issues with this.
The upload is still not working. The sales nominal code ‘0001’ or ‘1’ are not being accepted.
I am trying to import the test csv file I sent.
Apologies - I’m one step ahead of myself. It’s just pending some final testing and will go live this afternoon. I’ll let you know here when this has gone live.
This topic was automatically closed after 7 days. New replies are no longer allowed.