1

(3 replies, posted in Setup)

If your account fiscal year on 01-01-2020 to 31-12-2020 and started entries on 2020,
the only thing you can do is Closing GL transactions (Banking and General  Ledger->Closing GL Transactions).
This function is do nothing but only prevent entering new transactions and disable edition of already entered transactions up to specified date.

Using phpMyAdmin export function or mysqldump command:
mysqldump -u root -p[root password] fa_database > fa.sql

3

(4 replies, posted in Reporting)

Hi, imranrafai,
Change the 2 files as follows:

reporting/includes/pdf_report.inc  (ver 2.4.8 line 402 function SetCommonData, add 'branch_ref' in array.

        'branch' => array('br_address', 'br_name', 'salesman', 'disable_branch','branch_ref'),

reporting/includes/doctext.inc

            $aux_info = array(
                _("Customer's Reference") => $this->formData['branch_ref']   ,

Hi, please refer to
https://frontaccounting.com/punbb/viewtopic.php?id=9008

5

(2 replies, posted in Setup)

@dearmosin, thanks for the compliment and your time for watching.

I tried to set the $allow_gl_reopen = 1; in config.php but it not working.
should be $SysPrefs->allow_gl_reopen in table or allow_gl_reopen in config.php ?

Agreed,
I found there is an option to allow gl reopen in code, but I can't find the setting in fa setup menu, maybe I miss it?
What I am doing is temporary remarks the line 47,48,49 to bypass the checking.
   

gl/manage/close_period.php :

    if (date1_greater_date2(sql2date(get_company_pref('gl_closing_date')), $_POST['date']))
    {
        if (!$SysPrefs->allow_gl_reopen) {
            //display_error(_("The entered date is earlier than date already selected as closing date."));
            //set_focus('date');
            //return false;
        } elseif (!user_check_access('SA_GLREOPEN')) {
            display_error(_("You are not allowed to reopen already closed transactions."));
            set_focus('date');
            return false;
        }
    }

For purchased items, standard cost is needed for opening balance.

You can close Month end transactions on Banking and General Ledger->Closing GL Transactions. (version >= 2.4)
However it can't re-open or doing backdated posting by admin.
The only way of re-open is go to MySQL database and change the gl_closing date in x_sys_prefs table.

I have no idea what statement is.
look like is Petty cash account listing,and your sales is cash.
if is Petty cash account then you can use GL Account Transactions report.
go to Banking and General Ledger->General Ledger Reports->GL Account Transactions

Sorry, there is no data in Delivery note, so don't need to edit it.
Your new FA starting  on 1st Sept so all reports should start from 1st Sept and it should not shows in Order status listing, unless you enter date on Aug.

Go to Sales->Customer Transactions
Search your Invoice and edit it, and you have to edit the Delivery Note too.

I hope you have followed my video of create old unpaid sales invoice method, the method is used to knock off (erase) GL transactions.

I think it's ok to has one average cost for spare from 2 stores within a company.
The other way is 2 stores(branches) have their individual accounting (treat it as 2 companies).
and on fiscal year end you just need to consolidated 2 stores financial statements.
that's just my opinion smile

Create Tax Types (Setup->Taxes)
Create Tax Groups and include taxes.(Setup->Tax Groups)
Create Item Tax Types (Setup->Item Tax Types)
Select Tax Group for suppliers (Purchases->Suppliers)
Select Tax Group for Customer (Sales->Customer Branches)
Select Item Tax Type (Items and Inventory->Items).

FA is using perpetual weighted average cost inventory system,
perhaps you may share what is the reason of same item different cost in different location,
maybe there is alternative solution.

You are welcome.

17

(10 replies, posted in Setup)

1. Assets, Liabilities and Equity are Balance Sheet Accounts.
2. Income and Expenses are P&L (Income Statement) Accounts.

Like what u said, The difference goes to P&L (2).
which is then transferred to Retained Earnings (1).

This is the standard and what the follow message checking for.
The Retained Earnings Account should be a Balance Account or the Profit and Loss Year Account should be an Expense Account (preferred the last one in the Expense Class)

You can delete the empty fiscal year in MySQL table x_fiscal_year.
But you still have to check the above settings.

18

(10 replies, posted in Setup)

Retained earning is under liabilities in the Equity section of balance sheet.
It's ok to set it under Liabilities.
However you can set it to Equity by adding a new GL Account Class "Equity".

Unpaid sales invoices?
Yes, you'll need to create fiscal year before you can enter transaction in that period.
but if you have already entered opening balance on 2020, enter previous transaction will mess up your opening balance.

20

(10 replies, posted in Setup)

Even there's no transaction, the system still check the GL Account settings before closing, and if not setup the GL Accounts properly, you'll not getting the correct P&L figures.

21

(10 replies, posted in Setup)

Retained earnings is under Balance sheet Liabilities & equity section.
Check the Retained earnings account in Banking and General Ledger>GL Account Groups, the account Class should be Liabilities.

Year Profit/Loss is under Income Statement/Profit and Loss Statement.
Check the Year Profit/Loss account in Banking and General Ledger>GL Accounts,  Account Group should be Expenses.

You'll need to correct the Retained earnings or Profit/Loss account settings before you can close the fiscal year.

and you have to check the GL accounts generated from system, modify it to suit your company needs.

22

(10 replies, posted in Setup)

The fiscal years are generated from the script, make sure there is no sample data (transactions).
1st, create the current fiscal year, and go to Company Setup and set the current Fiscal Year.
Then you can close and delete empty fiscal years, click on edit icon and set "Is Closed" to "Yes" and click on Update button, and then delete the fiscal year.
If transactions exist, all transactions will be deleted and converted into relevant balances.

23

(3 replies, posted in Setup)

You are welcome.

Hi, siddiquinoor, you meant your company is tax exempt and all your transactions are no tax?
if so, you can delete tax group or exclude it from tax. (Setup->Tax Groups).
and delete all the tax type (Setup->Taxes).
then tax is excluded in all your transactions.

If your company is tax registered, for example Bangladesh is 15% GST tax.
You can create GST Tax type in Setup->Taxes, but you still can do transactions like sales and purchases which is tax exempt.
FA Tax system is very flexible to accommodate nearly all tax rules.

You can refer to my video on how to setup tax system for:
Purchase with and without tax.(Supplier Tax Group)
Sales with and without tax. (Customer Tax Group)
Item with and without tax. (Item Tax Type)
https://youtu.be/OcNLxozI9Ms

It could be the balance of Capital or Retained Earnings.
You can't adjust based on these.
you should enter all the account balance in old system Balance sheet into the new FA opening balance.