Hi,
I am getting a wrong cost price for transfer journal transaction for item where the costing is FIFO.
How does the cost price come on transfer journal?
Please suggest what has to be done.
Nisheet
*This post is locked for comments
Hi,
For some std cost item qty is 0 is warehouse (Example Qty - 0, value - (-253). How to adjust inventory value as zero 0? Or is these any option to mark the transaction after posting.
std. cost transactions do not appear on invent value adjust form.
Regards,
Nisheet
Hi Nisheet L,
You can - for example - make use of a counting journal and post a qty of 0 for the warehouse where you have no quantity.
For the warehouse where you have a quantity, you post the quantity.
Best regards,
Ludwig
Hi,
Transfer Transactions and std. cost transaction do not appear here.
How to settle values in warehouse for these.
Nisheet
Hi Nisheet,
As you told that qty is 0 but value not equal to 0.
If you want to adjust value also then you have to make adjustment manually.
Hi,
Overall inventory qty & value are correct. But the problem is that due to these transfer journals value is wrong in warehouse.
How to correct it now?
Can it be done by counting journal?
For some item qty is 0 is warehouse. How to make value also 0?
Regards,
Nisheet
Hello Nisheet, I cannot tell you why 1.26 vs. 60 RS is used in your case but you can probably check this possibly yourself. In the inventory transaction form that you show above you can select inventory-trace and/or inventory-cost explorer. In those forms you can identify additional information on how the costs prices are calculated. Best regards, Ludwig
Hi Ludwig,
It's ok that there is no ledger voucher for this transaction. But the issue is that, receipt price is 60 Rs. but the cost price is transfer journal is 1.26 Rs. How can it be? What can be the reason?.
So the warehouse wise inventory value report is wrong. In the warehouse the cost amount is not as per qty & per cost per unit becomes wrong.
Nisheet
Hi,
There is some problem in opening the link.
Can You share the content please?
Nisheet
Hi,
Please also check the following post, which gives you a deep inside into the inventory valuation in AX.
This might help in addition to what I mentioned before.
Best regards,
Ludwig
Hello Nisheet,
Isn't this a pure inventory transaction that does not create a financial voucher and thus does not affect your inventory valuation at all?
Can you check if a ledger voucher has been created for this transaction? I would expect that this is not the case.
As this transaction is classified as a non-financial transfer it won't be picked up by the inventory closing/recalclation process. Why should it? You just move an item from warehouse A to warehouse B and your accountants do not even see the value in their ledger accounts.
Another thing to consider is that AX always regulates only issue transactions but not receipts.
If AX would make an adjustment to the issue value of your inventory transfer, then you would have an issue price that is different from your receipt price, which does not make sense.
Does this clarify things?
Best regards,
Ludwig
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156