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

Hi all
if you could give a bit of assistance, we sell to retail stores accross the country, eg we supply B&Q but we have each induvidual store set up as induvidual debtors, however when they make a payment they pay from a head office and pay accross all accounts. This is fine except when they use a credit against one store to reduce the overall payment, i seem unable to clear this credit of debtors as when in the receive payment menu it will not allow me to post cash against a refund, i can only do it when the invoice amount is greater than the credit amount, can anyone tell me why this is happening and how i post a payment accross multiple accounts taking into account that some accounts i am posting only credits
ta bcmw

bcmw wrote:each induvidual store set up as induvidual debtors,

Well, that's the root of your problem - use one account with different delivery addresses.

As for sorting out the current mess, version details would give us a clue as to the options available to you.

Thanks Dave
We are using Line 50 ver 12.01
We have set some debtors up with multiple delivery addresses, but they also seem to have set others up as induvidual debtors which is causing the problem
Any advice much appreciated
bcmw

Well, whichever way you go it's going to be ugly and painful...

Firstly - stop the rot. Make sure each debtor is billed on a single account in future.

Secondly - tidy up the mess. I think I'd go for a minimum change approach. That's to say, try to allocate payments without adjustments. If it works, fine, if it doesn't you need to move the credit from the account to which it was posted to the account to which you're posting the payment. I can think of two ways of doing this - equally ugly. The first is via File Maintenance; change the account to which the credit was posted. VERY ugly, but easy. Alternatively, raise an invoice on the account that holds the credit note, and then credit the account to which you need to post the payment, use the same nominal for each. Then post the payment. Less ugly, but harder work.

Best of luck, Carruthers.