SageForum for UK versions of Sage 50- Help and support.

I am trying to import come 'Cash' journals from a feeder system via the Audit trail transactions import.

I am putting VAT codes and amounts under the relevant tax columns, but they aren't getting posted as i would expect, only the net amounts are appearing in the nominal.

Should it work what I am doing ? Is there something in the setup that I haven't done ?

Thanks

Can you cut and paste the csv into a reply so we can see what you are doing?

Bruce - thinking about it further, I realised that it was correct that journals shouldn't impact on VAT postings, and thus the VAT returns as it could be double counting the income. What I do need to to is to import them as a "Sales Invoice" or similar, perhaps into a dummy account. I think I have worked out where to head on this one :¬)

I may be back.......

Further to this, I am trying to upload some "Audit Trail Transactions" for prior year data - all of the nominal codes are departments are set up, but when I import it ignores all of the departments and puts it all to the default department - any ideas ?

I am using JC and JD journal types:-

JC,,58996,100,01/04/2007,Import,2006/7,actuals,366214.15,T2