Author Topic: TxnID not found when making payment against an invoice  (Read 8517 times)

johnlewisdesign

  • Member
  • *
  • Posts: 81
TxnID not found when making payment against an invoice
« on: June 27, 2013, 03:13:56 AM »
Hi guys

I've got a weird issue in QB Enterprise 2013. I can post an invoice, which returns the TxnID DF0C-1372320837 and posts as expected. When I make a payment against the invoice, it tells me TxnID DF0C-1372320837 was not found. What could be the problem? QBXML all looks valid...

johnlewisdesign

  • Member
  • *
  • Posts: 81
Re: TxnID not found when making payment against an invoice
« Reply #1 on: June 27, 2013, 04:21:34 AM »
I think I answered my own question...the company file I am working with has various level of subaccounts - but the file was not set to 'show lowest subaccount only'. This also means you need an account number for every account, even inactive ones, or you cannot select this option.

johnlewisdesign

  • Member
  • *
  • Posts: 81
Re: TxnID not found when making payment against an invoice
« Reply #2 on: June 27, 2013, 04:50:47 AM »
Nope, that didn't fix it.


johnlewisdesign

  • Member
  • *
  • Posts: 81
Re: TxnID not found when making payment against an invoice
« Reply #3 on: June 27, 2013, 05:59:40 AM »
<?xml version="1.0" encoding="ISO-8859-1" ?>
<?qbxml version="12.0" ?>
<QBXML>
<QBXMLMsgsRq onError="stopOnError">
<ReceivePaymentAddRq>
<ReceivePaymentAdd>
<CustomerRef>
<ListID>800003D4-1371656076</ListID>
<FullName>abc, Ltd.</FullName>
</CustomerRef>
<ARAccountRef>
<ListID>800000A3-1370477831</ListID>
</ARAccountRef>
<TxnDate>2013-06-27</TxnDate>
<RefNumber>1234</RefNumber>
<TotalAmount>0.01</TotalAmount>
<PaymentMethodRef>
<ListID>80000002-1256932063</ListID>
</PaymentMethodRef>
<AppliedToTxnAdd>
<TxnID>DF10-1372337472</TxnID>
<PaymentAmount>0.01</PaymentAmount>
</AppliedToTxnAdd>
</ReceivePaymentAdd>
</ReceivePaymentAddRq>
</QBXMLMsgsRq>
</QBXML>


This is my output.
« Last Edit: June 27, 2013, 07:25:29 AM by johnlewisdesign »

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 468
Re: TxnID not found when making payment against an invoice
« Reply #4 on: June 27, 2013, 06:28:15 AM »
I haven't seen the problem you're describing, so I can only offer a couple things that may be worth looking at:

I notice that the QBXML is showing a different TxnID value than identified in your earlier messages. Is it possible that you deleted/voided the targeted QB Invoice?

Are you logged into QB with Admin level access? If not, does your login's access allow ReceivePayment?

The CustomerRef elements identify both ListID and FullName...are they both correct for the targeted Invoice? Are they identifying the same Customer? What happens if you omit the CustomerRef::FullName element?


HTH!

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852

johnlewisdesign

  • Member
  • *
  • Posts: 81
Re: TxnID not found when making payment against an invoice
« Reply #5 on: June 27, 2013, 07:16:33 AM »
I notice that the QBXML is showing a different TxnID value than identified in your earlier messages. Is it possible that you deleted/voided the targeted QB Invoice?

Sorry, yes I made a new one and tried again after I enabled the subaccounts. I will be deleting all these anyway. The problem is still the same though. Strangely this only occurs in Enterprise 2013.


Are you logged into QB with Admin level access? If not, does your login's access allow ReceivePayment?

I did have a permissions issue with this user, but have since granted it full access.


The CustomerRef elements identify both ListID and FullName...are they both correct for the targeted Invoice? Are they identifying the same Customer? What happens if you omit the CustomerRef::FullName element?

It should be correct, as the invoice went through ok, but i will omit now and find out. Thanks Geoffrey. BRB

johnlewisdesign

  • Member
  • *
  • Posts: 81
Re: TxnID not found when making payment against an invoice
« Reply #6 on: June 27, 2013, 07:27:12 AM »
No dice, same thing. :( Darn it! Do you think something changed in 2013 compared to 2012? It works flawlessly on other systems.

I found this

https://idnforums.intuit.com/messageview.aspx?catid=7&threadid=7014

But technically this would still leave me 0.01 anyway, not a negative, I'm confused...

johnlewisdesign

  • Member
  • *
  • Posts: 81
Re: TxnID not found when making payment against an invoice
« Reply #7 on: June 27, 2013, 07:44:13 AM »
How would one go about querying the invoice and finding out the TxnID associated with it?

johnlewisdesign

  • Member
  • *
  • Posts: 81
Re: TxnID not found when making payment against an invoice
« Reply #8 on: June 27, 2013, 08:05:59 AM »
I also found this...could it be something changed?

http://dev.developer.intuit.com/qbSDK-current/ReleaseNotes.pdf

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 468
Re: TxnID not found when making payment against an invoice
« Reply #9 on: June 27, 2013, 02:56:46 PM »
You can query for an Invoice using RefNumber if you don't know the TxnID. You can also query for an Invoice using the TxnID, which is a very direct way to determine whether or not it's been deleted from QB.

A few more things to check...

Confirm that the CustomerRef::ListID is the same on the Invoice as on the ReceivePayment.

Same with the ARAccountRef::ListID.

What's the TxnDate on the Invoice? Is it <= the ReceivePayment TxnDate?

What R# (Release) is your QBE 2013 file using? (The F2 key will pop up a window with that and more.) There was a very short-lived R# that had problems with some functionality when called from an external app, but I don't recall the details--it may have been R6 but I can't confirm that at the moment.

HTH!

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852

johnlewisdesign

  • Member
  • *
  • Posts: 81
Re: TxnID not found when making payment against an invoice
« Reply #10 on: June 28, 2013, 02:10:52 AM »
That's good to know as the Refnumber is the invoice number anyway. I may add a further condition that fails over to RefNumber then.

Its on R7 now but the issue did surface on R6. Very valid points, will check the date too.

Finally I found something yesterday on the IDN mentioning IsPending property:

Quote
"In the InvoiceAdd or InvoiceMod request, there's an "IsPending" property. You'll want to set this to false.
"

Guess I'll exhaust these avenues and keep everything crossed!

Thanks Geoffrey.

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 468
Re: TxnID not found when making payment against an invoice
« Reply #11 on: June 28, 2013, 05:15:04 AM »
The IsPending default value has always been false, and that element can safely be omitted from all but those Requests where it needs to be true. If you query the invoice, double-check that its value is false. If it's not (and you made no change to its value in the QB UI) please post here.

HTH!

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852

johnlewisdesign

  • Member
  • *
  • Posts: 81
Re: TxnID not found when making payment against an invoice
« Reply #12 on: June 28, 2013, 08:09:17 AM »
(edited out as I worked this question out)
« Last Edit: June 28, 2013, 08:39:24 AM by johnlewisdesign »

johnlewisdesign

  • Member
  • *
  • Posts: 81
Re: TxnID not found when making payment against an invoice
« Reply #13 on: June 28, 2013, 08:34:33 AM »
OK so the plot thickens...

The returned TxnID for the payment is DF18-1372427179 whereas the invoice is DF10-1372337472!

TxnID for Record 1 of this customer's invoices is DF18-1372427179...
« Last Edit: June 28, 2013, 08:40:18 AM by johnlewisdesign »

johnlewisdesign

  • Member
  • *
  • Posts: 81
Re: TxnID not found when making payment against an invoice
« Reply #14 on: June 28, 2013, 09:33:35 AM »
Ah man that is that theory out of the window. Even with one invoice it still can't find it.

Geoffrey, how would you check the TxnID of an invoice from QB? I'm starting to wonder whether it is right in the first place. thanks.