Inventory stock balance

(0) Share

Report

Posted on by Community Member Microsoft Employee

At the stock status report I get message " a Revalued periodic cost item can result in a zero quantity and extended amount"

The valuation method for the item is FIFO periodic.

When I export out the transactions at iv30300 for this item, there is a balance for item.

What is the theory here ?

Thank you

Sanjay

*This post is locked for comments

All responses (4)

Answers (2)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Inventory stock balance

The Historical Stock Status report shows this comment regardless of the quantity, either if if it is zero or not. Prior to the HITB reset tool, several companies considered this report to reconcile IV versus GL. To me, that would be considered as an indicator or alarm to consider when matching GL with Historical Stock Status report, which actually has no effective link with GL.

With the HITB reset tool and HITB tableI would personally rely totally on the Historical Inventory Trial Balance report.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Inventory stock balance

Thank you Richard & Mahmoud,

One supplementary question how does the inventory balance get zeroed out where the historical table show a balance. Would it be due selecting options to remove historical transaction transaction during year end close ?

select itemnmbr, LOCNCODE,BINNMBR ,QTYONHND,ATYALLOC from iv00102 where itemnmbr='itemnumber'

-- Qtyonhnd is zero

select SUM(trxqty) from IV30300 where ITEMNMBR = 'itemnumber'

-- trxqty sum is not zero

Inventory inquiry screen report balance as zero

Inventory activity report report do list all activity on iv30300

And the inventory status report the extended amount is zero and extended quantity is zero.

Thanks again!

Sanjay
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Inventory stock balance

Sanjay, So long no see.

For periodic items, the historical stock status report prints out this notification per each line when the valuation method is precisely (4,5) which is; FIFO or LIFO periodic. As Mr. Richard explains, this is to ensure that having "extended amount" with "zero quantity" is justified.

One more thing to get enlightened, this could result with the FIFO or LIFO perpetual as well, this case is thoroughly illustrated in the post below; HITB Essentials Series – Zero Quantity and Negative/Positive Cost
Verified answer

Richard Whaley 25,195 on at

Like (0)

Report

RE: Inventory stock balance

If you revalue the unit cost of a periodic item and do not make a matching GL entry, you can have dollars left in GL for the items. Recent versions of GP provide a cost adjustment tool for periodic cost items that makes the matching GL entry.