Report Designer: Invoice Item variables

Show expandable text

We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

The Report Designer Invoice Item variables display information on reports about the setup of invoice items. The following table lists all of the currently available variables, what they output, and where the information is retrieved from within the application.

See also: Variables overview

Workpapers CS users: This section of variables is visible in the Design Tools frame in the Report Designer, but will not output any information. If any of these variables are inserted, the report or other document will display as "This report contains no data."

Invoice Items

Variable name Data content/source Format Variable syntax
Invoice Item Description The invoice item description, from Setup > Invoice items Text [InvoiceItem.Description]
Invoice Item ID The invoice item ID, from Setup > Invoice items Text [InvoiceItem.ID]
Invoice Item Inactive Date The invoice item inactive date (if applicable) , from Setup > Invoice items Date [InvoiceItem.InactiveDate]
Invoice Item Status The invoice item status (active/inactive) based on the inactive date field, from Setup > Invoice items Text [InvoiceItem.Status]
Invoice Item Type The invoice item type, from Setup > Invoice items Text [InvoiceItem.Type]

Discount Information

Variable name Data content/source Format Variable syntax
Discount Item Amount/Percentage The discount invoice item amount/percentage field, from Setup > Invoice items Number [InvoiceItem.DiscountInformation.AmountPercentage]
Discount Item GL Account The discount invoice item GL account number, from Setup > Chart of accounts Text [InvoiceItem.DiscountInformation.GLAccount]
Discount Item GL Account Description The discount GL account description, from Setup > Chart of accounts Text [InvoiceItem.DiscountInformation.GLAccountDescription]
Discount Item Method The discount invoice item Method (amount/percent) , from Setup > Invoice items Text [InvoiceItem.DiscountInformation.Method]
Discount Item Non Discount The discount invoice item, if discount applies (yes/no) , from Setup > Invoice items Yes/no [InvoiceItem.DiscountInformation.NonDiscount]

Group Information

Variable name Data content/source Format Variable syntax
Group Item Description The group invoice item description, from Setup > Invoice items Text [InvoiceItem.GroupInformation.ItemDescription]
Group Item ID The group invoice item ID, from Setup > Invoice items Number [InvoiceItem.GroupInformation.ItemID]
Group Item Quantity The group invoice item quantity, from Setup > Invoice items Number [InvoiceItem.GroupInformation.Quantity]

Inventory Information

Variable name Data content/source Format Variable syntax
Invoice Item GL Inventory Account The invoice item inventory GL account, from Setup > Chart of accounts Text [InvoiceItem.InventoryInformation.GLInventoryAccount]
Invoice Item GL Inventory Account Description The invoice item inventory GL account description, from Setup > Chart of accounts Text [InvoiceItem.InventoryInformation.GLInventoryAccountDescription]

Other Charge Information

Variable name Data content/source Format Variable syntax
Other Charge Item Amount/Percentage The other charge invoice item amount/percentage field, from Setup > Invoice items Number [InvoiceItem.OtherChargeInformation.AmountPercentage]
Other Charge Item GL Account The other charge invoice item GL account, from Setup > Chart of accounts Text [InvoiceItem.OtherChargeInformation.GLAccount]
Other Charge Item GL Account Description The other charge invoice item GL account description, from Setup > Chart of accounts Text [InvoiceItem.OtherChargeInformation.GLAccountDescription]
Other Charge Item Method The other charge invoice item method (amount/percent) , from Setup > Invoice items Text [InvoiceItem.OtherChargeInformation.Method]
Other Charge Item Non Discount The other charge invoice item, if discount applies (yes/no) , from Setup > Invoice items Yes/no [InvoiceItem.OtherChargeInformation.NonDiscount]

Purchase Information

