on 2016 May 23 10:02 PM
Hello Experts,
I am running 9.1 pl11 and need to update the PO price after discount on the Wizard's Step 3 window with a special cost if some criteria is met.
I did a little testing and if I check off the 'print target document' box, my simple 'SELECT 10.00' F/S worked updating the price field.
But I really need to update the price field based on the customer from the base (Sales Order) document which I have added to the screen using the Form Settings.
Using the System Information, the field for the base document is
Form 5400100007
Item 5400000019
Pane 4
Column 5400000003
But this doesn't seem to work like on a sales order screen line item ie $[$38.4.0] is the item code
Is it not possible to grab the screen values on the Procurement Wizard windows and use in a formatted search?
if this is the case, any clever ideas/suggestion on how I can modify the PO price when it is created using the Procurement Wizard. There are a lot of line items being processed through the wizard and I need to catch the exceptions.
Thank you in advance for any replies.
Best,
Laura
Request clarification before answering.
i have answered my own question i just had too many zeros in the elements
Item 540000019
Pane 4
Column 540000003
$[$540000019.540000003.0] is the base doc. (five zeros in the first element and 6 zeroes in the second.) i use refresh regularly when field changes: customer/vendor code and my client requires the "Print target document" to be checked - that check mark triggers the f/s.
and it reads the right doc# so i then am updating the price successfully according to my clients needs for special pricing.
this is using 9.1 PL11 when the note above was corrected.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
$[$38.4.0] is referred to current form. In your FMS, you will look for data in RDR1.
Frank
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
100 | |
11 | |
10 | |
9 | |
6 | |
4 | |
4 | |
4 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.