Is it possible to look up the purchase history of an item with costs, so I can track the cost that I have paid for an item over time. I am currently pulling a "Movement History" report and need to pull up each PO individually to look up what I paid.
Is there a better way?
The cost and price of the item is constantly changing and that information is not as standard kept in the database. Retail Realm has an add-on that does provide that capability [End Of Day Merchandising]. This software however will require that you upgrade your MSDE to Full SQL [if you have full SQL no problem].
If you want more information contact me
Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk] CEO - Retail Realm
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.