Active WP - Debtor/Creditor Workpapers calculate GST for GST-free invoices/bills as well

Issue: Users may encounter an issue where the GST is automatically calculated when importing a GST-free invoices or bills from their source system (e.g., Xero) into a debtor or creditor workpaper in Active, despite the calculation being unnecessary.

Xero Bill:

Active Creditors Workpaper:

Cause: A combination of current limitations in the Xero API and our code, which do not fully support importing/computing GST values for debtors/creditors.

The automatic GST calculation is triggered by the formulas in the GST Calculated column in the workpaper, allowing users to make adjustments as required.

Workaround/Resolution: To reconcile GST values, users should resort to alternative reports in Xero/Active. It's important to note that debtor/creditor workpapers are not considered the definitive source of truth for GST values. Users can still make necessary adjustments to GST values within the debtor/creditor workpaper as necessary.

Active WP - Exported Balancing Journal Not showing in Xero

Active WP - Resolving "A binder column is required" Error in Active Workpapers

Active WP - Dates not displaying correctly, showing 1901 in some cases.

Active WP - Error: "Excel found a problem with one or more formula references in this worksheet..."

Active WP - How to Troubleshoot Debtors/Creditors OB