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
Have something to add? Share your thoughts — no account required.
Ask the community — no account required