76 Reply by cedricktshiyoyo

(11 replies, posted in Banking and General Ledger)

Sorry I meant displaying the summary of account groups just like for Balance Sheet and Profit Loss.

Without listing all accounts details:

example:
   
Account     Account Name     Brought Forward     This Period     Balance
                                                Debit     Credit     Debit Credit     Debit Credit
Class - 1 - Assets
Group - 1 - Current Assets
Total - Current Assets     0.00     0.00     0.00     0.00     0.00     0.00
Group - 2 - Inventory Assets
Total - Inventory Assets     0.00     0.00     0.00     0.00     0.00     0.00
Group - 3 - Capital Assets
Total - Capital Assets     0.00     0.00     0.00     0.00     0.00     0.00
Class - 2 - Liabilities
Group - 4 - Current Liabilities

Total - Current Liabilities     0.00     0.00     0.00     0.00     0.00     0.00
Group - 5 - Long Term Liabilities

Total - Long Term Liabilities     0.00     0.00     0.00     0.00     0.00     0.00
Group - 6 - Share Capital
Total - Share Capital     0.00     0.00     0.00     0.00     0.00     0.00
Group - 7 - Retained Earnings
3590     Retained Earnings - prior years     0.00     0.00     0.00     0.00     0.00     0.00
Total - Retained Earnings     0.00     0.00     0.00     0.00     0.00     0.00
Class - 3 - Income
Group - 8 - Sales Revenue
4010     Sales     0.00     0.00     0.00     0.00     0.00     0.00
Total - Sales Revenue     0.00     0.00     0.00     0.00     0.00     0.00
Group - 9 - Other Revenue

Total - Other Revenue     0.00     0.00     0.00     0.00     0.00     0.00
Class - 4 - Expense
Group - 10 - Cost of Goods Sold

Total - Cost of Goods Sold     0.00     0.00     0.00     0.00     0.00     0.00
Group - 11 - Payroll Expenses

Total - Payroll Expenses     0.00     0.00     0.00     0.00     0.00     0.00
Group - 12 - General & Administrative expenses

9990     Year Profit/Loss     0.00     0.00     0.00     0.00     0.00     0.00
Total - General & Administrative expenses     0.00     0.00     0.00     0.00     0.00     0.00
Total - 06/30/2018     0.00     0.00     0.00     0.00     0.00     0.00
Ending Balance - 06/30/2018     0.00         0.00         0.00

Go to forum: Banking and General Ledger

77 Topic by cedricktshiyoyo

(2 replies, posted in Banking and General Ledger)

Hello everyone

I have noticed that when you print a trial balance, there is no total amount after each account group.
is it the same for everyone?

Go to forum: Banking and General Ledger

78 Topic by cedricktshiyoyo

(11 replies, posted in Banking and General Ledger)

Hello everyone

is it possible to obtain a trial balance in drill down? Just the same way as for Balance SHeet And Profit Loss Drill down.
Without listing all the accounts in details, since account details can be obtained in the general ledger report.

Go to forum: Banking and General Ledger

79 Reply by cedricktshiyoyo

(3 replies, posted in Installation)

With xampp I think you need to use the full path at the command line, something like this, perhaps:

C:\xampp\mysql\bin\mysql -u {username} -p {database name} < file_name.sql

On Windows this should work (note the forward slash and that the whole path is not quoted and that spaces are allowed)

USE your db;

SOURCE D:/My Folder with spaces/Folder/file to import.sql;

Hope this help.

For large databases, you need to import from command line.  do not use phpmyadmin.

Go to forum: Installation

80 Reply by cedricktshiyoyo

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

If you are not very familiar with ubuntu/linux .  I suggest you first install FA on a windows computer, install your FA Modules, make sure everything is running properly then you can copy your files to a linux computer, you will not face issues.

FA performance on Linux and Windows is not the same. It's just about permissions, nothing else.
Try windows you'll see.

regards.

Go to forum: Modules Add-on's

81 Reply by cedricktshiyoyo

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

I realized, it was a problem of directory permissions, FA is not working properly with Linux/Ubuntu you need to give write permissions to folders and subfolders otherwise some modules will not work properly.

if you are using windows, you may not encounter any problem installing FA.

if you are using ubuntu    make sure FA has a write permission to all directories

