Merge creditor with debtor
We recommend that anyone wishing to use this feature consults with a dealer.
This functionality makes it possible to merge a creditor with a debtor so that entries from the creditor and debtor act as if they were a single account. For example, sales invoices can be offset with purchase invoices.
Please note! We recommend that the functionality is thoroughly tested in each case.
Note! If a creditor is merged with a debtor, it cannot be reversed.
Note! Reconciliation dashboards on debtors and creditors cannot handle "Merged Creditors with Debtors".
Note! Check if the equalizations are running correctly on the merged debtors/creditors before using the function.
When the vendor is merged with the debtor, all entries on the vendor are moved to the debtor's entries. Therefore, after the merge, a manual re-posting of the balance on the vendor from the vendor master account to the debtor master account should be made so that it can be reconciled with balance lists.
There is still a debtor and creditor account in the system after the merge, and purchase and sales invoices etc. can still be posted to the debtor and creditor. The invoices will still be visible, for example, in the invoice archives under Debtor and Creditor/Reports/Invoices respectively.
A field called From creditor has been added to the debtor entries and a similar field called From debtor has been added to the creditor entries.
On the merged debtor/creditor, the creditor and debtor entries will have a mark in this field so that you can clearly see on the debtor entries that the entry comes from a creditor and vice versa.
A field called Vendor has been added to the debtor file. This field is automatically filled in by the system with the vendor that the debtor is merged with. In the vendor file, there is a corresponding field called Debtor.
When you subsequently post to the vendor, the entries will automatically be shown to the debtor and posted to the debtor summary account. The creditor's entries will therefore be included in the debtor balance list in the future, and it will also be possible to see the open creditor entries when creating interest and reminders.
Similarly, the open items on merged debtors/creditors will also be visible under Payment proposals in the Accounts payable module, making it possible to create payments to the merged debtor/creditor.
The menu item for merging vendor with debtor can be found under Vendor/Maintenance/Merge/Merge Vendor with Debtor. However, please note that this feature is only available for resellers.
If this function is used, an accounting decision must be made each year as to whether the total value of the combined debtor/creditor should have been placed under liabilities instead, because the total value is negative. If this is the case, this value must be manually reposted via the accounting journals, as the value of the combined debtor/creditor is always included in the debtor summary account regardless of whether the total value is positive or negative.
If this function is used, an accounting decision must be made each year as to whether the total value of the combined debtor/creditor should have been placed under liabilities instead, because the total value is negative. If this is the case, this value must be manually reposted via the accounting journals, as the value of the combined debtor/creditor is always included in the debtor summary account regardless of whether the total value is positive or negative.