Requirement.
We have a Fixed positioned flat file from external system which have more than 1 million records where I have to import into LEDGERJOURNAL, customer doesn't want the all records as they want to group by the CURamt,DebtAmt based on the fields and date and load into the journal using Standard AIF Service.
Environment: AX2012 R2 CU7.
I have one solution.
My Idea is.
1. Build the .net component that parse the flat file and do group by on that generate the XML using XSLT and use this component and xsl in transformations in AIFInbound port.
Do any one have any other Idea. Please provide the solution.
krishna.
We have a Fixed positioned flat file from external system which have more than 1 million records where I have to import into LEDGERJOURNAL, customer doesn't want the all records as they want to group by the CURamt,DebtAmt based on the fields and date and load into the journal using Standard AIF Service.
Environment: AX2012 R2 CU7.
I have one solution.
My Idea is.
1. Build the .net component that parse the flat file and do group by on that generate the XML using XSLT and use this component and xsl in transformations in AIFInbound port.
Do any one have any other Idea. Please provide the solution.
krishna.
