I see this is great API, I want to start to work on Unicenta POS integration. There are many posts regarding to Unicenta but there are not fully functional one.  I just need to integration Sales/Stock deduction on Sales/Sales Return/Cash Transfer to Debitors/.

Please let me know your suggestions, may be there are already work have been done on this previously so I can continue this. Please let me know your suggestions.

Regards

I agree with you guys and therefore I have gave up on this after researching structure of Angular. Angular processes variables on browser which is complete different story than FA built. t would be better to have Angular which will modernize FA but it also means too much hassle. I will try to make only some slight UI code changes which will make much difference on look.

none cares :S

Hi All,

Id like to get in contact with developers who are experienced with angular framework and is able to modify FA to work based on Angular. I want completely remove JsHttpRequest.js and related JS framework and replace them with Angular.
Please PM me if anyone interested.

Regards,
Turkel.

5

(0 replies, posted in Wish List)

Hi,

I wish to see extended version for dbpager class as it is very simple for sorting, filtering lucks on many features such as exporting selected data, simple/advanced filtering, autocomplete features, showing transaction source module, management attached documents and memos directly on inquery.
As Accountant I am manly working on inquery pages which generated by dbpager. May be it would be better to integrate new library as db pager as it is hard to develop such many features for FA, ex: https://github.com/APY/APYDataGridBundle


Regards,
Turkel.

Hi,

1. Can we have feature for each GL Account to accept Manual Entry or Block Manual Entries? We need it for this reason:

On invoice entry:
CR  Account Payable
DR  Cost P&L

We need to block Account Payable account manual transaction entry as Payable should only contain transactions by modules (PL) but not manual direct transactions. Sales with Receivable, Accumulated Depreciation, Bank Accounts and so on.


2. We need Sub Level Accounts Under GL Accounts EX:

|Class: Asset
|_Group: Account Receivable
|__GL Account: Receivable from Trade Customers
|___Analytical Account 1: ABS Customer Receivable Account
|___Analytical Account 2: Intern Trade Customer Receivable Account
|___Analytical Account 3: Globeks Customer Receivable Account
...

