I am looking for a table that logs the oldest items in system (which means the receipt date is earliest and qty on hand >0).
I found table INReceiptStatus and INCostStatus might contain the data I want. But both of them do NOT look totally right.
For example,
For INReceiptStatus it lacks receiptNbr “007658”
While for INCostStatus it lacks more receiptnbr, and even worse, it did not track the right receipt date.
Can someone tell the logic on manipulating the two tables? Or if can point me the right direction for the data I am looking for, that would be even better.
Best answer by mvolshteyn
The InCostStatus table contains data with breakdown set by the Valuation Method. In your example, it is Average (ValMethod = ‘A’) which means that it should contain 1 line per stock item and CostSiteId (which is normally a warehouse but can be a warehouse location if location is set to be costed separately). So, here InCostStatus table has really blank data for ReceiptNBr and ReceiptDAte (‘1900-01-01’ and ‘ZZ’ stand for ‘blank’). It is only FIFO valuation method which makes these fields fill in the InCostStatus
Unlike it, INReceiptStatus contains receipt nbd and receipt data for every inventory receipt/return. Basically, these data should be realiable (only exception are inventory adjustments which do not create new InReceiptStatus but update existing ones by selection of oldest open. So basically, this table should deliver data you request. If you see, it is new correct for some case, special ivestigation is required
The InCostStatus table contains data with breakdown set by the Valuation Method. In your example, it is Average (ValMethod = ‘A’) which means that it should contain 1 line per stock item and CostSiteId (which is normally a warehouse but can be a warehouse location if location is set to be costed separately). So, here InCostStatus table has really blank data for ReceiptNBr and ReceiptDAte (‘1900-01-01’ and ‘ZZ’ stand for ‘blank’). It is only FIFO valuation method which makes these fields fill in the InCostStatus
Unlike it, INReceiptStatus contains receipt nbd and receipt data for every inventory receipt/return. Basically, these data should be realiable (only exception are inventory adjustments which do not create new InReceiptStatus but update existing ones by selection of oldest open. So basically, this table should deliver data you request. If you see, it is new correct for some case, special ivestigation is required
The InCostStatus table contains data with breakdown set by the Valuation Method. In your example, it is Average (ValMethod = ‘A’) which means that it should contain 1 line per stock item and CostSiteId (which is normally a warehouse but can be a warehouse location if location is set to be costed separately). So, here InCostStatus table has really blank data for ReceiptNBr and ReceiptDAte (‘1900-01-01’ and ‘ZZ’ stand for ‘blank’). It is only FIFO valuation method which makes these fields fill in the InCostStatus
Unlike it, INReceiptStatus contains receipt nbd and receipt data for every inventory receipt/return. Basically, these data should be realiable (only exception are inventory adjustments which do not create new InReceiptStatus but update existing ones by selection of oldest open. So basically, this table should deliver data you request. If you see, it is new correct for some case, special ivestigation is required
Thank you so much for the detail explanations. I have 1 more question, for INReceiptStatus , we also have “QtyonHand” field , right? If the evaluation method set to “Average”, how does the system know the “qtyonhand” for each receipt. Does inventory is deducted by receipt date FIFO by default?
The InCostStatus table contains data with breakdown set by the Valuation Method. In your example, it is Average (ValMethod = ‘A’) which means that it should contain 1 line per stock item and CostSiteId (which is normally a warehouse but can be a warehouse location if location is set to be costed separately). So, here InCostStatus table has really blank data for ReceiptNBr and ReceiptDAte (‘1900-01-01’ and ‘ZZ’ stand for ‘blank’). It is only FIFO valuation method which makes these fields fill in the InCostStatus
Unlike it, INReceiptStatus contains receipt nbd and receipt data for every inventory receipt/return. Basically, these data should be realiable (only exception are inventory adjustments which do not create new InReceiptStatus but update existing ones by selection of oldest open. So basically, this table should deliver data you request. If you see, it is new correct for some case, special ivestigation is required
Thank you so much for the detail explanations. I have 1 more question, for INReceiptStatus , we also have “QtyonHand” field , right? If the evaluation method set to “Average”, how does the system know the “qtyonhand” for each receipt. Does inventory is deducted by receipt date FIFO by default?
@mvolshteyn sorry to trouble you ,I forgot to set the kind reminder. I hope my quesiton would find you well.
Thank you so much for the detail explanations. I have 1 more question, for INReceiptStatus , we also have “QtyonHand” field , right? If the evaluation method set to “Average”, how does the system know the “qtyonhand” for each receipt. Does inventory is deducted by receipt date FIFO by default?
The InReceiptStatus table is always updated on FIFO basis (or to be more exact, certainly for FIFO, Average and Standard valuation, and probably also for Specific, though the latter needs checking)
This table is just an auxiliary one, needed only to track remaining quantities for each receipt. It is not used for calculation of COGS according to valuation method, and so there is such degree of freedom
The InReceiptStatus table is always updated on FIFO basis (or to be more exact, certainly for FIFO, Average and Standard valuation, and probably also for Specific, though the latter needs checking)
This table is just an auxiliary one, needed only to track remaining quantities for each receipt. It is not used for calculation of COGS according to valuation method, and so there is such degree of freedom
@mvolshteyn Thank you ,super, you really know things inside out. Fantasitc, thank you.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
