Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Need help entering in case quantities

Posted on by 80

I am new to GP, new to EDI, and new to my role. I import orders into GP, review them, and then export the orders to our warehouse. Our customers commonly order in individual unit SKUs and I translate them to case SKUs before exporting to the warehouse. I need to figure out where I can enter in the case quantity so this information is also included on the 940 sent to the warehouse. Currently when we send ASNs it appears we are only sending one of an item instead of a case of eight, and the customer thinks they are being shorted seven items. Can someone assist me?

*This post is locked for comments

  • Kristin3737 Profile Picture
    Kristin3737 80 on at
    RE: Need help entering in case quantities

    Frank, you are a godsend. I just sent you my email. This manual will be great!

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Need help entering in case quantities

    Our experience has been the same as yours Kristin.  I have a copy of the Process Logic manual.  Send me an email through this forum and I'll send it to you.

  • Kristin3737 Profile Picture
    Kristin3737 80 on at
    RE: Need help entering in case quantities

    Yes, we use Process Logic as well, but have had issues getting responses to our questions. Do you know if your client has a good contact there? Or even if they had some sort of manual I could use as a resource trying to figure things out...

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Need help entering in case quantities

    Okay.  I have a client who uses SPS and there's a piece of middleware from a company called Process Logic, which is an add-on to GP, that is used to format the GP data for EDI transmission.  Are you using the same tool?  If so, part of the Process Logic setup involves entering UOM conversion values. You need to check your setup.  If you're using some other middleware, it should also have UOM conversion settings as well.

  • Kristin3737 Profile Picture
    Kristin3737 80 on at
    RE: Need help entering in case quantities

    When I have asked them about this issue, they have acted like we should be sending them that information in the 945. The warehouse (the party that generates the 945) says that we should be sending it in the 940. So that brings me back to trying to figure out if GP can do it. Any ideas, or should I go back to SPS and insist that they do this translation? Thanks for your help!!

  • Kristin3737 Profile Picture
    Kristin3737 80 on at
    RE: Need help entering in case quantities

    We are using SPS.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Need help entering in case quantities

    Your EDI application should have an area where you set Unit of Measure conversions.  I would look there first.  What EDI package are you using?

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans