Mapping to ERP

We were recently acquired by a larger company. we currently use EPICOR 10. I would like to be able to do the mapping from our COA to the parent COA in EPICOR. Is there a field in which this can be done? Can we for example create a rule that says all revenue accounts per our COA map to one GL account in the parent COA?

Hi, do you have multi books?

No we do not have multiple books.

If you had multiple books, i believe that you could create a separate “Book” and then the system would automatically create the postings to the second book for you. Then at the end of a period, you could export the balances to your parent without translation.

OR, you could “Simply” create a UD Table that contains a list of translations (from account -> to account) and then create a Query that exports all the data.

We spoke to a consultant today and had no luck. We were recently acquired and need to create a stub period. We wanted to change the dates for our period 3 to be split into two different periods. So we would have a total of 13 periods. We can an error message that says the end date cannot be changed GL journals have been created against this period.

Any ideas? What have others done when they are acquired in the middle of the month?