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
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
ConsulBiotech, Investigação e Desenvolvimento, Unipessoal, LDA
Boa tarde, O Standard accounts aparentemente não liga ao servidor CIEDUL e consequentemente as mi...
14:42 24 Oct 2024
HC
Boa tarde, uma vez mais solicitamos resposta à questão colocada. ...
15:13 21 Oct 2024

Supervisionamos regularmente o fórum dentro do horário normal de trabalho e tentamos responder a todas as questões em 24 horas

Pode subscrever notificações para qualquer mensagem neste fórum, seleccionando o ícone 'estrela' no canto superior direito da lista de tópicos. Tem de iniciar sessão para utilizar esta funcionalidade.