Back Order Review
Exploring
When a customer orders goods for which you do not have enough stock, you can place the order in back order. You then need to follow up on these orders and take steps to replenish your stock.
This program lets you review sales orders that are on back order, and optionally create a supply to replenish the shortage.
Things you can do in this program include:
- View sales order lines which are in back order
- Create requisitions or purchase orders for bought out items
- Create jobs for made-in items
- Create supply chain transfers to transfer the required items from another of your warehouses
This program is accessed from the Program List of the Syspro menu:
- Program List > Sales Orders > Sales Order Processing
The Back order function in SYSPRO enables you to manage customer orders for items for which you have insufficient stock to satisfy the demand.
You can configure each customer to allow the entry of back order quantities when processing sales orders for the customer. You can also select whether to allow partial shipments for the customer, or whether the full order must be shipped.
Regardless of whether you select to release back orders automatically after you print an invoice or SCT document, the back order quantity remains in back order if:
- the order is hierarchical.
- the item is stocked and either the Requested and mandatory or Requested but optional packaging option is enabled. These lines must be manually shipped to ensure that packaging details are entered.
- multiple bins is in use for the warehouse against the order line.
- the item is traceable, ECC-controlled or serialized.
- the item is the parent or a component of a kit.
- there is insufficient stock and stock is not allowed to go negative.
| Module affected | Details |
|---|---|
|
Accounts Receivable |
You can configure each customer to allow the entry of back order quantities when processing sales orders for the customer. In addition, you can select whether to allow partial shipments for the customer, or whether the full order must be shipped. |
|
Sales Orders |
When processing a sales order for a stocked line where the order quantity exceeds the available stock on hand and stock is not allowed to go negative, the system enters the available stock in the ship quantity field and places the balance in the back order quantity field. When processing a sales order for non-stocked items where the order quantity exceeds the quantity you have entered in the ship quantity field, the system places the balance in the back order quantity field. You can configure the system to automatically display the Insufficient Stock window for the order shortage. This enables you to select an alternate stock item or to process a supply chain transfer for stocked items, or to create a purchase order, requisition or job for either stocked or non-stocked items. Alternatively, you can use the back order review to create purchase orders and requisitions for bought-out items; and jobs for made-in and subcontract items. By creating a purchase order, requisition or job that is linked to a sales order line, you ensure that when goods are received into stock the sales order line is updated automatically. You can configure the system to automatically move any remaining back order quantity to the ship quantity field after printing an invoice or SCT transfer document for a partial shipment. You use the Back Order Release program to manually release order lines that were placed on back order during sales order processing. Hierarchical orders and orders which are in suspense at the time of running the program are automatically excluded. You use the Import Back Order Releases program to release/update a batch of sales order lines by processing back order release information that is imported from an ASCII file. Although quantities are typically moved from the Back order field to the Ship quantity field on a sales order, you can indicate that quantities must move from the Ship quantity field to the Back order field. Several reports are available to assist you in monitoring order backlog. In addition, you can view back order information for sales order lines in the Sales Order Query, Sales Invoice Query, Dispatch Note Query and Customer Query programs. |
|
Bill of Materials |
If you select to run the Advanced Trial Kitting (Legacy) report using the sales order selection, then only sales order lines with a back order quantity greater than zero are included. |
|
RMA |
If you enable the Fix In-house option for an RMA receipt, then the system automatically creates a back ordered non-stocked sales order for returning the item to the customer once it has been repaired. You can also select to automatically put the order quantity into back order on the sales order you create when processing a cross shipment, or when processing an exchange on an RMA receipt. |
|
Requirements Planning |
When you run the Requirements Calculation program and select to include sales orders in requirements, then the demand quantity for each merchandise line is calculated by adding the ship and back order quantities and converting it to the stocking unit of measure. |
Buyers are individuals in a company responsible for identifying sources of supply and for purchasing products or services from these sources. Within SYSPRO, the buyer code assigned to a stock code indicates the person responsible for purchasing the item.
You typically assign buyers to stock codes when you have more than one person in the company responsible for purchasing products or services.
Buyers can be used as a selection criterion in a number of SYSPRO reports.
You assign buyer codes to bought-out stock items using the Stock Code Maintenance program.
Within SYSPRO a job is equivalent to a works order. Against each job you record what material is required and what operations/instructions must be performed to complete/convert the raw materials into the finished product.
Within SYSPRO, a non-stocked code is allocated to an inventory item that you don't stock in any of your warehouses.
Non-stocked codes are created using the Non-stocked Codes program. They are used in the Quotations module to uniquely identify items that can be used within the Quotations and Estimates programs.
Non-stocked codes created using the Non-stocked Codes program can be converted into stocked codes if the New stock code in non-stocked table setup option is enabled (Setup Options > Preferences > Distribution > Inventory).
A planner is a person who is responsible for ensuring that all the details relating to a specific event (or project) are catered for so that the event takes place on time and without incident. Within SYSPRO, a planner indicates the person in a company responsible for planning the manufacture of made-in stock items.
You would assign planners to stock codes when you have more than one person in the company who is responsible for planning the manufacture of made-in stock items.
Planners can be used as a selection criterion in a number of SYSPRO reports.
You maintain planners using the Planners program.
You assign planner codes to made-in stock items using the Stock Code Maintenance program.
A purchase order is the document used to define the details of a product or service provided by a seller to a buyer. It becomes a temporary legal contract to buy products or services once the seller accepts it.
Once the need for goods or services is identified and the pre-purchase activities (e.g. requisitioning, supplier sourcing and price negotiation) are complete, a purchase order for the goods is placed with the relevant supplier.
When the need for goods or services is identified from either sales, production or another area of the business, a purchase requisition for the goods is created.
The person who creates a new requisition is regarded as the originator of the requisition. Although the initial requisition information does not have to be correct (the originator might not be aware of stock codes, order quantity contracts, etc) it must, however, be corrected by subsequent users before the requisition can be confirmed.
When a requisition is approved, the requisition user who approved the requisition can change it. However, once the approved requisition is routed, it can no longer be changed. It has to be routed back to the approver to either change it or to un-approve it so that the required changes can be made.
Once the requisition is approved and all other pre-purchase activities (such as supplier sourcing and price negotiation) are complete, a purchase order for the goods is placed with the relevant supplier.
A stock code is a number that uniquely identifies an inventory item that is bought or manufactured and which is typically stored in one or more warehouses.
All activity relating to the forecasting, purchasing, manufacturing, stocking and selling of a stocked item is tracked by means of the stock code.
A stock code can be linked to one or more lot numbers if the item is defined as lot traceable. If there is a warranty, the stock code can be defined as serialized and linked to one or more serial numbers.
If the Bill of Materials module is installed, stocked items may be linked in a parent/component relationship for use in Work In Progress and Sales Orders (Kit sales).
You can use the stock code as a selection criterion when generating reports.
You maintain stock codes using the Stock Code Maintenance program.
In SYSPRO this refers to an order type that is processed using the Sales Order Entry program.
SCT orders enable you to transfer stock between your warehouses at the current inventory cost of the stock (always in your local currency).
Stock is allocated immediately and can then be physically transferred at a later date. This lets you reserve stock to be transferred to another warehouse.
Items to be transferred can be placed on backorder.
You can optionally print an order acknowledgment and delivery note for an SCT order type.
Although only stocked merchandise lines and comment lines can be captured for a SCT order, the transfer cost multiplier assigned to the stock code/warehouse lets you include transport costs at the receiving (target) warehouse.
A transfer reference number is allocated (or entered, if you indicated that goods in transit references must be generated manually) at the time of releasing the SCT to a status 8 - To Transfer.
Although similar to inter-branch transfers, SCTs don't require the capture of customer details.
Within the Requirements Planning system, SCT orders are treated as both a supply and a demand and the system takes into account any items that are part of a warehouse transfer awaiting receipt at the target warehouse.
Within SYSPRO, a warehouse represents an actual warehouse containing your inventory items (i.e. a physical warehouse) or a grouping of your inventory according to specific characteristics of the item (i.e. a logical warehouse).
For example:
You may want to split your inventory raw materials and finished goods into different logical warehouses even though they are located in the same physical warehouse.
You maintain warehouses using the Warehouse Maintenance program.
Starting
You can restrict operator access to programs by assigning them to groups and applying access control against the group (configured using the Operator Groups program).
The following configuration options in Syspro may affect processing within this program or feature, including whether certain fields and options are accessible.
The Setup Options program lets you configure how Syspro behaves across all modules. These settings can affect processing within this program.
Setup Options > Configuration > Distribution > Dispatch Notes
- Manual release to invoice
Setup Options > Configuration > Distribution > Inventory
- Multiple bins
Setup Options > Preferences > Distribution > Sales Orders
- Cancel open order previously invoiced
- Back orders
- Auto insert sales order additional text
- Auto insert dangerous goods text
The following items are ignored and excluded from the review:
- Hierarchical orders
- Order lines with a status of S - In suspense
- Order lines for sales orders in a D - Draft status. A draft order commits no stock and has no back-order quantities until it is released to an active status, so it is excluded from the review.
- Scheduled order lines if they have not yet been allocated
When a job is linked to a sales order (i.e. you created a job for a particular sales order and a valid link between the job and the sales order exists) then:
-
while the job is not marked as Complete, the sales order is not displayed in the review.
Jobs are not set to complete against sales order lines when the Job complete retain link to sales order setup option is enabled. Therefore, these sales order lines are not included in the Back Order Review program. -
when you process a receipt for the job and you mark the job as Complete, the following can occur:
-
If the quantity is enough to satisfy the entire back order quantity required, then the quantity is issued to the sales order. The back order quantity is moved to the ship field on the sales order and the order is not displayed in the review.
-
If the quantity does not satisfy the entire back order quantity required, then the sales order is displayed in the review.
-
If the quantity is receipted into a bin which is on hold, then the quantity is not issued to the sales order and the sales order is not displayed in the review.
-
If you changed the warehouse on the job and did not select to update the sales order as well, then the quantity is not issued to the sales order as it is receipted into a different warehouse. The sales order remains on back order, but is not displayed in the review.
-
Solving
You can only create a job for a back order line under the following circumstances:
- The sales order line does not already have a job attached to it
- The sales order line is not an inter-branch transfer, debit note or credit note
-
The sales order is in one of the following statuses:
- 1 - Open order line
- 2 - Open back order line
- 3 - Released back order line
- 4 - Line in warehouse
You cannot create a requisition if the Allow creation from sales order review option is not enabled against your requisition user code in the Requisition Users program.
When you reject a line in the Back Order Review program, the system inserts a D into the review field (i.e. MReviewFlag) of the SorDetail table and will exclude the line from future reviews unless you select the option to include previously rejected lines.
When creating a job from within the Back Order Review program, any Job narrations and any sales order additional text (i.e. Sales Order Add. Text) defined against the stock code are automatically added to the job which is created.
To prevent the sales order additional text defined against the stock code from being added to the job, you need to disable the Auto insert dangerous goods text and Auto insert sales order additional text setup options (Setup Options > Preferences > Distribution > Sales Orders).
Using
Following the entry of a sales order document into the system, a status code is assigned to the order header indicating its progress within the system.
The status code held against an order determines which functions can be performed at that point, particularly during maintenance and printing.
The current order status is stored in the SorMaster table.
The status may also be stored in the SorMasterRep table, but may not be the same as the status in the SorMaster table.
For example:
For an SCT order, the status in the SorMasterRep table is the order status at the time of performing the transfer, whereas the order status in SorMaster is the current status.
The following are the possible statuses that can be assigned to a sales order header:
| Status | Description |
|---|---|
| 0 - Order in process |
The entered order is currently being maintained by another user or the End order function was not performed (e.g. a power failure occurred during the entry or maintenance of an order). This status can be reset to the previous status using the Order Maintenance function. |
| 1 - Open order line |
An order has been entered into the system. A delivery note must be printed before the order can be released for invoicing. Next status: 4 - In warehouse The following actions place an order into a status of 4 - In warehouse:
|
| 2 - Open back order |
An order or billing contains lines which could not be shipped owing to a stock shortage. The order or billing may have been partially invoiced, but there are remaining lines on back order. Releases for a Blanket Sales Order have been accepted. An order or billing has to pass through the invoicing process at least once to become an open order. You can cancel an order that is in a status 2 - Open back order providing that the order has been partially invoiced and the Cancel open order previously invoiced setup option is enabled (Setup Options > Preferences > Distribution > Sales Orders). Your configuration of the Back orders setup option affects how this status is updated (Setup Options > Preferences > Distribution > Sales Orders):
Next status:
|
| 3 - Released back order |
An open back order now has items to be shipped and has been released for delivery note printing. Billings are released into status 8 - To invoice, not status 3 - Released back order. The next delivery note print will produce a delivery note document. Your configuration of the Back orders setup option affects how this status is updated (Setup Options > Preferences > Distribution > Sales Orders):
Next status: 4 - In warehouse |
| 4 - In warehouse |
A delivery note has been printed for an open order or a released back order. Next status: 8 - To invoice |
| 8 - To invoice |
A billing has been entered. A back ordered billing has been released. An order in the warehouse has been released. Next status:
|
| 8 - To transfer |
A Supply Chain Transfer order has been entered. Next status: 9 - Complete |
| F - Forward order |
The order is indefinite and must be released before it is processed as a normal order. Next status: 1 - Open order line When releasing a Forward order, the quantity is placed in back order when any of the following are true:
|
| S - In suspense |
An order or billing has failed credit checking. An order or billing has been placed on hold. Next status: The order reverts to the status in process (0 - Order in process) prior to the order being suspended. |
| 9 - Complete |
A sales order has been fully invoiced and will be removed from file when the Order Purge program is run. When a Blanket Sales Order is complete in terms of invoicing, it is set to a status of S - In suspense while waiting for the next release. It is not set to a status of 9 - Complete. |
| * Cancelled |
An order was canceled during entry (i.e. before it was completely entered into the system) and will be removed from the file when the Order Purge program is run. |
| \ Cancelled |
An order was canceled prior to invoicing and will be removed from the file when the Order Purge program is run. |
| R - Released to picking |
Indicates that an order has been released to picking. An open order (status 1 - Open order line) which contains lines for picking, would typically move to a status R - Released to picking and then P - In picking. Sales orders can only be invoiced when the picking cycle has been completed. |
| P - In picking |
Indicates that the order is currently within the picking process. Once picking has completed, the order would return to a status 1 - Open order line, therefore enabling you to add additional lines if required, or proceed to the next required stage. |
|
D - Draft |
An order is held for validation and approval before it can be processed. Orders are created in this status when the Place orders in draft status setup option is enabled to place sales orders in draft on creation. The AI Sales Order Rules Engine agent evaluate the order and flags any errors and warnings, which you correct or accept in Draft Order Review.
You can release an order to status 1 - Open order line, 2 - Open back order line or 8 - Line ready to invoice only once it has no outstanding errors and any warnings have been accepted with a reason. While an order is in D - Draft, no stock is committed and the order is excluded from credit checking and demand planning. |
The line status allocated to an order line is used primarily in the Warehouse Management System.
The line status can be displayed in the Order Line Status pane of the Sales Order Entry program by right clicking in the pane, selecting the Show Captions option and dragging the Line status caption onto the form.
The line status can also be displayed in the Detail Lineslistview of the Sales Order Query program by right clicking in a listviewcolumn heading, selecting the Field Chooser option and dragging the Line status field onto the listview.
The following are the possible status codes that can be assigned to an order line:
| Status | Description |
|---|---|
| 8 - Line ready to invoice |
Indicates one of the following:
|
| C - Complete |
Indicates that the order line was set to 'Complete' by the operator. |
| P - In picking |
Indicates that picking is currently in progress for the order line. |
| R - Released to picking |
Indicates that an order line has been released to picking. |
| K - Picking complete |
Indicates that picking has completed for the order line. |
The following program(s) and business object(s) currently manipulate or consider the line status:
-
Release Reserved Stock
Sets the line to a status of 8 - Line ready to invoice after the stock is released.
-
Columns in a listview are sometimes hidden by default. You can reinstate them using the Field Chooser option from the context-sensitive menu (displayed by right-clicking a header column header in the listview). Select and drag the required column to a position in the listview header.
-
Fields on a pane are sometimes removed by default. You can reinstate them using the Field Selector option from the context-sensitive menu (displayed by right-clicking any field in the pane). Select and drag the required fields onto the pane.
The captions for fields are also sometimes hidden. You can select the Show Captions option from the context-sensitive menu to see a list of them. Click on the relevant caption to reinstate it to the form.
If the Show Captions option is grayed out, it means no captions are hidden for that form.
-
Press Ctrl+F1 within a listview or form to view a complete list of functions available.
Referencing
| Field | Description |
|---|---|
|
Start Review |
Select this to accept your Review Criteria selections and display the data accordingly. This option is enabled when you initially access the program but, thereafter, is only re-enabled when you select the Change Criteria option. The stock items matching the options you selected are displayed in the SO Back Order Review listview. |
| Change Criteria |
Select this to change the previously selected review criteria. This function is only enabled after you select the Start Review function. |
| Field | Description |
|---|---|
|
Ship dates |
Indicate the ship date(s) for which to include back order lines. |
|
Stock codes |
Indicate the stock code(s) for which to include back order lines. |
|
Warehouses |
Indicate a range of warehouses for which to include back order lines. If a specific warehouse is entered, then only sales orders containing at least one order line for that warehouse are included. |
|
Sales orders |
Indicate the sales order(s) for which to include back order lines. |
|
Buyers |
Indicate the buyer(s) for which to include back order lines. This filters the stock codes according to the buyer defined against the stock code in the Stock Code Maintenance program. If a single buyer is selected, then non-stocked items are excluded by default, but can be included using the Non-stocked items selection option. |
|
Suppliers |
Indicate the supplier(s) for which to include back order lines. |
|
Planners |
Indicate the planner(s) for which to include back order lines. This filters the stock codes according to the planner set up against the stock code in the Stock Code Maintenance program. If a single planner is selected, then non-stocked items are excluded by default, but can be included using the Non-stocked items selection option. |
|
Include / exclude options |
|
|
Include previously rejected lines |
Enable this option to include lines that were previously rejected in the review. |
|
Include lines with canceled items |
Enable this option to include lines that contain canceled items in the review. For example: You created a job using the Back Order Review program and then deleted the job. The sales order line with the deleted job is then only included in the back order review if this option is enabled. |
|
Include made-in, subcontracted, kit items |
Enable this option to include made-in, subcontracted and kit items in the review. This only applies if the Work in Progress module is installed. |
|
Include bought out items |
Enable this option to include any bought out items in the review. This only applies if the Purchase Orders module is installed. |
|
Include counter sales in status 8 |
Enable this option to include any counter sales items that are in a status of 8 - To invoice in the review (this excludes normal orders in a status of 8 - To invoice). |
|
Include billings in status 8 |
Enable this option to include any back order items that are attached to a status 8 - To invoice billing in the review (this excludes normal orders in a status of 8 - To invoice). This does not include normal orders in a status 8 - To invoice. |
|
Non-stocked items |
Indicate your preference for non-stocked items in the review: Include non-stocked items in the review. Exclude non-stocked items from the review. Display only non-stocked items in the review. |
|
Preferences |
|
|
Copy attached comment lines to PO |
Enable this option for the ability to copy comment lines attached to a sales order merchandise line to the purchase order created for that sales order line. This enables you to duplicate information captured against the sales order line on the purchase order. |
|
Allow SCT for non transfer-supplied wh |
Enable this option to allow the creation of supply chain transfers for warehouses that have not been configured as transfer-supplied. |
|
Remove processed lines |
Enable this option to remove all processed lines which have a purchase order or job allocated to them. Enabling this option improves performance as it results in only the relevant information being loaded. |
The pane displays the sales order lines according to the criteria indicated at the SO Back Order Review Criteria pane.
We have only listed the fields that require additional information.
This lets you alternate between rejecting and reinstating a line.
The highlighted line is either reinstated or rejected depending on its status when you select this function.
This function can be used in conjunction with the option to Include previously rejected lines (SO Back Order Review Criteria pane).
This lets you create one of the following supply requests for the highlighted line:
-
A job for made-in or subcontracted parts.
By creating a job that is linked to a sales order line, you ensure that when goods are received into stock the sales order line is updated automatically.
When you create a job for a kit component, the job is created using allocations from bill of materials.
-
A requisition or purchase order for bought-out items.
By creating requisitions you ensure that the sales order for which the purchase order was created is updated automatically when the purchase order is receipted in. This prevents the stock from inadvertently being sold to someone else.
-
A supply chain transfer from the sales order line.
This lets you view when the stock item is available to be sold using the Inventory ATP Query program.
ATP stands for Available to Promise.
This lets you view more information about the sales order line using the SO Browse on SO Lines program.
| Field | Description |
|---|---|
|
Status |
This indicates the status of the sales order line. If a Canceled entry appears in the Status column, then it indicates that a purchase order was created for the line and the purchase order was then deleted. A Rejected entry will appear in the Status column if you used the Reject/Reinstate function to reject the line. |
|
Alternate stock |
The text Alternate stock available is displayed in this column if alternate stock codes exist for the sales order line and the following setup options are enabled:
|
This screen is displayed when you select the Create Job /P Order / SCT function.
| Field | Description |
|---|---|
|
Accept |
This lets you accept your selections and enter information required to create the relevant SCT, purchase order, requisition or job. |
|
Cancel |
Select this to return to the listview. |
|
Supply to create |
Indicate the type of supply that you want to create: Create a purchase order for the selected sales order line using the PO Creation program. The customer's purchase order number is inserted on the purchase order, if it is defined against the sales order. You cannot create a purchase order for a supplier who is on hold. Create a purchase order requisition for the selected sales order line using the Requisition Entry program. Create a supply chain transfer for the selected sales order line using the SO Supply Chain Transfer Creationprogram. Create a job for the selected sales order line using the Job Entry program. |
|
Requisition user |
Indicate the user code to use for creating a requisition. This user code must have the Allow creation from sales order review option enabled in the Requisition Users program. |
Copyright © 2026 Syspro PTY Ltd.