The Batch Processing option of EBMS allows the user to query a batch of sales orders. The Batch Processing dialog can be used to process and print sales invoices in a single batch rather than processing sales invoices individually. The batch process module allows the user to configure user defined queries to list and select the invoices that should be processed.
Launch the Batch Processing module by selecting Sales > Batch Processing from the main EBMS menu to open the following list:
Select the desired Query to list the sales orders that are to be processed. If this query does not exist, complete the following steps to create the Special Orders on Sales Orders query.
Click on the Queries button to open the query list as shown below:
Click on the Add Query button to create a new query or sales order group. The following dialog will open:
Enter a short description as the query Id and click the OK button.
Enter a Query Description.
Click on one of the query buttons since the sales orders can be queried based on information from 3 different databases:
The Customer Query will query the Customer record - If the query based on the customer record is true than ALL sales orders for the specific customers will be listed.
The Sales Order Query will query the sales order header file (ARINV.DBF) - Most queries will be based on this file. Queries based on the ship date, Ship Via setting, sales person, invoice date, etc are common batch processing queries.
The S.O. Detail Query will query the sales order detail file (ARINVDET.DBF) - If any of the query for any details lines of the sales order are true the sales order will be listed. For example, a query can be created that will list all sales orders that contain a specific inventory item.
Some query examples:
Do not set any query settings to list all sales orders
The following sales order query will list all SOs that have a Ship Via setting that equals Northern. This query setting is common to group sales orders based on a delivery truck or route
The following sales order query is used to list all sales orders from the e-commerce module:
Set the following advanced sales order query to list all sales orders with a Ship Date that equals today's date
The Following Sales Order Query to list all sales orders that contain the inventory item - LABOR:
Click OK to save the query. Click OK to save the Special Orders query. Repeat for any other new Query options.
Click the Close button to return to the query list.
Select the appropriate query.
Select the sales orders that you wish to process by clicking on the Process column to enable the check mark. Use the Select All or Unselect All buttons to select all or remove all the selection check marks.
Click on a sales order record and click on the View Sales Order button to view a highlighted sales order.
Click on the Process button to process all the invoices that are selected. The following dialog will appear:
Set the invoice date and click OK.
Review the Sales > Invoices > Processing a Sales Order section for more details on invoice processing.
Reports can be added to the Print button to print a packing list, sales order, or other form for the entire list. Review the Reports > Print Button section for more details.