Money leaves bank but is fully refunded by supplier.
Ok, bank can be matched off against each other easily enough eradicating that.
Unfullfilled Purchase order exists so should you not raise a credit note against it (type PCR rather than PIN) which will effectively wipe it out.
All that you do to raise the credit note is click on the purchase invoice to be annulled, bottom left of the screen there's the raise credit note link, click on that, ensure that the dates correct and press enter. Sorted. Not even any amounts to input and the comments are taken care of for you.
Back to the other issue.
Whats causing you grief with the final accounts?
How far have you got with it?
Talk me through what your doing and I'll tell you where your going wrong.
... As a quickie, just to get the obvious one out of the way, you do realise that you can't be editing the file in VT Transaction+ when you attempt to do the import into Excel don't you?
Talk in a bit,
Shaun.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
After reading your reply I've realised that I'm not answering the question asked but thinking about a somewhat different scenario and in the case described using reversals one would need to reverse both the Payment and the Purchase Invoice.
Doh, I'm really having an off day today!
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
I am very impressed with VT so far and all difficulties seem to have been of my own making.
I have imported a CSV file from transaction+ into Accounts Production but no figure work flowed though. As this was past midnight last night I am fairly sure the problem is with me.
I then used the manual method and all was well and accounts were produced as I would expect.
I will try the import method again and post the results tomorrow for assistance ( or applause ?) if necessary.
Pick the type of business and click the stored in VT Transaction+ button
Click Ok
If it doesn't come up immediately click the properties toolbar icon (white box with a P just outside the upper left corner... Its the second icon along).
Enter the basic details (company name, number, tax district, start of period (other three fields completed automatically on tab))
Click OK
Click the button marked with VT in the bottom right corner with a red arrow pointig to a document icon (its the 8th icon along).
That should have the get balances from an existing workbook option selected.
Click continue
You will be asked to save the document before continuing
Once saved a pop up will ask you what workbook that you want to associate the accounts with, click the appropriate .VTR file and press OK
Make sure that update comparatives is ticked
Click OK
You have your full set of properly formatted accounts directly from VT Transaction+ without any manual intervention.
HTH,
Shaun.
p.s. edited just for spelling so bad that even I could spot it!
-- Edited by Shamus on Tuesday 24th of February 2015 07:04:01 PM
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
I must admit to being very old school in that i still do manual accounts and then use software to check / file etc.
My excuse is that there were no software or desktop PCs when i trained.....
I was one of the first when training to buy a calculator with a roll of thermal paper
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