Variable name Data content/source Format Variable syntax
Invoice Item Purchase Cost The invoice item cost of Purchase, from Setup > Invoice items Number [InvoiceItem.PurchaseInformation.Cost]
Invoice Item Cost of Goods GL Account The invoice item cost of goods GL account, from Setup > Chart of accounts Text [InvoiceItem.PurchaseInformation.GLCostofGoodsAccount]
Invoice Item Cost of Goods GL Account Description The invoice item cost of goods GL account description, from Setup > Chart of accounts Text [InvoiceItem.PurchaseInformation.GLCostofGoodsAccountDescription]

Sales Information

Variable name Data content/source Format Variable syntax
Invoice or Service Item Sales GL Account The invoice or service item sales GL account, from Setup > Chart of accounts Text [InvoiceItem.SalesInformation.GLSalesAccount]
Invoice or Service Item GL Account Description The invoice or service item sales GL account description, from Setup > Chart of accounts Text [InvoiceItem.SalesInformation.GLSalesAccountDescription]
Invoice or Service Item Non Discount The invoice or service item, if discount applies (yes/no) , from Setup > Invoice items Yes/no [InvoiceItem.SalesInformation.NonDiscount]
Invoice or Service Item Sales Price The invoice or service item sales price, from Setup > Invoice items Amount [InvoiceItem.SalesInformation.Price]

Sales Tax Group Information

Variable name Data content/source Format Variable syntax
Sales Tax Group Description The sales tax group invoice item description, from Setup > Invoice items Text [InvoiceItem.SalesTaxGroupInformation.ItemDescription]
Sales Tax Group ID The sales tax group invoice item ID, from Setup > Invoice items Number [InvoiceItem.SalesTaxGroupInformation.ItemID]
Sales Tax Group Rate The sales tax group invoice item rate, from Setup > Invoice items Number [InvoiceItem.SalesTaxGroupInformation.Rate]
Sales Tax Group Description The sales tax group invoice item description, from Setup > Invoice items Text [InvoiceItem.SalesTaxGroupInformation.SalesTaxDescription]

Sales Tax Information

Variable name Data content/source Format Variable syntax
Sales Tax Item GL Sales Tax Account The sales tax item sales tax GL account, from Setup > Chart of accounts Text [InvoiceItem.SalesTaxInformation.GLSalesTaxAccount]
Sales Tax Item GL Sales Tax Account Description The sales tax item sales tax GL account description, from Setup > Chart of accounts Text [InvoiceItem.SalesTaxInformation.GLSalesTaxAccountDescription]
Sales Tax Item Non Discount The sales tax invoice item, if discount applies (yes/no) , from Setup > Invoice items Yes/no [InvoiceItem.SalesTaxInformation.NonDiscount]
Sales Tax Item Sales Tax Description The sales tax item sales tax description, from Setup > Firm Information > Sales Taxes Text [InvoiceItem.SalesTaxInformation.SalesTaxDescription]
Invoice, Other or Service Item Tax Status The invoice, other or service item tax status, from Setup > Invoice items Text [InvoiceItem.SalesTaxInformation.TaxStatus]

Shipping Information

Variable name Data content/source Format Variable syntax
Shipping Item Amount/Percentage The shipping invoice item amount/percentage field, from Setup > Invoice items Amount [InvoiceItem.ShippingInformation.AmountPercentage]
Shipping Item GL Account The shipping invoice item GL account, from Setup > Chart of accounts Text [InvoiceItem.ShippingInformation.GLAccount]
Shipping Item GL Account Description The shipping invoice item GL account description, from Setup > Chart of accounts Text [InvoiceItem.ShippingInformation.GLAccountDescription]
Shipping Item Method The shipping invoice item method (amount/percent) , from Setup > Invoice items Text [InvoiceItem.ShippingInformation.Method]
Shipping Item Non Discount The shipping invoice item, if discount applies (yes/no) , from Setup > Invoice items Yes/no [InvoiceItem.ShippingInformation.NonDiscount]

See also: Report Designer: Procedures

Was this article helpful?

Thank you for the feedback!