![]() |
|
#1
|
|||
|
|||
|
Tracking cost/price adjustments
I work in an environment where several people are making changes to item costs and prices over time, but there is no central log for tracking who made changes or when. It becomes difficult for me to give quotes to a customer if I don't know if the price of an item is up-to-date or if I need to contact our supplier to get a new cost.
So I'd like to be able to do two things: 1. Quickly identify the date when the price was last updated. 2. Keep a history of prices so we can easily see how they have changed over time. I realize I could create custom fields to track these things, but it would obviously work better if we didn't have to enter data that was already being tracked by the Quickbooks system in some hidden way. Does anyone know if there is a built-in way of accessing this kind of information? Thanks! |
|
#2
|
|||
|
|||
|
You can use your Reports>Purchases>Purchases by item detail report to see what you paid for items on previous bills. Make sure you set the date to "all" and you will see the cost per item that you paid on the bill including changes.
You WILL NOT be able to see who changed the cost. You should never change inventory costs as all that is handled when you enter bills. If you want to keep an updated list of non-inventory costs the closest thing to "automatic" updating would be to download excel spreadsheets from your suppliers and use the "add multiple list entries" feature to import the updated pricing.
__________________
John Cronkite http://AdvancedQuickBooksServices.com/ |
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|