Welcome Guest, you are in: <root>AFIweb • Login

Page History: Sales Tax Due Report

Compare Page Revisions

5 4 3 2 1 0 Current 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Tue, 13 Feb 2018 08:38

Table of Contents [Hide/Show] Default Menu Location General Description Fields/Filters Standard Report Fields(Headers) Standard Report Fields(Line Items Detail)    Group Footer Summary

Default Menu Location¶

Reports >> Sales Tax >> Sales Tax Due

General Description¶

The Sales Tax Due report is used for determining the amount to pay taxing authorities for sales.

Fields/Filters¶

By Period or By Date Range: Options to choose a report type

Month: Month for the report (Require only if the "By Period" is selected)

Year: Year for the report (Require only if the "By Period" is selected)

Beginning Date: Beginning date for the report (Require only if the "By Date Range" is selected)

Ending Date: Ending date for the report (Require only if the "By Date Range" is selected)

Customer Number: Customer code

Item Number: Item code

Sort By: Options for report generation

Standard Report Fields(Headers)¶

Company

• company
  

Date Range

• gd_passdate
  

Customer

• 'Customer : ' + alltrim(gc_cust)
  

Item Number

• 'Item: ' + alltrim(gc_item)
  

Warehouse

• 'Whse: ' + alltrim(gc_plant)
  

Standard Report Fields(Line Items Detail)¶

Order Number

• sono
  

Customer Name

• CUSTOMER
  

Customer No.

• custno
  

Invoice No.

• invno
  

Invoice Date

• invdate
  

Sales Price

• extstot
  

Standard Cost

• gc_costlabel
  

Profit

• profit
  

Group Footer¶

Total for customer

• 'Total For customer - '+alltrim(CUSTOMER)
  

Sales Price

• cextstot
  

Standard Sales

• cstcost
  

Profit

• profit
  

Summary¶