INVENTORY VALUE MONTH TO MONTH - CDK

INVENTORY VALUE MONTH TO MONTH - CDK

Postby 918PartsMgr » Thu Dec 02, 2021 9:50 pm

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
918PartsMgr
 
Posts: 22
Joined: Fri Aug 06, 2021 2:53 pm

Re: INVENTORY VALUE MONTH TO MONTH - CDK

Postby Stevenspeaking » Fri Dec 03, 2021 3:48 pm

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.
sbrittain@mcgovernauto dot com
Stevenspeaking
 
Posts: 193
Joined: Thu Jun 14, 2007 12:00 am
Location: Massachusetts

Re: INVENTORY VALUE MONTH TO MONTH - CDK

Postby bsnyder723 » Fri Dec 03, 2021 4:31 pm

If you run MGR, I believe it shows you the values for the previous 11 months.
bsnyder723
 
Posts: 376
Joined: Wed Jul 17, 2019 8:30 pm
Location: Central NJ

Re: INVENTORY VALUE MONTH TO MONTH - CDK

Postby yosvany » Sat Dec 04, 2021 2:28 pm

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
yosvany
 
Posts: 26
Joined: Thu Jun 25, 2020 6:14 pm

Re: INVENTORY VALUE MONTH TO MONTH - CDK

Postby RLWOLF » Mon Dec 06, 2021 2:51 pm

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
RLWOLF
 
Posts: 75
Joined: Fri Apr 20, 2007 12:00 am

Re: INVENTORY VALUE MONTH TO MONTH - CDK

Postby PartsOnBackorder » Mon Dec 06, 2021 3:05 pm

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
PartsOnBackorder
 
Posts: 57
Joined: Thu Apr 08, 2021 12:43 pm
Location: NEVADA

Re: INVENTORY VALUE MONTH TO MONTH - CDK

Postby 918PartsMgr » Wed Dec 08, 2021 7:01 pm

Okay, I will give these a try. I appreciate the responses from everyone.
918PartsMgr
 
Posts: 22
Joined: Fri Aug 06, 2021 2:53 pm


Return to Parts Managers

Who is online

Users browsing this forum: Google [Bot] and 9 guests

cron