Order Booking Report (SOR735)

Using Reports

Use the Order Booking Report to review booked orders and print them for tracking purposes.

You must set the Order Booking flag on the Use tab of SO Static Control F/M to indicate how many months to store order booking information.

To ensure additional accuracy, the Order Booking Report is based on the system date (not the FACTS date). The End-Of-Period Update (SOU890) program also uses the system date for Order Booking processing.

Order Booking Process Description

The system books orders in the following ways:

• Orders are booked through SO Order Entry.
  
• In Quote Entry, quotes can be converted to orders by setting the Conv Stat flag to "Y" for a line(s) and enter "Y" at the Convert quote to sales order prompt in the Order Entry footer.
  
• Recurring documents are entered in Recurring Document Entry with posting dates. When you run the Post Recurring Documents program, it creates orders for those source documents that are within the posting range.
  
• Blanket orders are entered in Blanket Order Entry. When you run the Blanket Order Release Register, it creates orders for the source documents that meet the specifications.
  

The system considers an order as edited if the initiating warehouse, document total, total cost, or primary/secondary/inside salesperson contains a net change. If you change an order and then change the order again in manner that does results not result in a net change of information, the system does not consider the edit for order booking tracking. For example if modify the document total, total cost, or primary/secondary/inside salesperson and then change the information back, the system does not record the change..

However, if an order is changed then deleted in the same session, the system tracks only the deletion.

The program provides many report criteria options to allow for tailoring the report. You can print booked orders, orders that have been entered through various methods in the SO module (excluding direct invoices, credit memos, and counter sales) and edited orders, orders that have been changed and/or deleted.

The information and report selection available pertaining to Salesperson is determined by the Inside/2^nd Slsp flag set in SO Static Control F/M. Information prints for the inside salesperson only if the Inside/2^nd Slsp flag in SO Static Control F/M is set to "I" or "B". Information on second salesperson prints on the report if the Inside/2^nd Slsp flag is set to "2" or "B". In addition, the report selection based on a salesperson only applies to the current salesperson at the time the report is printed.

Limitations/Exclusions

• The Order Booking Report does not report on direct invoices, credit memos, or counter sales where items can be committed and not shipped.
  
• The report does not reflect anything that takes place during or after confirmation of the original order.
  
• Once an order is confirmed, order booking no longer tracks the order, so changes to or deletions of back-ordered documents are not tracked.
  
• CRS-generated orders will not be included since they usually contain replacements and not new sales.
  
• The system does not track the original (source) entry of blanket orders and recurring orders. However, each order created by a source blanket or recurring order is included in the report.
  
• The report information is displayed by order, not by line-item.
  
• If the LIFO/FIFO costing method is used, the cost and GM at the time of the original entry prints on the report. The report is not updated by final cost.
  
• Order booking records will only be created for new documents. Changes made to orders that already existed before order booking was turned on will not be tracked.
  

Click Field Descriptions for information on each field.

See Also

Using Reports

Using print options

Using report templates

Viewing reports on screen (using the viewer)

Using reports and prints as audit trails

Open topic with navigation