In Paragon, you can import and export files containing reference items or transactions. Here, we will show you how to make this task that much easier by exporting, editing, and re-importing inventory, thereby allowing you to complete mass adjustments.
From the Home screen, hit the settings button at the top right corner of the screen.
Now, from the 'Reports and Data' card, hit 'Export'.
A modal will pop up and you'll be prompted to choose what you would like to export. Here, we chose 'Inventory'. Once selected, hit the green Export button. Inventory will be exported by warehouse location.
You will be notified once your export is complete, and you can now open the Excel file relating to your inventory in Paragon. The Excel file will display column titles such as 'ItemID', 'Location ID', 'quantity', 'cost', 'reason' and 'EffectiveDate'.
Note that the inventory is shown by location. This means that the Excel file displays what is included in the 'History' tab of the inventory module in Paragon. Therefore, if you have a product with no inventory, and no adjustments made, the product will not show up on the Excel sheet.
From the Excel File, you can now edit the quantity of inventory, the cost per unit, and/or enter a reason code. Note that reason codes must match exactly to the ones you have already set up in your Paragon system. You can also enter a date in the effective date column if the date of the actual stock change is not the date that you are importing the inventory file into Paragon.
In this example, we are making an adjustment to a product that had no inventory (Item BLK-ROBO). We are therefore adding the product to the excel sheet, entering the location (warehouse) in which we would like the inventory to show, and adjusting the quantity. You can also add a unit cost, and reason code if need be.
It's important to note that the column headings must remain exactly the same when re-importing your inventory data.
Hit the settings button at the top right hand of the screen.
From the Settings screen, hit 'Import' from the Reports & Data card.
The Import modal with pop up and you will be prompted to choose what you would like to import. Here, we will choose inventory.
This step is only necessary if you selected to have journal entries generated for inventory. To verify this, access the settings page, then click on my company.
Then, click on the financials tab, and verify the setting for automatic journal. If not set to Financials & Inventory, go ahead and skip to step 6!
If you do have Financials & Inventory, in the import modal, you will have the option to either create one journal entry per item you modified, or one journal entry for all items.
The first option will create one journal entry for every inventory change the system detects in your file.
The second option will calculate the total value of the inventory changes in your file and create only one journal entry. This wiki gives more information about the creation of journal entries regarding stock adjustment.
Once chosen, hit 'select a file' and choose the updated Excel file. Once selected, hit 'upload'. The modal will notify you of the progress, and let you know if any of the rows failed to import properly, and if so, which row exactly.
Once the process is complete, hit the blue back button to get back to the settings screen. From there, you can select the inventory module, and see the changes to your inventory.
Navigate to the inventory module from the more button. Here, by hitting the History tab, we how our inventory was adjusted.