Re: History Files

7/6/2004
Common issues.  ERLCOM is the best tool to begin the learning process.  I'd
suggest, that once you understand the relationships, and before you start
data testing, create a list of all the possible combinations of data that
COM can generate.  (i.e. ship complete, ship partial, ship partial with
backorder, ship partial without backorder, etc..)  Then create some test
data.  Observer the data changes.  Its been my experience that this will
shorten the learning curve.

Also, depending on the version of MAPICS and when you purchased, you may
have INFO Workplace.  If you do, the subsets provided by MAPICS are another
excellent tool to learn from.  Also INFOWP can generate a flat file from the
COM files that will be easier to DTS to SQL.

Kevin Fox
kdfox@xxxxxxxxxxxxx

-----Original Message-----
From: Randy Volkin [mailto:rvolkin@xxxxxxx] 
Sent: Saturday, July 03, 2004 11:31 AM
To: mapics-l@xxxxxxxxxxxx
Subject: RE: MAPICS-L Digest, Vol 2, Issue 184

I am trying to write reports from the files :) .  I am importing this data
into Sql Server via DTS Processes that transform the data into something
that is reportable.  As you may expect, I am running into many road blocks
but the ERLCOM tool has been most helpful.


-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of mapics-l-request@xxxxxxxxxxxx
Sent: Saturday, July 03, 2004 12:00 PM
To: mapics-l@xxxxxxxxxxxx
Subject: MAPICS-L Digest, Vol 2, Issue 184

Send MAPICS-L mailing list submissions to
        mapics-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/mapics-l
or, via email, send a message with subject or body 'help' to
        mapics-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
        mapics-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of MAPICS-L digest..."


Today's Topics:

   1. Re: History Files (Kevin Fox)


----------------------------------------------------------------------

message: 1
date: Fri, 2 Jul 2004 10:10:04 -0700 (GMT-07:00)
from: Kevin Fox <kdfox@xxxxxxxxxxxxx>
subject: Re: History Files


Be very certain of what you are trying to do.  MAPICS COM behaves
differently depending on many variables.  Partial orders will appear in both
files.  Shipped complete orders MAY appear in ship history or MAY have a
status flag on the header to indicate shipped with NO corresponding record
in the history files.  

There is no easy method to write reports from the files.

What is it you are trying to do?

Kevin Fox
kdfox@xxxxxxxxxxxxx


------------------------------

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) digest 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.



End of MAPICS-L Digest, Vol 2, Issue 184
****************************************