Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing Sales Orders IF item is available

Status
Not open for further replies.

mlacc

Programmer
Jan 4, 2005
2
US
I'm trying to import sales orders to MAS90 using VI. I want to check if the item is available before creating an SO. If the item is available, import the sales order. Otherwise, go to the next record.

Does anyone have an idea on how to do this?
 
Hi.

Under your record types, there is a section for criteria.

If you check that and have it read im1 total qty on hand < qty orderd, that should do the trick.

It won't know though if it has only 1, and you import 10 sales orders for one each.

ChaZ
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top