Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Error parsing complete XML return string - ItemReceiptItemLineSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v7 Forum

 New Topic 
 
 Post Reply 
[1]  
 Error parsing complete XML return string - ItemReceiptItemLine 
 Author   Message 
  Glade Warner 
  
 Group: Members 
 Posts: 9 
 Joined: 2006-07-08 
 Profile
 Posted : 2007-03-02 03:36:32
I am having trouble inserting some rows into the ItemReceiptItemLine table.  It seems OK for some inserts, but not for others.

QB Version: QuickBooks Enterprise Manufacturing  & Wholesale Edition Version 7.0
QODBC Version: 7.00.00.207
The error: [QODBC] Error parsing complete XML return string.

The version of the query I am posting here has the ItemLineQuantity after the PurchaseOrderLineTxnLineID.  After reading a few other posts on the "Error parsing" problem I tried the ItemLineQuantity after the RefNumber, but it made no difference.

What do you suggest?

Thanks,
Glade Warner



My Query:
INSERT INTO ItemReceiptItemLine (VendorRefListID, RefNumber, ItemLineLinkToTxnTxnID, ItemLineLinkToTxnTxnLineID, ItemLineQuantity, FQSaveToCache)  Select VendorRefListID, {fn CONCAT({fn CONCAT(RefNumber, ' - ')}, {fn CONVERT(PurchaseOrderLineSeqNo, SQL_VARCHAR)})}, TxnID, PurchaseOrderLineTxnLineID,5000.0 as ItemLineQuantity, 0 as FQSaveToCache from PurchaseOrderLine where VendorRefFullName ='Metropak the Bag Source' and RefNumber='3970' and PurchaseOrderLineSeqNo=1

From QODBCLOG.TXT:
2007-03-01 08:23:39 QODBC Ver:  7.00.00.207 *********************************************************************************************************************
IsAService: False
SQL Statement: INSERT INTO ItemReceiptItemLine (VendorRefListID, RefNumber, ItemLineLinkToTxnTxnID, ItemLineLinkToTxnTxnLineID, ItemLineQuantity, FQSaveToCache)  Select VendorRefListID, {fn CONCAT({fn CONCAT(RefNumber, ' - ')}, {fn CONVERT(PurchaseOrderLineSeqNo, S
QL_VARCHAR)})}, TxnID, PurchaseOrderLineTxnLineID,5000.0 as ItemLineQuantity, 0 as FQSaveToCache from PurchaseOrderLine where VendorRefFullName ='Metropak the Bag Source' and RefNumber='3970' and PurchaseOrderLineSeqNo=1
Optimizer Passthrough Disabled
Unsupported scalar function CONCAT

2007-03-01 08:23:52 QODBC Ver:  7.00.00.207 *********************************************************************************************************************
IsAService: False
SQL Statement: INSERT INTO ItemReceiptItemLine (VendorRefListID, RefNumber, ItemLineLinkToTxnTxnID, ItemLineLinkToTxnTxnLineID, ItemLineQuantity, FQSaveToCache)  Select VendorRefListID, {fn CONCAT({fn CONCAT(RefNumber, ' - ')}, {fn CONVERT(PurchaseOrderLineSeqNo, S
QL_VARCHAR)})}, TxnID, PurchaseOrderLineTxnLineID,5000.0 as ItemLineQuantity, 0 as FQSaveToCache from PurchaseOrderLine where VendorRefFullName ='Metropak the Bag Source' and RefNumber='3970' and PurchaseOrderLineSeqNo=1
Error parsing complete XML return string (8)
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="6.0"?>
<QBXML>
    <QBXMLMsgsRq onError = "continueOnError" responseData = "includeAll">
        <ItemReceiptAddRq requestID = "1">
            <ItemReceiptAdd defMacro = "TxnID:1C684953-24D7-40BE-AEB9-BBAB4ED0481A">
                <VendorRef>
                    <ListID>800002E5-1170883828</ListID>
                </VendorRef>
                <RefNumber>3970 - 1</RefNumber>
                <ItemLineAdd>
                    <Quantity>5000.00000</Quantity>
                    <LinkToTxn>
                        <TxnID>21E48-1170884230</TxnID>
                        <TxnLineID>21E4A-1170884230</TxnLineID>
                    </LinkToTxn>
                </ItemLineAdd>
            </ItemReceiptAdd>
        </ItemReceiptAddRq>
    </QBXMLMsgsRq>
</QBXML>


From qbsdklog.txt (includes multiple attempts):
20070301.080154    I    7300    RequestProcessor    ========= Started Connection =========
20070301.080154    I    7300    RequestProcessor    Request Processor, QBXMLRP2 v6.0
20070301.080154    I    7300    RequestProcessor    Connection opened by app named 'FLEXquarters QODBC'
20070301.080154    I    7300    CertVerifier    The Authenticode signature validated OK.
20070301.080154    I    7300    RequestProcessor    Opening the file in the DoNotCare mode.
20070301.080154    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 7300).
20070301.080154    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.080154    I    10200    QBSDKMsgSetHandler    QUERY: Host
20070301.080154    I    10200    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.080154    I    10200    QBSDKMsgSetHandler    QUERY: Company
20070301.080154    I    10200    QBSDKMsgSetHandler    Request 2 completed successfully.
20070301.080154    I    10200    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070301.080154    I    10200    QBSDKMsgSetHandler    Request 3 completed successfully.
20070301.080154    I    10200    MsgSetHandler    Finished.
20070301.080154    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 7300), ret = 0.
20070301.080202    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 7300).
20070301.080202    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.080202    I    10200    QBSDKMsgSetHandler    QUERY: PO
20070301.080202    I    10200    PurchaseOrderStorage::DoQuery    Setting iterator chunk size to 00000500
20070301.080202    I    10200    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.080202    I    10200    MsgSetHandler    Finished.
20070301.080202    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 7300), ret = 0.
20070301.080202    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 7300).
20070301.080202    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.080203    I    10200    QBSDKMsgSetHandler    QUERY: Transaction Delete
20070301.080203    I    10200    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.080203    I    10200    MsgSetHandler    Finished.
20070301.080203    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 7300), ret = 0.
20070301.080203    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 7300).
20070301.080203    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.080203    I    10200    QBSDKMsgSetHandler    ADD: Item Receipt
20070301.080203    E    10200    StorageInterface    *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error.
20070301.080226    E    7300    RequestProcessor    Process Request error = 80010105
20070301.080438    I    7300    RequestProcessor    Connection closed.
20070301.080438    I    7300    RequestProcessor    ========== Ended Connection ==========

20070301.080507    I    8140    RequestProcessor    ========= Started Connection =========
20070301.080507    I    8140    RequestProcessor    Request Processor, QBXMLRP2 v6.0
20070301.080507    I    8140    RequestProcessor    Connection opened by app named 'FLEXquarters QODBC'
20070301.080508    I    8140    CertVerifier    The Authenticode signature validated OK.
20070301.080508    I    8140    RequestProcessor    Opening the file in the DoNotCare mode.
20070301.080508    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 8140).
20070301.080508    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.080508    I    10200    QBSDKMsgSetHandler    QUERY: Host
20070301.080508    I    10200    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.080508    I    10200    QBSDKMsgSetHandler    QUERY: Company
20070301.080508    I    10200    QBSDKMsgSetHandler    Request 2 completed successfully.
20070301.080508    I    10200    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070301.080508    I    10200    QBSDKMsgSetHandler    Request 3 completed successfully.
20070301.080508    I    10200    MsgSetHandler    Finished.
20070301.080508    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 8140), ret = 0.
20070301.080511    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 8140).
20070301.080511    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.080511    I    10200    QBSDKMsgSetHandler    QUERY: PO
20070301.080511    I    10200    PurchaseOrderStorage::DoQuery    Setting iterator chunk size to 00000500
20070301.080511    I    10200    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.080511    I    10200    MsgSetHandler    Finished.
20070301.080511    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 8140), ret = 0.
20070301.080511    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 8140).
20070301.080511    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.080511    I    10200    QBSDKMsgSetHandler    QUERY: Transaction Delete
20070301.080512    I    10200    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.080512    I    10200    MsgSetHandler    Finished.
20070301.080512    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 8140), ret = 0.
20070301.080512    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 8140).
20070301.080512    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.080512    I    10200    QBSDKMsgSetHandler    ADD: Item Receipt
20070301.080512    E    10200    StorageInterface    *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error.
20070301.080520    E    8140    RequestProcessor    Process Request error = 80010105
20070301.080702    I    8140    RequestProcessor    Connection closed.
20070301.080702    I    8140    RequestProcessor    ========== Ended Connection ==========

20070301.082033    I    8448    RequestProcessor    ========= Started Connection =========
20070301.082033    I    8448    RequestProcessor    Request Processor, QBXMLRP2 v6.0
20070301.082033    I    8448    RequestProcessor    Connection opened by app named 'FLEXquarters QODBC'
20070301.082033    I    8448    CertVerifier    The Authenticode signature validated OK.
20070301.082033    I    8448    RequestProcessor    Opening the file in the DoNotCare mode.
20070301.082033    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 8448).
20070301.082033    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.082033    I    10200    QBSDKMsgSetHandler    QUERY: Host
20070301.082033    I    10200    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.082033    I    10200    QBSDKMsgSetHandler    QUERY: Company
20070301.082033    I    10200    QBSDKMsgSetHandler    Request 2 completed successfully.
20070301.082033    I    10200    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070301.082033    I    10200    QBSDKMsgSetHandler    Request 3 completed successfully.
20070301.082033    I    10200    MsgSetHandler    Finished.
20070301.082033    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 8448), ret = 0.
20070301.082056    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 8448).
20070301.082056    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.082056    I    10200    QBSDKMsgSetHandler    QUERY: PO
20070301.082056    I    10200    PurchaseOrderStorage::DoQuery    Setting iterator chunk size to 00000500
20070301.082056    I    10200    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.082056    I    10200    MsgSetHandler    Finished.
20070301.082056    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 8448), ret = 0.
20070301.082056    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 8448).
20070301.082057    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.082057    I    10200    QBSDKMsgSetHandler    QUERY: Transaction Delete
20070301.082057    I    10200    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.082057    I    10200    MsgSetHandler    Finished.
20070301.082057    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 8448), ret = 0.
20070301.082057    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 8448).
20070301.082057    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.082057    I    10200    QBSDKMsgSetHandler    ADD: Item Receipt
20070301.082057    E    10200    StorageInterface    *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error.
20070301.082111    E    8448    RequestProcessor    Process Request error = 80010105
20070301.082152    I    8448    RequestProcessor    Connection closed.
20070301.082152    I    8448    RequestProcessor    ========== Ended Connection ==========

20070301.082157    I    9204    RequestProcessor    ========= Started Connection =========
20070301.082157    I    9204    RequestProcessor    Request Processor, QBXMLRP2 v6.0
20070301.082157    I    9204    RequestProcessor    Connection opened by app named 'FLEXquarters QODBC'
20070301.082157    I    9204    CertVerifier    The Authenticode signature validated OK.
20070301.082158    I    9204    RequestProcessor    Opening the file in the DoNotCare mode.
20070301.082158    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 9204).
20070301.082158    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.082158    I    10200    QBSDKMsgSetHandler    QUERY: Host
20070301.082158    I    10200    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.082158    I    10200    QBSDKMsgSetHandler    QUERY: Company
20070301.082158    I    10200    QBSDKMsgSetHandler    Request 2 completed successfully.
20070301.082158    I    10200    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070301.082158    I    10200    QBSDKMsgSetHandler    Request 3 completed successfully.
20070301.082158    I    10200    MsgSetHandler    Finished.
20070301.082158    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 9204), ret = 0.
20070301.082204    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 9204).
20070301.082204    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.082204    I    10200    QBSDKMsgSetHandler    QUERY: PO
20070301.082204    I    10200    PurchaseOrderStorage::DoQuery    Setting iterator chunk size to 00000500
20070301.082204    I    10200    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.082204    I    10200    MsgSetHandler    Finished.
20070301.082204    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 9204), ret = 0.
20070301.082204    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 9204).
20070301.082204    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.082204    I    10200    QBSDKMsgSetHandler    QUERY: Transaction Delete
20070301.082204    I    10200    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.082204    I    10200    MsgSetHandler    Finished.
20070301.082204    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 9204), ret = 0.
20070301.082204    I    10200    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 9204).
20070301.082204    I    10200    SpecVersion    Current version of qbXML in use: 6.0
20070301.082204    I    10200    QBSDKMsgSetHandler    ADD: Item Receipt
20070301.082204    E    10200    StorageInterface    *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error.
20070301.082211    E    10200    QBSDKProcessRequest    *** INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST ***.
20070301.082215    E    9204    RequestProcessor    Process Request error = 80010105
20070301.082300    I    9204    RequestProcessor    Connection closed.
20070301.082300    I    9204    RequestProcessor    ========== Ended Connection ==========

