Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Physical Inventory incorrect on transfer orders

Posted on by 165

AX2009:  Live in AX 7/29/13

We're having trouble figuring out what is going wrong with our transfer order transactions that the inventory remains in the transfer warehouse as well as the destination warehouse.  We have a consultant telling us- this is OK as it's just a posting issue and that it's not wrong but Physical Inventory is the only place that I can see what we really have at a site(regardless of warehouse) and with inventory moving to a warehouse and not coming out of the transit warehouse- I can't tell what inventory we have.  Is our consultant correct- Is this normal?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Physical Inventory incorrect on transfer orders

    Hello,

    Have you determined now to get the bad inventory under the transit warehouse out of the system. We had product received directly into the in-transit warehouse and now we can not get it out. The return order is closed and invoiced for this transaction.

    Thanks

  • jhsharma Profile Picture
    jhsharma 70 on at
    RE: Physical Inventory incorrect on transfer orders

    Hi

    But in my case if I go for receiving the Transfer Order when I post it as received an error message showing the error message as insufficient inventory, on check I found the inventory is lying in the transit ware house. how do I resolve this issue

  • Verified answer
    tamic Profile Picture
    tamic 165 on at
    RE: Physical Inventory incorrect on transfer orders

    Yes- I see the difference when I look at a received transfer.  The physical inventory in the transfer warehouse is gone- go figure:-)

    I will proceed as suggested-  Thank you very much!

  • Verified answer
    Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Physical Inventory incorrect on transfer orders

    If the transfer order is not received the stock is not yet in the destination warehouse. Due to the many many ways this can be done the simplest approach for you is to ask the business the process steps. Yes they can periodically close transfers and allow the stock to process whilst cleaning up later, but it makes writing an external on hand report very very difficult. In summary they have done the registration part of the process but not the physical receipt which can show you what you are seeing. Look at a received transfer order and the transactions by batch and it will make sense, not that it is much help to you for what you are trying to do.

  • tamic Profile Picture
    tamic 165 on at
    RE: Physical Inventory incorrect on transfer orders

    Transfer order status is "Shipped"

    Yes- When I filter by just Batch- the 57 cases is doubled in the total.

    So if the problem is due to the transfer order not being "Closed" then what is the normal lag time that we might see inventory in both locations- seconds?  The consultant is telling me that often times the closing process is done periodically and not at the time of transaction (referring to other companies using AX).  This is crazy to me that we would leave the transfer order open when all inventory movement is complete.  

    Yes it's possible that we customized but not sure what.  I'm on the back end just trying to write a report of inventory on hand by site and this is hanging me up.  FYI- Our consultant is not a specific AX consultant so I question if he really knows but he is adamant that this is not wrong.

    I thank you so very much for your help!

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Physical Inventory incorrect on transfer orders

    Ok and what is the status of the transfer order? Is it fully received with all process complete? Simple test is if you filter without warehouse just on batch is the physical inventory double what you have? If so you have a problem if the transfer order is closed as your stock is doubling with each transfer. any customizations?

  • tamic Profile Picture
    tamic 165 on at
    RE: Physical Inventory incorrect on transfer orders

    Thanks for your help:)

    Here is an example where the same 57cases are in both transit warehouse FL-INT and warehouse FL-DC

     

     

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: Physical Inventory incorrect on transfer orders

    If you have received all stock into the destination warehouse there should be no physical stock left in-transit. However we do not have the whole picture so we cannot say the consultant is wrong. Can you describe an example and add a screen shot?

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,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans