Hi Rich,

Thank you for your reply. I had zero out the balances in those files and YAAFREP. However it still would not let me delete the personal account, and when I ran an aging the values came back.

I found a file BSPASML0 that also had the balances. I cleared this one out and well as the other four. And I was able to delete the personal account.

Doug


-----Original Message-----
From: MAPICS-L [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of McCracken, Rich
Sent: Monday, April 11, 2016 2:16 PM
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Subject: Re: [MAPICS-L] IFM Data

Doug,
If you have already checked file YAA4REP and not found any settlement lines, I suggest looking for records for the entities in YAEQREP - Ledger Balance, YADKREP - Aged Balances, or UAHMREP - Entity Financial Division Balances.
Rich McCracken



Rich McCracken
Financial Systems Specialist
2400 MacArthur

Longview, TX 75603
United States

+1 903 237 7219 Phone
17219 Alternate

-----Original Message-----
From: MAPICS-L [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Morrison, Doug
Sent: Monday, April 11, 2016 12:10 PM
To: MAPICS-L@xxxxxxxxxxxx
Subject: [MAPICS-L] IFM Data

Twelve years or so ago we setup a couple of financial divisions (71 & 72) and processed normal transactions in these financial divisions for about two years. We then sold the segment of the business in these financial divisions.

Fast forward to today I am trying to clean up this old obsolete data. The majority of it purged just fine however I have a hand full of entity personal accounts I can't delete because the system thinks there is outstand AR and or AP. I have been looking at the AR of one entity and am finding that the settlement record is missing. However we cannot process an ARA transaction against the invoice. I suspect that when the business was sold one shot programs were run to get zero out balances but not all files were correctly updated.

I'm wondering if anyone has any suggestions on what file(s) might need to be reset so the system doesn't think there is outstanding AP/AR.

Thanks for any information you can offer.

Doug




--
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.




This electronic mail transmission contains information from Joy Global Inc. which is confidential, and is intended only for the use of the proper Addressee. If you are not the intended recipient, please notify us immediately at the return address on this transmission, and delete this message and any attachments from your system. Unauthorized use, copying, disclosing, distributing, or taking any action in reliance on the contents of this transmission is strictly prohibited and may be unlawful. Privacy-JGI


--
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.