Field Descriptions

Table Information

 

Tax Status by Transaction Report

What can I do in this screen?

Use this screen to mark transactions included in previous VAT (Value-Added Tax) reports. This will ensure that future VAT reports do not include these marked transactions.

You can access two subtasks in this screen: Tax Accounts (Bills) or Tax Accounts (Vouchers), depending on whether you select the Bills radio button or the Vouchers radio button.

When should I use this screen?

Use this screen before you prepare your company's VAT return.

Field Descriptions

Transaction Type

Use the fields in this block to select the transaction that you wish to exclude.

Output

Bills

Select this radio button to view your company's billing transactions.

Type

Use this drop-down box to view all your company's billing transactions or just a specific type.  The choices are: "All," "Customer Product," "Project Product," "Manual," "Milestone/ Percent Complete," or "Sales Order."

Invoice Date

Starting

Enter, or use the Calendar Lookup to select, a beginning invoice date for a range of invoices to display in the table window.

Ending

Enter, or use the Calendar Lookup to select, an ending invoice date for a range of invoices to display in the table window.  The default for this field is today's (system) date.

Input and Acquisitions

Vouchers

Select this radio button to display voucher (Accounts Payable) information in the table window.

Type

Use this drop-down box to view all your company's vouchers or just a specific type.  The choices are: "All," "AP," "PO," "TE" (Time & Expense), or "Travel."

Check Date

Starting

Enter, or use the Calendar Lookup to select, a beginning check date for a range of checks to display in the table window.

Ending

Enter, or use the Calendar Lookup to select, an ending check date for a range of checks to display in the table window. The default for this field is today's (system) date.

Table Window (Upper)

If you select the Bills Transaction Type, this upper window will display the Customer ID, Customer Name, Bill Type, Invoice Number, Invoice Date, Due Date, Entered Date, Invoice Amount, Tax Amount, Discount Amount, Discount Taken Amount, Paid Amount, Declaration Point Code, EC Country Dest Code, Intrastat Reference No, Mode of Transport, Permit ID, Shipping Method Descriptive Code, Supply Date, Traffic Direction Cd, Value Added Tax ID, and Value Added Tax Date for the bills selected.

If you select the Vouchers Transaction Type and select the Execute icon, this upper window will display the Vendor ID, Vendor Name, Voucher Number, Voucher Type, Invoice Number, Invoice Date, Due Date, Entered Date, Check Number, Check Date, Fiscal Year, Period, Invoice Amount, Tax Amount, Discount Amount, Discount Taken Amount, Paid Amount, Declaration Point Code, EC Country Dest Code, Intrastat Reference No, Mode of Transport, Permit ID, Shipping Method Descriptive Code, Supply Date, Traffic Direction Cd, Value Added Tax ID, and Value Added Tax Date for the vouchers selected.

Table Window (Lower)

If you select the Bills Transaction Type, this lower window will display further details including: Item, Item Revision, Item Selling Description, Price Catalog Code, Unit Price Amount, Units Quantity, Total Price Amount, Tax Code, Tax Amount, Total Before Discount Amount, Discount Percentage Rate, Discount Amount, Net Amount, Commodity Code, Correction Code, EC Country Origin Code , Mass Quantity, Mass Quantity Unit of Measure, Nature of Transaction code, EC Country Ship Code, Customs Type Cd, Supplemental Units No, and Value Amt.

 

If you select the Vouchers Transaction Type and select the Execute icon, this lower window will display further details including:  Voucher Line No, PO, Po Line No, Item, Item Revision, Item Selling Description, Unit Price Amount, Units Quantity, Total Price Amount, Line Charge Cost Amount, Tax Code, Tax Amount, Line Charge Tax Amount, Total Before Discount Amount, Discount Amount, Net Amount, Recovery Amount, Commodity Code, Correction Code, EC Country Origin Code, Mass Quantity, Mass Quantity Unit of Measure,  Nature of Transaction code, EC Country Ship Code , Customs Type Cd, Supplemental Units No, Value Amt, Use Tax Amount, and Line Charge Use Tax Amount.   

Tax Accounts

Select this link to open the Tax Accounts (Bills) subtask or the Tax Accounts (Vouchers) subtask, depending on whether you selected the Bills radio button or the Vouchers radio button.

Table Information

Changes to this screen update the RPT_TAX_LN (Report Tax Line) and RPT_TAX HDR (Report Tax Header) tables.

Top of Page