Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Inventory Allocation f...
Microsoft Dynamics SL (Archived)

Inventory Allocation for a Lot/Serial Item

(0) ShareShare
ReportReport
Posted on by Cynthia Audain 1,280

Hi

I encountered a scenario where on looking at the inventory status inquiry screen for a lot/serial item, I am seeing a value in the "Inventory Allocation column" but I cannot decipher why the value exists.

Now I know from experience that any values for an item that are allocated, it could mean that the item is in an inventory batch that has not been released.  However, in this case all inventory batches have been released in the system, so this is what is puzzling to me.

On executing some scripts, I noticed that in the LotSerT table, the specific line record for the value allocated is showing without a batch number and the transaction  has 0 in the Rlsed column. I assume that this is where the problem lies but I am not sure.  However, I went ahead and updated the table with the batch number and changed the value to 1 for release, but that did not help.

Has anyone experience this issue before or have any suggestions on what could be the problem and how to fix this issue?

Any assistance will be greatly appreciated.

Thanks

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Allocation for a Lot/Serial Item

    Lisa, This is what I know. status is MST meaning active or inactive. The IN batch should release and update MST status and Sert will be linked to intran and loctable transaction. If is not update you are correct should be a transaction order management or inventory that is suspended keeping the allocation shipping not invoice.

    If the transaction is completed then we need to update or those table fields once is completed ran integrity check. Thanks  

  • Cynthia Audain Profile Picture
    Cynthia Audain 1,280 on at
    RE: Inventory Allocation for a Lot/Serial Item

    Yes, actually that was the first table I checked and I saw where the inventory allocation column has a value.  I am not sure of what process that updates the LotSerT table.  The particular record in question is showing as not released.

    Thanks for your response.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Allocation for a Lot/Serial Item

    Lisa, I haven't work with serial for a while but there is another table lotsermst, did you check that one?. Thanks

  • Cynthia Audain Profile Picture
    Cynthia Audain 1,280 on at
    RE: Inventory Allocation for a Lot/Serial Item

    Hi Nam

    Yes I did, but that did not help....   Not sure what has occurred or is occurring to cause this issue.

    Any further suggestions?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Allocation for a Lot/Serial Item

    Hi Lisa

    Did you run IN integrity check ?, I used to get in this problem and it was solved when run it.

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…

Vahid Ghafarpour – Community Spotlight

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

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans