custom purchase order generation
Posted: Mon Apr 09, 2018 6:17 pm
Hi,
Jiwa 7.0.175
Customer would like to have "Weighted And YTD Average" option in PO Generation form.
There are 2 challenges to me
1. capturing additional parameters (No. of months for Sales Average 1 and 2, Month Cover required min/max)
2. passing additional parameter values to SP
for 1. I think I can either add control the the form or capture with a popup form (similar to Purchase order form).
However, I'm not sure what to do with 2. as I assume the form will only past predefined list of parameters to SP?
First thing comes into my mind is to save additional values into a temp table and have SP to check the value when it runs.
Otherwise, a plugin has to get lines and add to the PO Generation object by itself.
Can you please suggest if there is any easier way to achieve this?
Jiwa 7.0.175
Customer would like to have "Weighted And YTD Average" option in PO Generation form.
There are 2 challenges to me
1. capturing additional parameters (No. of months for Sales Average 1 and 2, Month Cover required min/max)
2. passing additional parameter values to SP
for 1. I think I can either add control the the form or capture with a popup form (similar to Purchase order form).
However, I'm not sure what to do with 2. as I assume the form will only past predefined list of parameters to SP?
First thing comes into my mind is to save additional values into a temp table and have SP to check the value when it runs.
Otherwise, a plugin has to get lines and add to the PO Generation object by itself.
Can you please suggest if there is any easier way to achieve this?