robert_m78
asked on
Cost Centre Hierarchy
I am developing a VB application that takes cost centre data in the form of text files from ERP applications like SAP, Peoplesoft etc. My application parses the text files and rebuilds the cost centre hierarchy in the client application. Cost centre details need to include name and address of centre, contact details, and other details which may go beyond the details of the General Ledger.
To do this, each cost centre record also needs to have one or more fields which uniquely identify each cost centre's parent, so my program can "look up" each cost centre parent and rebuild the hierarchy. It follows that the cost centre records need to be in order of highest level first, so the parents can be found.
My questions are
a. How likely is it that companies will be able to export text files from their ERP systems in this format?, and
b. Does anyone have any practical examples of how cost centre coding typically works?
To do this, each cost centre record also needs to have one or more fields which uniquely identify each cost centre's parent, so my program can "look up" each cost centre parent and rebuild the hierarchy. It follows that the cost centre records need to be in order of highest level first, so the parents can be found.
My questions are
a. How likely is it that companies will be able to export text files from their ERP systems in this format?, and
b. Does anyone have any practical examples of how cost centre coding typically works?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks, sorry its taken forever to close this one!
either ask the other partys to export in ascii comma delimited.
this makes it really easy to read the file without little effort or use ADO. I think comman delimited would be best.
b) Sorry NO
Cheers
Andy