Sage 100

v2017 premium. I want to use VI to change SO_SalesOrderHeader.OrderType from B to Q. VI doesn't allow it. How do I get this to work? I believe it is a ddf / dde modification but I don't recall the exact process.

Note that inventory on-order qty's have to be updated when this happens.

I haven't looked closely but very likely the business object itself doesn't allows that (IOW probably not a dictionary thing). You could edit it directly into SQL but be careful obviously.

@LeeGraham Yes, I also need to set the BO qty to 0 on the line and rebuild SO sorts to recalc on BO qty. @AlnoorCassim Thank you. I can use a SQL query but it will be a bit messy. The owner has approximately 3000 specific sales orders he wants changed. I have an Excel spreadsheet of the order numbers. If it were every backorder or a range of backorders it would be simple.

Export, edit, delete the orders via script, import? The export could be to another table - or just copy the tables in SQL. Except, are they B because some piece was shipped at some point? IF so, do they care about that Sales Order History? Copy the B's to new tables, import via VI as quotes with new numbers and hire a temp for couple of days to delete the B's from SO...