Thursday, March 4, 2010

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.

0 comments: