Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Lot Issue

Posted on by Microsoft Employee

Dear All,

I have been facing an issue in GP 10 for quite some time regarding Lots to get updated. The issue which is being faced is after we receive the inventory materials from the warehouse using the Receivings Transaction Entry screen. Once the materials is received from the warehouse and the print is taken there is Lots and the quantities are being shown in the print and it is submitted to accounts for Posting. But when the accounts people do the recheck before posting there won't be any lots available and they will have to do the lot update again. I can't understand how does the lots which is saved gets removed.

I have been trying to find a cause or a scenario regarding this issue for quite some time now but failed in the process. So if anyone else have faced the same issue or has any idea about this please let me know.

Thanks

Shefi

*This post is locked for comments

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Lot Issue

    Thanks for your response Shefin

    Please never hesitate to share any further inquires.

    For the mean time, feel free to close the case if it is fulfilled. Otherwise, would appreciate to hear back from you.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Lot Issue

    Hello Mahmoud,

    Yes the saving of the receivings does not create any lots.

    The lots are created only once the Receivings has been posted and then only the cost also gets updated accordingly.

    Thanks and Regards,

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Lot Issue

    Hello Shefin

    Apparently the modified screen has nothing to do with the overall process, you need to be 100% sure that saving a receiving transaction will not create* any lots at all, neither inventory cost layers to be consumed.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Lot Issue

    Mahmoud,

    Thanks for the reply.

    You mean to say, make posting of Receivings available to warehouse users and Accounts to Enter/Match the original posted receiving?

    If yes means, here the things are quite different actually we have provided a modified screen to warehouse users and the cost value is removed from the screen so they don't see the cost of the items neither do they know the cost of the material being purchased. The print they are taking is also of a completely modified report with no cost and provide to accounts. Then accounts take the GP print provided to verify and do the rest of the part.

    The funniest and the most confusing part over here is this doesn't happen every time. But when it happens it happens to all the Receivings which are saved in any of the Batch available which previously had lot numbers.

    Thanks and Best Regards,

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Lot Issue

    Shefin

    Good to hear back from you

    When you save a receiving transaction entry in Dynamics GP, inventory cost layers are not created at all, and therefore lot numbers can not be consumed until the receiving transaction entry is "Posted".

    Would it be possible that they post a receiving to update inventory stock balance, and then the accounting check to enter/match the original posted receiving ?

    I believe there is something about your process that is not quite clear to me.

    I would appreciate further in details explanation and screen shots if any, in order for this issue to be clearly settled.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Lot Issue

    Hello Mahmoud,

    Thanks for the reply.

    Yes we receive the items on Receiving Transaction entry window and enter the Lot Numbers for each line item (but this is done through programming, we are updating the lot number)

    Yes we save it and then reopen to take print and check. then provide it for double check and posting to account department.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Lot Issue

    Hello Shefin

    You are welcome to Dynamics GP community

    I would like to get things clear before trying to help you out on this issue. According to your explanation above, this is the steps that I believe you are doing:

    • You receive the items on the Receiving Transaction Entry window and enter the Lot Numbers for each line item
    • The document above is "Saved" to be waiting for double check and posting by the accounting department

    Is this the scenario of your process ?

    Your feedback is highly appreciated

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans