So when you do the PUR-STK, your lot cost is the cost of that receipt based on the transac6tion date. If you have multiple dates for that lot it will use the cost for the first date.
If you do your cost adjustment (ADJ-CST) are you specifying the FIFO lot you are adjusting or are you just adjusting the lot itself? That can make a difference if you unreceive because you are unreceiving the original transaction (FIFO lot) which has the original cost and there is another FIFO transaction that is still sitting there.
That is my analysis, you will need to prove it out with the transaction data.
Charlie Smith
CTCharlie@...
Cell: 860-919-1708
Office: 817-862-9862
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, June 16, 2015 8:01 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Issue with landed cost if material is unreceived
Lot FIFO
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:e8377c.png@1ac5b155.4f912021]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, June 15, 2015 4:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Issue with landed cost if material is unreceived
What is the costing method for the part?
Charlie Smith
CTCharlie@...
Cell: 860-919-1708
Office: 817-862-9862
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, June 15, 2015 1:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Issue with landed cost if material is unreceived
Hello,
E9.05.702
I think we found an issue when unreceiving a material receipt, in Receipt Entry, when there is landed cost involved.
In many cases, we are unable to know the entire landed cost at the time the container hits our warehouse so we will receive the material first and then come back and enter the landed costs afterwards, in receipt entry.
We do not use the container functionality and perform all this work in Receipt Entry.
Entering landed costs after the material is received cause the landed cost value to hit the “Applied to Variance†bucked.
However, this still triggers an adjustment to cost transaction that appears to update the part cost. On the GL side, we are seeing a debit to inventory and a credit to inventory adjustments for this cost adjustments, which makes sense.
If for some reason, we unreceive the material receipt, the value credited to inventory is only the material amount and does not include the landed cost from the cost adjustment transaction.
We think this means that the landed cost is not getting cleared from inventory, which as a side note we have a major difference between the inventory GL and the stock status.
For example, we received 10 parts for a total of $100, or $10/part.
We later add landed costs for a total of $10 which. when dispersed, brings the material cost to $11/part.
We see the first PUR-STK for $10/part. Then we see the ADJ-CST for $1/part.
When we unreceive, we only see the PUR-STK with a value of $10/part.
The TranGLC records seem to verify this.
Has anyone else encountered this or know if we are looking at it wrong?
Joe Rojas | Director of Information Technology | Mats Inc.
dir: (781) 573-0291 | cell: (781) 408-9278 | fax: (781) 232-5191
addr: 179 Campanelli Parkway | Stoughton | MA | 2072
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:97fc5f.png@a578e5b7.4a81ceb5]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]