I printed the physical inventory worksheets in IC 8.1D and we are now counting. When we are done, I plan on importing the new counts and "Posting Inventory Reconciliation". I just realized that I probably should have done the day end before printing the physical inventory worksheets. Is it okay to do the day end now? Will the "ship not costed" in OE and "receipts not costed" in PO cause a problem? Should I reprint the physical inventory worksheets after I run the day end in OE and POA? Or should I post the physical inventory first then run the day end? Please let me know ASAP. Thank-you.

Hi Softrak Support,

If you have a chance to answer this today, I would really appreciate it!

Thanks,

Hi Susan,

You want to do an End of Day on the data that matches your cutoff for your inventory count. Then you rerun your Print Physical Inventory Worksheet, but don't print out a hard copy. Make sure you create your adjustment work file. This is key. This set of files (several) effectively freezes your inventory and is the basis to load your counted details into Inventory.

You can copy and paste this workfile into any dataset and it sounds like you will want to do that so that the quantity reported on hand (after the End of Day) will be the correct cutoff for your entered quantities and potential adjustments of count discrepancies. It's possible that you may need to copy into your live data but need more details.

Normally we would suggest that all count sheet be entered into Excel, with the on hand quantities compared to Counted quantities based upon the stocking unit of measure. That being done, you can complete any variance analysis before loading the quantities into Adagio Inventory, in your XLS.

Your Count sheet in XLS is normally created easily using Gridview to query your Inventory Adjustment file. This XLS count sheet is an effective freeze of inventory that can be imported easily into Adagio Inventory instead of manually rekeying all of the counted data. The beauty of this process is that you can load (import) the inventory count details after you have validated the count details with recounts and variance analysis, and continue shipping and receiving because the loaded count details will adjust the inventory quantities effective the date of the count.

It is a sweet process for an efficient inventory count. We don't know anyone that still manually keys inventory quantities for physical count details into Adagio Inventory given that you can import using this method. Talk to your Adagio consultant. I'm sure they can assist.

Best,
Brian

Hi Brian,

Thanks for the info. We use a similar process to what you describe. We do a day end first, then create the work file. Once our count is done we enter the quantities in excel and import the physical inventory worksheet, check the reconciliation report, then post the inventory reconciliation. My concern this time was that I forgot to do the day end first and so I had a number of "shipped not costed" and "received not costed" in OE and PO. I figured this would throw off the cost used on the adjustments for the affected items. So, since I knew that we hadn't made any changes in IC (i.e. added or deleted item codes or changed any quantities), I did the day end and re-created the work file. I think I'm good to go now and the spreadsheets I originally created for data entry will still match the new work file.

Really appreciate your input and ideas.