Can we get to know how much Vendor Credit and BillPayment amount each applied to specific Bill?

Thank you for posting in the Community, @chetan003.

In QuickBooks Online, you're able to open Bill Payments to view how much is the applied credit.

Since you're using API to link your bill and credit, I suggest you contact the app to check about the bill.

Please feel free to read these handy articles for your reference:
- Enter bills and record bill payments in QuickBooks Online

- Applying vendor credits

Just leave a comment on the thread if you have further questions. Have a great weekend!

We don't use API to link Bill and Credit. We link Bill and Credits in Quickbooks. And then we try to pull that information through API and here is the problem. The Payment object which have linked Bills and Credits does not provide the information about which Bill is linked to which Credit and how much amount is applied.

See the BillPayment Object below. It just provide information of linked Bills and Credits but does not provide which Bill is linked to which credit and what amout is applied to that Bill.

{ "QueryResponse": { "BillPayment": [ { "VendorRef": { "value": "290", "name": "Lonza AG" }, "PayType": "Check", "CheckPayment": { "BankAccountRef": { "value": "33", "name": "First Republic Bank" }, "PrintStatus": "NotSet" }, "TotalAmt": 19725.33, "domain": "QBO", "sparse": false, "Id": "28648", "SyncToken": "1", "MetaData": { "CreateTime": "2021-04-16T13:18:41-07:00", "LastUpdatedTime": "2021-04-23T11:48:13-07:00" }, "DocNumber": "FX 632214", "TxnDate": "2021-04-14", "CurrencyRef": { "value": "USD", "name": "United States Dollar" }, "Line": [ { "Amount": 24726.4, "LinkedTxn": [ { "TxnId": "27730", "TxnType": "Bill" } ] }, { "Amount": 12778.9, "LinkedTxn": [ { "TxnId": "27571", "TxnType": "Bill" } ] }, { "Amount": 16404.8, "LinkedTxn": [ { "TxnId": "27986", "TxnType": "VendorCredit" } ] }, { "Amount": 1375.17, "LinkedTxn": [ { "TxnId": "28647", "TxnType": "VendorCredit" } ] } ] } ], "startPosition": 1, "maxResults": 1, "totalCount": 1 }, "time": "2021-05-28T05:52:59.618-07:00" }

We don't use API to link Bill and Credit. We link Bill and Credits in Quickbooks. And then we try to pull that information through API and here is the problem. The Payment object which have linked Bills and Credits does not provide the information about which Bill is linked to which Credit and how much amount is applied.

See the BillPayment Object below. It just provide information of linked Bills and Credits but does not provide which Bill is linked to which credit and what amout is applied to that Bill.

{ "QueryResponse": { "BillPayment": [ { "VendorRef": { "value": "290", "name": "Lo" }, "PayType": "Check", "CheckPayment": { "BankAccountRef": { "value": "33", "name": "First" }, "PrintStatus": "NotSet" }, "TotalAmt": 19725.33, "domain": "QBO", "sparse": false, "Id": "28648", "SyncToken": "1", "MetaData": { "CreateTime": "2021-04-16T13:18:41-07:00", "LastUpdatedTime": "2021-04-23T11:48:13-07:00" }, "DocNumber": "FX 632214", "TxnDate": "2021-04-14", "CurrencyRef": { "value": "USD", "name": "United States Dollar" }, "Line": [ { "Amount": 24726.4, "LinkedTxn": [ { "TxnId": "27730", "TxnType": "Bill" } ] }, { "Amount": 12778.9, "LinkedTxn": [ { "TxnId": "27571", "TxnType": "Bill" } ] }, { "Amount": 16404.8, "LinkedTxn": [ { "TxnId": "27986", "TxnType": "VendorCredit" } ] }, { "Amount": 1375.17, "LinkedTxn": [ { "TxnId": "28647", "TxnType": "VendorCredit" } ] } ] } ], "startPosition": 1, "maxResults": 1, "totalCount": 1 }, "time": "2021-05-28T05:52:59.618-07:00" }

Hi there, chetan003.

Thank you for coming back to the thread to add further information about your concern. I'll share extra details on how QuickBooks Online works if there's a 3rd party involved.

When you're using 3rd party app while working with QuickBooks Online, all the information depends on the data shared by each software. Since you already linked the Bill and Credits in Quickbooks and you used API when pulling up that information, I suggest contacting the app provider as mentioned above. They have the tools to investigate the cause of why the payment object which has linked between two entries does not provide the information on which Bill is linked to. Then, which Credit and how much amount is applied.

Please refer to this article to view steps on how you can run a specific report that will reflect all payments made to vendors: Run a report with vendor totals.

If you have any other concerns or additional questions about QuickBooks, post a comment below. I'll be around to help. Wishing you the best.

We don't use any third party app. I said we are link Bill and Credit directly in Quickbooks and it results in BillPayment. The issue is that when we pull this BillPayment through API it does not show which Bill is linked to which Credit.

Thanks for getting back here, @chetan003.

I got additional steps so you can see which credit and bill are linked to the bill payment. You can first check it inside your QuickBooks Online (QBO) account. To do so, please follow these steps:

1. Go to the Expenses menu.
2. Choose Vendors.
3. Click the name of the vendor you need to check.
4. Select the Bill Payment to open.
5. Then, click the More button.
6. Choose Audit history.

When confirmed that the transactions are correctly linked, I suggest reaching out to the app developer to further help you check why the Bill Payment that was pull up using API don't show the bill and credit. 

Also, since you've mentioned above that you're not using any third-party app, I recommend consulting our Technical support team to further check the bill payment transactions. To do so, please follow the steps in this article: QuickBooks Online Support.

Then, to find sources and articles you can save for future use, feel free to visit our Community Help page. Just type a keyword of your concern on the search bar so the system will show related articles for you. You can also simply select any of the categories displayed. 

Keep me posted if you have further concerns managing your bill payments in QBO. I'll be on the lookout for your response. Have a good one.

I mean the Quickbook BillPayment API itself does return only Bills and Credits. It does not return the link information. Thats the problem.

See below Quickbooks BillPayment API response.

{ "QueryResponse": { "BillPayment": [ { "VendorRef": { "value": "290", "name": "L" }, "PayType": "Check", "CheckPayment": { "BankAccountRef": { "value": "33", "name": "First" }, "PrintStatus": "NotSet" }, "TotalAmt": 19725.33, "domain": "QBO", "sparse": false, "Id": "28648", "SyncToken": "1", "MetaData": { "CreateTime": "2021-04-16T13:18:41-07:00", "LastUpdatedTime": "2021-04-23T11:48:13-07:00" }, "DocNumber": "FX 632214", "TxnDate": "2021-04-14", "CurrencyRef": { "value": "USD", "name": "United States Dollar" }, "Line": [ { "Amount": 24726.4, "LinkedTxn": [ { "TxnId": "27730", "TxnType": "Bill" } ] }, { "Amount": 12778.9, "LinkedTxn": [ { "TxnId": "27571", "TxnType": "Bill" } ] }, { "Amount": 16404.8, "LinkedTxn": [ { "TxnId": "27986", "TxnType": "VendorCredit" } ] }, { "Amount": 1375.17, "LinkedTxn": [ { "TxnId": "28647", "TxnType": "VendorCredit" } ] } ] } ], "startPosition": 1, "maxResults": 1, "totalCount": 1 }, "time": "2021-05-28T05:52:59.618-07:00" }

Hello there, chetan003. 

You can get in touch with our developers who can give you more details about the linking of the credit and bill payment options. You can visit their site and log in through your Intuit Account. Just click here to be routed to their page. 

I'll be attaching articles that are helpful in handling your vendor transactions:

• Enter bills and record bill payments in QuickBooks Online
• Applying vendor credits
• Common custom reports in QuickBooks Online

Just let me know if you have other questions. I'll be here to keep posted with your replies. Stay safe!