Question Status

Suggested Answer
Megan_S asked a question on 22 Jul 2014 1:46 PM

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.

Reply
Suggested Answer
Mahmoud M. AlSaadi responded on 22 Jul 2014 8:26 PM

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,

Best Regards,

Mahmoud M. AlSaadi

Dynamics GP Essentials |   mahmoudsaadi.blogspot.com

Reply
Suggested Answer
Natarajan SankaraNarayanan responded on 23 Jul 2014 2:06 AM

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;

Reply
Suggested Answer
Somakarpagamoorthy Kanagasabapathy responded on 23 Jul 2014 2:29 AM

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

Note: Please mark it as verified, if this answer your question. Because this will helps to some others who experience the same.

Best Regards,

Somakarpagamoorthy K | Microsoft Dynamics GP Consultant | Dynamics Thoughts

Reply
Suggested Answer
Mahmoud M. AlSaadi responded on 22 Jul 2014 8:26 PM

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,

Best Regards,

Mahmoud M. AlSaadi

Dynamics GP Essentials |   mahmoudsaadi.blogspot.com

Reply
Suggested Answer
Natarajan SankaraNarayanan responded on 23 Jul 2014 2:06 AM

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;

Reply
Suggested Answer
Somakarpagamoorthy Kanagasabapathy responded on 23 Jul 2014 2:29 AM

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

Note: Please mark it as verified, if this answer your question. Because this will helps to some others who experience the same.

Best Regards,

Somakarpagamoorthy K | Microsoft Dynamics GP Consultant | Dynamics Thoughts

Reply