I've just been sorting our bank & as part of it paid a load of invoices/credit notes which had been paid by BACS. I then realised that I'd made a mistake & so deleted the action thinking that it would show the invoices & credit notes which the payment was for as outstanding & I could just pay them again. Big mistake. It now shows that some of the invoices have been cancelled out by credit notes which I hadn't dealt with at that point & so now the account looks like crap & it's going to be a nightmare to sort. Someone please tell me there's a way to undo deleting the payment.
<Edited to add: I'm using Sage 50 Accounts 2008>
Thanks all
Kev
-- Edited by KevMc on Tuesday 21st of May 2013 01:19:20 PM
I'm gutted to say that hasn't worked. The invoices still aren't outstanding & when I look at the details the only thing that has changed is that instead of having the reference of the credit notes listed in the debit part it has the reference of the invoice itself.
I've attached screen-dumps of before & after which hopefully explain things better than I can.
Before
After
-- Edited by KevMc on Wednesday 22nd of May 2013 10:50:47 AM
I'm not sure I understand - neither the "before" nor the "after" screenshots show invoices referencing themselves, and to confuse me further, it's a different invoice you've selected in both.
In both cases, the allocations are against credit notes - transactions 31471 to 31474 in the first image (the invoice with ref p23224, transaction 31466), and transactions 31469 to 31471 in the second image (the invoice with ref p23222, transaction 31464).
In case I wasn't clear, the transactions you need to fiddle with as described, which *should* cause those invoices to be de-allocated (and does here when I throw some dummy data into Sage**), are those credit transactions: 31469 to 31474. In other words, starting with 31469, but repeating for all of them, go into File Maintenance => Corrections, and carry out the following steps:
Find transaction 31469 and double click on it
Change the supplier account to a different one
Save the modified transaction
Double click on the transaction again.
Change the supplier account back to the original.
Save the modified transaction.
Step 3 is vital. You must save the transaction before changing it back, otherwise you will have made no changes. You can add a step 3b at this stage if you like, where step 3b involves calling up the supplier ledger and going to the account you are trying to fix. Transaction 31469 should no longer be on the account because it's now on another one, where it will be until you carry out steps 4 to 6, and transaction 31464 (the invoice) will have £65.34 outstanding on it.
The reason it works is because Sage will not allow credits on one supplier account to be allocated against debits on a different one (and the same applies to the sales ledger) - so the moment you save the modified transaction with a different supplier code, the allocations are removed. And when you modify the transaction to put it back on the proper account, Sage doesn't create the allocations again because it doesn't know how you are going to allocate it.
** You are using an older version than me, but AFAICR, this method did work in your version.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Bingo, that's worked like a dream. It's basically what I was doing earlier as suggested but changing the reference (the p3222 etc number I give the invoices) didn't fix it whereas changing the supplier account does.
Apologies for the pictures being of different invoices, I didn't plan for it not working so I posted a picture of 1 invoice which I'd made changes to & the final 1 which I hadn't in a vain attempt to help my description. Ever tried to describe something you're not sure about? It's a nightmare so sorry about that too.
Thanks very much for the help Vince, I can crack on now
