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
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.
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
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156