Importing

Importing

Didn't find your answer?

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.

avatar
By chrisdxuk
24th Feb 2013 20:13

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.

Thanks (0)
Replying to DMGbus:
avatar
By johndon68
25th Feb 2013 16:56

Importing Bank Transactions

chrisdxuk wrote:
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

 

 

Thanks (0)
avatar
By User deleted
24th Feb 2013 20:48

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.

Thanks (0)
avatar
By kanyombe
24th Feb 2013 23:45

Thanx Chrisdxuk and Sally20. Will try ur advise right away.

Thanks (0)
avatar
By kanyombe
25th Feb 2013 23:57

 

 

To give you a clear picture guys, the following is the part of the attachement I want to import to Sage, but it has still failed. How should I arrange it? In my COA, nominal 1200 is the nominal for my current a/c and 1215 is for the a/c where I want to take the transactions. Thank you all for your responses guys. Will be glad to get a solution. JP.

 

PIFOOT7601728/01/2011100T91KennethBR12154602402/05/201224.2T91KennethBR12154602402/05/201232.15T91KennethBR12154602404/05/201246.8T91KennethBR12154602408/05/201220.65T91Kenneth

 

Thanks (0)
avatar
By johndon68
26th Feb 2013 08:05

Bank Account

Just to confirm, 1215 is set up as a bank account in Sage?

John

Thanks (0)
avatar
By johndon68
26th Feb 2013 08:11

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

Thanks (0)
avatar
By kanyombe
27th Feb 2013 11:36

Thank you very much John.
 

Thank you very much John.

 

Thanks (0)
avatar
By kanyombe
27th Feb 2013 15:12

Hello John, am coming to you again. What should be the content of these missing two columns please? Also to confirm to you, 1215 is set as a bank account in my Sage and the lines above are from a CSV saved file.

Thanks (0)
avatar
By johndon68
27th Feb 2013 15:52

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

 

 

Thanks (0)
avatar
By cmdaccy
28th Feb 2013 11:35

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"?

Thanks (0)
avatar
By hsr1012
28th Feb 2013 12:22

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

Thanks (0)
avatar
By kanyombe
05th Mar 2013 14:35

Thanx you very much guys for your advise. I followed it and I finally did it. 

JP Kanyombe

Thanks (0)