Business Central FAQs

After successful Authorise of the connection to BC, click on [Test] button. The checkbox Extension Installed will be ticked if the custom extension is installed in BC.

There are no companies updated on or after the Last Update date value in the integration page. Set this date picker to an earlier date to get companies. On first import we recommend setting to year 2000 then Save the form before importing.

Make sure the intended VAT setup is configured in GST/VAT Posting Setup page in BC.

When posting AP/AR in BC, GST/VAT Bus. Posting Group is inherited from BC’s Vendor/Customer and Prod. Posting Group is Worbkench’s Export Code if the account in BC does not have it.

Note: This could also be triggered when the Vendor’s GST/VAT Bus. Posting Group and the Account’s GST/VAT Prod Posting Group combination does not exists in the GST/VAT Posting Setup

Cause: Blocked GST/VAT Posting combination cannot be used to post documents in BC.

Solution: Make sure that the GST Types export codes in WB are in line with BC. Request the client to update Vendor/Customer and Account’s GST Bus. Posting Group to correct value.

Cause: This error is caused by Vendor/Customer setup in BC. The vendor/customer’s payment term code is not found in the list of Payment Terms in BC.

Solution: Request the client to update the Vendor/Customer payment term code to a valid value.

Cause: This error is caused by posting to an account in BC that doesn’t have Gen. Posting Type set.

Solution: In BC, edit the account and select a value for this field in BC, and re-export the batch.

Cause: The Analysis2 value is not a valid dimension value for Global Dimension 2 in BC. The General Ledger setup global dimension setup should always correspond to the Business Central Integration page dimensions

Solution: Update either WB Business Central page dimension 2 setup or BC Gen Ledger global dimension 2 setup.

Cause: Custom Extension v1.18.2.108 or higher is not installed in client’s BC instance and the Change AR Posted Doc No checkbox in BC integration page is ticked (image below).

Short Term Solution: Untick the Change AR Posted Doc No checkbox to allow the client to export AR invoices (image below).

Long Term Solution: If the client intend to use WB Invoice number as the Doc No in BC, install the latest custom extension in BC instance and tick the Change AR Posted Doc No checkbox in BC integration page (image below)

Cause: Custom Extension v1.18.2.106 or higher is not installed in client’s BC instance and the OnHold field is checked in AP Invoice (image below).

Short Term Solution: Untick the OnHold field in AP invoice page to allow the client to export AP invoices (image below).

Long Term Solution: If the client intend to tag AP Invoices as OnHold in BC, install the latest custom extension in BC instance.

Cause: The Vendor/Customer setting Prices Including VAT/GST is turned on.

Solution: Turn off this setting for the vendor/customer. Search of other vendors/customers with this setting on and turn them off as well to prevent GST issues with those companies as well.

To make sure that an invoice total amount inclusive of tax/gst exported to Business Central is always the same as in Workbench, the amounts exported from Workbench are inclusive of tax/GST.

Solution:   

1. In BC integration page, make sure that the Job Receipts and Payments checkbox is checked.

2. Change the Last Update to the date of when the receipt or payment is made in Business Central then [Save] the form.

3. Once saved, click on [Sync]. The bottom part of the screen will show result of the sync.

Solution:   

1. Find the supposed paid invoice in WebWB, take note of the invoice number.

2. Verify that the invoice is paid in Business Central.

   1. For Job Receipts

      1. Go to Customer Ledger Entries and locate the invoice by filtering External Document No using the invoice number