Member Login

Username
Password
Forget Password
New Sign Up
  Search Forums

  FREE Support
  Forums

  QODBC v10
  QODBC v9
  QODBC v8
  QODBC v7
  QODBC v6

  QODBC FAQs

The QDeveloper Forum is the property of Data Access Worldwide, Australia. The contents of this forum have been taken by FLEXquarters.com Limited, Hong Kong at: http://support.flexquarters
.com/esupport/
without our permission.

 


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

Forum : Error applying credit to invoice (credit transaction object was deleted or modified)Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v9 Independent Self Help Forum

 New Topic 
 
 Post Reply 
[1]  
 Error applying credit to invoice (credit transaction object was deleted or modified) 
 Author   Message 
  John 
  
 Group: Members 
 Posts: 5 
 Joined: 2007-03-20 
 Profile
 Posted : 2010-02-12 02:10:16

Can anyone provide any insight into the issue behind this error?  Out of the hundreds of these type transactions my software inserts each day, I see this error on one or two.  I'm not sure if the problem is with this transaction or with the credit memo being referenced.  I can query the referenced credit memo manually and verify that it does exist and it does have credit remaining.

2010-02-10 20:04:33 QODBC Ver:  8.00.00.237 *********************************************************************************************************************
IsAService: False
SQL Statement: INSERT INTO ReceivePaymentLine ( CustomerRefListID,TxnDate,AppliedToTxnTxnID,AppliedToTxnSetCreditCreditTxnID,AppliedToTxnSetCreditAppliedAmount,FQSaveToCache ) VALUES  (  ?, ?, ?, ?, ?, ? )
3173 - The related credit transaction transaction object specified by the ID F461B-1265801454 was deleted or modified.
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="6.0"?>
<QBXML>
    <QBXMLMsgsRq onError = "continueOnError" responseData = "includeAll">
        <ReceivePaymentAddRq requestID = "1">
            <ReceivePaymentAdd defMacro = "TxnID:C5A03C7D-8AE0-4D14-98A1-1A399AEAAFE8">
                <CustomerRef>
                    <ListID>800001AF-1175537453</ListID>
                </CustomerRef>
                <TxnDate>2009-12-22</TxnDate>
                <AppliedToTxnAdd>
                    <TxnID>E4D8A-1260469562</TxnID>
                    <SetCredit>
                        <CreditTxnID>F461B-1265801454</CreditTxnID>
                        <AppliedAmount>5.00</AppliedAmount>
                    </SetCredit>
                </AppliedToTxnAdd>
            </ReceivePaymentAdd>
        </ReceivePaymentAddRq>
    </QBXMLMsgsRq>
</QBXML>
Output XML:
<?xml version="1.0" ?>
<QBXML>
    <QBXMLMsgsRs>
        <ReceivePaymentAddRs requestID="1" statusCode="3173" statusSeverity="Error" statusMessage="The related credit transaction transaction object specified by the ID F461B-1265801454 was deleted or modified." />
    </QBXMLMsgsRs>
</QBXML>

 

 
John 
 
  Top 
  Tom Aczel 
  dd4bf_dawworld.jpg
 Group: Administrator 
 Posts: 6281 
 Joined: 2006-02-17 
 Profile
 Posted : 2010-02-12 23:22:20

The normal format to apply a overpayment is:-

TO APPLY A PAYMENT CREDIT
INSERT INTO ReceivePaymentLine (CustomerRefListID, ARAccountRefListID,
AppliedToTxnTxnID, AppliedToTxnPaymentAmount, AppliedToTxnSetCreditCreditTxnID,
AppliedToTxnSetCreditAppliedAmount) VALUES ('AE0000-1197765289',
'40000-933270541','5C2C-1197773093', 500.00, '5C29-1197772163', 500.00)

By the sounds of things it's possible that the related credit transaction transaction object specified by the ID F461B-1265801454 was modified by either another QuickBooks user or another transaction. I would check the SDK Messages Log for further clues.

 

 

  Top 
  John 
  
 Group: Members 
 Posts: 5 
 Joined: 2007-03-20 
 Profile
 Posted : 2010-03-20 04:28:35
Tom, I found an old post that suggested switching QB into single user mode as a way around this specific error.  I tried that on the failed credit transactions, and amazingly, it does work every time.  As a work around that's fine for now, but I would still like to find a solution if possible.  If you have any further suggestions, I will appreciate them.  Thanks. 

 
John 
 
  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to    

Copyright (c) 2006-2009
Data Access Worldwide, Australia. This FREE self help forum website was copied by FLEXquarters.com Limited, Hong Kong to: http://archive.qodbc.com
/forum50f5.html
without our permission.

The QDeveloper Forum is dedicated to the FREE professional exchange of information. QODBC and FlexODBC users can post support queries, report product bugs, or simply search topics for help. Data Access Worldwide - Asia Pacific normal office business hours are 9am to 5pm week days Australian EST with the exception of Public Holidays.
       
ABN: 86 544 223 459
PO Box 873, Boronia VIC 3155 Australia  Tel: 03 9761 3644  Intl: +613 9761 3644