How to turn off "Consolidated" lines when posting from 4-2 (Payable Invoice) to 1-3(Journal Transaction) ?

SUGGESTED

While trying to prepare for budget, I'm pulling the transactions per GL Account and classifying them.   However when I do this, it's pulling the details from the 1-3 (Journal Transactions) so half of my detail just shows "consolidated" for description.   I've pulled the report into excel, then opened the "report on screen" and have been drilling into each of these "consolidated" details to find out what is behind it but it's taking forever!   Is there a setting we can change (even if it's just going forward) that when I post a Payable Invoice that each line gets posted individually in the Journal transaction also? 

Piggy-backing on this question:  Is there a setting we can change that if a Payable Invoice has an attachment, the attachment is also included on the Journal Transaction so I don't have to drill down to see the receipts? 

Thanks so much for your help in advance!

  • 0
    SUGGESTED

    Unfortunately If the entry comes from A/P and they coded multiple grid lines to the same account it comes into the GL as consolidated. 

    But if its a JE, you can use or not use the check box "use desc from transaction line".  If you use it, it pulls from the grid details, if you don't check it, it pulls the desc from the top of the record.  

    No Attachments do not transfer when AP invoices have attachments.   

    Thought:

    If you are budgeting (for financials and not jobs) why do you need to see the detail anyway?  Unless things were not coded to the correct account.

    Otherwise all you need is the GL summary report to get totals for each account for the month, year, or prior years.