Hello,
We are trying to automate backorder drop (transfer from backorder to order). Where can I update (SQL table) to change the default quantity shortage logic and change it back after the transfer is complete.
*This post is locked for comments
It's called Default Quantity Shortage Options, DFQTYSOP. The stored values are as follow:
1 - Override Shortage
2 - Sell Balance
3 - Back Order Balance
4 - Back Order All
5 - Cancel Balance
6 - Cancel All
7 - Distribute
Thank You - which field in SOP40100?
The Quantity Shortage option is stored in the Sales Setup table (SOP40100). For the Backorder All and Backorder Balance values, you must first check if an item is configured to allow those, in the Item Master table (IV00101).
Share
Report
All responses (
Answers (
26,225
