need help in change GL Date from back end

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
dvsprao108
Posts: 76
Joined: Fri Aug 01, 2008 4:55 am
Location: India

need help in change GL Date from back end

Post by dvsprao108 »

Hi Friends,

Actually there was a group Id stucked in GL_Inerface due the period is not in open status (NOV-08).

One of my friends adviced me to change the GL Date as current period (FEB-09) at GL_Interface table, then you can import the journals in current period.

So, can anybody please provide me the sql script that how to change the GL Date [@] GL_INTERFACE table?

Thanks in advance,
Prakash
dvsprao108[@]gmail.com
siva sankar
Posts: 130
Joined: Sun Mar 11, 2007 1:47 am
Location: India

Post by siva sankar »

Hi,

Instead of updateing through backend GL_DATE ,Better to open period (GL period) and import the group id manually.

Thanks & Regards,

Siva
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

No idea from where these transaction came into interface (any sub module). Better you follow what Siva said instead of changing dates in interface table. tks
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest