The Part Transaction History Tracker for this part SB100 indicates that on 1/31/2024 a cost roll was made which updated the part cost, but it seems the part cost never updated and remained at $0. PTHT shows the cost after the costrollup but when I checked in the part tracker shows 0 cost.
any thoughts
Do you have mulitple cost site IDs?
No
In my experience, only entries in the PartTran file are those that affect inventory value. If there was no quantity on hand for a part when the cost update occurred, then zero times the old cost is zero and zero times the new cost is zero.
I’m with Mark. What does the Part Tran look like with all transaction types when you are seeing the zeros including the Running Total?
Right, that’s what doesn’t make sense to the question being asked.
But what I was trying to figure out was what the person is asking, I think he understood it was 0.
The cost in the Part Tracker also remains at 0. Why is that the case? For this part, the last cost roll was on January 31, 2024, but the cost did not update in the Part Tracker. What could be the reason for this?
Since the Part Transaction History Tracker has already recorded the cost roll, would the solution be to simply update the Part Tracker with the new cost amount? again this Qty is 0 on hand.
There are logs saved for each roll and load of costing workbench.
Do you see anything in the logs for that costing workbench load/roll/post?
No, I didn’t see the log. Since this involves activities from 10 months ago, I’m not sure if the log is still available.
It might be depending on the size of your company and what your admin is doing with the log files.
Let me ask you this, if you pull that part into the costing workbench right now, then roll it, do you see any errors in the logs?
Hi Utah,
I don’t see any errors. I performed the cost rollup for this part in the pilot environment, and while I have the quantity on hand, the cost was not reflected in the part tracker. When I rolled up the cost again, it showed zero.
Pay close attention to the part tracker when looking at the costs, if I recall it defaults to the first site cost record which may not be the site you are logged into or the site you are using the PTHT. This is particular annoying if you have done a part upload and included all sites, but you only use the part in a few sites.
site cost was there from the day one in the system.
Simon that’s what I keep trying to tell them.
Senthil, would you please show us what cost site ID is applied to the site that you are in?
When you’re in the costing workbench it asks you to select a cost site ID to post to, is it the same cost site ID as the one you are looking at in your part tracker for your part?
Are you multi-site?
Can I start by asking that?
And you are using standard costing yeah?
