Tax Credit Report

Purpose: This report displays merchandise, freight, additional freight, handling, additional charges, tax, GST, and PST totals for all credit invoices within a given date range.

How to print: Use the Printing the Tax Credit Report (PTCR) menu option.

For more information: See the sample report in PDF format.

Note: This report is also available as a .csv (comma-separated value) file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in CSV (Spreadsheet) Format for more information.

Contents: Credit invoices display on this report in ascending invoice date sequence. Within invoice date, credit invoices display in ascending invoice number sequence.

• Date Range: The date range entered at the Tax Credit Report Screen in MM/DD/YY format.

• Invoice date: The date the credit invoice was generated in MM/DD/YY format. From the INS Invoice date field in the Invoice Ship To table.

• Invoice #: The credit invoice number. From the IHD Invoice # field in the Invoice Ship To table.

• Order #/ Ship To: The order number and ship to number associated with the credit invoice. From the Order # and Ship to # fields in the Invoice Ship To table.

• Ship To Name/Address: The name and address of the ship to customer associated with the credit invoice. Depending on how you create the order, the shipping address can be:

• the order-level shipping address, as set up through Assigning an Order Shipping Address.

• a permanent shipping address for the customer, as set up through Using a Permanent Shipping Address in Order Entry.

• a recipient customer, as set up through Adding a Recipient Order in Order Entry.

• the name and address of the Customer Sold To who placed the order.

Note: Address lines 2, 3, and 4 display only on the .csv report format. In order to include leading zeros for the zip code on the .csv report format, you need to format the cells in the spreadsheet application to include leading zeros.

• Customer Class: The customer class defined for the sold to customer on the order. From the CCL Customer class field in the Customer Sold To table. Note: The customer class displays only on the .csv report format.

• Process Date: The date the credit invoice was processed. From the IHD Invoice Process Date field in the Invoice Header table. The system updates this field when the order is billed if the Update Invoice File with System Date During Billing (D51) system control value is selected.

• Merchandise: The total dollar value of the merchandise. Merchandise amount does not include tax, handling, additional charges, or freight. From the INS Merchandise field in the Invoice Ship To table.

• Freight: The freight charges for the invoice. From the INS Freight field in the Invoice Ship To table.

• Additional Freight: The total dollar amount for freight charges exceeding the order’s base freight charge. This is a shipper-level charge directly associated with the order, as opposed to the line item. Additional freight is defined for the shipper in the Ship Via table. Examples of additional freight charges that might apply include charges for overnight shipping, second day delivery, padded van, etc. Additional freight charges may include the standard freight charges, depending on how you have set up the shipper. In this case, the Freight will be blank. From the INS Add’l freight field in the Invoice Ship To table.

• Handling: The cost of any special handling on the order, such as personalizing, monogramming, or engraving, and any gift wrapping charges. Any duty charges on the invoice are included in this total. From the INS Handling field in the Invoice Ship To table.

• Additional Charges: The total charges exceeding standard charges on the current order. From the INS Add’l Charges field in the Invoice Ship To table. Additional charges may include:

• Additional source code charge

• An additional charge for services that apply to the source code or offer. These charges apply if you have set up a service charges table for the source code or offer. The system applies the additional charge to the order based on the total dollar value of the merchandise.

• Additional shipper/item charge

• An additional charge that applies to the item, depending on the shipper you select to deliver the item. Such charges may apply when the item exceeds established shipping rate charges. For example, delivery of an oversized item may incur an additional shipper/item charge. Additional shipper/item charges apply when defined for the shipper.

• Ad hoc charge

• An additional charge, such as a charge for a gift box, that you assign at order entry. You initially define ad hoc charges in the Additional Charges table.

• Dollar discount

• An additional charge (credit) that is applied based on the total dollar value of the merchandise.

• Tax: The sales tax for the invoice. This field includes GST and PST, if any. Tax rates vary by delivery location, and their calculation depends on the laws governing their application. The system stores tax rules in the System Control table, Customer table, SCF and other tax tables. This field does not include hidden tax. From the INS Tax field in the Invoice Ship To table.

• GST: The Canadian Goods and Services Tax, if any. This field displays only if there is a GST charge or credit on the invoice. From the INS GST field in the Invoice Ship To table.

• PST: The Canadian Provincial Services Tax, if any. This field displays only if there is a PST charge or credit on the invoice. From the INS PST field in the Invoice Ship To table.

• Totals: Final Merch, Freight, Add’l freight, Handling, Add’l charges, Tax, GST, and PST totals for all credit invoices on this report.

Dollar totals on the PDF report format: On the PDF report format, the system removes the cents from totals that are in the millions. For example, the report lists 1,000,000 instead of 1,000,000.00.