First Previous - Page 1 of 1 - Next Last

The inflexibility of Sage

  • Fellow PM.Dip
  • Practice Licence
  • 336 posts
  • # 77126

I have realised to my cost how inflexible Sage is.   Yesterday I discovered that one of a new client's supplier accounts was wrong and I tried to use the 'write off transaction' function to delete an old outstanding balance.  Unfortunately Sage 50 obviously differs from Sage Instants as it wrote off all of the outstanding transactions and not just the one that I thought I had highlighted. I realised too late that I had not taken a back up before I did the journal and afterwards I could not alter the journal as Sage came up with an error message about not being able to alter the transaction because the transaction had been marked as reversed.

I have re-entered the outstanding balance as an invoice on the supplier account so that it still shows as a balance outstanding, but in the long term I realise that this does not resolve the error because the value of the journal correction is still sat incorrectly in bad debt. 

Can someone please advise me how to make the correction.

I was thinking along the line of a journal to cr bank (at the same time as I pay the supplier), and dr bad debt, and then delete the newly created invoice on the supplier account.  That way the supplier account will show a nil balance, the bank account will be reduced by the appropriate amount, and the bad debt will be reduced to the right amount.

Would this be correct?

Needless to say I have learnt several important lessons from this....! 

  • 88 posts
  • # 77137

Hi, By write off are you referring to bad debt write off. Did you use the write off wizard which gave you 4 different scenarios? Write off accounts- Write off transactions- Write off transactions below a value and write off small overpayments. 
As long as didn't clear the audit trail you should be able to recover the data back. To deactivate the reversing journals feature....... settings- company preferences- parameters- tab down to enable reversing jounals and deselect the tick box. Then  file.. maintenance.

Tim 

  • Fellow PM.Dip
  • Practice Licence
  • 336 posts
  • # 77138

Hi Timm

Thanks for your answer - I'm away from my client's office today but I'll try the deactivation method next time.

By write off I meant that I was in the supplier module and used write off/refund option then write off supplier transaction, selected the supplier, and then selection the transaction.  However insetad of writing off the one transaction that I had selected it wrote them all off!

I haven't cleared the audit trail, but I have no idea how to recover data back without doing a complete restore, and this would restore back to the last time I took a backup. I've done a lot of work on my client's Sage since then and don't want to have to reenter everything.

Wouldn't my journal work to amend the error? 

  • 88 posts
  • # 77145

Hi Debbie,

To w/o the transactions in a supplier account you could try this method.

Post a dummy credit note to decrease the balance on the supplier record to 0.00

Open the supplier payment window and bring up the supplier o/s invoices,credit notes and payments.
Highlight the payment column of the credit note you just entered and pay in full.
From the same window highlight the payment invoices o/s and pay in full.
To allocate the transactions, check the analysis total box shows 0.00 and save.

Have a nice weekend
Tim 

  • 22 posts
  • # 77149

Hello Debbie,

When you performed the Write/off, the only two ledger accounts to become affected by this would be 8100 & 2100. You should see a credit to 8100 Bad Debt Write off nominal code, and a debit to 2100 Creditors Control Account nominal code.

When you re-entered the outsanding balance as an invoice to the Supplier, if you posted it as the gross to 8100, but no VAT figure when you select T1 tax code, this will bring the Bad Debt back to a zero balance, and put the 2100 nominal code back to its correct balance also. The VAT Control Account & Ledger Account, say 7504 for Office Stationery would still be as before the write-off.

Without knowing which way you re-entered the invoice balance, I am only suggesting the way to complete it if you entered the invoice as above, but perhaps you could clarify what you did for me.

Thanks, 

  • Fellow PM.Dip
  • Practice Licence
  • 336 posts
  • # 77153

Timm

Thanks for the suggestion of a dummy credit note - i'll do that next week.

Angie - the invoice was posted through the supplier module to 5000 purchases with T0 for no VAT.  What would you suggest now?

I really appreciate your help.

Many thanks 

  • 22 posts
  • # 77165

Debsiesaid:

“Timm

Thanks for the suggestion of a dummy credit note - i'll do that next week.

Angie - the invoice was posted through the supplier module to 5000 purchases with T0 for no VAT.  What would you suggest now?

I really appreciate your help.

Many thanks ”


Morning Debbie,

OK here goes!

Based on what you have told me, first of all, please complete a credit note to the Supplier using the same 5000 nominal code and T0 tax code, and same amount as the invoice. This will put your nominal 5000 back to as it should be, as this is already posted by way of the original invoice prior to the write-off. This will also remove the figure from the Creditors Control Account.

Then you can put the amount back on the Supplier as an invoice using nominal code 8100 and place the gross amount in the net column with T1 tax code but remove the VAT figure that appears there before you save. This should then bring the 8100 nominal code back down to zero, and re-post the same figure to the Creditors Control Account again.

Once you have completed this, you should have two outstanding entries in your Suppliers Account. One for the invoice, and one for the credit note, both posted to 5000. The third one is the correct outstanding invoice amount posted to 8100, so ignore this one for now. Go into Bank, and select Supplier. Call up the Supplier Account, then without placing an amount to pay, select these two when they appear, and select 'Pay in Full'. This should allocate the invoice with the credit note, and canel each other out, and clear them as paid. Hopefully once you have completed this, you should see the one invoice posted to 8100 and ready to pay by the client.

I do hope this has helped, and look forward to hearing such when you're done. Any problems, please also let me know.

Thanks,



Edited at 26 Nov 2011 10:49 AM GMT

  • Fellow PM.Dip
  • Practice Licence
  • 336 posts
  • # 77169

Thanks Angie, that's a great help.  I'll follow your instructions when I'm back in his office on Tuesday.

Thanks again. 

  • 22 posts
  • # 77170

You are very welcome!

  • Fellow PM.Dip
  • Practice Licence
  • 336 posts
  • # 77300

Angie

Thanks very much - your advice was great and everything is back as it should be! 

  • 22 posts
  • # 77304

Debsiesaid:

“Angie

Thanks very much - your advice was great and everything is back as it should be! ”


Evening Debbie,

That's great news to hear.

Thanks for letting me know, and you are most welcome!

All the best to you! 

First Previous - Page 1 of 1 - Next Last
bottomBanner
loading