Resolved Topic: Opening GL
Asked 3/7/2017 11:08:31 PM +05:45
Opening GL
#1595
4

3/7/2017 11:08:31 PM +05:45

Hello , I followed your instructions in setting opening GL

https://mixerp.org/forums/thread/285/where/,

but when I try to verify the voucher, it says

"ِAccess is denied, you cannot verify past or future dated transactions"

File : Screenshot from 2017-03-07 19-04-16.png

then I found that you mentioned that MixERP prevented past dated transactions

https://mixerp.org/forums/thread/255/regarding-past-date-transactions#607

** How to set opening GL? **

p.s. I did not run any EOD operations yet.

Answered 3/19/2017 2:16:15 AM +05:45
RE: Opening GL
#1613
4

3/19/2017 2:16:15 AM +05:45

Hello,

Thanks for your help, unfortunatelly none of these solutions made it.

The problem is always when I try to update "verification_status_id" with 1 , it gives "access is denied"

So I updated it with "2" and it worked !!

I used GUI of pgAdmin, as above codes did not work, here you are the tree:

File : Selection_653.png

Then update field with "2" not "1":

File : Selection_654.png

Would you please provide easy ability to update past transactions, it's very important.

Marked as Answer
All Posts
RE: Opening GL
#1597
binod
Captain
4Y
485
95T

3/8/2017 8:49:58 PM +05:45

The proper way would have been this:

Let's say, you want to start your transactions from January 1, 2017. Opening balance entries should be done on December 31, 2016.

Perform EOD --> December 31, 2016.

You're now on January 1, 2017.

What can you do?

You can manually verify the transaction from database backend by using a query.

UPDATE transactions.transaction_master
SET 
    verification_status_id = 1, 
    verified_by_user_id = 1, /*or desired user id*/
    last_verified_on = NOW(),
    verification_reason = 'Approved opening transaction entry'
WHERE transaction_master_id = ????
RE: Opening GL
#1600
4

3/9/2017 2:32:41 AM +05:45

Hello,

When I choose EOD, it automatically shows date : Jan 1 2017. As it is the start date of my year.

How to make EOD of Dec. 31 2016?

Thanks

RE: Opening GL
#1601
binod
Captain
4Y
485
95T

3/9/2017 3:05:07 AM +05:45

For the first time (when no EOD has been performed yet), the system brings in the current date of the database server. So, changing the date on the database server (momentarily) would show your desired date. Once EOD has been performed, the system goes on to the next date, thenceforth, won't depend on the computer clock anymore.

RE: Opening GL
#1607
4

3/16/2017 2:44:14 AM +05:45

Hello Binod,

I tried the 2 methods.

  1. SQL method

It returned error. When I executed the mentioned query, I got this error message:

NOTICE: Columns except the following will be ignored for this update: verified_by_user_id, verification_status_id, verification_reason. ERROR: Access is denied.

********** Error **********

ERROR: Access is denied. SQL state: P9001

When I trid to edit by GUI, I got same error:

File : Selection_651.png

  1. EOD method

I changed date of DB server to 31-December 2016, I logged out of mixERP then logged in, but it kept seeing EOD at 1-1-2017.

I tried change "fiscal year" to start at 31-Dec-2016, but still sees EOD at 1-1-2017.

What to do? This is step is very frustrating and delays me to start using the system.

Thanks

RE: Opening GL
#1608
2Y
18
4T

3/17/2017 12:22:54 PM +05:45

Hello, I would suggest some steps on this problem. If it works let me know. First change the transaction start date:

SELECT * from office.offices

UPDATE office.offices SET transaction_start_date='2016-12-31' WHERE office_id='???'

Second, update the book date of the opening balance entry

SELECT * FROM transactions.transaction_master

UPDATE transactions.transaction_master SET book_date='2016-12-31' WHERE transaction_master_id='???'

And Finally,

UPDATE transactions.transaction_master SET verification_status_id = 1, verified_by_user_id = 1, last_verified_on = NOW(), verification_reason = 'Approved opening transaction entry' WHERE transaction_master_id = ???

RE: Opening GL
#1613
4

3/19/2017 2:16:15 AM +05:45

Hello,

Thanks for your help, unfortunatelly none of these solutions made it.

The problem is always when I try to update "verification_status_id" with 1 , it gives "access is denied"

So I updated it with "2" and it worked !!

I used GUI of pgAdmin, as above codes did not work, here you are the tree:

File : Selection_653.png

Then update field with "2" not "1":

File : Selection_654.png

Would you please provide easy ability to update past transactions, it's very important.