try this :
sudo chmod 777 /var/www/html/account/*
sudo chmod 777 /var/www/html/account/modules/*

etc...

Go to forum: Modules Add-on's

82 Reply by cedricktshiyoyo

(6 replies, posted in Banking and General Ledger)

@Braath Waate I think the solution you give  is like running away from the actual problem, you are giving a sort of detour.

Sorry but how do you make a petty cashier(Who is an Employee) to become a supplier? Now when I need to get reports, data about my suppliers,     i will have it all mixed up right?

I mean, I am not a software engineer but I think our senior software developers can come up with a script that will make it possible to add atleast one GL Account in the dropdown list when you process payment or deposit.

I know, it can be tricky having PAYMENT/DEPOSIT AND JOURNAL ENTRY not to do the same thing. Maybe a counterpart field can be inserted in the journal entry to solve this. (By the way it's just my own views, maybe not correct)

Go to forum: Banking and General Ledger

83 Reply by cedricktshiyoyo

(6 replies, posted in Banking and General Ledger)

Petty cash is a current asset and should be listed as a debit on the company balance sheet. To initially fund a petty cash account, the accountant should write a check made out to "Petty Cash" for the desired amount of cash to keep on hand and then cash the check at the company's bank.

So, is it possible to add it in the drop-down list when processing payment/deposit. Without necessarily setting it as a bank account?

In FA Petty Cash is by default set as bank account, so when you print bank statements, petty cash transactions are also showing.

Any help!!!

Regards to all

Go to forum: Banking and General Ledger

84 Reply by cedricktshiyoyo

(7 replies, posted in Banking and General Ledger)

How do you withdraw cash from an empty account? I think allowing the account to go negative is not a good idea.
I am assuming there is no money on that account, how do you make a payment then?

Go to forum: Banking and General Ledger

85 Topic by cedricktshiyoyo

(6 replies, posted in Banking and General Ledger)

Hello there,

I was wondering if there is a possibility to add an account in the dropdown list when processing a payment or deposit from an account which is not necessarily a Bank account?

Reason being when You use journal entry , there is no field for counterPart/Person.

Scenario:  The organization write a check to Petty Cashier to withdraw cash from Bank account, which will be used for administrative expenses like fuel, Employee per diem, transport, Hotel etc.

Transaction 1 :  Credit Bank - Debit Petty Cash

Transaction 2 : Credit Petty cash  - Debit Employee acct

With Regards

Go to forum: Banking and General Ledger

86 Topic by cedricktshiyoyo

(1 replies, posted in Banking and General Ledger)

Hello there,

I have a question concerning the cash flow statement extension, when I download and update the extension, it shows in the Banking reports,
When I print it only collecting bank accounts opening balances and net value.
There are no other activities like:

1. Operating Activities
2. Investing Activities
3. Financing Activities
   etc...

Is it the same for everyone? Maybe I made mistakes while downloading the repo.

Regards to all!

Go to forum: Banking and General Ledger

87 Topic by cedricktshiyoyo

(3 replies, posted in Banking and General Ledger)

How do I create subsidiary ledger if the entry involves accounts receivable or accounts payable?
Because I need the report to only show a general ledger balance, not all the details?

eg. GL 1150
    Sub 1150 - 01
    Sub 1150 - 02
   etc ...

Any help?

Cedrick

Go to forum: Banking and General Ledger

88 Reply by cedricktshiyoyo

(18 replies, posted in Report Bugs here)

okay, but how do you record for example a payment of a small amount like 2 dollars? Are you writing a check?

I believe the petty cash is not a bank account right? It's money kept at hand by the petty cashier I believe for quick transactions that do not require writing of a check and making small payments like perdiems, transportation, fuel etc..

Regards

Go to forum: Report Bugs here

89 Reply by cedricktshiyoyo

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

@notrinos in FA version 2.4.7  the installation is done, I can also access the module but I can't create any position.

When I try to create a job position nothing is showing up? What could be the problem? Is it only working with FA 2.4.7?

Regards

Cedrick

Go to forum: Modules Add-on's

90 Reply by cedricktshiyoyo

(18 replies, posted in Report Bugs here)

@detkenn I don't think using payment is good idea, I don't know if you have noticed,
when you make an entry using payment, only bank accounts are listed, there is no other accounts.
Maybe our seniors can help also clarify for us, why is that so?
I believe we are all here to contribute with ideas not only coding but also provide our experts like @joe with our insights to make FA the best of the best.

With that in mind, I am bringing this illustration;

Not all payments are done through bank transactions right? Assuming I need to make a payment of $2, am I going to write a check for that amount?
The petty cashier is often given a certain amount of money at hand to pay for small transactions, now when He you process a payment, the petty cash must be credited and the other account debited.

Is there a possibility to allow a cash account (WHICH IS NOT BANK ACCOUNT) (if not all asset accounts) to appear in the list when processing a payment? @joe

Regards to all

Cedrick

Go to forum: Report Bugs here

91 Reply by cedricktshiyoyo

(18 replies, posted in Report Bugs here)

A thousand times thanks brother @kvvaradha . The code worked perfectly.
This was exactly what I needed. I will modify it little bit with your permission for other accounts too.

Big thanks again!!!

Go to forum: Report Bugs here

92 Reply by cedricktshiyoyo

(18 replies, posted in Report Bugs here)

I would like to either warn the user when they are about to post entry?
The system should either refuse to accept the post or warn the user that is making post on a wrong account type e.g.

I am not a good programmer, I am more of system administrator. So I am suggesting to the senior programmer:

1. If they can Insert a validation on the credit debit field, in that when a user select an expense account for example, the debit field become disable.
IF it's an asset account, credit field because disable or readonly, to prevent users from posting in the wrong account, which automatically lead to a wrong report if not all reports.

2. Maybe leave the system to accept the entry but warn the user before posting

Kind regards

Go to forum: Report Bugs here

93 Topic by cedricktshiyoyo

(18 replies, posted in Report Bugs here)

Dear all,

I would like to bring this to your attention something I have noticed in FA reporting system.

I have made a mistake unknowingly, I credited an expense account instead of debit, the system accepted my entry.
Now, when I was printing out the trial balance, I got wrong figures because, the balance of the expense account was on credit and not debit.
Is it possible to restrict posting a credit on an expense account vise versa, restrict posting on a credit account?

Thanks in advance

cc:
@joe
@notrinos

Go to forum: Report Bugs here

94 Reply by cedricktshiyoyo

(2 replies, posted in Misc. Charts of Accounts)

I am also looking for the same thing, were you successful with it?

Go to forum: Misc. Charts of Accounts

95 Reply by cedricktshiyoyo

(3 replies, posted in Banking and General Ledger)

Thanks @rafat for your reply,
The suggestion you gave me, allows to have company name on the header, which I am happy for.
Now, I needed a space provided at the bottom where the receiver of the money can put is signature after printing the voucher.

Thanks again.

Go to forum: Banking and General Ledger

96 Topic by cedricktshiyoyo

(3 replies, posted in Banking and General Ledger)

Dear all, I was wondering how I can print a cash receipt voucher from FA,
For example, I am giving  a cash advance to an employee from petty cash, then I would like to print cash voucher which he/she will sign on, the file for reference. How can one do that?

Big thanks

Go to forum: Banking and General Ledger

97 Reply by cedricktshiyoyo

(6 replies, posted in Reporting)

@rafat  @apmuthu  ....

I think we all agree that when we install FA for the first time all accounts balances are ZERO right?
Now, I am creating a new bank account  in FA , automatically the account balance is set to ZERO also right?

Finally, I want to deposit money on my new bank account, remember this is a new company without any previous transactions, all GL Accounts balances are ZERO, when I am depositing that money to the bank which account am I going to post the CREDIT since all my accounts balances are zero? SHOULD I create a temporary account Post a negative credit, debit the bank then delete that temporary account or what???


SUGGESTIONS:

What if the option to insert to all GL Account and bank account beginning balances was added to the all process to facilitate new companies with ZERO previous transactions???
Thousands apologies to the SENIOR MEMBERS if I seem to not understand your procedures!!!

Go to forum: Reporting

98 Reply by cedricktshiyoyo

(6 replies, posted in Reporting)

I am not sure if I understood well , what you are saying!!

Here my question:

I am a new company, I have no transactions at all, all my accounts debits are zero.
Now, I open up a bank account with initial debit of Xyz amount, how do I record that initial balance?
Keeping in mind that the deposits I am making are not coming from any of my GL Accounts incomes or whatever, it is my initial opening balance.
Money which could come from anywhere. HOW DO I RECORD IT in the bank ledger without having to credit a specific account?

"SINGLE ENTRY NEEDED HERE"

Go to forum: Reporting

99 Reply by cedricktshiyoyo

(4 replies, posted in Setup)

But I think that isn't right, so what do you do with accounts you don't want??
Accounts that are not needed in your charts of accounts?
What have noticed even if you disable the account it still appears in the reports.

So, I think users should be allowed to modify their own charts of accounts and delete whatever is not necessary to them!

Go to forum: Setup

100 Topic by cedricktshiyoyo

(4 replies, posted in Setup)

Senior Developers,

I have noticed that an account cannot be deleted even if you remove all transactions linked to it... It still says, THE ACCOUNT CANNOT BE DELETED BECAUSE THERE ARE TRANSACTIONS DONE WITH IT!!!
Yet I have deleted all transactions with that specific account.

The only option i had was to login in the database and delete the record, but what about the end users, they have no access to the database, how will they delete accounts which the do not want anymore????

Go to forum: Setup