[Picture]GRD_INVLINES Grid Component
Purpose
The application administrator uses the GRD_INVLINES grid component on the ASWINVOICES.A5W to see the details of the items in an order.
Description
The GRD_INVLINES component is a tabular read-only grid based on a view that merges fields from the invoice_items, invoice_header, and product tables.
The grid has three calculated fields. The purpose of the calculated fields is to calculate the discount, tax and extended values for each record. The page script uses these values to calculate the totals for the invoice.
disc_ext = ((Quantity*Price) * Invoice_Header->Discount) * -.01 tax_ext = ((Quantity * Price) * Invoice_Header->Sales_Tax) * .01 tot_ext = Extension + (((Quantity * Price) * Invoice_Header->Discount) * -.01) + ((Quantity * Price) * Invoice_Header->Sales_Tax) * .01 |
Containers
Notable Grid Control Property Settings
Control |
Property |
Description |
Disc_Ext |
Summary values > Total |
"True" |
Summary values > Total display format |
alltrim(str(<value>,250,2,"$(B")) | |
Tax_Ext |
Summary values > Total |
"True" |
Summary values > Total display format |
alltrim(str(<value>,250,2,"$(B")) | |
Tot_Ext |
Summary values > Total |
"True" |
Summary values > Total display format |
alltrim(str(<value>,250,2,"$(B")) |
See Also
Supported By
Alpha Five Version 7 and Above
![[Picture]](http://support.alphasoftware.com/images/ASW_GRD_INVLINES.gif){kind=link}