TABLE OF CONTENTS




Users can create and maintain the customer orders in the system which supports multiple warehouses for customer order. The Customer Orders (CO) list contains the collection of all customer order lines. CO must be in this collection to be available from the drop-down list. The customer order states the item, the quantity demanded, due date for the order. The fields in the CO form are:

FIELDDESCRIPTION
Customer Order Header

CO Number

A CO Number uniquely identifies a customer order

Customer Code

Customer of the order

(Must exist in Customers master)

Address

Delivery address

Shipping ZonesIdentifies the shipping zone of the customer order

Notes

Remarks on the CO

Status

Open: CO line is still in process. Line is not completely shipped.

Completed: CO line fully shipped

Due Date

Target shipping date

Customer Order Line

CO Line

Customer order line number

Warehouse

Warehouse to ship from

(Must exist in Warehouses master)

Item

Item that is ordered by the customer

(Must exist in Items master)

Non Inv Item
Select this field for non-inventory item.  

Description

The Item Description field automatically populates based on the Item Number and becomes editable and compulsory when the Non-Inv Item checkbox is checked.

UOM

Order line item’s unit of measurement

(Must exist in UOMs master

and UOM Conversions master if is not an item’s base uom)

Status

Open: CO line is still in process. Line is not completely shipped.

Completed: CO line fully shipped

Due Date

Target shipping date of the line

Qty Ordered

Quantity of the item ordered

Qty RequiredTotal quantity remaining to fulfill the CO line. (Qty Ordered - Qty Shipped + Qty Returned) 
Qty AllocatedTotal quantity allocated from Allocation. 
Qty ShortageTotal quantity unallocate. (Qty Required - Qty Allocated)
Qty PickedTotal quantity picked. This field is updated by the CO picking and Pick List pick transaction from the mobile application.
Qty ShippedTotal quantity shipped. This field is updated by the CO Ship transaction from the mobile application.

Qty Returned

Total Quantity returned. This field is updated by the CO return transaction in the mobile application.


Add New Customer Order

Case: Adding a new Customer Order record.

1. In the Customer Orders List form, click the Add button.

2. Fill in all required fields.

3. Click the Add CO Line button to continue.

4. Fill in all required fields in the CO line.

5. Click the Save button to complete or click the Save& Add New Line button to add another CO line for the same CO.


Add New Customer Order Line

Case: Adding a new Customer Order line on an existing Customer Order.

1. In the Customer Orders List form, click the CO Number (highlighted in blue) which needed to add a new CO line.

2. In the View Customer Order form, click on the Add CO Line button.

3. Fill in all required fields in the CO line.

4. Click the Save button to save the CO line or click the Save & Add New Line button to add a CO line to an existing CO.


Edit Customer Order

Case: Editing an existing Customer Order.

1. In the Customer Orders List form, click the CO Number (highlighted in blue) to make modifications.

2. In the View Customer Order form, click on the Edit CO button.

3. In the Edit Customer Order form, update the fields you wish to change.

4. Click the Save button to complete the editing.


Edit Customer Order Line

Case: Editing an existing Customer Order Line.

1. In the Customer Orders List form or View Customer Order form, click the Edit button of the CO Line to make modifications.

2. In the Edit Customer Order Line form, update the fields you wish to change.

3. Click the Save button to complete the editing.


Delete Customer Order

Case: Deleting a Customer Order.

1. In the Customer Orders List form, click the CO Number (highlighted in blue) to delete.

2. In the View Customer Order form, click on the Delete CO button.

3. Click the Yes button to confirm the deletion, otherwise, click the Cancel button.


Delete Customer Order Line

Case: Deleting a Customer Order Line.

1. In the Customer Orders List form or View Customer Order form, tick the checkbox for the line you wish to delete.

2. Click on the Delete button.

3. Click the Yes button to confirm the deletion, otherwise, click the Cancel button.


Import Data From Excel Template

1. In the Customer Orders List form, click the Import button and select the Excel file to import.

Note: Visit here and download the file "04-Import Templates" to import data. Kindly refer to the Opening Balance Migration guide for the file importation rules and constraints.

2. Click on the Import button.

3. Ensure the success message is displayed at the top right. Users can check the status and log file from the Background Task.