Sage 100

v4.5.6 Inventory Trial Balance - Is this a viable report now? Client needs a valuation report today as of 4/30. Is it close enough for bank reporting? Is it reliable? Is there a way to suppress items with zero on hand quantities? I don't see a suppression option on the selection panel. Can this be done with a Crystal tweak?

How about the Inventory Valuation Report by Period? You can exclude zero balances on that one.

@ThereseLogeais does that one work right now (never trusted that one)? @JeffSchwenk have not verified that report, but I would think it was a good one. It is also crystal so why couldn't you suppress zero through crystal?

I didn't guarantee it!! Yes, you could modify the Trial Balance to suppress zero quantity items.

@JeffSchwenk - yes you can in crystal - select - transaction qty not = 0

Thanks All

Wait, @DianeRuth if you're talking about the Trial Balance report, there is no transaction quantity. The ending balance is a formula but you could still use that as a selection criteria. {@EndingBalanceQTYOnHand}+{@EndingBalDollarAmtOnHand}<>0 (You can sometimes have odd cents in the ending dollar amount so I would use both.)

Thanks again.

The Inventory Trial Balance should be good enough for bank reporting. The Trial Balance and the Inventory Valuation by Period report both use the Inventory Item Warehouse History by Period file to get the beginning balance for the period and then show the activity and calculate the ending balance. This all works perfectly providing the history by period file is correct and it may not be - in particular with clients who have been on MAS prior to the 4.4 upgrade. There is a utility in Inventory that can re-calculate the history by period if needed but it can create errors as well. An interesting exercise is to run both the Trial Balance and the Valuation by Period report for the same date and see if the numbers match. I'm not trying to bash either report, they are as good as it gets in the Sage 100 world. However, they are not nearly as solid as the trial balances in AP and AR. AP & AR use the trasaction and payment history to calculate the balances, inventory relies on the summary file (which in theory is based on the transaction history) as a starting point and this can create issues.

Your right @ThereseLogeais I was looking at the detail transaction report not the trial balance..

Actually @BernieLehman I did run the valuation report and trial balance as of today for assurance that they at least match right now.

FWIW - I have had good luck recently with the Valuation by Period in 4.5 and 2013 matching the IM Trial Balance.

I have ran both the Valuation by Period and Trial balance Report in Version 4.4 and above and they match consistently. Which is a good sign.