Standard Cost at Time of PartTran transaction - Standard Cost Variance

Kinetic ERP
1

Not sure if anyone has a stored procedure or a subquery that is written for this, but I am looking to source the standard cost for a part at the time a parttran transaction took place.

The way to do this would be to see the last time the cost was rolled and given the date sent to the stored procedure and then grab the last cost right then…

Or something like that. I thought I had it down and I am about to re-work it… just wondering if I could leech of someone here and also provide an answer to the larger group should anyone else ever face this.

If I work out a query that seems to work I’ll share it.

1 Like
2

Could probably also grab it from the costgrp table and check what date it was posted.

1 Like
3

So, this begs the question.

Do you think there are errors happening with your costing? This seems like something unnecessary. You have me interested

1 Like
4

Nah I don’t I am trying to give the detail behind the variance for a ADJ-PUR transaction- So I’d need the OUR unit cost and the standard cost at the time of the transaction to show the math to our buyers.

1 Like
5

You can’t get that off of the PartTran?

6

Not sure, I’ll look. I picked this report back up after like 6 months of not looking at it and I assumed that because I made a subquery to source the standard cost it wasn’t on that row.

1 Like
7

My bad, it does not look like it is there. I thought there was a PPV column, but I did not see one.

You should be able to trace from PartTran to the GL to see what cost was received and then how that was split out in the entry.

8

Time to break out that secret TranGLC decoder ring. I thought the variance was in the PartTran too.

1 Like
9

Right!?!?

It’s been a while, but I thought the secret key was the ABT GUID.

1 Like
10

Oh it is, but the calculation for it is not… meaning the standard cost.

1 Like
11

Can you expand on this “secret key” haha

2 Likes
12

Join PartTran to TranGLC on ABTUID = ABTUID

4 Likes
13

I didn’t know about that one.! That’s a lot easier than this: Efficient Joining Between the TranGLC and PartTran Tables - KB0039633

2 Likes
14

I believe that is the key between the two. I have not done a report that needs to go from PartTran to the GL in a while. But that is the one thing I remember from it.

1 Like
15

Thank you

1 Like