Batches

The Batches tab under Documents is where you enter one or more SQL statements, as well as the field that provides a list of possible batches that can be associated with a document. The Batches tab is visible for Document Type "Order" and "Shipment". This tab is only visible if the Batches Supported check box is checked for the Document. See Document Details for more information.

Enter one or more SQL statements in order to retrieve the Batch field. One of these must be the Key Provider, which is run first and determines the number of rows returned. The SQL statements on the Batches tab can use the following input parameters :

• Any fields from the Header tab
• Any fields from Company Fields tab

Here is an example of a Key Provider SQL :

SELECT BatchId FROM Batches WHERE (BatchType = 'O')

One SQL statement should define the field that will return the batch name chosen by the user. In this example, it is BatchID.

In StarShip, the Batch ID field displays on the user's source system-specific tab when shipping against a document for which Batches are enabled. The user can then select from a drop-down list populated by the Batch names. For subsequent shipments, the Batch ID field defaults to the previously used Batch Name, if available.

The selected batch is returned in the "Batch.BatchName" input field shown on the Documents > Write Back > Document tab.  You will then create a SQL Statement on that tab to write back the batch to the ERP interface document.  

See Batch Write-Back for more information.