20070301.082334    I    6372    RequestProcessor    ========= Started Connection =========
20070301.082334    I    6372    RequestProcessor    Request Processor, QBXMLRP2 v6.0
20070301.082334    I    6372    RequestProcessor    Connection opened by app named 'FLEXquarters QODBC'
20070301.082334    I    6372    CertVerifier    The Authenticode signature validated OK.
20070301.082334    I    6372    RequestProcessor    Opening the file in the DoNotCare mode.
20070301.082334    I    7616    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 6372).
20070301.082334    I    7616    SpecVersion    Current version of qbXML in use: 6.0
20070301.082334    I    7616    QBSDKMsgSetHandler    QUERY: Host
20070301.082334    I    7616    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.082334    I    7616    QBSDKMsgSetHandler    QUERY: Company
20070301.082334    I    7616    QBSDKMsgSetHandler    Request 2 completed successfully.
20070301.082334    I    7616    QBSDKMsgSetHandler    QUERY: DataExtension Definition
20070301.082334    I    7616    QBSDKMsgSetHandler    Request 3 completed successfully.
20070301.082334    I    7616    MsgSetHandler    Finished.
20070301.082334    I    7616    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 6372), ret = 0.
20070301.082339    I    7616    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 6372).
20070301.082339    I    7616    SpecVersion    Current version of qbXML in use: 6.0
20070301.082339    I    7616    QBSDKMsgSetHandler    QUERY: PO
20070301.082339    I    7616    PurchaseOrderStorage::DoQuery    Setting iterator chunk size to 00000500
20070301.082339    I    7616    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.082339    I    7616    MsgSetHandler    Finished.
20070301.082339    I    7616    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 6372), ret = 0.
20070301.082339    I    7616    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 6372).
20070301.082339    I    7616    SpecVersion    Current version of qbXML in use: 6.0
20070301.082339    I    7616    QBSDKMsgSetHandler    QUERY: Transaction Delete
20070301.082339    I    7616    QBSDKMsgSetHandler    Request 1 completed successfully.
20070301.082339    I    7616    MsgSetHandler    Finished.
20070301.082339    I    7616    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' finishing requests (process 6372), ret = 0.
20070301.082339    I    7616    QBSDKProcessRequest    Application named 'FLEXquarters QODBC' starting requests (process 6372).
20070301.082339    I    7616    SpecVersion    Current version of qbXML in use: 6.0
20070301.082339    I    7616    QBSDKMsgSetHandler    ADD: Item Receipt
20070301.082339    E    7616    StorageInterface    *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error.
20070301.082348    E    7616    QBSDKProcessRequest    *** INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST ***.
20070301.082352    E    6372    RequestProcessor    Process Request error = 80010105

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-03-02 08:48:49

You cannot play with the ItemLineQuantity, each line must be receipted in full. Linked Item Receipts must be done like this:

INSERT INTO "ItemReceiptItemLine" ("VendorRefListID", "RefNumber",
"ItemLineLinkToTxnTxnID", "ItemLineLinkToTxnTxnLineID",
"FQSaveToCache") 
Select "VendorRefListID", {fn CONCAT('POLink', "RefNumber")},
"TxnID",
"PurchaseOrderLineTxnLineID",
0 as "FQSaveToCache" from PurchaseOrderLine
where "VendorRefFullName" ='Perry Windows & Doors' and "RefNumber"='401'
and "PurchaseOrderLineSeqNo"=1

If the quantity needs to be varied, update the purchase order line first.

See: How do I receive Items against a Purchase Order? Receive Inventory without Bill? ItemReceipts for more information.

 

  Top 
  Glade Warner 
  
 Group: Members 
 Posts: 9 
 Joined: 2006-07-08 
 Profile
 Posted : 2007-03-02 12:16:17
Tom, my customers receive things in stages, not all at once.  I want to send the partial receipts to QuickBooks as they are performed by the receiving clerks.  My insert queries work most of the time.  I get an occasional problem, and captured one of the SQL that causes the trouble (posted in this thread).

Are you sure that I can't set the ItemLineQuantity in this query?  If not, then how would I receive less than expected on the PO?


Thanks,
Glade Warner 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-03-02 13:11:23

I bearly got linked receipts going in the first place. What you need to do is to change the purchase order first. For example, if 30 were ordered and 10 were received, change (UPDATE) the quantity on the purchase order line from 30 to 20 and then add (INSERT) a new purchase order line for 10 and fully receipt that line, leaving 20 still to be received on the original purchase order line.  Ok?

The error "*** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error." should also be read as meaning you can corrupt the company file if you keep on doing this.

 

  Top 
  Glade Warner 
  
 Group: Members 
 Posts: 9 
 Joined: 2006-07-08 
 Profile
 Posted : 2007-03-03 05:57:49
Thanks for the information.  That is helpful.
Unfortunately POs are created by another department and are a business document that are sent out to the customers.  It is not appropriate that I modify any PO, other than recording receipts.

I'll modify my code so that if the receipt is exactly a full receipt (not over and not under) then I'll follow your advice and not use the ItemLineQuantity so a full receipt gets recorded in QuickBooks.  Otherwise, I'll continue to use the ItemLineQuantity and capture any exceptions thrown.  For those with exceptions, I'll post an error message telling the receiving people that they will need to complete recording the receipt directly in QB.  I'll also hope that the company file is not corrupted.

I don't see that I can do anything else.

Thanks for your quick replies.  You always do a great job!

-- Glade Warner 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to