Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Restricting Total on R...
Microsoft Dynamics GP (Archived)

Restricting Total on Receivings Transaction Entry screen

(0) ShareShare
ReportReport
Posted on by Megan_S 90

I am looking for a way to restrict the Total on the POP_Receivings_Entry screen. After a PO is auto received, a user can alter the Qty Shipped as well as the Unit Cost, which can drive up the total considerably. I am looking for a way to tell that when the total for the POP_Receivings_Entry screen is 500 greater than the original amount to not allow the user to continue. I have tried creating a Trigger with the Support Debugger tool, but have been unsuccessful thus far.

*This post is locked for comments

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Restricting Total on Receivings Transaction Entry screen

    I would suggest you to use Tolerance Handling feature for your requirement. For your reference have a look on the below links.

    www.socius1.com/dynamics-gp-tip-improve-receiving-with-tolerance-handling

    www.goerpcloud.com/purchase-order-tolerance-handling-in-dynamics-gp-2013

    Note: You can also create a customization to prevent users to auto-invoice/save/post the receiving entry if total is greater than 500.

    Hope this helps!!!

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Restricting Total on Receivings Transaction Entry screen

    Hi Megan,

    Please find the below sample script that may help you to resolve this. 

    Startup script:

    l_result = Trigger_RegisterFocus(anonymous('Post Button' of window POP_Receivings_Entry of form POP_Receivings_Entry), TRIGGER_FOCUS_PRE, TRIGGER_AFTER_ORIGINAL, script Validation);

    if l_result <> SY_NOERR then

       warning "Focus trigger registration failed for POP_Receivings_Entry.";

    end if;

    Validation Script:

    local currency Total;
    Total = (Subtotal of window POP_Receivings_Entry of form POP_Receivings_Entry) - ('Trade Discount Amount' of window POP_Receivings_Entry of form POP_Receivings_Entry)
    + ('Freight Amount' of window POP_Receivings_Entry of form POP_Receivings_Entry) + ('Misc Amount' of window POP_Receivings_Entry of form POP_Receivings_Entry)
    + ('Tax Amount' of window POP_Receivings_Entry of form POP_Receivings_Entry);

    if (Total > 500.00) then
    disable 'Post Button' of window POP_Receivings_Entry of form POP_Receivings_Entry;
    lock 'Post Button' of window POP_Receivings_Entry of form POP_Receivings_Entry;
    end if;

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Restricting Total on Receivings Transaction Entry screen

    I don't think there is an out of the box functionality to manage the total amount (cost). Rather, there is a good feature in the purchasing module (Quantity Tolerance) which could help you better manage the receiving from a quantity perspective rather than amount.

    You may check further details on the following post: Security set up for Purchase order processing

    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,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