Sales Pre-Invoice Exceptions Report ranges and options

Ranges

See Reports - Ranges overview for more information.

Options

Only Shipped Orders?

Select Yes to process only orders in Stage 3 (Shipped).

Select No to process orders in Stage 2 (Picked) and Stage 3 (Shipped). If you specify a list of order numbers in the List option, the system ignores this option.

Note:  If you select No and there are Counter Sales (CS) orders from a TWL warehouse to be invoiced, run WL Entry Batch Shipping Report before Sales Pre-Invoice Exceptions Report to ensure that all CS orders are properly updated relevant to the processing activity in TWL.

Enter a List of Order #s?

Select Yes to enter a specific list of order numbers, including orders in Stage 1 (Ordered). If you select Yes, click List to display the Order List window and specify the orders to process. This option overrides any ranges you may have entered.

Note:  You can specify an order in stage 1 (entered); however, it is checked for a subset of the exception conditions that are applied to orders in stage 2 or 3. This includes the stage, order type, and order quantities, freight requirements, order approval, terms, serial/lot numbers, and bill to customers are not validated until the order progresses beyond stage 1.

Run For Ser(V)ice, (S)ales Order, (B)oth)?

This option applies to the Service Warranty module.

Specify V to print invoices and warranty claims for sales orders tied to active Service Repair Orders (SRO).

Specify S to print only sales orders that are not tied to SROs.

When a sales order line is tied to a Service Warranty SRO line that has a billable, internal, or remanufactured job code, the rebate is applied when the line is entered and recalculated during invoice processing. If the SRO line has a warranty job type, the rebate is removed from the line when the rebate is recalculated by the Sales Entry Invoice Processing Report because no rebate should be applied.

Create Stock Adjustments at Invoicing?

Select Yes and if the quantity on hand goes negative, a stock adjustment transaction is written to the internal ICET table to bring the quantity on hand back to zero when Sales Entry Invoice Processing Report is run. Stock adjustments are not actually made when you run the Sales Pre-Invoice Exceptions Report.

The next time physical count sheets are printed, this product automatically prints so you can recount the actual quantities. The quantity on hand should never go negative. If it does, it indicates there may be a problem with your counting routine or a product was added to stock but was never received in the system. The current date is added to the last stock out date on the product record and the stock available date is cleared. If the product is a build-on-demand kit, each component is updated in the same manner.

Automatic stock adjustments are not created during invoice processing when the Product Warehouse Product Setup On Hand amount does not cover the quantity for products with a reservation type of Against Receipts or Always. This situation occurs when inventory has been reserved from pending receipts that were never entered and updated in the system. An exception is created because the appropriate receiving functions must be updated prior to invoicing for inventory picked from pending receipts. After you complete the receiving update, you can invoice the order.

Select No to not make stock adjustments at invoicing. Product quantities are checked in Product Warehouse Product Setup, and if necessary, this message prints on the exception report: Stock Adjustment Needed, Make Proper Changes.

Delete Today’s Existing Exceptions?

Select Yes to delete any previous exceptions created if the Sales Pre-Invoice Exceptions Report was already run today (invoices reflect the current date). If you have already reviewed the invoice exceptions from a previous run of the Sales Pre-Invoice Exceptions Report and resolved their exception conditions, this removes all previously created exceptions so you do not review them again. Any previously created exceptions that still qualify as an exception (the exception condition was not resolved) are created again.

Select No if you ran the Sales Pre-Invoice Exceptions Report for the current day, but did not review and resolve any of the exceptions. This creates exceptions for any new sales order invoices created since the previous report was generated.