Order and Shipment files

Order and Shipment files

Many aspects of the features/workflows on this page do not reflect what is currently implemented in OpenLMIS 3.

 

Orders

Shipment

Gliffy Diagram is only supported by the cloud editor

Because Forge macros arent supported by the legacy editor, you'll need to convert this content to the cloud editor to display this macro properly. Find out more about converting to the cloud editor

 

The following diagram depicts the activities associated with creating an order from an approved requisition (converting a requisition to an order) from the user's perspective.

Use Case 1: happy path - send an order file via FTP transfer with only one warehouse available for external fulfillment

Use Case 2: happy path - send an order file via FTP transfer when multiple warehouses are available for external fulfillment

Use Case 3: edge case - print out an order file to send manually for external fulfillment

Gliffy Diagram is only supported by the cloud editor

Because Forge macros arent supported by the legacy editor, you'll need to convert this content to the cloud editor to display this macro properly. Find out more about converting to the cloud editor

 

Order file

Order File format

Fields

Labels

Fields

Labels

Order Number

Order Number

Facility Code

Facility Code

Product Code

Product Code

Quantity Ordered

Quantity Ordered

Pack Size

Pack Size

Order file Name

Order file is generate with name ‘O’ + order number.csv

Validations

  1. One order file generated per Requisition

  2. Quantity Ordered = Packs to ship

  3. Any product with Quantity Ordered as zero is excluded from the file

  4. If Quantity Ordered for all product in an order is zero no file is generated

Still to play

  1. Genarting order file and placing it on configured FTP server

  2. Logic to place file as per supplying depot

Shipment file

Shipment File format

Fields

Labels

Mandatory?

Order Number

Order Number

Y

Product Code

Product Code

Y

Quantity Shipped

Quantity Shipped

Y

 

Shipment file Name

Any file with .csv extension is Picked up for processing from configured folder

Validations

  1. One Shipment file can accept multiple orders

  2. If any order has error, complete file is errored out

  3. Any other columns in shipment file are ignored

  4. Mandatory fields required for success processing

  5. Valid Order number, Product code is checked

  6. Quantity Shipped – If decimal,is trimmed to Integer and accepted

  7. File with duplicate entry of order number and product code combination – Accept the last entry

Architecture and User flow

OpenLMIS: the global initiative for powerful LMIS software