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.
midrange.com
