Administration, Core Financials, and Project Accounting

[TRoop]

For version 7.2 May 09 MU, I have a new scenario we are trying to resolve regarding the GL Fiscal Calendar setup...

We have a new subsidiary company we recently acquired and are setting up in Mas 500. This company operates on a different calendar than our parent company operates under. They have a schedule set up that starts from July 1st previous year to June 30th current year.

We went ahead and set up the calendar with this configuration last evening. This morning I was bombarded with emails from users saying that they were looking at their customers sales in the Customer Status window and their Sales dollars were nowhere near being correct. After researching this, it appears that the tarCustSalesHist table was recalculated for the parent company as well as the newly acquired company...

Does anyone have any idea on how this table is rebuilt or if there are any stored procedures I can look at to show me how the current fiscal period and fiscal year are created when a new calendar structure is implemented??

Thank you...

[rsisk101 · Accepted solution]

Tim,

Did you try 

Accounts Receivable / Activities / AR Utilities / AR Recalculate History ?

[TRoop]

Yes... I actually worked with Tony Baron and we tested using this process to fix justthe Customer Sales History. Thanks for assistance...