Open Forum

Expand all | Collapse all

NAV Data archiving cleanup

  • 1.  NAV Data archiving cleanup

    SILVER CONTRIBUTOR
    Posted 8 days ago
    Hi Folks,

    I am tasked to create a process to clean up the historical transactions and archive them in order to speed up the NAV functionality.

    I see that NAV crashes when a user opens the Item Card, Posted Sales Invoice minimum 2-3 times a week.

    What is the best practice to be followed to archive NAV historical data?

    Any suggestions are most welcome.

    Thanks in advance,


    ------------------------------
    Archana
    Business Systems Analyst
    American Labelmark Company (Labelmaster)
    Chicago IL
    ------------------------------


  • 2.  RE: NAV Data archiving cleanup

    TOP CONTRIBUTOR
    Posted 8 days ago
    The best way is not to. NAV and SQL can handle billions of records in a single table. You should investigate the issues as they happen. If the system is actually crashing there should be something in the event log on the machine running the service tier.

    Data is the most common thing to jump to when there are mysterious performance issues, but it's hardly ever the reason in my experience. What may seem like a lot of data to you is nothing to the system. My best advice is to treat each instance as a single issue and prove the cause, rather than assume it is the amount of data. It could be bad data on a single record. Not enough memory on your server. A bad service tier configuration. Literally hundreds of things.

    If you want to "archive", you can start a new company in NAV and bring over open balances. Some tables there is just no good way to unwind (like the Item Ledger).

    ------------------------------
    Matt Traxinger
    NAV Developer
    ArcherPoint Inc.
    San Antonio TX
    ------------------------------



  • 3.  RE: NAV Data archiving cleanup

    TOP CONTRIBUTOR
    Posted 8 days ago
    I will second everything Matt mentioned.

    With that said, there are some tools built into the system to assist in either removing or condensing data.  If you navigate to Departments/Administration/IT Administration/Data Deletion... you will find tools to delete archive versions, delete empty registers, condense G/L entries, etc.  You can review these and test first prior to making changes to your live environment.  Also, always remember to create a backup prior to doing any deleting or condensing.

    ------------------------------
    David Wiser
    Project Manager/Solution Architect
    Beck Consulting
    Seattle WA
    ------------------------------



  • 4.  RE: NAV Data archiving cleanup

    SILVER CONTRIBUTOR
    Posted 8 days ago
    Thank you David.

    This really helps.

    ------------------------------
    Archana Kulla
    Business Systems Analyst
    American Labelmark Company (Labelmaster)
    Chicago IL
    ------------------------------



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