Topics started by EXLBLUND

1 Topic

E
Do Gooder (Customer)
EXLBLUNDDo Gooder (Customer)
asked in Finance (Financials)

Need automated daily export of financial data

I had a request come my way and hoping for some guidance.  We have a new Controller here and he is wanting to utilize a corporate account reconciliation process.  This would involve exporting data daily from IFS in a certain format (see below).  I’m sure this is doable, but don’t know best way to do so.  First look seems like the External File functionality in Accounting might be a place to start.  Wondering if anyone has set this type of transfer up before and if I am on the right track. Thanks in advance!  We are on Apps8 sp1+ To integrate  we’ll need a trial balance and ledger transaction file published to a FTP directory daily.  Text files Pipe delimiter “|” No column headings Static filename (so data overwrites and doesn’t create new files) Trial Balance- 13 months rolling periods including current month (include all accounts- even without activity and zero balance)BU Name|Year|Month|Account|Account Description|Opening Balance|Net Activity|Total Debits|Total Credits|Ending Balance

1
pwlm
Hero (Partner)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings