I'm trying to get the GL expense account for A/P purchases to display in the Cash Disbursmenst Journal.
Any suggestions?
I'm trying to get the GL expense account for A/P purchases to display in the Cash Disbursmenst Journal.
Any suggestions?
The Cash Disbursements Journal report shows one item with amount (credit) for each cash account and one item with amount (debit) for each offset account. If an offset amount was keyed on the Apply to Expenses tab its Account ID will be an expense account. If, however an offset amount was keyed on the Apply to Invoices tab its Account ID will be the A/P account of the paid invoice.
Please note that with negative numbers things are reversed with negative cash amounts being debits and negative offset amounts being credits.
Also note that a check entered via the Payments option on the Tasks menu can have data on both the Apply to Invoices tab and the Apply to Expense tab.
To see expense accounts for purchases run a Purchase Journal report. There the credit amounts will be for an invoice's A/P account and the debit amounts will be for expense accounts.
If you need to see the expense data only for paid invoices you will need to add the Payment Status field to the Purchase Journal (Fields tab under Options), dump the report to Excel, sort by the Payment Status column, remove all rows for unpaid invoices and replace the old incorrect totals with sum formulas.
To generate such data on the fly without the dump to Excel would require the creation of a custom report in Crystal Reports for Peachtree. See the Crystal Reports forum link at
Have something to add? Share your thoughts — no account required.
Ask the community — no account required