Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Adjustment Item charges received from Vendor once stock is transfer to another warehouse

Posted on by 105

Hi Everyone,

Need you input on item charges received from Vendor once Purchase order in fully Invoiced and Qty. is transferred to another warehouse.

Scenario:

Step 1 - Purchase order (PO-001) fully received and invoiced on 14th April 2020 in Warehouse1 for Item 123456 Qty - 5.

Step 2 - Qty transferred from Warehouse1 to Warehouse2 on 18th April 2020 for Item 123456, Qty - 5.

Step 3 - Freight charges received AED 100 and allocated on 15th May 2020 (either from Vendor or Forwarder) on the Purchase order (PO-001).

Step 4 - Inventory value report as on 15th May 2020 for Item ABC show amount as AED 100 in Warehouse1 with zero Qty.

Item Transaction:

pastedimage1599553859839v2.png

Item adjustment form (closing and adjustment)

pastedimage1599553746482v1.png

Cost adjusted to Purchase order but it recalculation is not helping to do adjustment of cost and it is lying in Warehouse 1 with no inventory.

How we can adjust or move AED 100 in Warehouse2 where Qty is available or how we can adjust this cost in Qty. available in existing Warehouse 2? Also is there any set up to strict the Item charges in Purchase order if Inventory is consumed?

  • tabarret Profile Picture
    tabarret on at
    RE: Adjustment Item charges received from Vendor once stock is transfer to another warehouse

    Hello Chandra,

    Do you have a sandbox environment that you can post the Movement journal with Charge, and then view the Voucher and associated ledger postings?  

    Regaring your main concern:  Any adjustments would need to be posted as manual ledger postings to the general ledger.  

  • Dynamics.com Profile Picture
    Dynamics.com 105 on at
    RE: Adjustment Item charges received from Vendor once stock is transfer to another warehouse

    Dear Taylor,

    Thank you for your reply.

    Request you to please let me know the impact of charges on cost on ledger?

    Is recalculation work on Project Item Jounral?

    My main concern here is charges uploaded on PO for which stock now moved to Project, how we can adjust this cost base on my above given scenario.

  • Suggested answer
    tabarret Profile Picture
    tabarret on at
    RE: Adjustment Item charges received from Vendor once stock is transfer to another warehouse

    Hi Chandra,

    There is a field called 'Charges on cost', located on the General tab of the Movement journal lines.  You can also specify the relevant Site and Warehouse.  Would this be an option for you?

    pastedimage1599680003539v1.png

  • Suggested answer
    nunomaia Profile Picture
    nunomaia 10,684 Super User on at
    RE: Adjustment Item charges received from Vendor once stock is transfer to another warehouse

    You could try to customize a feature to automate that process

  • Dynamics.com Profile Picture
    Dynamics.com 105 on at
    RE: Adjustment Item charges received from Vendor once stock is transfer to another warehouse

    Dear Taylor,

    I think there is no option to add charges in movement journal. Moreover my transaction the item journal in Project management. My issue is cost lying in Warehouse 1, how i can adjust this cost?

  • Suggested answer
    tabarret Profile Picture
    tabarret on at
    RE: Adjustment Item charges received from Vendor once stock is transfer to another warehouse

    Hello Chandra,

    Have you considered posting a Movement journal on Warehouse 2, and adding your charges on the Movement journal?  

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans