You can easily upload warehouse information by importing initial inventory information even if these items correspond to more than one batch, accelerating your processes by importing .csv - comma separated values - files . This process can be performed on Inventory Adjustment window and here we will show you how it works:
Go to Inventory Adjustment window and click on Create new record to generate a new file.
You will be taken to a new window where you must fill the order detail, there you must:
Fill Header information, don't forget to enter mandatory fields before saving: Motion Date, Warehouse.
Save.
A record number will be assigned, this record number must be copied and then entered on first column of your excel file (see column order below).
Generate csv file (see video example)
Now, back on your browser, click context menu and Import.
Click on select file to upload, then browse and choose your csv file name. Confirm by clicking Upload.
Your values will be imported as a list, now use the arrows to validate their breakdown of information and Confirm.
Now you must confirm their locator (warehouse), click accept.
To finish this process, click context menu and select Complete. Then confirm.
Notes:
If your csv file containes batches information for a batch that does not exist, it will be automatically created, see more here.
Products must have the Lot box checked in Charge Master II in order to perfom lots usage:
3. The current column order goes as follows:
[Document No]
[Warehouse Key]
[Product Key]
[Product Name]
[Locator Key]
[Lot No]
[Quantity count Pack]
[c_uom_value]
[Quantity Count]
[UOM Value]
[Guarantee Date]
We hope this improves your Cirrus experience. Remember to share this information and ask for help if you need it.
Date: July 21, 2022