Hi,

I am desperately trying to retrieving invoices linked to payments to check if the payment balance is zero in order to skip those specific payments when I then try to link new imported invoices into payments with balance <>0.

I use the scripts below but it does not return me the list of invoices applied to the single payments to check if the total equal the payment total amount. Where is the problem with the script?

Thank yo so much.

Michele Annoni

Hi Michele,

It looks like you might be trying to query for the payments that have the full name of “room_no”, but it might not be pulling everything due to a missing add of “IncludeRetElement”.

Try adding after PCQB_RqAddFieldWithValue( “IncludeLineItems” ; True ), the following:

Set Variable [ $$Result; PCQB_RqAddFieldWithValue( “IncludeRetElement” ; “AppliedToTxnRet” )

That should instruct QuickBooks to also provide any transactions that the payment has been applied to, which should point you to the invoices that were paid by the received payment.

-PCI Team

Dear Sir,

I changed like this but still not working

I tried again with this script but, if I include the two linen in red after the EXECUTE it will not return the "TxnID". If take them out it returns the "TxnID.

Dear All,

disregard this issue ticket. I solved the problem.

Thank you for your support.

Michele Annoni