Ticket Billing -Technical Notes

When the ticket billing process (FV712P04) runs it scans for open pending records by reading through index 9 on the Pending file <STATUS><COMPANY><INV_NO>.  This program uses the ZREPORT macro and breaks on Company name.  As each company is processed an invoice record is created, with a type of IN and the appropriate source (TB) and subtype.  Pending lines are then selected based on the STATUS being open and the TYPE being "T".  As a line is selected the original invoice line is loaded into the TRANSACT buffer, set inactive, assigned a new invoice number and type, then saved.   At this point sales statistics are updated, including the customer file, statistics files and the inventory master.

Gencode Tables

Generic Code tables can be set up for the Ticket Billing and the Invoice Cycle field in the Company Master file in order to control the information that is entered into each of the fields and to force users to enter valid data into the field.

Ticket Billing: To create a Generic Code Table for the Ticket Billing field, you should create a Gencode Table with a Table Name of F54:232.  Two records should be created in this table.   One should have the code field set to Y if normal ticket billing is used, if PO based ticket billing is used one should have the code field set to "P", and one should have the code field set to N to allow non-ticket billing customers.

Invoice Cycle: To create a Generic Code Table for the Invoice Cycle field, you should create a Gencode Table with a Table Name of F54:228.  Records should be created in this table for each Invoice Cycle you will be supporting.  Commonly used Invoice Cycles might include EOM (end of month), 15th (billed on the 15th) and NA (not applicable).  The Billing Cycle code should be entered in the Code field of each Gencode record.  The appropriate description should be also entered for each record.   The Invoice Cycle field is used to select the customers to be processed when running the Invoice Ticket Billings program from the menu or automatically in the Job Processor.

More:

Ticket Billing - Business Issues