Page 1 of 1

custom purchase order generation

PostPosted: Mon Apr 09, 2018 6:17 pm
by perry
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?

Re: custom purchase order generation  Topic is solved

PostPosted: Wed Apr 18, 2018 11:58 am
by Mike.Sheen
Hi Perry,

I've added improvement DEV-6576 to make this easier/possible in 07.01.01 - but in the meantime I think your idea of writing to a ##Temp table and have the stored procedure obtain the values needed from there is the best option.

Mike

Re: custom purchase order generation

PostPosted: Wed Apr 18, 2018 12:02 pm
by perry
Thanks Mike,