Name of Feature/Request: Add Posting Date Column and Filter for Report Builder - GL Posting Cash Dataset
What financial, time savings, or quality of life improvements will occur from this: To have columns and filters for Posting Date when using GL Posting Cash Dataset | Frequency: Whenever the user runs the report with GL Posting Cash Dataset | When the customer runs the report builder (Beta( with the dataset GL Postings Cash Basis, The totals do not match with the P&L report using cash basis. This is because the current Report Builder (Beta) does not have columns and filters for Posting Date when using GL Posting Cash Dataset
And when used Accrual basis it does match.The customer needs to process sales tax/use tax, and this is causing great stress to him.
This customer does not use Accrual basis, he uses Cash Basis, therefore for him it is Importsant to have columns and filters for Posting Date when using GL Posting Cash Dataset, when he uses the report builder to match or tally with the P&L.
Attempted Solutions So Far: Suggested a work around, exporting the P&L Report and performing the calculations on a spreadsheet.
Digging deep - Any additional Why behind this request / How was this accomplished before Striven in what system or software: Original Description: : I’m having an issue with reporting. If I create a report (beta) based on GL Account: Product Cost using cash basis, the totals do not match (not even close) opening the P&L report using cash basis and drilling in on the product cost. Accrual does match. I need to process sales tax/use tax by the end of the day and this is causing great stress. | Previously accomplished: This customer uses Cash Basis, therefore for him it is Importsant to have columns and filters for Posting Date when using GL Posting Cash Dataset. to run the report builder
StrivenID: 5114062