Sage 100

Question from customer below - PO/JC - I have tested and don't see any other built in options to make this process more efficient - other than copying and pasting the Job # down to each row. Any other suggestions? ""When creating a new PO from a Master or Repeating PO, is there a way to update all line items with the new Job Number without having to go to each line item and change it? I read in the Knowledgebase that there should be a field in the Main PO Entry, but I find no way to make it appear. Some of our Master PO's have dozen of line items. So the time it takes to change each one, every time we create this job, is considerable.

Sounds like a script should work here...

After getting an education the other day from Alnoor, I believe you can do this with a script. You would need to add a UDF to the PO header where you would set the Job Number. When the job number get's updated, the script would change the job number on each row. You have to decide how deep you have to go to keep things standardized and synchronized. If the Jobs need to be validated, you would have to have a UDT and then sync the UDT to the Job Table, etc.

script would definitely work - this is one of those, ""I can't be the first person asking for this, it should be free"" clients. But I don't think there is any out of the box solution.

May not be the first but his is a small choir in a vast auditorium with poor acoustics!

well said Shawn - I might steal that use it from time to time (daily)!

Actually, I have a client doing something similar in PO receipt of goods. They enter the current exchange rate for the Euro and the script changes the current PO cost of each item. Client normally receives about 50 lines that this executes on quite quickly....

is that script for sale Jeff - sounds like I could take that and make some modifications?

Actually, this was before scripting. We did it in PVX. Contact @RandyMarion as he is the one who did it.