1 (edited by anoopmb 10/18/2018 01:51:36 am)

Topic: Approval System for GL Postings Demo and SourceCode

Hi,

This is one of another modification to FrontAccounting. There may be bugs and I am not giving any warranty for my modifications.

Expecting suggestions , only minimal changes done

1. When creating users we can enable or disable direct GL posting for that user

2. In access setup we can enable or disable Modifying approval pending GL Transactions

3. Approver can approve,reject or void that transaction

4. Rejection and voiding will prompt for memo

5. To  Approve pending transactions go here Banking and Ledger tab -> inquiries ->Pending GL Transactions

Source code link and Details :Github Link

Demo Link Demo

Approver
login : admin and demo

User/Accountant

login : demouser and demo

ANOOP
membtech.in

Re: Approval System for GL Postings Demo and SourceCode

To make it easy for integration in FA, provide the changed files alone or the diff file.
Also you made changes to the database schema / records (sys_prefs)? There is an extra flag field in the users table called "allow_direct_posting" and db version bumped to v2.4.2 in version.php but not changed in the sql files.
You have also added another user function get_user_real_name().

@joe: nice addition to FA - please check it out. It certainly affects the "DB Schema Freeze" policy.

3 (edited by anoopmb 05/21/2018 04:08:11 am)

Re: Approval System for GL Postings Demo and SourceCode

Hi apmuthu,

I changed the db version to integrate it as a software update

I have added two new files in sql folder

Basically it will put a status flag on gl_trans table and audit_trail table

0=>Pending
1=>Approved
2=>Rejected

reasons/memo for rejections are stored in separate table


Heres the download Link for changed files Download

Copy the files to root folder and do the software update and Its Done!

ANOOP
membtech.in

Re: Approval System for GL Postings Demo and SourceCode

Does this update comply with FA version 2.4.4?
I want to try it before work

Re: Approval System for GL Postings Demo and SourceCode

@king1984


Yes This modification done on version 2.4.4

ANOOP
membtech.in

Re: Approval System for GL Postings Demo and SourceCode

Very beautiful work

I have an important inquiry
Can I enable and disable this property?

Can you send modified files only?

7 (edited by anoopmb 05/27/2018 02:05:50 am)

Re: Approval System for GL Postings Demo and SourceCode

Thank you @king1984

Instead of disabling you can allow direct posting for all users and restrict the entry to approval page

Modified files download link is given above

ANOOP
membtech.in

Re: Approval System for GL Postings Demo and SourceCode

@anoopmb - This is definitely a good feature. But if you go with separate table instead of gl_trans and audit_trail to save them in a separate tables and when you user moderates and the moderators accept it. You can simply insert them into the gl_trans and audit_Trail table. You can make it as extension.  I feel all users may not need such a features. If someone doesnt understand the system and when they enter an GL entry and tries to check in its inquiry and cant find it means, it will be burden to them.

So its possible to make it as extension and keep the entries in separate table, once the moderator accepts, you can insert into the actual tables.

Re: Approval System for GL Postings Demo and SourceCode

Do not forget to consider that the document number will be checked only in the core tables and not in the extra tables. You may land up accumulating "yet to be approved" entries in the new table - possibly all with the same document number!

10 (edited by anoopmb 05/28/2018 03:28:26 am)

Re: Approval System for GL Postings Demo and SourceCode

@kvvaradha
I think it may be difficult to build it as a extension without core file changes. I just gave an idea so if joe make the necessary changes in core files to integrate it as extension it will be possible

users  can view the gl entry using the gl_trans_view popup , it will also display the current status ,name of approved by, rejected by and reasons for rejections etc

@apmuthu
right. there is such possibility

ANOOP
membtech.in

Re: Approval System for GL Postings Demo and SourceCode

hey,
i have checked this at different server, well can you please tell me how can i update existing FA to this one? need to replace files or something else..

Regards

Re: Approval System for GL Postings Demo and SourceCode

Check the FA 2.4.4 announcements page for changed file set.

Re: Approval System for GL Postings Demo and SourceCode

Any update of this modification? Does it work in fa 2.4.6?

Re: Approval System for GL Postings Demo and SourceCode

mostly it should work , you may try once, by the way i will check it and post an update

ANOOP
membtech.in

Re: Approval System for GL Postings Demo and SourceCode

@joe: Can integrate the Approvals System into atleast FA 2.5.

Re: Approval System for GL Postings Demo and SourceCode

@joe if you include this it will be very helpful for lots of users

it helps to monitor accountants entry, if any help required  i am ready

ANOOP
membtech.in

Re: Approval System for GL Postings Demo and SourceCode

@joe my vote for it, please consider.

www.boxygen.pk

Re: Approval System for GL Postings Demo and SourceCode

I will have a closer look again.
I've been very busy on other work.

Thanks

Joe

Re: Approval System for GL Postings Demo and SourceCode

Hello again,

I will put this on the 2.5 implementations. Also let Janusz comment on this.

/Joe

Re: Approval System for GL Postings Demo and SourceCode

Great.....

www.boxygen.pk

Re: Approval System for GL Postings Demo and SourceCode

Thanks Joe..

ANOOP
membtech.in