i am creating a custom report so that all the below fields shown inside the red border mentioned in the screen- shot will appear. However, I can’t be able to understand which columns to choose in the definition. In particular i am unable to get the highlighted sub-total amount to appear.
That’s because it isn’t a “single value” in the sense that subtotals are dynamic and could mean anything. In fact in your given example, you have two instances of “sub-total” appearing on a single invoice.
If I understood you correctly, I think you were trying to get the total value of the invoice amount.
If that’s the case, why not show the following columns:
Sales Invoice > Total amount in base currency
Sales Invoice > WithholdingTaxAmount
Then, you can copy to clipboard and do the subtraction in a spreadsheet.
Adding to what @Ealfardan already said, any displayed transaction contains processed information from the database. The processing is encoded in the transaction view itself. The results of the processing—the subtotals, etc.—are not stored in the database.
Hi,
thank you fo the various input. I was able to achieve the below report. However, If i collapse the group the receipt date does not appear in the report. I want the receipt date to show as well along with the sub-total value.
Every line item on a custom report represents one general ledger transaction. So you will never get a sales invoice and corresponding receipt showing on the same line. Additionally, a receipt is a credit, and you have selected only debits.
