Hi everyone. I am a bit new to sage, and I am trying to Import Audit Trial Transactions (BRs in particular). However I am getting an error message; "Error in field2 Invalid Account Number". In my field2, I have the nominal for the Account number ie nominal 1215. Hope someone can help. thanx. JP
Replies (13)
Please login or register to join the discussion.
importing bank receipts
Sage doesn't like importing bank data. Tried it my self and got same message. Possible solution is to code as SC item and put BR in a separate column when importing so you know which is a bank receipt and which is true credit note for Vat purposes.
Importing Bank Transactions
Sage doesn't like importing bank data.
It is only SR and PP bank transactions that cannot be imported - there is nothing to stop BR (as per the original question) & BP transactions being imported...
John
Importing Bank Receipts
I take it that you do actually have a nominal code 1215 set upon your Sage? If so then try changing all the BR's to nominal code 1200. Once imported you can do a bulk transfer from NC1200 to NC1215. Sage will not import sales on account or payments on account. So chrisdxuk's idea will work. You will only have VAT issue's if you are operating cash accounting.
Import Format
You may, of course, not have them mapped but, assuming you are using the standard import format and the lines you posted above are from the CSV file then you are missing 2 columns - Details and Reference between the date and net amount columns.
Allowing for that then the lines you've posted import without any problems form me as long as 1215 is marked as a bank account.
John
Importing Bank Transactions
The 2 columns can be anything you want but, assuming you are using the standard Sage import format they can be blank so the line in your file could look like this:
BR,1215,4602,4,08/05/2012,,,20.65,T9,0,1,Kenneth
What is important is the format you are using for the import - when you go through the import routine, what does the Field Mappings screen look like, assuming the standard import format it should shows A-H in the Imported Field column.
John
What line is the error on?
Not sure if you had already sorted this, if you have then ignore the comments below!
What line does Sage say the error is on? You've got a Purchase invoice in there as well as BR's. If the error is on Line 1, have you got a supplier set up under the reference "FOOT"?
Not sure if ...
You have resolved this yet but the error will depend on the line. If it is line 1 check you have a supplier account for FOOT as you say account 1215 exists.
PM as I have a full list of import formats for sage if you would like them.
Helen