If you permit me to suggest, although I am far away of being such a developper like you and your fellows :

using alphanumeric as I suggest , open for you the door for an easy developement of a report generator who can be easely integrated with your system and will be simple to manipulate by the end user like me (finally i am not a programmer, I am a civil engineer who likes the programming and was very impressed by what you done with this software and like it too much).

What i suggest will help a lot for the simple reason that a Function such Get_Value("1012*") will bring you all the down tree levels balance in a simple SQL statement. And in this case you will discard the complication issuing from using Group/Subgroup Loops. You will have a direct access to any level of Groups/Subgroups from the Master_GL easely. Those Groups/Subgroups are the Heart of all kind of reports an Accountant or an Analyst use.


Finally, it is my opinion not more. and for myself already I made a little of changes to the Types & Classes and i use them all as alphanumeric ID's.

Thanks & My Best Regards,


Khaled

OK thanks Joe,

you wanna big_smile.

I spent my time today arround 4 hours or more to discover it.

From other side :

Another strong improvement you may add to your system if you can switch to alphanumeric the A/C classes ; Types ; and movers accounts.

in this case you may impose tree form of all your Chart of Account [COA]

which permit a upward movement so simple w/ the SQL family.

If you check with : MYOB , PEACHTREE, NAVISION etc... all of them adopt this philosophy of preparing and using the COA. The main idea that :

it helps a lot in grouping and quering at all levels.

COA's ex :

101
1011
1012
10121
10122
etc....

Regards,


kalido

Hello,

I already Solve it.

But Since I am not " WOW " in Java , I hope that you help :

in config.php, I add the follwing lines to define 2 Variables :

$date_system   = 0 ;   // Originally included

// New Variables to use later on in the file : /includes/ui/ui_view.inc

$WeekDay_1_OFF = 0 ; // sun=0 ;mon=1; Tue=2; --> Fri=5;Sat=6
$WeekDay_2_OFF = 6 ; // sun=0 ;mon=1; Tue=2; --> Fri=5;Sat=6

Then in  the file  /includes/ui/ui_view.inc, You go to the lines :

1- Go arround line # 786 and add to the :
    function get_js_date_picker()
    the 2 Varibales already defined in config.php as global :
        global  $WeekDay_1_OFF, $WeekDay_2_OFF;

2 - Go arround line # 1100 and change the line :
          $js .= "}  else if (dayOfWeek == 0 || dayOfWeek == 6) {";

WITH :
$js .= "} else if (dayOfWeek == $WeekDay_1_OFF   || dayOfWeek == $WeekDay_2_OFF   ) {";    // Khaled

BUT at each time you need to change the WeeDay OFF's Variables in config.php, you need to delete the file /company/js_cashe/date_picker.js
And then restart the page to take effect.

---------------------------------------------------------------------------------
Finally, a huge efforts you did with this very interesting Ver 2.2.

it is really interesting and outstanding.



Regards,


Khaled

Hello,


How can I Setup the Calendar w/ Friday off as Bellow :

- Use the Gregorian Calendar as

- Assign the Week End : Friday is Off

- Saturday is 1st work day of the week.

I tried to Track it through the software, but I could not.

Can you help ?


Kalido

HI,

I checked Google Chrome, it works OK.

I checked Internet Explorer Ver 8 , it works OK.

kalido

Dear Joe,

To make sure it is not a problem of installation I checked the demo 2.2 beta.

i faced the same problem, which means surely a problem of Internet Explorer Browser.

I use :

->    IE Ver : 7.0.6000.16890

->    OS = Vista Ultimate

The error comes with yellow pyramid at the bottom left of the window with a black exclamation mark.


================================================
To note , i did not face this problem with FA's bellow Ver:2.16



kalido

Hello,

Please advise what is the purpose of inactive account.

kalido

Hello,

When Entering the Web Pages of FA 2.2 Beta, I face the Following :

1 - Always I have this error :

Internet Explorer

Line : 335
Char : 1
Error : Expected Identifier, String or Number
Code : 0
URL : --> Any Web Page when I enter the Software.

2 - When I try to open a report, It directly close the Report Pages & I cannot continue with it and it redirects me to main_reports page.

3 - also, in the page : http://localhost/FA220-beta/gl/manage/gl_accounts.php?

when choosing an A/C for editing, FA do not  display the selected A/C. Practically it acts like nothing asked or changed in the A/C Combo box Selector.

kalido

Hello,

as mentionned, Is it possible to include Customers/Suppliers A/C in JV's directly.

As per the Software, the Deposits/Payments are the only way to interact with the Suppliers or the customers.

Can we include the Customers/Suppliers ID's in the Journal Vouchers ?


is there a way to do that ?


Thanks,


Kalido

Hello,


Is There any way to Inquire the Account(s) Types/Groups, and also to print it out ?

For now we need to exctract it from the 'Account GL' Report Statement who is mainly aware of the Active Accounts and not aware of the Account Groups.

This feachure will help a lot in the Accounting Analysis.



Regards,


Kalido

61

(2 replies, posted in Reporting)

hi,

I resolved the Problem, but I don't know if it affects anything else, I think you have an Idea if it is. (Please Advise)

I trace the " Warning Icon " appeared in the upper middle of the page :

warning.png ; it seems that it is declared by a Javascript setimeout() problem.

I changed the follwing in the file :      /js/utils.js

line 28    tout = tout | 3000;    // default timeout value
line 29    set_mark(tout>5000 ? 'progressbar.gif' : 'ajax-loader.gif');

to

line 28    tout = tout | 30000;    // default timeout value
line 29    set_mark(tout>50000 ? 'progressbar.gif' : 'ajax-loader.gif');

I increased   3000   to   30000   &    5000   to   50000.

The " web page " display + pdf reports generating problems was resolved.

==========================
BUT for the listed bellow errors appeared in the /temp/error.txt , Ihave no answers, do you have ?

1.
[07-Sep-2009 10:49:28] 0:admin:gl_account_types.php:195: Non-static method reserved_words::get_any_numeric() should not be called statically


2.
[07-Sep-2009 10:49:28] 0:admin:language.php:124: Non-static method get_text::gettext() should not be called statically

3.
[07-Sep-2009 10:49:28] 0:admin:gettext.php:177: Non-static method get_text::_support() should not be called statically


Finally sorry for this disturbs I caused.

Regards,


Khaled

62

(2 replies, posted in Reporting)

Hi again,

What i noticed also :

- if I add a new Group Type Account , it accepts it but to see the additions shown in the table, I need to refresh the Web Page manually

- also if I delete a Group Type Account, it accepts it but to see the deletion shownin the table, I need to refresh the Web Page manually



Also from other side When I checked the file  /temp/error.txt

I found the following errors :

1.
[07-Sep-2009 10:49:28] 0:admin:gl_account_types.php:195: Non-static method reserved_words::get_any_numeric() should not be called statically


2.
[07-Sep-2009 10:49:28] 0:admin:language.php:124: Non-static method get_text::gettext() should not be called statically

3.
[07-Sep-2009 10:49:28] 0:admin:gettext.php:177: Non-static method get_text::_support() should not be called statically


Regards,


Khaled

Hello,

in The COA of my Company I use

- A/C Types/Groups/SubGroups extend the 100 Groups Acnts

- A/C Active Accounts extend the 100 Acnts Also

The Problem is :

- in the Training Co. Evrything is smooth in the reporting.

- when I entered my Co. through an .sql statement, I faced 3 probs.

   1 - Since the A/C types is big, I could not Edit any of it.
        When I asked for editing, the system seems to run w/ a blue arrows as
        normal, then it stopped and could not forward and retreive the data and
        display it for editing. the Blue Arrows showed in the upper middle of the
        screen and who shows the progress , becomes Red After being Blue.

   2 -  I tried to output a COA pdf report , the same problem I faced. Nothing
         Processed.

   3 - When I logout of my Co. & Login to the Training Co. to test the Edit Page of
        the A/C Type + The COA Reports, The Problem is now persisting.

Any Idea Please, Finally I am not an expert in the PHP Environement.

Regards,



Khaled

Hi,

Another I Idea :

If you adopt a VARCHAR types for the ID's of Classes (var 3) & Group

Accounts (var 6) in Addition of the Active Accounts (var 15) and which already

the option is available for (var 11) , I am 100% sure that

we will have an enormous flexibily in the Software, especially that the

accountants always need the Summation at a certain level of the account

Groups  / Subgroups, and even at the level of Active Accounts , when they do

the summation for ex. 4000***** . Your FA will be highly flexible and very

competitive to All the line of  Desktop Applications Such as Peachtree ot MYOB

or others.

Regards,


Khaled

Thanks a lot, I think you got the point.

I trace the issue programatically and I found it a little bit complicated for me to catch it.

As an additional idea (since you mentioned the new releases) , if we have the possibilty to print the Inquiries it will be a wise idea [ I think that smile ].


Regards,


Khaled

ok thanks.

I don't think there is a way to retrieve/print the Vouchers generated in :

[ Banking & GL ] Tabs , as per Manually Entered Reference ID's.

Practically, the accountant prepare his Vouchers and give them ID's references , register the data into the computer.

Then after, if he wanna review his work, he will return back the ID's he gaved to his vouchers.

/kalido

Good Afternoon,

Thanks for your prompt reply.

Does this [ $print_invoice_no = 0 ] cover the Vouchers generated by :

============================================
- Bank Account Payment Entry      ; Payments TAB

- Bank Account Deposit Entry        ; Deposits TAB

- Journal Entry                             ; Journal Entry TAB

- Transfer between Bank Accounts ; Bank Accounts Transfers TAB

- Budget Entry                              ; Budget Entry TAB

- Reconcile Bank Account              ; Reconcile Bank Account TAB
============================================

From Other side, why do you think FA could not generate reports and sometimes does. This problem was evolved when I set $print_invoice_no = 1, and still persist after setting it to $print_invoice_no = 0. Is it a matter of Memory Management of my PC ( I am trying FA on my PC + wampserver) ?

Again, thanks for your help.

Regards,


kalido

Hello,

I Set the following in the config.php :

============================================================
/* print_invoice_no. 0 = print reference number, 1 = print invoice number */
//    $print_invoice_no = 0;

$print_invoice_no = 1;                                      // kalido
=============================================================

My intention is to have the GL Reference nb to be displayed in the out reports instead of the Transaction internal numbering,

the system failed to generate PDF files, also it it drops several times and stop out. and in the rare times it generates an excel file

in which I saw that always the trans_no appear and not the reference nb (tis reference nb , generally we adopted as a reference for that registered transaction)


Any Idea ?


Generally, it is necesary to display and to track any transaction voucher (also invoices) by its reference nb associated to it, because the trans_no will change whenever any later modification occur to that transaction.


Regards,


Kalido

Hello,

FA is a vry flexible accounting system, by the month after month improvements it

seems is convering a wide variety of accounting needs.


I noticed that if I Stick to only the Modules :

Setup & Banking & General Ledger & Dimensions,

I can so easely do the Accounting excercises of my company without the

need for other modules except of Difining the Customers Or Suppliers (+ the

Definition of the Inventory location = used to setup the Co.).

Is it right or I am wrong, please advise.

From other side, I am wondering why you use :

- Purchasing/Payment to Suppliers
- Salses/Customers

although you have the Payments & Deposits Facility in the Banking & General Ledger Tab,Since those 2 Actions are not related to Invoices directly ?

Also if you permit me to ask : I think the work you are doing and improving in the Sales + Purchasing Modules are robust, but it needs :
- Simplify its entries and logics
- Arrange a help screen for those two Modules, since they need to, and nobody will understand the logic sequence  of it except of you.
this will help & diminue the Q&A related to those 2 parts.

Finally Congratulation for this system, who proved to be a simple/flexible package.

Regards,


Kalido

Hello,

- if we left account_code2 blank, it generates the PDF file, but it issues this error :

Undefined index: account_code2 in file: D:\wamp\www\FAoriginal-Modified\reporting\rep701.php at line 98

- if I fill a value for the any account_code2, the PDF report will not be generated


Regards,


kalido

71

(1 replies, posted in Items and Inventory)

Hello,

I noticed that, in the Company Setup, we need to define a sales type for  defining the :

Base for auto price calculations :

Can you clarify that for me plese when it is used inside the Prog and wht it will affect.

Also, in the same circle, can you kindly clarify for me what is the purpose of the :

Tax included :

when defining the a new Sales Type

Regards,


khaled

Thanks, I will Try that : $go_debug =1.

From other side you said that : " So far there was no volunteer to fulfill the need for complete FA help system, so you can be the first one . "

If we Split the Help files to several modules, you will Have :

Module 1. Installation of FA + Declaration of a New Company
              ( already fully covered )

Module 2. Setup a New Company w/ Data Ranging from : Currency
               Definitions , Up to Dimensions Setup.

Module 3. Banking & General Ledger Transactions & Tasks + Dimensions

Module 4. Sales (Receivables) & Purchases (Payables) entory

Module 5. Inventory

Module 6. Manufacturing

Module 7. Reporting

For Myself, I will try to cover the Modules 2 & 3. When finished my 1st attempts
I will send to you to revising it.

I hope from other side somebody will interfer and do other modules

Example 1 :

Preparation Checklist for the Company :

This Preparation Checklist is to assist you in making the decisions and assembling the information needed to set up a business in FA.

The Checklist covers Setup-Task areas corresponding to the pages in FA.
You should respect the order in Fullfilling the Data bellow.

Data to Prepare                                Accessed from the Menu :

1. Currencies:                                    Banking & General Ledger               
2. Fiscal Years:                                   Setup
3. Sales Type:                                    Sales
4. Company Profile:                            Setup
5. Display Setup:                                Setup
6. Forms Setup:                                  Setup
7. Printers:                                         Setup
8. Print Profiles:                                  Setup
9. General Ledger:                             GL Account Classes
                                                        GL Account Groups
                                                        GL Accounts
                                    Nec. A/C's -> Exchange Variances, Shipping Charges,
                                                        A/R, Sales, Sales Discounts Given,
                                                        Sales Prompt Pymnt Discounts,
                                                         A/P, Discounts Received,
                                                         Inventory, C.O.G.S., Inventory
                                                         Adjustments, Item Assembly Costs
                                                         Account
10. System and General GL Setup:       Setup
11. Taxes:                                          Setup
12. Tax Groups:                                  Setup
13. Payment Terms:                            Setup
14. Shipping Company:                       Setup
15. Inventory Locations:                      Items and Inventory
16. Bank Accounts:                             Setup
17. Points of Sale:                               Setup
18. Quick Entries:                                Setup
19. Dimension Entry:                           Dimensions
20. User Accounts Setup:                     Setup

Notes :
- Beginning Balances : Initialized via a " Journal Voucher "
  They represent any outstanding customer or vendor invoices, outstanding
  earnings and deductions for employees/sales reps, outstanding invoices and
  payments for jobs, and the quantity and cost of inventory items currently on
  hand.

Example 2 :

Note: I assume you start to adopt the Account Group id as varchar(6)

Account Classes :
- Max lentgh = 3 Digits Numbers from 0 to 999. ex : 100 ; 200 ; 300 ; 400 ; 500 ; etc..
- Define how the accounts will be Organized/Grouped in Reports and Financial Statements.
- They also control what happens during fiscal year-end.


Account Groups :
- Max lentgh = 6 Characters. ex: 42 ; 420 ; 421 ; etc...
- An Account Group is a " Header Account " and he is used to summarize the transaction results of the " Active Accounts " belong to it.
- An Account Group may have Multiple Hierarchically " Sub Header Accounts ", but they all should have the same " Account Class " Types Definition.
- It is well recommended to include the " Account Group " number as a part of the begining " Account Group " Description Field. This will help you recognisze them easely later on because the Software do not show the " Account Group " Numbers in the reports and rely only on showing the Description Field of it.

Accounts : ( Active Accounts )
- Max lentgh = 15 Characters. ex: 4213 ; 42214 ; etc..
- An " Active Account " is the Bottom Low Level of the Chart of Accounts Hierarchy Tree for the company where all the transactions occur on.
- It is well recommended to include the " Account Group " number as a part of the " Active Account " number to profit from the " Department Masking " Report Facilities. In this case you should define your account as :
- let say that you have an "Account Group " nb = 421
- So you need to use an " Active Account " nb such as : 4211 ; 4212 ; etc..
- Generally, it is recommended to Define the " Active Account " as a composition of 2 parts :
[ A/C Group Part ][A/C Part] where the Max Total Length = 15 Characters
[ A/C Group Part ] Max length = 6 Char
[ A/C Part ] Max length = 15 - Length ( A/C Group Part )
ex : [ A/C Group Part ] <--- 421 345 ----> [ A/C Part ] & the A/C Number will be: 421345


Department Masking :
FA offers a powerful feature called Masking that helps you departmentalize your financial statements. To take advantage of this feature, you need :
- 1st Define your account numbers in hierarechical way.
- 2nd include the Account Group Numbers as a part of the " Active Account ".
- 3rd Setup your Account Numbers in a special way to consider the departments or branches
Say you want to set up a company that comprises :
- Main + Remote Branch
- Sales + Service Departments.
You could establish a 9 x Character Account Number :
- with the 7th character representing the Location ( Main ; Remote branches )
- and the 8th + 9th character representing Departments (01 = Sales ; 02 = Services)
Then you would enter each Normal Account Number in your chart of accounts 4 times, with each combination of Locations and Department codes:

Account nbs : -------M01 ; -------R01 ; -------M02 ; -------R02

When you order a reports later on using REPGEN or Other Reports Generators you may use < Department Masking > to analyse Departments or Locations Transactions such as:
SQL for All Departments 02 : *****02
SQL for Remote Bransh + Department 01: *****R02
Masking offers a lot of possibilities. You know your needs, so use your imagination when setting up your chart of accounts to take advantage of this powerful feature.


smile

I tried Also :


$help_base_url = $path_to_root.'/modules/wiki/pmwiki.php?n='._('Help').'.';

                                     instead of

$help_base_url = $path_to_root.'/modules/wiki/index.php?n='._('Help').'.';

                                     in the FA : config.php

                                     it works also the same like  :

$help_base_url = $path_to_root.'/modules/wiki/pmwiki.php/Help/';


Kalido

You are absolutly right.

But how can I let the :

http://localhost/frontaccount214/modules/wiki/index.php?n=Help.NewSalesOrderEntry


OR Similar ,not to issue a Blank Page ?


Any Solution ?

I did not discover the Trick. I followed Exactly the Installation recommendation, but it always issue that Blank Page.

I am sure it is a matter of web page redirecting problem, because when i use the other method :

$help_base_url = $path_to_root.'/modules/wiki//pmwiki.php/Help/';   

it woeks, but in the mode as you mentionned (WIKI Pages Interfaced).


Regards,

Kalido

To resolve the problem I asked for yesterday I did the following :

1.

I changed in config.php :

$help_base_url = $path_to_root.'/modules/wiki/index.php?n='._('Help').'.';

to

$help_base_url = $path_to_root.'/modules/wiki//pmwiki.php/Help/';   

Then, When I press on the ' Help Button ' , a WIKI page is called and

opened correctly.

2.

I installed the WIKI module through FA installer as REPGEN


& So, it works well. But you need to make sure of wiki/local/config.php :

it should be configurred well.


Now I am Searching for a WIKI WYSIWYG Editor to simplify the update of the Help Pages.

Do you know any ?


Regards,


kalido