Open Forum

Expand all | Collapse all

Jet reports - how to hide reversed entries?

  • 1.  Jet reports - how to hide reversed entries?

    SILVER CONTRIBUTOR
    Posted Feb 15, 2019 04:06 PM
    ​We did a reimplementation to NAV2017 at the beginning of 2017, including an overhaul of our chart of accounts and dimension structures. Because we were still working out the bugs, we ended up doing a lot of reversing entries when the wrong dimension/posting date/GL account was used. Now  we're trying to figure out an easy way to run our detailed ledger reports for auditors and internal stakeholders without all of the washed entries.

    We have Jet Essentials - does anyone know of a way to filter out the reversed/reversing entries?

    ------------------------------
    Tara Langley
    Accounting Manager
    Culver Franchising System, LLC.
    Prairie du Sac WI
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Jet reports - how to hide reversed entries?

    NAVUG ALL STAR
    Posted Feb 18, 2019 10:21 AM
      |   view attached
    Tara,

    Did you utilize the Reverse Transaction functionality? If so, both the reversal and the original transactions are marked with a reversal check mark. You could filter these out.

    Regards,

    ------------------------------
    Amanda Mayer
    New View Strategies
    Milwaukee WI
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Jet reports - how to hide reversed entries?

    SILVER CONTRIBUTOR
    Posted Feb 18, 2019 01:14 PM
    Thank you! The Reversed Field is one I was not familiar with, but I knew there had to be a way to do it. (Now, if anyone knows how to match up other journal entries that wash by date, amount, similar document number, etc. - that would be the "unicorn" to make this process complete. I won't hold my breath.)

    ------------------------------
    Tara Langley
    Accounting Manager
    Culver Franchising System, LLC.
    Prairie du Sac WI
    ------------------------------

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role