Invt/Crystal Question

[dmrVA]

My frozen stock status $$$ did not match my ledger Finished Goods account. I compared the GL Trial Balance report for the account to IM History Trx report. They do not match.

I wanted a simpler way to compare, so I was going to write a Crystal report off the IMINVTRX.btr to pull the same data from that file in the same format as the GL
report so I could easily see where the variance was.

But, the IMINVTRX.btr does not show the account. Does anyone know what file this information is stored in as it relates to the Inventory Transaction. Thanks

Using Macola 7.6.200.5, Pervasive SQL

 

[maccrystal]

Assuming you use multiple finished goods or componet asset accounts based on the Material cost type you would need to use the IMtypLoc_sql. Link on the loc and material cost type. The asset account is the combination of MN_no,SB_NO and DP_no. This file can be used to create a Frozen Stock status by account, or a stock status by account. You can link the IMINVTRX_file in a similar manner.

http://www.appstratinc.com