RE: automating Create Ledger Entries

Bob,
Thanks for the input.

-----Original Message-----
From: Bob Tenney [mailto:bobtenney@earthlink.net]
Sent: Friday, November 08, 2002 4:39 PM
To: mapics-l@midrange.com
Subject: Re: automating Create Ledger Entries


Chris, I pretty sure that there are two  routines to create ledger
entries -- one for GL and one for IFM. And, it is very likely that the API's
are for the GL routine. You need to negotiate with MAPICS, Inc. about an API
that works when IFM is installed.

Creating your own batch job is more complicated than it looks. There is a
lot of housekeeping to protect against sending the same transaction to IFM
more than once and you have to take steps to maintain the drill down from
IFM to IM.

If you are on a calendar month, running automatically on a Sunday can create
reconciliation problems when the preceeding week spans two months. When this
happens, you would have to create GL entries for the "old" month when you do
your IM closing. Then, your  "Sunday Special" handle the entries for the
next month. If you forget to do this, you will have a mess.

Creating GL entries automatically also assumes that your account assignment
rules and priorities are working correctly.  If there are problems, you need
to make manual journals to correct them. (If you just assign accounts
automatically without making GL entries fixing rules and priorites problems
is much easier).

Bob Tenney
 Bob Tenney Solutions, LLC
 MAPICS - FRx - Crystal Reports
 828-526-8976

Visit www.tenneypubs.com for books on IFM, FRx,
General Ledger Interfaces, COM, Cost Accounting, and Info WorkPlace



----- Original Message -----
From: "Neely, Chris (CAG-PG)" <Chris.Neely@poultry.com>
To: <mapics-l@midrange.com>
Sent: Friday, November 08, 2002 10:24 AM
Subject: RE: automating Create Ledger Entries


> Thanks for responding Bob. What the users requested is that I automate the
> 'Assign Accounts' and 'Create Ledger Entries' options in MAPICS for MAPICS
> inventory transactions. I am able to do this using MAPICS APIs. But it
> appears that I can only do it if I am not interfacing with IFM. The
problem
> is the transaction header screen that pops up on the 'Create Ledger
Entries'
> option. Obviously, in an autamated batch job I am not going to have a
screen
> pop up in the middle of the night for a user to key in this transaction
> header information. So, I need to be able to create that transaction
header
> in my batch job without having to display a screen for a user to input the
> information.
>
> Should I be attempting to automate this process in the first place? Is
this
> a good idea? We have five locations doing this process. The idea was to
> relieve them of this work and have it done automatically every Sunday at
> noon for each location.
>
> Thanks for any help
>
> -----Original Message-----
> From: Bob Tenney [mailto:bobtenney@earthlink.net]
> Sent: Friday, November 08, 2002 8:37 AM
> To: mapics-l@midrange.com
> Subject: Re: automating Create Ledger Entries
>
>
> Chris, I assume that you are trying to interface G/L entries from a
> non-MAPICS application to IFM. If this is so, then going through the
Legacy
> System Bridge is your best bet. You can define an LSB transaction type and
> set up many of the defaults for your transaction header. Also, IFM edits
LSB
> data in the same way that it edits native transactions.
>
> If you try to create a native IFM batch transaction, you have to do all
the
> internal housekeeping that IFM does when processing LSB records. For
> example, you need to assign and increment the transiaction ID that lets
IFM
> keep transaction header and related detail records together.
>
> If your non-MAPICS application passes invoice or cash information to IFM,
> interfacing becomes more complicated. At a minimum, you need to
synchronize
> vendors/customers, terms, taxes, and banks.
>
> Bob Tenney
> Bob Tenney Solutions, LLC
> MAPICS - FRx - Crystal Reports
> 828-526-8976
>
>
> Visit www.tenneypubs.com for books on IFM, FRx,
> General Ledger Interfaces, COM, Cost Accounting, and Info WorkPlace
>
>
> ----- Original Message -----
> From: "Neely, Chris (CAG-PG)" <Chris.Neely@poultry.com>
> To: <mapics-l@midrange.com>
> Sent: Friday, November 08, 2002 1:25 AM
> Subject: automating Create Ledger Entries
>
>
> > Has anyone automated 'Create Ledger Entries' while interfacing with IFM?
> >
> > I am trying to figure out how to bypass the screen to create the
> transaction
> > header record so that I can run this as a weekly submitted job. Is there
a
> > way to create this header record without having the screen pop up? Do I
> need
> > to use legacy bridge?
> >
> > It appears easy to automate if I did not have IFM interfacing.
> >
> > Any help would be appreciated.
> >
> > Thanks
> >
> > Christopher Neely
> > ConAgra Poultry
> > _______________________________________________
> > This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> > To post a message email: MAPICS-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
> > or email: MAPICS-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/mapics-l.
> >
>
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
> or email: MAPICS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
> or email: MAPICS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/mapics-l.
>

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