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’


4. Amend first row ‘PURCHASEORDERDETAIL’ according to your transaction type
  • 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