Hi,

I have been trying to setup Inventory however, i have completed the first stage by importing all my data fields from excel...i now need to insert prices and quantity as at my last stock count date....i have a problem as i am not quite sure how to do this.....i created a new file where i just selected the item code and the price and when i tired to import it to adagio it came back with error message saying it wasnt the correct format...could you please give some quidance on how this is done.Thanks

If you get an error that a file doesn't have the correct format, it means your import template does not match the import file. The best way to correct this is to open your import file and note each column/field. Then open the Import function and the Field Selection screen, and make sure that the selected fields on the right side are identical to your import file.

If you are starting your inventory setup from scratch, the Import Items function is best for setting up default prices and most recent cost and most other information except quantities. The Import Physical Inventory or Import Adjustments (quantity and cost) is probably the quickest way to set up the quantity and inventory costs.

Thanks for the information...however, i am not sure if should now erase what i have already done and start from scratch.....so far i have imported the stock codes and description of the stock for all departments.....but i dont have any prices etc....are your suggesting i get rid of this and select the option to import physical inventory?

If you haven't posted any transactions yet, there is no problem in setting the 'Overwrite' option on the import template, making sure the template and file matches, and re-import your item list over top of whatever you have. Any differences (like prices) will be over-written. You need to import items to write the prices.

The suggestion to use Import Physical Inventory or Import Adjustments is for updating the quantities on hand for each location.