This answer was correct
Mutual Settlement between Customer and Supplier
2016-11-04
We have a situation whereby a supplier is also considered a customer by the company.

They have invoices both for Purchases and Sales. So if we will look at the Sales and Purchase Ledger report. It will show the two invoices coming from two registers and the balance naturally will tell show what is the difference between the two.
DR. CR
Purch Invoice ------------------------- 100K
Sales Invoice ------------------------- 50K _______
Balance------------------------------ 50K

So how do we record this in the sales ledger and the purchase ledger?
This answer was correct
Created by12:52 4 Nov 2016
We have a situation whereby a supplier is also considered a customer by the company.

They have invoices both for Purchases and Sales. So if we will look at the Sales and Purchase Ledger report. It will show the two invoices coming from two registers and the balance naturally will tell show what is the difference between the two.
DR. CR
Purch Invoice ------------------------- 100K
Sales Invoice ------------------------- 50K _______
Balance------------------------------ 50K

So how do we record this in the sales ledger and the purchase ledger?
2015-02-19
Hello,

You have two options:

1) you create a payment mode in sales or purchase ledger called Mutual Settlements, and then you create sales ledger receipt for 50K and purchase ledger payment for 50K using the same payment mode that will then get debit and credit both 50K

2) you can also create a new GL Transaction, open flip E, and make first row type C for customer, and select outstanding sales invoice for 50K. Then on the second row you make row type S for supplier, and select outstanding purchase invoice for 50K and save. You can also select multiple sales or purchase invoices like that, and adjust debit or credit amounts to make sure that total debit equals to total credit. This GL Transaction then also makes both the sales and purchase invoices paid in the ledger

Using receipts and payments with Mutual Settlements payment mode is better option if you want to use payments journal and receipt journal reports and see how much has been settled in a period. If you use GL Transaction, then you cannot easily see any report to see what amounts have been settled like that. Just check with your customer if this reporting is needed at all, if not then GL Transaction is easier entry, and you could use Settlement object on all rows to pull a report in GL for Debtors account or Creditors account to see all settlements.

Hope this helps.

Kind regards,
Kaido
Back to the list
Latest Posts
Boa tarde, Após a última atualização (8.5 2024-10-16) os grupos de acesso deixaram de existir. Agr...
14:06 3 Dec 2024
Monica Amado
Bom dia, Sónia, Por favor efetuar o download e importe o ficheiro em anexo através de: Sistema &...
11:48 26 Feb 2024
You can subscribe to notifications for any post in this forum by selecting the 'star' icon on the top right corner of the topics list. You have to log in to use this functionality.