| Both sides previous revision Previous revision Next revision | Previous revision |
| integration:coms [2026/09/30 09:59] – [Automatically sending inventory and buffer files] Gary Willetts | integration:coms [2026/09/30 10:19] (current) – [Pick lists] Gary Willetts |
|---|
| |
| ==== Pick lists ==== | ==== Pick lists ==== |
| On finalisation of a customer invoice), 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 === |
| 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.//site_code//.Lot//ddmmyyyy//.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 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) | 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 Axios.//site_code//.BOH//ddmmyyyy//.csv.ready) | 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. |
| |
| All 4 csv files are created at the same time. The BOH and Buffer files 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. | 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 ==== |