PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 06/08/2009 1:54 PM by  drhoades44
mass delete of AP520 interface
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
drhoades44
Advanced Member
(96 points)
Advanced Member
Posts:46


Send Message:

--
06/01/2009 2:20 PM

    I uploaded an AP520 with Update=Y in error (in a dev environment). Is there a way to mass delete all these records? Thanks for any assistance--not finding anything documented in Lawson KB.

    Brad Schauer
    Private
    Private
    Veteran Member
    (222 points)
    Veteran Member
    Posts:76


    Send Message:

    --
    06/02/2009 3:43 PM
    The AP520 was run with the update flag set to Y? So the records no longer exist on apcinvoice, apcdistrib, and apcpayment?

    How many records are you needing to delete?

    Brad
    drhoades44
    Advanced Member
    (96 points)
    Advanced Member
    Posts:46


    Send Message:

    --
    06/08/2009 1:45 PM

    Yes, I did it in a development prodline. As far as I have learned, there is no mass delete for AP conversion similar to GL. I went through the AP data text pdf file and looked for anything updated by AP520, browsed the data with SQL Server and wrote some delete statements. Very ugly but I'm glad I went through it in a dev environment. This is our first AP conversion. I'm now working in another prodline (incidentally) and am careful to make UPDATE=N. I'm getting an error "Problemist accounting unit and account required". The accounting unit, account and sub-account exist--verified with GL20. Not sure what the issue could be...

    drhoades44
    Advanced Member
    (96 points)
    Advanced Member
    Posts:46


    Send Message:

    --
    06/08/2009 1:54 PM

    Found answer. After you run AP520, if you want to do again, I'm deleting (with SQL Server) the records for this company in APCDISTRIB and APCINVOICE. I didn't get all the records in APCDISTRIB deleted and it had two records for this one entry. Onward...

    You are not authorized to post a reply.