Jeff:
Your reply addresses a question we have been trying to resolve regarding physical counts, how they post and how the variances are adjusted and posted.
As you note, when the physical count is created each item record receives a time stamp (CountTime) along with the current RMS on hand quantity (QuantityRefreshed) in the PhysicalInventoryEntry table.
Ideally the on hand quantity (QuantityRefreshed) is a "frozen" value upon which adjustments will be made regardless of any inventory transactions (sales, receivings, transfers, etc) that may occur between the time that the PhysicalInventoryEntry table was created and the time that the actual counts are posted. If this is the case then inventory adjustments resulting from the count will post against the "frozen" quantities and not the current computer on hand quantites.
Do you know "for certain" which quantity is used for posting?
If the adjustments are made against the frozen quantities based on the time stamp at creation and the later time when the physical count is posted then the business can be resumed between the completion of the count and the eventual posting - and the adjustments will be correct for the point in time when they were created.
This is the Holy Grail question about physical counts. It seems that every POS/inventory management program handles this differently and it is necessary to fully understand how these adjustments are handled.
Thanks for your input.
Aloha, Miles
Pacific Computer Systems Miles Baidack snipped-for-privacy@pacificcomp.biz
Supporting Business Since 1985 Phone: (808)395-8156 or (808)277-8156
"Jeff @ Check Po > Michelle, > > Natively, RMS takes into account the time the items were counted and > adjusts appropriately. > > If your scanner has the option to record the time when scanned, you can > import that into the PI. > > Otherwise, after you import your scans, if you right click on the body of > the items in the PI, you can turn on the Counted Date column and modify > the counted time and date. > > When RMS commits the items, it adjusts based on the time counted. > > -- > > Jeff > Check Point Software >