Skip to main content

Business Central Error: Debit Rounding Account Is Missing in Vendor Posting Group

Posting a payment or applying vendor entries in Business Central stops with this error:

Debit Rounding Account is missing in Vendor Posting Group Code: XXXX.
G/L Account No. must have a value in G/L Entry: Entry No.=NNNNN. It cannot be zero or empty.

The fix

  1. Open Vendor Posting Groups and find the code named in the error.
  2. Fill in both Debit Rounding Account and Credit Rounding Account.
  3. Post again.

Which account? A profit and loss account, such as your rounding differences account or your realized exchange gain/loss account. Use the same account for both fields. Do not use the payables account.

Why it happens

You partly paid a foreign currency entry, and rounding left a one-cent gap in local currency. Business Central needs an account to post that cent to.

Example: invoice of USD 302.00 at rate 4.2345, part-paid with USD 101.00.

Step Calculation MYR
Invoice 302.00 × 4.2345 = 1,278.819 1,278.82
Payment applied 101.00 × 4.2345 = 427.6845 427.68
Remaining, by subtraction 1,278.82 − 427.68 851.14
Remaining, at the rate 201.00 × 4.2345 = 851.1345 851.13
Difference 851.13 − 851.14 −0.01

That 0.01 is posted as a Correction of Remaining Amount to the rounding account. If the field is blank, posting fails. The second line of the error is only a side effect of the first.

When to expect it

  • Yes: foreign currency entries left partly open. Part-payments, overpayments, advances, and credit memos of a different amount.
  • Never: local currency entries, or entries paid in full.

It looks random because the cent only appears on some combinations of amount and exchange rate. That is why the same vendor can post fine for months and then fail.

Tip: fill in the same two fields on your other vendor posting groups and on your Customer Posting Groups. The same error can happen on the sales side.

Labels:
Location: Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia

Comments

Post a Comment

Popular posts from this blog

How to Reverse Posted Documents in Business Central

  If you need to amend or change a posted documents in Business Central, there are few ways to do it instead of having you to manually create a reversal journal or Credit Memo to rectify a Posted Document. Before you proceed to Correct or Cancel any document that posted in Business Central, you need to identify the origin of the posted document, as the method of cancellation depends on the document type.   There are 2 types of documents that posted in Business Central. i.                      Journals – E.g., General Journals, Purchase Journals, Payment Journals, Sales Journals, Receipt Journals etc. ii.                    Documents – E.g., Purchase Invoice, Purchase Credit Memo, Sales Invoice, Sales Credit Memo etc.   A.       A.     C orrecting ...
Post a Comment
Read more

Foreign Currency Revaluation in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central (BC) allow users to account for foreign currency transactions. BC also able to translate the registered foreign currency amount into functional currency that setup in the entity using the conversion rates which setup in Exchange Table.   Due to the exchange rates fluctuate constantly, as a dollar worth in foreign currency today might not equivalent to the same foreign currency worth the next day. Hence, users are required to adjust the open documents that transact in foreign currency which include open invoices, credit memos, and advance payments. Once the open documents transacted in foreign currency is revalued, the gain and loss which calculate after comparing the closing rates at the period end will be posted to profit and loss as unrealised gain and loss, ensuring that the subledgers and general ledger can be reconciled.   This process can be done using Adjust Exchange Rate in BC, a batch job to adjust the exchange rates fo...
Post a Comment
Read more

How to Consolidate Customer and Vendor Balances in Business Central

Understand that some customer of the company might be the vendor of the company too. There is a feature in Business Central that allows users to consolidate both customer and vendor balances without making unnecessary payment or receipts. Prerequisite Setup for Customer and Vendor Consolidation Page: Marketing Setup           1.        Setup a Business Relation Code for each Customers and Vendors.          2 .        Assign a number series under Contact Nos. A number will be pickup from the number series when there is a new Contact code created. To Link the Relation between Customer Card and Vendor Card 1.        Go to Customer Card, look for the customer that you need to link in Customer Contact. 2.        Confirm the Customer Name that you have selected. 3.        Link with the C...
Post a Comment
Read more