Stonefield Query for Sage Accpac ERP Version 3.3 Build 3713

We released an update to Stonefield Query for Sage Accpac ERP version 3.3 today. It has the following new features:

• There are now relationships between the Order Entry Sales History Details table and the Credit/Debit Notes, Invoices, and Combined Invoices & Credit Notes tables, and the Accounts Receivable Document Details table and Item Pricing table.
• There are a couple of new fields available in the Accounts Receivable Documents table: Document Amt (Functional) and Document Amt (Customer). These fields contains the document amount with taxes removed and retainage (if any) included.
• There are three new fields available in the Accounts Receivable Document Details table: Extended Amt (Customer), Amt / Tax Base (Customer), and Amt / Tax Base (Functional). The latter two contain the detail line amount not including any taxes, and is also the amount the tax amounts are based on.
• There are a couple of new fields available in the Accounts Payable Documents table: Document Amt (Functional) and Document Amt (Vendor). These fields contains the document amount with taxes removed and retainage (if any) included.
• There are a couple of new fields available in the Accounts Payable Document Details table: Amt / Tax Base (Vendor), and Amt / Tax Base (Functional). These fields contain the detail line amount not including any taxes, and is also the amount the tax amounts are based on.