Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

imorting inventory adjustments when tracking lot numbers

Posted on by Microsoft Employee

I can't get this integration to work proplerly.   Does any have an example of one that works?

*This post is locked for comments

  • AndreaIES Profile Picture
    AndreaIES 1,005 on at
    RE: imorting inventory adjustments when tracking lot numbers

    How do you get the Lot number source? I only can see Inventory transaction serial. Am I missing something?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: imorting inventory adjustments when tracking lot numbers

    Error: Items.Lot Numbers does not have a default value.

    DOC  1 ERROR: Field "Items.Item Number" does not have a default value.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: imorting inventory adjustments when tracking lot numbers

    All of the line items import except the ones with more than one line per item.   In that case the transaction is blank.    I do not have a transaction header, because I have no need to have one transaction.  It is fine to bringin the 2500 counts in multiple transactions, but one batch.  

    I finally figured out that the inventory transactions using multiple lots must be made in the base unit of measure - there is no translation to other units happening.  This was causing an error message for a while.   Let me re-run it and see what I'm getting now.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: imorting inventory adjustments when tracking lot numbers

    Hi Steve,

    Integration manager comes with an example for importing a serial number. That example won't work for Lot number because the quantity field would need to represent how many items go with a particular lot. I haven't had any problems importing lot numbers. I have three sources. 1- the transaction header 2-the items  3- the lot numbers.

    What error messages are you getting?

    Kind regards,

    Leslie

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