Stock Activity--Billing

This report prints all transactions from the invoicing and no charge Service parts entry programs.  This includes contract invoices and voids and credit memos.  The main sort is warehouse.  This is the report to print all of the items entered on invoicing records by the warehouse that the items were invoiced out of.  The file that is used is the Sales Analysis File.  This is the same file that the Detail Item Sales Report uses.  The Salid File is initialized with the Billing/A/R End Of Month.  The Stock Activity Billing Report produces data for the current month only.

 

Included on the report for each item is the quantity and unit of measure, ship to customer number, invoice or credit memo number, service call number, and transaction date.

 

The report is useful for auditing movement of an item by warehouse.  The Stock Activity Inventory Report includes all inventory transactions for an item.  The Stock Activity Billing Report includes all invoicing and no charge service ticket transactions for an item.

 

 

 

Enter Data

Transaction Date

 

The date accepted at the menu prompt upon entry to the program is used when printing the report for a specific date.

 

Upon entering the program, the printer selection routine appears.  The ESC escape key may be entered to interrupt the input or printing.

 

Inventory Transaction List For A'll, S'pecific Date Or E'nd

 

 

Inventory Transaction List For A'll, S'pecific Date Or E'nd

 

Enter an E to exit the report.  To include invoicing transactions entered for the current accounting month, enter an A for All.  This includes all invoicing and no charge service ticket entry transactions made after the AR/Billing End Of Month purge Initialize Index Files were run for the previous month.  It is the program Initialize Index Files which initializes the Sales Analysis Files.  Any invoicing transactions made after running this purge are considered in the current month.  Enter an S to print the transactions for a specific date.  The date that is used is the system date stored in the Sales Analysis record.  This date must match the date that was input upon entry to the report.  Once again, only current month records are included.

 

 

Report Results

The following information is included on the report for each item.  The items are printed in smallest to largest warehouse number order followed by smallest to largest product class order.  All information is from the Sales Analysis File unless noted.

 

WH#  The warehouse number the item was invoiced out of.  The name of the warehouse from the Warehouse File.  All contract invoice.

 

PC#  Product class.

 

ITEM NUMBER  The complete item number.

 

DESCRIPTION  The complete item description from the Item File.

 

QTY  The quantity involved in the transaction.  Voids and credit memos print with a negative sign.  The unit of measure that is defined in the Item File prints after the quantity.  If a broken pack is entered, an E for each prints instead of the Item File’s unit of measure.  The E discriminates between broken pack transactions and items that are assigned a unit of measure of each or EA.

 

CUST #  The ship to customer number.

 

CUSTOMER NAME  The full customer name from the Customer File.

 

INV/CM #  The invoice or credit memo number.

 

CALL #  On billable service tickets and no charge parts entries, the service call number is printed.

 

TDATE  The transaction date, which is also the invoice date.

 

 

 

Report Results

 

A sample report is displayed below.