Scenario
Quotation set Closed status prompted ‘Total quantity – total cancelled quantity cannot less than transferred quantity’
(Tick “Closed” checkbox and click save)
(Non-Accounting transactions refer to Quotation, Sales Order, Delivery Order, Purchase Requisition, Purchase Order and Goods Received Notes)
Solution
1. Go to File > Utilities > QNE Management Tools
- 2. Once QNE Management Tools prompted, go to Tools > Intelligence SQL Queries
2. Click on Import Script button, select script (download from below link)
https://drive.google.com/open?id=0BzrrsMUq-H6gbWM3N0dfY0pxX3c
3. Tick on checkbox ‘Overwrite Generated SQL’
- Quotation: QUOTATIONDETAIL
- Sales Order: SALESORDERDETAIL
- Delivery Order: DELIVERYORDERDETAIL
- Purchase Requisition: PURCHASEREQUISITIONDETAIL
- Purchase Order: PURCHASEORDERDETAIL
5. Example: I cannot set Quotation to Closed then I will amend my first row like below
6. Click Execute button and close QNE Management Tools
7. You may go back to the non-accounting transaction and set closed again.
** Learn more about Azure Cloud
** Learn more about QNE Hybrid Cloud Software