INVENTORY VALUE MONTH TO MONTH - CDK

[918PartsMgr]

Good afternoon everyone, I was wondering if there was a function or report I can run in CDK that will show me my total inventory value from month to month. Trying to fix a mess from the old regime and curious if I could look at total value, maybe I could find a month that it jumped significantly. Then I can dial in a bit further from there. Any help would be appreciated.

Regards,
E

[Stevenspeaking]

this won't help with the past values....
But going forward you can create you own history for your records at each month end.

Use the Inventory Value Report (PHR-PH7) to calculate the value of part numbers by source. The report includes:
 Value: Total value of your parts
 Core value: The total value of your core parts
 Total value: The combined value of parts plus core value.

[bsnyder723]

If you run MGR, I believe it shows you the values for the previous 11 months.

[yosvany]

also in the manufactures website if you are on their program like rim or aro and so forth they have the totals there too month to month, but running an MGR is the best way

[RLWOLF]

Go to the AC menu
go to AGRI
go to ACCOUNT BALANCES
go to HISTORY
enter beginning dates and ending dates
This will show you end of month inventory balances by year by month
Good Luck

[PartsOnBackorder]

PHR -> RUN -> PH7 ( INVENTORY VALUE INCLUDING CORES ) This will give you an up to the minute inventory total . You can run this monthly with your stack to print out your values or you can run it at any time

[918PartsMgr]

Okay, I will give these a try. I appreciate the responses from everyone.