Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Custom Sales Transaction Window

(0) ShareShare
ReportReport
Posted on by 165

Hi,

At my company, we use trinity in GP 2010 for dual quantities summary. We are going to migrate to GP 2013 from GP 2010 and that option is out of the picture. Our WDSC will manage the dual quantities for us but I need a field to use in GP 2013 to display the UOM from that product. Right now GP just use the UOM of the product, but we sold some of the item in CASE not in LB. Can this be possible? 

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Custom Sales Transaction Window

    Hi,

    Yay! Microsoft confirmed the Modifier with VBA is now included with the Starter Pack. Now, if they would only include Integration Manager, we'd be in business.

    Kind regards,

    Leslie

  • Suggested answer
    RE: Custom Sales Transaction Window

    Hi Leslie,
    I am not sure how the GP2013 Modifier comes automatically. But, I believe the clients should have purchased the Licensing for the Configuration and Development (Customization Package). The "MODIFIER WITH VISUAL BASIC FOR APPLICATIONS" comes with the Customization package.
    Attached the screenshots for your reference.

    Customization-Suite.jpg

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Custom Sales Transaction Window

    Hi Shane,

    Just so you know, anyone who is on GP 2013 automatically has Modifier. All of my clients picked it up when the upgraded. My clients that only had GL, AR and AP picked it up too. As you may know, I don't sell the software, If I'm wrong someone will hopefully respond with a correction.

    Kind regards,

    Leslie

  • Joel Perez Profile Picture
    Joel Perez 165 on at
    RE: Custom Sales Transaction Window

    Thanks to all... we will use Reporting Services to create the report. Hopefully we can make  all the UOM available.  Thanks again for all the info in this matter.

  • Verified answer
    RE: Custom Sales Transaction Window

    Hi Joel,

    As suggested by Leslie, it can be done in two ways. In order to do it with VBA you require license for that product. I hope, you have the license for the VBA Modifier? If not, you have to go with the dexterity but that involves bit of extra coding and deployment work. Better, contact the Dexterity developer for your requirement.

  • KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: Custom Sales Transaction Window

    Hi Leslie,

    I believe I misunderstood what Joel was trying to accomplish but you pointed him in the right direction.

    Thank you,

    Kirk

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Custom Sales Transaction Window

    Hi Kirk,

    If you want to add an additional field to the sales transaction entry scrolling window, you will have to add it with modifier and then populate the value using VBA. Unfortunately, you can't just drag it from a table to the scrolling window. You could also use Dexterity.

    Kind regards,

    Leslie

  • Joel Perez Profile Picture
    Joel Perez 165 on at
    RE: Custom Sales Transaction Window

    Hi Kirk,

    We are using SOP. Just find the defind fiel setting. Just need to know how can I put it in the SOP window.

  • Suggested answer
    KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: Custom Sales Transaction Window

    Hi Joel,

    Are you using SOP or AR invoicing?

    It sounds like you might just need to define the field in SOP setup. I can't remember the exact path to the window but let me know if you need it and I can look it up for you.

    Regards,

    Kirk

  • Joel Perez Profile Picture
    Joel Perez 165 on at
    RE: Custom Sales Transaction Window

    Thanks Kirk,

    right now for GP 2010 we use trinity (myridas) because our product are random weight. We sold or invoice cases sold it in LB. I know that GP cannot manage 2 UOM for a product. But my WDCS will do the dual quantities or change from LB to Case base on AVERAGE WEIGHT. But my costumer need to see both things, cases and weight. Someone told me that my WDCS could write in a USER DEFINE table and I just need to activated in the sales transaction entry windows.

    sorry for my English.  

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

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,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans