Search options (Page 2 of 4)

Dear Joe

I don’t think that this is a permanent solution , I think you have two options for that , the first is to add criteria will be selected from compo box which will include the query about the location , the second is to delete this code “WHERE loc_code='DEF'” and make the sorting according to the location
I think you have reform the sql code here in version 2.1.3 , and really it is very bad practice in developing when you force your end user to use particular data like this case I have to maintain a record for a location its code “DEF”
Best Regards

I think this is because i delete DIF location from the list of lacation , but it is very strange here in designing , as you have to put a compo box include the locations to be selected and not to be defined by sql query .

ok you can delay 2.1.3 for a week till I'll finish the demo data for new COA

Best Regards

What I suggest you is to ship the empty chart of account as a default and then you can make a demo data for that particular chart of account available in the website , what I intend to do is to feed the demo data with a written problem to make the user understand very well the process of data , once the data entered and the reports generated we can show this results in website
I also suggest to close the demo data in the website and the users see the enquiries and reports only , I mean change the access rights for demouser to enquiries and we can setup a new company with a demo data but demouser will be accountant
So the companies I recommend are :
1.Empty with a new chart of account
2.Demodata with unchanged data and demouser with enquiries access right
3.Demodata with changed data and demouser with accountant access right

If we will apply this and ship an accounting problem as PDF file included with the frontaccounting this will make the solution more popular for accountants as we will give them the key of the solution by showing them the accounting problem and how we can process it to get the final reports through frontaccounting

For the demodata with unchanged data I can provide you by next Friday 05/06/2009 because I need more time to check the process of the solution , so if you can delay version 2.1.3 for more one week it will be better because I’m afraid that maybe there is more bugs must be cleared .

Thanks and Best Regards

you are right , and maybe we can use it in the future

for that minor manual correction I think that it deserve

actually I didn't understand what you will do for the release 2.1.3 , do you mean that all these changes related to the class type field and sublevel reporting will be in the next minor version 2.1.3 ?

in the other hand I recommend to include the class type field and sublevel reporting in version 2.1.3 and i hope we can start concentrate in the output strengthen by adding cash flow statement , then ABC costing methods , then give the different option to the user to chose from costing methods FIFO or LIFO or Average Method
later on we can also concentrate in manufacturing to get into depth of modern cost accounting , then we have to design our HRM , CRM , SCM

a lot of things we are dreaming with and we hope more success for this solution 

Best regards

I had a look to version 2.2 and I had a look in the new field or compobox that you add , and let me just share with you my small knowledge about the financial solutions .
I found this field that you add little bit strange and will not give the user the flexibility expected and more confusion will be for sure , I know that you as a developer you need to reach to your target which is in our case change the sign of liabilities and capital and the profit and loss but also if we have to achieve our goal we have use a logical way

actually I'm not familiar with php and mysql , but I have some knowledge in SQL server before 8 years and now I'm working as financial controller so from my experience I can tell you that the best way is to include a list field consists of three options with a title of "Class Type"
1- Assets
2- Liabilities
3- Owners Equities

the profit and loss will be positive for profit and negative for loss as usual and will be programmed to be added after the classes with a type of owners equities

the formula of report must be " Assets = Liabilities + Owner Equity (Capital) + Net Profit - Net loss "

if you will apply what I explain you will get standard balance sheet that there is no two accountants will disagree about .

in the future and as an effort to enrich the accounting practise using FrontAccounting , our forum in [url]www.infotechaccountants.com/forums[url/] , which include more than 56000 membership of Arab accountants and professors will help in designing the cash flow statement in the FrontAccounting according to international financial reporting standards and international accounting standards as a gift to FrontAccounting beside our gift of translating FrontAccounting into Arabic

for the future as God will and for the purposes of cash flow statement you will need to add more fields in classes and groups and accounts to obtain the cash flow statement , we will discuss this later which we hope to be included in version 3 series .

more over this also I think FrontAccounting need to attract more experts in financial accounting and auditing to give the correct advice about the critical scientific issues related to the outputs of FrontAccounting

Thank you Joe

am I missing something ? , the change log file in sourceforge.net not include any update after 30.04.2009

thank you for the sublevel presentation

did you upload the new updated file to sourcefoge.net ?

what about the minus sign in the side of capital and liabilities which must be reversed and the profit and loss amount in balance sheet must be reversed as well .

thank you for your great efforts

Thank you Joe

you have to be patient little bit , all what I meant by adding those topics is to make the FrontAccounting the best free accounting solution .
I fixed the demo in the site and you can try it in http://infotechaccountants.com/fatraining , you will fine Arabic Template Ver. 212 company and try to export the chart of accounts to excel file

why this problem happen ? , we all have to answer this question for the potential new users of FrontAccounting

By the way I fixed the link , I think your developer know very well the link of Spreadsheet_Excel_Writer Package .

Thanks

great , but what about inside balance sheet , you have to complete the belonging journey that you start by adding that it might be belonging to assets side or that it might be belonging to capital and liabilities side !!

more over the above mentioned information , in the part of owner's equity the "calculated return" which it must be named "Net Income " or " Net Profit or Loss " must be in our case here negative figure not positive , I thing all the signs of section of owner's equity must be reversed