Open Forum

Expand all | Collapse all

Purge Function in Lanham EDI

  • 1.  Purge Function in Lanham EDI

    TOP CONTRIBUTOR
    Posted Mar 02, 2017 11:11 AM
    Has anyone use the Purge Function in Lanham EDI ?

    I want to know what does this one do and what is the impact if I use this Purge Function.

    We are trying to clean up our database.

    ------------------------------
    Berlinda Yap
    IS Service Manager
    Foremost Groups, Inc.
    East Hanover NJ
    ------------------------------


  • 2.  RE: Purge Function in Lanham EDI

    TOP CONTRIBUTOR
    Posted Mar 02, 2017 11:44 AM
    I have recently used the Purge E.D.I. Receive Documents function and the Purge E.D.I. Send Documents function.  Both enabled me to delete old send and receive documents based on a date.

    If you have a test system, I recommend you try it out there first so you will feel comfortable running it in your live environment.

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA



    NAVUG Board of Advisors, Programming
    NAVUG Programming Committee
    NAVUG Membership Committee
    ------------------------------



  • 3.  RE: Purge Function in Lanham EDI

    TOP CONTRIBUTOR
    Posted Mar 03, 2017 09:30 AM
    Dear Lewis,

    Yes, I do have a testing database - I will try it there like you said.

    Thanks
    Berlinda

    ------------------------------
    Berlinda Yap
    IS Service Manager
    Foremost Groups, Inc.
    East Hanover NJ
    ------------------------------



  • 4.  RE: Purge Function in Lanham EDI

    Posted Mar 03, 2017 07:59 AM
    Berlinda. 

    We set up the purge function to run every night in the job queue and purge incoming and outgoing documents older than 90 days.  This frees up a TON of space because the Lanham EDI module saves every incoming and outgoing data element as a record.  Those add up pretty quickly.  This helps searching for and processing EDI documents be much faster.  

    If you're interested, I'd be happy to share the code that we run in the job queue.  

    ------------------------------
    Jason Chance
    Senior Programmer/Analyst
    Seventh Generation
    Burlington VT
    ------------------------------



  • 5.  RE: Purge Function in Lanham EDI

    TOP CONTRIBUTOR
    Posted Mar 03, 2017 09:32 AM
    Dear Jason:

    That would be nice if you can share the code regarding the job queue for purging.


    Thanks
    Berlinda

    ------------------------------
    Berlinda Yap
    IS Service Manager
    Foremost Groups, Inc.
    East Hanover NJ
    ------------------------------



  • 6.  RE: Purge Function in Lanham EDI

    Posted Feb 06, 2020 12:19 PM
    Jason, we are using the Purge function for Lanham in NAV 2017, and doing so manually.

    We would appreciate help setting up a Job Queue entry to perform this in a scheduled manner.

    Would you be able to assist?

    Thanks,
    Gerry Witjes

    ------------------------------
    Gerry Witjes
    Mohawk Medbuy Corporation
    ------------------------------



  • 7.  RE: Purge Function in Lanham EDI

    Posted Mar 03, 2017 10:09 AM
    As part of our monthly database maintenance routines I use both the Archive and Purge processing reports. I archive documents older than 45 days (they are removed from the list view) and purge documents older than 7 months. Archiving makes searches faster and the purging helps to keep the database trim.

    ------------------------------
    Stephen Marsh
    Enterprise Services Manager
    Axxess Logistics
    Vaughan
    ------------------------------



  • 8.  RE: Purge Function in Lanham EDI

    TOP CONTRIBUTOR
    Posted Mar 06, 2017 09:32 AM

    Dear Stephen:

    We have archived all past years EDI Documents (Send/Received) but never attempt to do the purge as not sure if there is any impact.

    Just out of curiosity - if you purge the data, do you ever have someone asking to find it again for like auditing purpose or any other legal purpose?

    Thanks

    Berlinda



    ------------------------------
    Berlinda Yap
    IS Service Manager
    Foremost Groups, Inc.
    East Hanover NJ
    ------------------------------



  • 9.  RE: Purge Function in Lanham EDI

    Posted Mar 07, 2017 07:06 AM
    Hi Berlinda, 

    We've not yet had anyone come back looking for the EDI document for the purposes of an audit and there would be plenty of other related documents (Sales Orders, Purchase Orders, etc.) in NAV that would satisfy that need anyways. We have had a partner come back and ask for the raw EDI file and/or to retransmit a missing file but that usually happens within a week or so of the original transmission. We've only ever used the EDI documents for troubleshooting purposes.

    ------------------------------
    Stephen Marsh
    Enterprise Services Manager
    Axxess Logistics
    Vaughan
    ------------------------------



  • 10.  RE: Purge Function in Lanham EDI

    TOP CONTRIBUTOR
    Posted Mar 08, 2017 03:14 PM

    Appreciate your input on this.  We have not seen anyone ask for it so far even when we archived it.
    Only a few 812 was asked for from past year by our accounting.

    Thanks

    Berlinda



    ------------------------------
    Berlinda Yap
    IS Service Manager
    Foremost Groups, Inc.
    East Hanover NJ
    ------------------------------



  • 11.  RE: Purge Function in Lanham EDI

    SILVER CONTRIBUTOR
    Posted Feb 07, 2020 09:56 AM
    If you deal with retailers then you may need to do Chargeback research for ASNs.

    ------------------------------
    Bill Solano
    SR EDI Technical Specialist
    CCA & B, LLC (The Elf on The Shelf)
    Atlanta GA
    ------------------------------



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