integration:coms

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
integration:coms [2026/09/25 15:59] – [Shipment files] Gary Willettsintegration:coms [2026/09/30 10:19] (current) – [Pick lists] Gary Willetts
Line 55: Line 55:
 These files are retrieved from the remote SFTP server according to the schedule. A single file can contain multiple shipments but the rows for a shipment will always be grouped together. Depending on the identity of the source and destination store, a single shipment will either be turned into a supplier invoice (to receive stock) or a stock transfer customer invoice (to send stock to another store). These files are retrieved from the remote SFTP server according to the schedule. A single file can contain multiple shipments but the rows for a shipment will always be grouped together. Depending on the identity of the source and destination store, a single shipment will either be turned into a supplier invoice (to receive stock) or a stock transfer customer invoice (to send stock to another store).
  
-Shipments are created as customer invoices with placeholder lines. They are created in the correct store by matching the supplier code and program of a shipment in the shipment file to the entries made in the  table in the settings (see the  section above).+Shipments are created as customer invoices with placeholder lines. They are created in the correct store by matching the supplier code and program of a shipment in the shipment file to the entries made in the **COMS site Code/Description and Store code table** table in the settings (see the [[coms#setup|Setup]] section above).
  
 The shipment ID is stored in the **Their ref** field of each customer invoice created. The shipment ID is stored in the **Their ref** field of each customer invoice created.
Line 70: Line 70:
  
 ==== Pick lists ==== ==== Pick lists ====
-On finalisation of a customer invoice (carried out on one of the satellites), a pick list file needs to be created on the server. To do this, on customer invoice finalisation a sync message (type 'axiosRequestFilesCreate') is sent to the server. That message is processed by the sync queue and turned into a pick list file which is stored locally to await upload to the remote SFTP server according to the schedule.+On finalisation of a customer invoice, a pick list file is created on the server and sent to NHLMIS. To do this, on customer invoice finalisation a sync message (type 'axiosRequestFilesCreate') is sent to the server. That message is processed by the sync queue and turned into a pick list file which is stored locally to await upload to the remote SFTP server according to the schedule. 
 + 
 +The pick list files generated by mSupply have the filename format: ''Axios.PickList//ddmmyyyyhhmmss//ONE-S-//shipment Id//-//random number//.csv.ready'' 
 + 
 +where: 
 +  * ''//ddmmyyyyhhmmss//'' is the date and time the file was created 
 +  * ''//shipment Id//'' is the ID of the shipment sent from the One Network that this pick list belongs to 
 +  * ''//random number//'' is a 5 digit random number 
 + 
 +An example is: ''Axios.PickList26072019155745ONE-S-15049-30604.csv.ready''
  
 === Pick list detail === === Pick list detail ===
Line 78: Line 87:
 There are 4 types of files that are sent automatically once a day at the time set in the preferences. They are: There are 4 types of files that are sent automatically once a day at the time set in the preferences. They are:
  
-1. Lot file (filename Axios.Lotddmmyyyy.csv.ready) +1. **Lot file** (filename Axios.//site_code//.Lot//ddmmyyyy//.csv.ready): Contains a line for each unique batch in stock in the site (main store plus secondary store).
-Contains a line for each unique batch in stock in the site (main store plus secondary store). +
- +
-2. Inventory file (filename ) +
  
-3. Buffer file (filename )+2. **Inventory file** (filename Axios.//site_code//.Inventory//ddmmyyyy//.csv.ready): Contains a line for each line of stock which is not on hold and is assigned a funder (transaction category with a code assigned to the supplier invoice the stock was received on).
  
 +3. **Buffer file** (filename Axiois.//site_code//.Buffer//ddmmyyyy//.csv.ready): Contains a line for each unique batch which has stock for each item for each funder (transaction category with a code assigned to the supplier invoice the stock was received on) which is not on hold. Batches with no funder are ignored.
  
-4. BOH file (filename )+4. **BOH file** (filename Axios.//site_code//.BOH//ddmmyyyy//.csv.ready): Contains the same lines as the Buffer file but with different information for each line.
  
 +A set of all 4 files is created for each row in the **COMS site Code/Description and Store code** table in the preferences. All the files are csv type and are created at the same time. The BOH and Buffer files for all sites are sent immediately but the Lot and inventory files are sent after the delay time ("**Time (from creation) to wait before uploading inventory files**") set in the preferences.
 ===== Filenames ===== ===== Filenames =====
 ==== Pick lists ==== ==== Pick lists ====
  • Last modified: 2026/09/25 15:59
  • by Gary Willetts