Clearing out the GL

[Chris Kelleher]

My client has been using MFG/PRO for three years - everything but the GL.
They have been posting to the GL, extracting certain data, and feeding it
into a different "Brand X" General Ledger system (don't ask why). All
adjustments were entered into Brand X system, as well as data from many
other sources. The contents of the MFG/PRO database is half-correct,
incomplete junk.

Now, we are looking to reclaim GL functionality back into MFG/PRO.

I would like to:
1) wipe the GL clean,
2) enter a beginning balance as of 3 years ago, and
3) convert monthly activity from the Brand X GL into MFG/PRO.

I know how to perform steps 2 & 3, but how do I wipe the GL clean?

Your advice is appreciated.


John Warshawer
john@jdwconsulting.com

 

[Chris Kelleher]

John,

Have a look at:

36.23 - GL Transaction Delete/Archive
25.13.7 - Transaction Post
25.13.11 - Transaction Consolidation

I'm not sure if that will "wipe the GL clean" - but it's a good place to
start.


Here's a little code snippet you can use to find all menu selections that
delete something:

<BLOCKQUOTE><font size="1" face="Arial, Verdana">code:</font><HR><pre>
for each mnt_det where mnt_lang = "US"
and mnt_label matches "*delete*" no-lock:
display
mnt_nbr mnt_select mnt_label.
end.
[/code]

- Tris Hopkins
Flexalloy-Textron

 

[Chris Kelleher]

I had to do this once on 8.5F. There is a utility called "Recalculate acd_det
totals" 36.25.39 (this is on 8.6E) Menu.

I deleted all gltr_ records using "for each", and then ran the utility. It wiped
out the GL information. After that, you may need to resinchronize the GL Report
Writer, after deleting that history too.

If I were you, I wouldn't take my advise immediately, but wait for the PEGers
to say whether or not this is advisable. It worked for me, but I had only about
30 transactions, and wasn't operating yet. Somebody had posted by mistake those
transactions thinking he was on the "Test" database, and we had not gone live.


Also, be sure to have backups, just in case.

Greetings.
Armando Franco.

 

[Chris Kelleher]

I forgot to ask before... Did they post the GL transactions? If not, use 36.23.2
to get rid of all the records. My last reply assumed the GL transactions were
already posted.

Armando.

 

[Chris Kelleher]

John --

The major transaction tables are acd_det, glt_det and gltr_hist, but I would
start by looking at the File Relationships (which will vary with the release
you are working with). As Armando pointed out, there are utilities for
removing (some of) this data.

Check the Index in this document which shows, at a high level, the portions
of the system that a given table is associated with.

Presumably you want to keep the static stuff (accounts, cost centers,
formats, budgets, calendars, etc.) -- ?

Another approach is to start with an 'empty' database. Process some
GL-related activity (such as inventory) through to completion. Take a File
Size Report before and after and see which tables change.

John Nisbet
Kilcreggan Systems and Software, Inc.
QAD Service Alliance Partner
1191 Chestnut Street Suite 2-6
Newton, MA 02464-1351
jnisbet@kilcreggan.com
(617) 969-5432 x201