Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Contributor
krock918316
Posts: 21
Registered: 03-25-2009
0

Using Next Order number on V/I Jobs

I've read the post on using TEMPS to get the next sales order number (http://community.sagemas.com/t5/Technical-and-Installation/Next-Order-Number-on-VI-Sales-Order-Impor...), but I can't get it to work.


I am on 4.20.0.18. I have it set up exactly as described, except post 3 of the above post says to set it to "Execute on both Header / Line". I don't see that option anywhere. The only option I have on the Temps is to "Assign Temp on (Key Assigns Only, Header Record, or Line Record).

 

Every time I run the job, it gives the same message on each of the 6 records in my test file -- "The Sales Order Number is Requried".

 

If you drill into the record, on the first instance of H.SalesOrderNo the result is "Fail" and data says "The Sales Order Number is required. On the second instance of H.SalesOrderNo the result is "Pass" and "Not Assigned". Any help is appreciated.

Contributor
krock918316
Posts: 21
Registered: 03-25-2009
0

Re: Using Next Order number on V/I Jobs

Ok. I think I see part of the solution. In 4.20 there is an item on the records tab "Change Next On". I've got it working on using the Next order on a change of PO#. I need it to get the next order number on change of PO# and on Change of Warehouse code. Any Ideas?