Accolent ERP Report Writer uses SQL Views for all forms and reports. The use of SQL Views eliminates the need for end-users to: write SQL Queries or understand the Accolent ERP database schema or worry about table joins. For each editable form there is a single master view that includes all the fields available for that form. Using the master view, end-users can edit the standard forms and save as their own customized version of the form.
Invoice Form Master Views
- The Invoice Form views contain the following fields which can be used to customize the standard form.
- Please contact ADS Solutions if you need help customizing the Invoice form.
| SQL View Name | Field Name | Description |
| [ADSvInvoiceFormHeader_Master] | Amount Due | Amount Due |
| Bill-To Address Line 1 | Bill-to address line 1 | |
| Bill-To Address Line 2 | Bill-to address line 2 | |
| Bill-To Address Line 3 | Bill-to address line 3 | |
| Bill-To Address Line 4 | Bill-to address line 4 | |
| Bill-To City | Bill-to city | |
| Bill-To Code | Bill-to customer code | |
| Bill-To Country | Bill-To Country | |
| Bill-To Name | Bill-to customer name | |
| Bill-To State | Bill-to state | |
| Bill-To Zip | Bill-to zip | |
| Company Address Line 1 | Company address line 1 | |
| Company Address Line 2 | Company address line 2 | |
| Company Billing Address Line 1 | Company billing address line 1 | |
| Company Billing Address Line 2 | Company billing address line 2 | |
| Company Billing City | Company billing city | |
| Company Billing Name | Company billing name | |
| Company Billing Phone | Company billing phone | |
| Company Billing State | Company billing state | |
| Company Billing Zip | Company billing zip | |
| Company City | Company city | |
| Company Country | Company country | |
| Company Logo | Company logo | |
| Company Name | Company name | |
| Company Phone | Company phone | |
| Company State | Company state | |
| Company Zip | Company zip | |
| Customer Address Line 1 | Customer address line 1 from customer master | |
| Customer Address Line 2 | Customer address line 2 from customer master | |
| Customer Address Line 3 | Customer address line 3 from customer master | |
| Customer Address Line 4 | Customer address line 4 from customer master | |
| Customer City | Customer city from customer master | |
| Customer PO No | Customer PO No | |
| Customer State | Customer state from customer master | |
| Customer Zip | Customer zip from customer master | |
| Discount | Discount | |
| Due Date | Due date | |
| Invoice Amount | Invoice amount | |
| Invoice Comments | Invoice comments | |
| Invoice Date | Invoice date | |
| Invoice No | Invoice number | |
| Payment Amount | Payment amount | |
| Quote Expiry Date | Date of quote expiration | |
| Salesperson Code+Name | Concatenated field showing salesperson code and salesperson name | |
| Salesperson Name | Salesperson name | |
| Shipping Instructions | Shipping instructions | |
| Shipping Method | Shipping method | |
| Ship-To Address Line 1 | Ship-To address Line 1 | |
| Ship-To Address Line 2 | Ship-To address Line 2 | |
| Ship-To Address Line 3 | Ship-To address Line 3 | |
| Ship-To City | Ship-to city | |
| Ship-To Country | Ship-to country | |
| Ship-To Name | Ship-to name | |
| Ship-To State | Ship-to state | |
| Ship-To Zip | Ship-tozip | |
| Special Instructions | Special instructions | |
| Terms | Terms of sale | |
| User Choice 1 | User Choice 1 from Customer master record | |
| User Choice 2 | User Choice 2 from Customer master record | |
| User Choice 3 | User Choice 3 from Customer master record |
| SQL View Name | Field Name | Description |
| [ADSvInvoiceFormMainQuery_Master] | Amount Due | Balance due on Invoice |
| Bill-To Code | Bill-To Code | |
| Category Code | Category Code | |
| Customer PO No | Customer PO No | |
| Due Date | Due Date | |
| Freight | Freight | |
| Invoice Total | Invoice Total | |
| Labor | Labor | |
| Non-taxable Total | Non-taxable Total | |
| Order Date | Order Date | |
| Requested Date | Requested Date | |
| Sales Tax | Sales Tax | |
| Salesperson Name | Salesperson Name | |
| Shipping Instructions | Shipping instrustions | |
| Shipping Method | Shipping Method | |
| Taxable Total | Taxable Total | |
| Terms of Sale | Terms of Sale |
| SQL View Name | Field Name | Description |
| [ADSvInvoiceFormGrid_Master] | Catch Weight | Catch weight of product |
| Extended Price | Extended Price | |
| Lot No | Lot No | |
| Notional Weight | Notional Weight | |
| Order Line Item Comment | Order Line Item Comment | |
| Price | Price per UOM specified | |
| Price/Pricing UOM | Price per pricing UOM | |
| Product Code | Product Code | |
| Product Description+Line Item Comments | Concatenated field showing product description and line item comments | |
| Qty on BO | Qty on BO | |
| Qty on Order | Qty on Order | |
| Serial No | Serial No | |
| Shipped Qty | Shipped Qty | |
| Shipping Instructions | Shipping instructions | |
| Taxed | Taxed | |
| Title Description | Title Description | |
| Title Sub-Report | Title Sub-Report | |
| Total Weight | Total Weight | |
| UOM | UOM | |
| Weight Description | Description of weight for catch weight products | |
| Weight of CatchWeight Product | Weight of catchweight product |