Sage 50 UKI Ideas Portal

Better supplier payment process please - to include allocation of credit notes to invoices in one transaction

I am experiencing real difficulties in keeping my Purchase Ledger in order.  I have suppliers that can have up to 200 invoices and credit notes each month and they require a clear remittance advice note that shows the supplier what I am agreeing to pay so that they mirror my purchase ledger on their sales ledger.  The problem I am experiencing is that when I am on the Supplier Payment page, I 'pay in full' the invoice that has been supplied and then select the credit note that matches it.  This credit note is also paid in full.  After following the supplier statement to the end, there is a balance that is agreed and paid and a remittance advice is produced that shows all the documents that I agree to be removed from my account.  The issue is when there is a document enquiry later on and I investigate this through supplier activity.  The activity record is all to pot.  The credit notes that I carefully posted against its matching invoice are now posted against several other invoices that have nothing to do with the credit note.  Sage tell me that I am entering the payments incorrectly.  I need to do this is two processes.  Firstly, on the supplier payment screen, I need to select the credit note, go to the relating invoice and enter the same value as the credit note so the balance is nil until all the credit notes have been chosen.  At the end, the balance will be nil, obviously, but a remittance can not be produce to notify the supplier because the balance is nil.  The second process is to then, after saving, go back into the supplier account, pay in full all the invoices, including those that have had a credit paid against them (but now shows a reduced value) and pay the balance shown.  A remittance for this can be produced but will not include any credit notes.  I always end up with complaints from suppliers as they have an incomplete remittance.  This processes generates considerable amount of work and is inefficient.  Surely there has to be a more common sense way of carrying out supplier payments?

  • Guest
  • Apr 6 2021