I’m trying to pull in historical inventory data from a company we recently purchased to go with our historical inventory data. I see in Prophet 21 that I can get almost all of the data from inv_tran table. Is there any table that hold the cost rollups so I can get the costs for a specific date if it changed between inventory transactions? I can use the cost column for the most part from the inv_tran table, but there are parts that don’t have a transaction for a couple years and the cost has changed for that part and I need to get the cost changes for those dates to reflect dollars on those dates. Thanks for any help!!
Not sure about Prophet, but do they have a tran type of ADJ-CST at all?
The only thing I can decipher is maybe a trans_type of “RU”, but there is no cost in the row for that type.
1 Like
I wish I could help ya… Do you have access to Epicweb?? Maybe there is a transaction guide there?