About Reindexing Order Entry
Reindexing recreates an index. You can reindex a number of files that are associated with the file P-MASTER. You can also reindex JOUR-S or other renamed sales journals.
When you create orders in the Order Entry application, an index for the P-MASTER file is automatically created. This index lets you retrieve customer pick tickets by customer name in a quick and efficient manner, and is updated each time you perform day-end procedures. However, if you have difficulty retrieving customer pick tickets by customer name, you should rebuild the index.
The first time you reindex P-MASTER, the files P-H-INDEX, P-BO-INDEX, and P-BININDEX are created. The file P-BININDEX is only created if you set the Always Print pick tickets in Bin Order field in the (LGØ) Order Entry Parameters screen to Y. Once created, these files are updated each time you perform day-end procedures.
The P-H-INDEX file keeps a record of all pick tickets placed on hold. When a customer places an order, the P-H-INDEX is searched first for any pick tickets previously placed on hold for that customer.
The file P-BO-INDEX contains all backordered items. This file is searched each time you print a Short-Buy or Backorder Report.
The P-BININDEX file is used only if you are using the split lines feature. This allows pick tickets to be printed in bin location order instead of sequence order.
The P-INDEX file and sales journal indexes are cross-references of the customer’s account number and pick tickets. Reindexing rebuilds order entry and sales journal indexes (P-INDEX and JO-INDEX) to keep information accurate.
When you create credit returns, the P-CRINDEX is created. This index contains the item number and customer number. If you set the Create Customer P/O Index File to Y in the (LGA) Sales Journals Parameters screen, the P-CPOINDEX file is created. This index contains both the customer’s short and long purchase order numbers.
The P-PJINDEX, P-CPJINDEX, and P-SPJINDEX files are only created if you are using the furniture module. These file contain the invoice number to project number, customer account number to project number, and salesperson and customer account numbers to project number, respectively.
The P-CDINDEX and P-CMINDEX files are used to view item history in the order entry application. These files lets you view items that were sold to the customer by specifying the item’s manufacturer and/or description. You can also view specific information about the sale of each item. The P-CDINDEX links the customer record to the item description for all items previously sold to the customer; the P-CMINDEX links the customer record to the manufacturer of all items previously sold to the customer.
When an index is created for a sales journal, the name of the index begins with the first two characters of the journal name. For example, the index for the May 1999 sales journal, Ø599-S, becomes MA-INDEX. These indexes allow you to inquire on pick tickets by customer account number instead of only by pick ticket number.
If you set the Build Sales Journal Index field in the (LGØ) screen to Y, the file JO-I-INDEX is also created. This sales journal index lets you inquire on items by customer.
Return to: