I need a report that show the exactly amount of item as well as purchase price, in purchase invoice and debit note, then a number showing the amount we need to pay.
I tried this well in another case, where there is no debit note. In this case, I don’t know how to show as I want.
@huyen, you should start by completing all the partial selection criteria in your custom report definition. For example, you have selected Inventory item, but left the secondary field blank. Likewise, you should complete your Where filters.
Understand that I cannot troubleshoot your custom report. I can only make further observations:
You have made more changes than I recommended, some of which caused more problems. I am not saying they were necessarily wrong to make, but that you are asking for help with a constantly changing report. Others cannot keep up.
You have recorded additional transactions with this supplier while you have been working on this report. That also makes it difficult to keep up, because you have not furnished information about the additional transaction.
You are selecting only debits, so you may not see relevant transactions.
You are not filtering for relevant accounts, so you are seeing both legs of the double entries. In some cases, the information you are asking for is missing from a transaction.
For report development purposes, it is often helpful to include the account name as a selection criteria. That way, you can see where the individual lines come from. Then you include appropriate account filters.
I would not include the “Inventory Item Purchase Price”, because that is just the amount you entered for the item in the Inventory Items tab. It may not be the amount you paid per unit on a purchase invoice.
@huyen be aware that Custom Reports do not have a Starting Balance for the report period, and that the above sample report does not show payments to the supplier. So the total (9,768.97) may not be what is owed to the Supplier. You need to verify the total with your other records and Supplier Statements.
@dcVest is right. That information is available simply by looking at the supplier’s payable balance. No need to define any kind of report, built-in or custom.
