Our company was recently acquired by another company and as such, we were asked to work on building an extract of our financial data out of NetSuite which then would be imported/ingested into the other company's financial system (SAP).
Here’s what we know so far:
[LIST]
[*]the goal is to make this export/import process generic enough so that it can be easily reused for their other acquisitions
[*]this extract is to be generated daily and posted to an FTP site
[*]they are looking for the following data elements (GL Account Data):
[LIST]
[*]Company
[*]GLAccount
[*]CostCentre
[*]ProfitCentre
[*]FuncionalArea
[*]Product
[*]PostingDate
[*]OriginatingCurrency
[*]OriginatingAmount
[*]FunctionalAmount
[/LIST]
[/LIST] Do you have any ideas on how this can be accomplished? Have you seen other companies do this before? I would only imagine that we would not be the first ones to do this, so hoping we can learn and leverage what others have done.
Thank you in advance for your help with this!