Knowledgebase
[QODBC-Desktop] How to Find Purchase Order Closed Check Mark Data using QODBC
Posted by Juliet (QODBC Support) on 08 September 2011 08:04 AM

How to Find Purchase Order Closed Check Mark Data using QODBC

Introduction

There is a closed check mark for a PurchaseOrder record or a given line item in a Purchase Order, normally it's related to two fields named "IsManuallyClosed" and "PurchaseOrderLineIsManuallyClosed" in PurchaseOrder and PurchaseOrderLine table.

IsManuallyClosed and PurchaseOrderLineIsManuallyClosed

Purchase Order Closed

The Field "IsManuallyClosed" in both table PurchaseOrder and PurchaseOrderLine contains the whole purchase order closed status. If it is true, the purchase order is closed and all the line items are closed as well.

Purchase Order Line Closed

The Field "PurchaseOrderLineIsManuallyClosed" in table PurchaseOrderLine contains the closed status of every line item. Only if all the line items under a specified purchase order are closed, the purchase order is automatically closed then.

(58 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).