Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Suggested answer

Transfer order receive: Insufficient transactions

Posted on by 5

Hi

I have created a transfer order with 4 batch numbers (through batch reservation) and shipped it. After shipment, I have registered it from arrival overview and posted its journal. Now, when I click Function > Receive and fill in the form and click OK, this error occurs:

Transfer order - Receipt Transfer number: TO139900003168 Line number: 1.00 Cannot receive quantity 200.00 because inventory transactions with status Ordered, Arrived or Registered are insufficient.

I checked inventory transactions and all of 4 batch numbers are registered in destination warehouse with desired quantities. Can anyone help?

Thanks,
Mohammad Javahery

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Transfer order receive: Insufficient transactions

    great you found hotfix and root cause

  • javaheryz Profile Picture
    javaheryz 5 on at
    RE: Transfer order receive: Insufficient transactions
    [quote]

    Thanks for the feedback, Mohammad.

    Do you have access to all warehouses as system administrator or using a normal security role? If you are not a system administrator, can you test the same process with the system administrator role? If you then have the same error, it might be related to the customization. If the error is not coming using the system administrator role, then it might be related to the security policy definition.

    [/quote]

    Thank you for your offers. I have done all of tests using system administrator account. We finally found source of problem. You can find details in my last reply to Rahul.

  • javaheryz Profile Picture
    javaheryz 5 on at
    RE: Transfer order receive: Insufficient transactions
    [quote user="Rahul Mohta"]

    from the table suggsted, the 1000 kg is already seen shipped and transit warehouses are seen in final status, the only pending update is to be received

    any quality order or blocking that someone/somehow could have been created?

    [/quote]

    We have done many tests and finally found out the cause: When destination warehouse doesn't have a default location, error occurs. When we set a default location for that warehouse, error disappears. Seems there is a bug in PU 29 in this regard.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: Transfer order receive: Insufficient transactions

    Thanks for the feedback, Mohammad.

    Do you have access to all warehouses as system administrator or using a normal security role? If you are not a system administrator, can you test the same process with the system administrator role? If you then have the same error, it might be related to the customization. If the error is not coming using the system administrator role, then it might be related to the security policy definition.

  • Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Transfer order receive: Insufficient transactions

    from the table suggsted, the 1000 kg is already seen shipped and transit warehouses are seen in final status, the only pending update is to be received

    any quality order or blocking that someone/somehow could have been created?

  • javaheryz Profile Picture
    javaheryz 5 on at
    RE: Transfer order receive: Insufficient transactions
    [quote]

    Hi javaheryz,

    Is this the only transfer order which gets stuck or are there more with this issue?

    Do you have extensible data security policies enabled in your environment? That could cause issues during the posting logic. If you have customizations, review them. It would also be highly recommended to test the behavior in an updated environment on version 10.0.10. I have not found an entry on LCS issue search which could be related, but there might be something fixed in the meantime.

    [/quote]

    Hi

    Every transfer order with more than two batch numbers in the same line has this issue. I have told our development team to check for possible issues in code logic as we have a couple of customizations regarding transfer orders. The only security policy we have is related to warehouses which doesn't apply to my test as I'm testing using my account and have access to all warehouses.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: Transfer order receive: Insufficient transactions

    Moved the question to the Dynamics 365 SCM forum

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: Transfer order receive: Insufficient transactions

    Hi javaheryz,

    Is this the only transfer order which gets stuck or are there more with this issue?

    Do you have extensible data security policies enabled in your environment? That could cause issues during the posting logic. If you have customizations, review them. It would also be highly recommended to test the behavior in an updated environment on version 10.0.10. I have not found an entry on LCS issue search which could be related, but there might be something fixed in the meantime.

  • javaheryz Profile Picture
    javaheryz 5 on at
    RE: Transfer order receive: Insufficient transactions
    [quote user="Rahul Mohta"]

    just get the inventory transactions in a TABLE and paste

    unless there is something custom in transfer order for a line we can ship and receive multiple batches (as seen in Pu34)

    also check on your environment page for any quality updates specific to your version

    [/quote]

    Below, you can find transactions. I have told our development team to check for possible customization conflicts. We are using PU29 and because I don't have access to install updates, I have to check this with our technical team.

    Item number Physical date Financial date Reference Number Receipt Issue Quantity Unit CW quantity CW unit Cost amount Site Warehouse Batch number Location Inventory status
    CO00001     Transfer order receive TO139900003174 Registered   200 KG 0   0 K1 K1-CO Golden Line-9802-02 Tank2 Available
    CO00001     Transfer order receive TO139900003174 Registered   200 KG 0   0 K1 K1-CO magarin-9802-1 Tank3 Available
    CO00001     Transfer order receive TO139900003174 Registered   200 KG 0   0 K1 K1-CO avesta-9802-01 Tank4 Available
    CO00001     Transfer order receive TO139900003174 Registered   400 KG 0   0 K1 K1-CO OPB0001 Tank1 Available
    CO00001     Transfer order receive TO139900003174   Picked -400 KG 0   0 KFI KFI-TR OPB0001   Available
    CO00001     Transfer order receive TO139900003174   Picked -200 KG 0   0 KFI KFI-TR magarin-9802-1   Available
    CO00001     Transfer order receive TO139900003174   Picked -200 KG 0   0 KFI KFI-TR Golden Line-9802-02   Available
    CO00001     Transfer order receive TO139900003174   Picked -200 KG 0   0 KFI KFI-TR avesta-9802-01   Available
    CO00001 5/18/2020 5/18/2020 Transfer order shipment TO139900003174 Purchased   400 KG 0   16400000 KFI KFI-TR OPB0001   Available
    CO00001 5/18/2020 5/18/2020 Transfer order shipment TO139900003174 Purchased   200 KG 0   8200000 KFI KFI-TR magarin-9802-1   Available
    CO00001 5/18/2020 5/18/2020 Transfer order shipment TO139900003174 Purchased   200 KG 0   8200000 KFI KFI-TR Golden Line-9802-02   Available
    CO00001 5/18/2020 5/18/2020 Transfer order shipment TO139900003174 Purchased   200 KG 0   8200000 KFI KFI-TR avesta-9802-01   Available
    CO00001 5/18/2020 5/18/2020 Transfer order shipment TO139900003174   Sold -200 KG 0   -8200000 KFI KFI-CO avesta-9802-01 Mehrvandad Available
    CO00001 5/18/2020 5/18/2020 Transfer order shipment TO139900003174   Sold -200 KG 0   -8200000 KFI KFI-CO Golden Line-9802-02 Mehrvandad Available
    CO00001 5/18/2020 5/18/2020 Transfer order shipment TO139900003174   Sold -200 KG 0   -8200000 KFI KFI-CO magarin-9802-1 Mehrvandad Available
    CO00001 5/18/2020 5/18/2020 Transfer order shipment TO139900003174   Sold -400 KG 0   -16400000 KFI KFI-CO OPB0001 Mehrvandad Available
  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Transfer order receive: Insufficient transactions

    just get the inventory transactions in a TABLE and paste

    unless there is something custom in transfer order for a line we can ship and receive multiple batches (as seen in Pu34)

    also check on your environment page for any quality updates specific to your version

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans