Sage 100

Sage 100 v. 4.5 Standard - Importing Purchase orders from csv. Each csv file contains one order for one vendor with each line listing vendor, item, whse, qty, cost, etc., but no predefined PO number. If using next to assign purchase order, then each line becomes a separate PO instead of a grouped PO for the vendor. The data is coming from another program. Is there away to grab the next purchase order number from PO setups hold it in a variable and assign it to all the lines that are imported? I've looked and looked and can't seem to see anything in VI that would work like that.

Are they in vendor number order?

Well it's only one vendor per file @BethBowers so yes it's in order so to speak.

If you point the Next to the vendor field and nothing else that is in the Header being imported changes, it should use the same PO number for the whole import.

@bethbowers is right. Check which header fields you are importing and make sure they aren't changing from one record to the next.

Got it, I'll give it a try, thanks!

Okay it's pointing to column one which contains the vendor div and number (00-#######). It's still not working it's importing as separate POs.

Are the 2 date fields the same on each line? If not it'll make a new po.

One date is the PO header date the other is the line required date and no they aren't the same. So If I follow you not only does the vendor number need to be identical for each line but all dates too? That does seem like a limitation since rarely would the PO date and the date the item is needed be the same.

Since the Header Req date is bogus anyway if all of the line dates are different, just make it equal to the PO Date

That was it @BethBowers and now I follow what you were saying @BrettLyder sorry been staring at this too long!

That's ok., I know the feeling!!