[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 the fields "IsManuallyClosed" and "PurchaseOrderLineIsManuallyClosed" in the PurchaseOrder and PurchaseOrderLine table.

IsManuallyClosed and PurchaseOrderLineIsManuallyClosed

Purchase Order Closed

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

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 is the purchase order automatically closed.

(59 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).