Hi, We are trying to find a report that will allow us to see Item Costs from a specific point in time. For example, we would like to know what the cost was for specific items as of 12/31/09 vs. what the cost was of these same items as of 1/31/10 and so on. Any help would be greatly appreciated. Thanks.
memorize the item movement history report how you want it, then edit in notepad from the folder C:\Program Files\Microsoft Retail Management System\Headquarters\Reports
Add this line to the first SELECT section: InventoryTransferLog.Cost AS Cost,
Add this line to the second SELECT section: TransactionEntry.Cost AS Cost,
Add this column to the end of the report: Begin Column FieldName = "ViewItemMovement.Cost" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "Item Cost" VBDataType = vbDouble Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1080 GroupMethod = groupmethodNone ColFormat = "#.##" End Column
Hi Matt: Thanks for the prompt response. Would this report be run from HQ or at the BO level? Also, what if we have several items that haven't moved during a specified time period but we still need to see what it's cost was during that same time? Thanks! Tracylee
Actually I answered the 1st question...obviously from HQ!! I also determined my 2nd question doesn't matter so you can ignore it. I do have another question though: Is there a way to also capture the Quantity on Hand prior to the item movement? Thanks so much for your help. Tracylee
Historical quantity is more dificult to determine, because it's not kept in any tables. The way to figure it out, is to use the current quantity and add/subtract any changes from that time. The best way to do this for a single item, is to again use the item movement history report for the item and date, then use the summary total to combine with the item's current QOH.
Got it. Thank you again...you have been a huge help! The accountant is extremely happy with the memorized report showing the Cost info!
Tracylee, We have actually developed a report that shows both historical cost and inventory by rolling back all item movement from now to the rollback date. If you are interested in learning more about this product, please shoot me an email or drop me a line.
Thank you,
Ryan Sakry Program Manager snipped-for-privacy@rite.us
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.