We need datafix for reopening
of close period please help in this respect as
my following modules ( AR, Purchas, Inventory,OPM FINANCIAL) Mar-12 are open and i have to create accounting for these modules.
The period in GL was closed mistakenly and please help in this respect.
My Question is why system allowed to Closed Permenent GL Period when others modules period are still open.
Ata ur Rehman
datafix for reopening or work arround
-
- Posts: 25
- Joined: Mon Jun 11, 2007 2:18 am
- Location: Pakistan
-
- Posts: 25
- Joined: Mon Jun 11, 2007 2:18 am
- Location: Pakistan
Pl try the following on TEST or VISION and verify one you are satisfied then only move to LIVE,
update gl_period_statuses set closing_status = 'O' where application_id = 101 and set_of_books_id = 1 and closing_status = 'P'
and PERIOD_NAME = 'Adj-99';
update gl_period_statuses set closing_status = 'P' where application_id = 101
and set_of_books_id = 1 and closing_status = 'O'
and PERIOD_NAME = 'Adj-99';
WARNING: ERPstuff will not be responsible for any loss as this is just a tip to be tested and we are not claiming it is a tested and verified way to do so.
update gl_period_statuses set closing_status = 'O' where application_id = 101 and set_of_books_id = 1 and closing_status = 'P'
and PERIOD_NAME = 'Adj-99';
update gl_period_statuses set closing_status = 'P' where application_id = 101
and set_of_books_id = 1 and closing_status = 'O'
and PERIOD_NAME = 'Adj-99';
WARNING: ERPstuff will not be responsible for any loss as this is just a tip to be tested and we are not claiming it is a tested and verified way to do so.
Who is online
Users browsing this forum: Ahrefs [Bot] and 13 guests