It is possible to create sub-level accounts within Category level which is good, but bad side is Balance Sheet lists all classes, categories and GL accounts which makes long long list.
I`d like to know your suggestions regarding to this case, how to set up accounts do not show Analytical Accounts, is it better to adjust balance sheet accordingly?


3. Revenue / Costs Accruals feature need to be renamed to Standing Journals as we are not about only cost but we can amortize any account in periods. Feature required here is to add approval of standing journal every selected period. ex: evry month accountant need to check standing journals and post them.


Regards,
Turkel

If curl fails why we are not try it with fopen and if it also fails we can sleep(10) and try again or just return. IP will load script for unknown period without result.

8

(11 replies, posted in Modules Add-on's)

Thanks for hint, these variables are in hooks.php so I have included it inside hooks.php within Class as constructor and it worked smile sample code is below:

    public function __construct() {
        global $_SESSION;
        // if _CJ is defined, login user non interactively
        if (@$cron_request) {
            $_SESSION['wa_current_user']->login($comp, $usr, $pwd);
        }
    }

$cron_request is variable within cron.php file which is server cron accesses.

9

(11 replies, posted in Modules Add-on's)

Hi,

I have created cron job module which will automatically update exchange rates and revalue foreign accounts on daily basis. It works when I am logged in but not when I am off or on cron request. I have created new user ex: cron, and tried to process login process with $_SESSION['wa_current_user']->login function without any luck.

Can someone instruct me how can I write authorization code better without use of password.


Regards

Hi,

I want to know why we have this IP in this code? version: 2.3.25 file: \gl\includes\db\gl_db_rates.inc Unknown code: $site="172.230.157.137";

I think it is also on new beta version of FA too.


Regards,
Turkel.

11

(4 replies, posted in FA Modifications)

@kvvaradha Agree, this is good to have user friendly names also it helps for references to trace transactions. By going more deep I see more functions related to them.

I should edit FA core code because there are built in functions like payment_person_name() which required modification of my types.
But now I have faced with new issue my code is in module and types.inc or gl_trans view files are not call it within FA :S

So will modify FA and keep logs, no other way to go sad

12

(4 replies, posted in FA Modifications)

ST_CUSTPAYMENT && ST_CUSTCREDIT will not help as I have difference table for clients and contracts with them. I need to process 3 type of payment per company or directly per client.

There are some usefull functions within FA like submenu_option, submenu_view, submenu_print where as they are but only for internal predefined types.

Anyway I have decided to copy existing similar type related functions into module and modify them with new types/names.

Would be better to have more generalized framework which will help to develop functions more easy and faster.

13

(4 replies, posted in FA Modifications)

Hi,

I need to add transaction type something like ST_CREDITPAYMENT and define custom actions like delete_comments, void_bank_trans, void_gl_trans. I will add this into types.inc There are some more functions relates to this like systype_db and without hook.

But what is the reason to create these transaction types? I want to understand the purpose for this. And also why do these types are not database managed but in file.

Regards.

14

(3 replies, posted in Wish List)

Hi,

Would be better if there are would be Attachment feature on every GL transaction page, supplier GRN input, inventory creation and etc. we have "Attach Documents" feature but it is in Set-Up and very primitive. would be better to access uploading file on every input page.


Regards.

Hi,

FA not have Scheduling Transaction handler and I want to built one. Currently FA only able to schedule FX rates and this update happens on new transaction entry but I need cron to be run on daily basis. This is because we have percentage calculator per day and this should be handled by cron jobs.

I want to know what is the best way to hard code Cron Job support for FA without modifying core files ? is there are future development hook or some kind of hook that I can hang on my code?

Regards,
Turkel.

16

(2 replies, posted in FA Modifications)

Hi, I have made mentioned changes above and results are OK for static pages but not for the parts retrewes by Ajax JsHttpRequest.
I have modified db_connect file and changed po file to be UTF8 compatible. ages appears with charset=utf8 but ajax shows incorrect characters. Please advise.

1. Recurring Journal Entries - We have it.

18

(3 replies, posted in Modules Add-on's)

Thank you for help this is something new for me and it works OK.

But is there are existing feature like detailed search per specific columns of database or I need design it?

Hi, I also have same issue on 2.3.25 version, very annoying. I have tested on Chrome, Internet explorer and same unresponsive links after 15 -20 minutes. Let me know if there are any working fix for this?

Hi,

Currently I am building creditors module for FA and I tack on borrower creation page. I have created it same as "Add and Manage Customers".

The problem is when I have many borrower (customer) ex 500+ I am not able to find required one from them with one drop box. I want to know how can simplify user interface here to search required Borrower (Customer).

Consider Borrower as Customer and assume that I have 500+ customers, and define how can I select one required customer among them with current drop down user interface.

Thanks

Hi FA team,

1. Recurring Journal Entries - like standing Journal which will automatically transfer  amounts from account to account on period basis. This transaction could be generated by cron jobs.
2. Cash Book - Id like to have separated Banking from General Ledger and name it as Cash Book. Banking part of FA is very weak because there are no details for company, customer, supplier bank account like SWIFT, Correspondent, Tax ID. Especially there are no Payment Order template to be printed and sent to bank.
2. Work Flow - FA is multiuser software but user integrity is not functional. Would be better to have logs for each actions of users within FA. FA need to have one table to save logs with ID for each and extra column for all other Tables to containing this id which will help to trace any transaction, entry have been processed by any user. Work Flow is the process of approval like is someone creates purchase order or customer order it need to go through predetermined users approval process.
3. GL Source - Every GL Transaction need to include link to source module like from which calculation do amount is created and it comes from which module. ex: Fixed Asset processed calculations and it generated GL Transaction but when we go inquery we see many transactions but can determine which one come from Fixed Asset module and other one is from Supplier Payment module.
4. Many PHP Hooks - I am Accountant and at the same time programmer smile therefore I with to have many hooks within FA code as I don`t want to change core FA files. In case of new function requirement it is not good manner to change core files of script.


Thanks you very much for this great software!

22

(5 replies, posted in Installation)

Yes right this is only solution for my case, database move made changes and I was not able to redo changes. Would be better to have some solution on this as it makes confusion.

Many Thanks.

23

(5 replies, posted in Installation)

OK finally İ have figured it out smile

I have modified this core FA file:
includes/db/connect_db.inc

I have added this line after the "mysql_select_db" :

mysql_query("SET character_set_results=utf8", $db);
mysql_query("set names 'utf8'",$db);

I would like this to be considered on next release of FA, because this makes confusion on users like me and after database move somtime ( I am not sure why) database connection collation changes and this small addition may solve it. Charset could be linked from actual language file reguired charset.

24

(5 replies, posted in Installation)

Hi,

I have recently formatted my debian server and restored frontaccounting backup to new debian. After setting up frontaccounting not encodes properly the ajax requests. all html part which is initially loaded are OK but when I make request something like supplier list list it is not shows up characters properly. I have checked database and characters are OK there too. I have tested debian locales and modified FA lang directory files as on wiki but still couldn`t get any luck.
Please see screenshot, red one is problematic where you see question marks, but blue one properly rendered with UTF-8.
http://i787.photobucket.com/albums/yy151/turkel_alizadeh/Capture.png

Please advise how to debug language ?

25

(2 replies, posted in Accounts Payable)

Hi,

I have a question about practice of handling simple petty cash expenses. I have made an initial investment to cash and Capital accounts and then made payment to several Supplier which are for company setup like legal expenses with use of "Payments to Suppliers". So I need these expenses are allocated directly yo expenses account without GRN but I see this transaction credits payable account. I am sure that by modifying supplier Accounts Payable may solve problem, but I will use same supplier also with GRN purchases in future.

Please let me know please how do you record direct cash expenses in your FA.


Regards,
Turkel.