Re: FRX Issue - Probably the DTS -- ANY insight?
Rich McCracken <RMcCracken-yS6WhPn/[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
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-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Chuck Mick Sent: Friday, February 05, 2010 5:24 AM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.