Mastery Trigger– Microsoft Great Plains modification example
Mastery is setting language and environment, the entire Great Plains is composed on. In this little short article we would like to provide you Dexterity trigger example. You can set up Dexterity from Microsoft Great Plains CD # 2.
The trigger determines QTY priced quote for the stock product and positions the outcome into “Quantity Quoted” customized field, plus it updates QTY offered– deducts QTY on orders, the trigger fires when we open IV_Item_Inquiry window.
Now lets take a look at the trigger body:
AST_Update_Qtys– this is the name of the trigger
* Trigger for after Display Existing Record of IV_Item_Inquiry. *
* Part 1 *
* Used to show the qty and compute priced quote and deduct the *
* qty on orders from the qty offered. *
regional currency lc_qty_quoted.
clear field ‘( L) Quantity Quoted’ of window IV_Item_Inquiry of type IV_Item_Inquiry
set accuracy of ‘( L) Quantity Quoted’ of window IV_Item_Inquiry.
of kind IV_Item_Inquiry to ‘Decimal Places QTYS’ of file IV_Item_MSTR – 1.
* If based upon website and website blank, set priced estimate to 0. *
if ‘( L) Display Options’ of window IV_Item_Inquiry of kind IV_Item_Inquiry = 1 and
‘ Location Code’ of window IV_Item_Inquiry of type IV_Item_Inquiry=””.
.
set ‘( L) Quantity Quoted’ of window IV_Item_Inquiry of kind IV_Item_Inquiry to 0.
terminate script.
If, end.
lc_qty_quoted = rw_qty_quoted_site(‘ Item Number’ of window IV_Item_Inquiry.
of kind IV_Item_Inquiry, ‘Location Code’ of window IV_Item_Inquiry.
of kind IV_Item_Inquiry).
set ‘( L) Quantity Quoted’ of window IV_Item_Inquiry of type IV_Item_Inquiry.
to lc_qty_quoted.
set ‘( L) Quantity Available’ of window IV_Item_Inquiry of type IV_Item_Inquiry.
to ‘( L) Quantity Available’ of window IV_Item_Inquiry.
of type IV_Item_Inquiry – lc_qty_quoted.
* Part 2 *.
* Used to occupy the sale price. *.
set ‘List Price’ of window IV_Item_Inquiry of kind IV_Item_Inquiry to ‘List Price’.
of table IV_Item_MSTR.
And this is how you do sign up the trigger:.
Start-up– script.
regional integer l_result.
l_result = Trigger_RegisterFocus( confidential(‘ Display Existing Record’.
of window IV_Item_Inquiry of kind IV_Item_Inquiry), TRIGGER_FOCUS_CHANGE,.
TRIGGER_AFTER_ORIGINAL, script SB_Update_Qtys).
Then, if l_result SY_NOERR.
cautioning “Focus trigger registration stopped working.”.
If, end.
Let us understand if you require assistance: 1-630-961-5918, 1-866-528-0577 or help@albaspectrum.com.
Microsoft Great Plains has numerous modification choices, you can utilize SQL shows from the back end, or VBA/Modifier to a little enhance end-user user interface. The most versatile system is Great Plains Dexterity modification. Mastery is configuring language and environment, the entire Great Plains is composed on. In this little post we would like to provide you Dexterity trigger example. You can set up Dexterity from Microsoft Great Plains CD # 2.