"Can any one please help on how to upload the Internal order Balances (with Asset under constructurion)"
What is the actual problem?
Assuming you want historical balances for each period on your Internal Order. One option is to:
Post a take-on journal for each month of the Internal Order:
Dr P&L Exp (Capex P&L Account) with Internal Order
Cr 999999 Opening Balance takeon GL (Balance Sheet)
Run settlement for each month:
Dr AuC
Cr P&L settlement account with Internal Order
Assumes you use a separate P&L settlement account otherwise you need to create a report painter report to report on the P&L Capex account if you don't (i.e. report painter separates settlements and actual expenditures ect in columns for the Capex account).
Above process is painful if you have many years of data. Otherwise you can pick the end of the prior fiscal year to post the bulk of the Internal Order Value then settle it, carry forward the AuC by standard asset module closing, and then post each period as above for the current Fiscal Year.
You would then need to exclude these figures from the Trial Balance for the remainder of the opening Balance postings at Go-Live.
Anyone with a better idea?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.