Thanks. We are an IFM site.
I know we have some records that have bad dates. I initially focused on
that as my guess...however, I saw some in previous periods too...so I
started to discount the validity of that direction.
The two recent records were in the December 2009 period...so if we were
good in December (I'm checking with my accounting folks) I guess this
isn't the direct problem...but it may still be worth us exploring the
edit / validation checking on the two fields.
Do you know if we could just exclude the detail from the load and use
the balance information from IFM rather than 'recalculating' with detail
records we don't use? That would definitely simplify our loads...
Chuck Mick
Diversified Machine, Inc.
(m) 517.643.3548
(o) 248.277.4315
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Rich McCracken
Sent: Friday, February 05, 2010 11:37 AM
To: 'MAPICS ERP System Discussion'
Subject: Re: [MAPICS-L] FRX Issue - Probably the DTS -- ANY insight?
Are your XA financials IFM or GL?
With IFM the FRx load will error with old or future dates in the GL
lines file YAA7REP. The fields we check are "Date of Document" A7FIDT
or "Date of Supply" A7FKDT. Users can accidently key in dates in these
fields with old or future years. The effective date field is usually
not a problem because any bad date will cause a posting error for a
period not open.
We have a process that searches these two fields for dates older than
1997 or future to 2010 and allows a user to correct the dates in only
these two fields when found. This work around has solved our FRx date
load errors.
Rich McCracken
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Chuck Mick
Sent: Friday, February 05, 2010 5:24 AM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] FRX Issue - Probably the DTS -- ANY insight?
Hello.
We are not 'big' FRX users...and generally our folks are not fans of the
package...but I digress in that we have the product and do use it.
Yes...I know Infor discontinued its relationship with Microsoft FRX /
dynamics. However, I'm hoping for some guidance or insight.
We are running a full load...and the load manager is showing a couple
errors. Once the load is complete...the FRX database / reports do not
contain all the information.
If I run the DTS using SQL enterprise manager, the final result appears
to be 2 errors. One errors is that a delta load didn't run...which is
obviously fine since we ran a full load. The second error is more
cryptic and appears more targeted.
The second error is on the frl_trx_detail. I see 16 (or so) errors.
The last error shows a problem with column 21 called attrib12. It
appears to be a data issue with the function to cast date.
I have opened the SQL database...and attrib12 appears to be one of the
date fields on the detail. I am uncertain how to locate the specific
offending record since the error just gives the row number. The row
number is around 1,650,000... I have queried the database...and we have
some 'odd' future dates in the field due to data entry issues. However,
the records do have valid periods...so I'm not sure this information is
even relevant.
I have tried multiple full loads.
I have deleted the various g32 files on the server...
Ideally...I need to resolve the issue and obtain our standard FRX
reports... I have several thoughts...if you can assist...
- We are missing a step...and once we perform that
step...the DTS will work fine...
- I do not think we use the 'offending' column...if that is
the issue...in any of our reports...we generally don't drill down below
the unit / nature / period combinations... Can I create a new DTS that
doesn't include that column?
- If the aforementioned is possible....could I just exclude
the whole detail table and only work with the unit / nature / period
balances...wow would that ever speed things up...
Any assistance or guidance is appreciated....
Chuck Mick
Diversified Machine, Inc.
(m) 517.643.3548
(o) 248.277.4315
_______________________________________________
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 message is intended exclusively for the
individual(s) or entity to which it is addressed. This message, together
with any attachment, is confidential and may contain privileged
information. Any unauthorized review, use, printing, retaining, copying,
disclosure or distribution is strictly prohibited. If you have received
this message in error, please immediately advise the sender by reply
email message to the sender and delete all copies of this message.
THIS E-MAIL IS NOT AN OFFER OR ACCEPTANCE: Notwithstanding the Uniform
Electronic Transactions Act or any other law of similar import, absent
an express statement to the contrary contained in this e-mail, neither
this e-mail nor any attachments are an offer or acceptance to enter into
a contract, and are not intended to bind the sender, LeTourneau
Technologies, Inc., or any of its subsidiaries, affiliates, or any other
person or entity.
WARNING: Although the company has taken reasonable precautions to ensure
no viruses are present in this email, the company cannot accept
responsibility for any loss or damage arising from the use of this email
or attachments.
_______________________________________________
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.
midrange.com
