Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

 How to know if the custom extension is installed in client’s Business Central instance?

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.

 On first import, why are there no companies imported?

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.

 The VAT Posting Setup does not exist. Identification fields and values: VAT Bus. Posting Group='XYZ',VAT Prod. Posting Group='ABC'

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

 Setup is blocked in VAT Posting Setup for VAT Bus. Posting Group GRSTD and VAT Prod. Posting Group GST15.

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.

 The field Payment Terms Code of table Sales Header contains a value (X) that cannot be found in the related table (Payment Terms).

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.

 Unable to post GLs: Posting to Account (x) must either be of type Purchase or Sale

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.

 AP Credit - The field xyz of table Purchase Line contains value(abc) that cannot be found in the related table (Dimension Value)

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.

 Custom extension is not updated to the latest version that handles Posting No on AR Invoices

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)

 Custom extension is not updated to the latest version that handles OnHold AP Invoices

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.

 GST amount different from Workbench

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.

 GST rounding on AP Invoices

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.

 How to manually re-sync receipts and payments

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.

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

  • No labels