Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Cost Amount for Transfer Journal

(0) ShareShare
ReportReport
Posted on by 140

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

  • Nisheet Profile Picture
    Nisheet 140 on at
    RE: Cost Amount for Transfer Journal

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Cost Amount for Transfer Journal

    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

  • Nisheet Profile Picture
    Nisheet 140 on at
    RE: Cost Amount for Transfer Journal

    Hi,

    Transfer Transactions and std. cost transaction do not appear here.

    How to settle values in warehouse for these.

    Nisheet

  • Suggested answer
    faiz7049 Profile Picture
    faiz7049 1,962 on at
    RE: Cost Amount for Transfer Journal

    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.

    7450.AX.jpg

  • Nisheet Profile Picture
    Nisheet 140 on at
    RE: Cost Amount for Transfer Journal

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Cost Amount for Transfer Journal

    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

  • Nisheet Profile Picture
    Nisheet 140 on at
    RE: Cost Amount for Transfer Journal

    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

  • Nisheet Profile Picture
    Nisheet 140 on at
    RE: Cost Amount for Transfer Journal

    Hi,

    There is some problem in opening the link.

    Can You share the content please?

    Nisheet

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Cost Amount for Transfer Journal

    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.

    fedotenko.info

    Best regards,

    Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Cost Amount for Transfer Journal

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans