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.
1 10/16/2020 07:37:46 am
Re: Back Date Entry (3 replies, posted in Setup)
2 10/09/2020 02:47:57 am
Re: A problem with the database backup (1 replies, posted in Installation)
Using phpMyAdmin export function or mysqldump command:
mysqldump -u root -p[root password] fa_database > fa.sql
3 10/03/2020 12:34:12 pm
Re: Customer Shortname in Invoices (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'] ,
4 09/30/2020 10:33:29 am
Re: Closing GL Transactions - Closed but need to Open (1 replies, posted in Banking and General Ledger)
Hi, please refer to
https://frontaccounting.com/punbb/viewtopic.php?id=9008
5 09/23/2020 11:17:31 pm
Re: Singapore GST Accounting (2 replies, posted in Setup)
@dearmosin, thanks for the compliment and your time for watching.
6 09/21/2020 09:07:15 am
Re: Month End/Year End Process, Fiscal months closing (4 replies, posted in Setup)
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 ?
7 09/21/2020 08:56:23 am
Re: Month End/Year End Process, Fiscal months closing (4 replies, posted in Setup)
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;
}
}
8 09/21/2020 07:44:56 am
Re: Periodic sales & purchase price maintenance (2 replies, posted in Items and Inventory)
For purchased items, standard cost is needed for opening balance.
9 09/21/2020 06:31:51 am
Re: Month End/Year End Process, Fiscal months closing (4 replies, posted in Setup)
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.
10 09/07/2020 01:44:05 pm
Re: How to check current balance of the day. (3 replies, posted in Banking and General Ledger)
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
11 09/07/2020 01:30:47 pm
Re: How to correct wrong sales date? (3 replies, posted in Accounts Receivable)
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.
12 09/07/2020 11:57:18 am
Re: How to correct wrong sales date? (3 replies, posted in Accounts Receivable)
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.
13 09/07/2020 06:33:09 am
Re: Calculate average cost by Inventory Location (5 replies, posted in Items and Inventory)
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
14 09/07/2020 05:58:04 am
Re: Make VAT show when raising a purchase order (1 replies, posted in Setup)
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).
15 09/07/2020 02:44:29 am
Re: Calculate average cost by Inventory Location (5 replies, posted in Items and Inventory)
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.
16 09/05/2020 09:58:40 am
Re: How to add old fiscal year data in current fiscal year. (3 replies, posted in Setup)
You are welcome.
17 09/05/2020 09:54:34 am
Re: Close and delete fiscal years (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 09/05/2020 09:10:25 am
Re: Close and delete fiscal years (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".
19 09/05/2020 08:40:54 am
Re: How to add old fiscal year data in current fiscal year. (3 replies, posted in Setup)
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 09/05/2020 08:30:08 am
Re: Close and delete fiscal years (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 09/04/2020 12:51:58 pm
Re: Close and delete fiscal years (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 09/04/2020 08:29:16 am
Re: Close and delete fiscal years (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 09/04/2020 01:31:03 am
Re: Install/Update Chart of Accounts Errors (3 replies, posted in Setup)
You are welcome.
24 09/03/2020 03:26:24 am
Re: I don't have tax calculated in my Purchase or Sales, what should I do? (5 replies, posted in Accounts Receivable)
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
25 09/02/2020 12:09:51 pm
Re: How to adjust existing account balance as opening balance in FA. (2 replies, posted in Banking and General Ledger)
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.