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).
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (