Page 1 of 1

need help in change GL Date from back end

Posted: Thu Feb 05, 2009 6:08 am
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

Posted: Wed Jun 24, 2009 11:32 pm
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

Posted: Fri Sep 11, 2009 12:53 pm
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