Open Forum

Expand all | Collapse all

Open Item Ledger Entries

  • 1.  Open Item Ledger Entries

    Posted Nov 18, 2019 12:27 PM
    Hello,

    We use Navision 2009 r2 and are unable to close inventory periods due to Open Item Ledger Entries.  What scenarios can cause Item Ledger Entries to remain Open?

    In this example, the Open transactions were a Purchase Receipt for Qty 345 and a Sales Shipment for Qty 345.


    Thank you,

    ------------------------------
    Stacy Laurent
    Accounting Supervisor
    Classic Accessories, Inc
    Kent WA
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Open Item Ledger Entries

    TOP CONTRIBUTOR
    Posted Nov 18, 2019 01:22 PM
    I believe that those entries would still be open if they have not yet been invoiced.

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl
    ------------------------------------------------------------------------

    NAVUG/D365BC-User Group Focus
    May 18-19, 2019
    Denver, Colorado
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Open Item Ledger Entries

    GOLD CONTRIBUTOR
    Posted Nov 19, 2019 06:19 AM
    Hi Stacy,
    We have the same issue since we started with closing inventory periods.
    We try to solve as much as we can with Item Application Entries.
    What's left, we do a hard change on the field Open of these lines.
    We set a filter on:
    Posting Date: Month which should be closed
    Open = Yes
    Remaining Qty < 0

    This is not how it should work, but this was the only solution we could find with our partner.
    I believe it's part of the history of entries in our system since 2003.


    ------------------------------
    Annette van der Muur
    Application Manager
    Hal Leonard Corporation
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Open Item Ledger Entries

    SILVER CONTRIBUTOR
    Posted Nov 19, 2019 03:40 PM
    Hi Stacy,

    The Purchase Receipt would still be Open if Purchase Matching to the Invoice has not happened yet.

    A Sales Shipment would still be open if the Sales Invoice has not been posted for this shipment.

    ------------------------------
    Jenifer Elliott
    Senior Application Consultant
    Technology Management Concepts
    807 Parkview Drive North, Suite 150
    El Segundo, CA 90245
    Phone: 831.277.3280
    Email: jelliott@tmc-la.com
    Website: www.abouttmc.com







    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Open Item Ledger Entries

    GOLD CONTRIBUTOR
    Posted Nov 20, 2019 10:11 PM
    ​Hello Stacy,

    Here are a couple settings to review:

    *If you use Serial or Lot numbering on the inventory Item(s) in question, then please make sure that the Item Tracking card that is assigned to this Item has 'Lot/SN Specific Tracking' set to True (checked).

    *Also you might check to make sure 'Prevent Negative Inventory' is set to True (checked) on the Inventory Setup page.

    ------------------------------


    Best Regards,

    Alex A
    Sr. NAV Consultant
    Los Angeles, CA, United States
    ------------------------------

    Academy - Online Interactive Learning from Experts


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