You are welcome
26 09/02/2020 11:18:19 am
Re: How to setup fiscal year in broken months? (3 replies, posted in Setup)
27 09/02/2020 07:27:03 am
Re: How to setup fiscal year in broken months? (3 replies, posted in Setup)
You can create fiscal from Jan to Dec and
Enter your existing account balance on 31 August in Journal Entry.
28 09/01/2020 02:23:33 am
Re: JV Posted Print no Full Page (7 replies, posted in Banking and General Ledger)
alternatively you can print report on General Ledger Reports -> List of Journal Entries.
just for my curiosity, why the journal have so many entries?
29 08/29/2020 07:26:46 am
Re: I don't have tax calculated in my Purchase or Sales, what should I do? (5 replies, posted in Accounts Receivable)
It's depend on how you set the tax system.
You can refer to:
https://frontaccounting.com/fawiki/index.php?n=Main.TaxSystem
30 08/29/2020 07:22:36 am
Re: How to record opening balance in first setup. (5 replies, posted in Banking and General Ledger)
All your mentioned accounts should be in old system balance sheet entries. The easier way is taking the old system balance sheet entries and enter into FA opening balance.
31 08/28/2020 02:34:00 am
Re: JV Posted Print no Full Page (7 replies, posted in Banking and General Ledger)
JV = Journal Entry?
32 08/25/2020 01:35:28 pm
Re: How to record money the Owners Put Into and Take Out of the Business. (5 replies, posted in Banking and General Ledger)
1. Dr Bank
Cr Owner's Equity(Capital)
2. Dr Owner's Equiry(Capital)
Cr Bank
33 08/24/2020 05:30:20 am
Re: Display Same GL Report same as General Ledger Inquiry (1 replies, posted in Reporting)
2) "the Description or Memo" is refer to person/memo?
It's no enough spaces to print all in A4 paper.
If you can leave out the dimension field on GL Report (rep704.php) change the memo column on 4 to 7, $rep->TextCol(4, 7, $txt, -2);
and remark the dimension (from line 162 on ver 2.4.8) as follow:
// Remove dimension
//if ($dim >= 1)
// $rep->TextCol(4, 5, get_dimension_string($myrow['dimension_id']));
//if ($dim > 1)
// $rep->TextCol(5, 6, get_dimension_string($myrow['dimension2_id']));
$txt = payment_person_name($myrow["person_type_id"],$myrow["person_id"], false);
$memo = $myrow['memo_'];
if ($txt != "")
{
if ($memo != "")
$txt = $txt."/".$memo;
}
else
$txt = $memo;
// Change memo on col 4 to 7
//$rep->TextCol(6, 7,$txt, -2);
$rep->TextCol(4, 7, $txt, -2);
34 08/23/2020 03:44:15 am
Re: Permit to Use FrontAccounting_Philippine Requirement (2 replies, posted in Installation)
Hi, I am not from Philippines, but I don't think we need to getting permit from tax authorities to use any accounting system.
Your invoices and financial reports must compliant with the financial regulations in your country,
and this can be done by settings and modifying reports in FrontAccounting.
35 08/21/2020 07:28:45 am
Re: Install/Update Chart of Accounts Errors (3 replies, posted in Setup)
Should be the file and directory permission problem, pls refer to:
https://frontaccounting.com/punbb/viewtopic.php?id=4387
36 08/21/2020 05:23:12 am
Topic: Singapore GST Accounting (2 replies, posted in Setup)
Hi, I have create a video on Singapore GST Accounting
https://youtu.be/OcNLxozI9Ms
Tax Compliance is the main concern of choosing accounting software,
hope my tutorial can help users on setting up the Tax system in FrontAccounting.
and please point out any mistakes I have make in video, thanks.
37 08/21/2020 04:05:43 am
Re: Is it Possible to Display Supplier Reference in Supplier Statement? (3 replies, posted in Accounts Payable)
add the 2 statement end of while loop. (after line 226)
if ($show_balance)
$total[3] = $total[0] - $total[1];
// display ref. on 2nd line
$rep->NewLine();
$rep->TextCol(1, 2,$trans['reference']);
38 08/20/2020 06:48:03 am
Re: Is it Possible to Display Supplier Reference in Supplier Statement? (3 replies, posted in Accounts Payable)
I think most users enter supplier invoice number in the supplier ref. field.
and usually supplier sent statement only include the invoice number,
for easier checking, It's good to include supplier ref in the Supplier Balances report (rep201.php)
If you know php, you can change the reporting/rep201.php in ver 2.4.8 is on line number 192
change $trans['reference'] to $trans['supp_reference']
while ($trans=db_fetch($res))
{
if ($no_zeros && floatcmp(abs($trans['TotalAmount']), $trans['Allocated']) == 0) continue;
$rep->NewLine(1, 2);
$rep->TextCol(0, 1, $systypes_array[$trans['type']]);
39 08/18/2020 02:24:27 am
Re: How to setup FA for an existing business. (5 replies, posted in Setup)
Instalment sales is a complicated program, current no such extension available.
you may need to ask for customize this extension.
We enter customer name and address in customer maintenance main form only,
maybe I not understand your question.
40 08/16/2020 01:44:01 pm
Re: How to setup FA for an existing business. (5 replies, posted in Setup)
You need to close the existing account and the balance sheet will be the opening balance in new FA accounting system.
you can refer to:
https://frontaccounting.com/fawiki/index.php?n=Main.OpeningBalances
or my YouTube Video, How to enter Opening Balances in FA:
https://youtu.be/Ka563SskUrg
41 08/14/2020 02:04:12 am
Re: Stock Item Quantity Total (4 replies, posted in Reporting)
For total or grand total of quantity, you can change the Destination to Excel in report menu and
using sum function to get the total quantity.
42 08/13/2020 09:19:16 am
Re: Stock Item Quantity Total (4 replies, posted in Reporting)
If you want to create your custom stock report you can refer to rep301.php (Inventory Valuation Report)
43 08/13/2020 09:04:27 am
Re: Stock Item Quantity Total (4 replies, posted in Reporting)
Inventory Valuation Report.
Go to Items and Inventory->Inventory Reports->Inventory Valuation Report
44 08/05/2020 02:13:04 pm
Re: Clarification on Fiscal Year and Closing GL Transactions (4 replies, posted in Banking and General Ledger)
Closing GL Transactions is used to lock the transactions to prevent entering new transactons up to specified date.
For example, accountant have done quarterly Tax report, he should close GL transactions to prevent new data that will affect the final tax report.
Closing a fiscal period is on Setup->Fiscal Years.
45 08/01/2020 10:04:36 am
Re: Bank Payment Entry Behaviour (6 replies, posted in Banking and General Ledger)
Hi jcnew, I have created 2 video about creating extension and reports.
hope these can help you.
https://youtu.be/t7znTMFvJvA
https://youtu.be/uj9QVCJQCv4
46 07/28/2020 03:08:10 pm
Re: Supplier Invoice Page possible? (10 replies, posted in Accounts Payable)
if your company manufacture not many different items, maybe you can create specific inventory a/c for each item.
47 07/23/2020 08:38:31 am
Re: Item Description on Item & Inventory (2 replies, posted in Items and Inventory)
Hi, are you asking where is the SQL statement located?
It is in includes/ui/ui_list.inc
48 07/05/2020 02:24:13 am
Re: Retained Earnings and Profit/Loss Year issue (23 replies, posted in Setup)
I think you are referring to Profit & Loss statement.
in manual accounting, you have to enter all debit and credit entries for trial balance, P&L and Balance sheet.
in computerize accounting system, all GL entries are posted from Sales,purchases, Journal entries etc modules,and trial balance, P&L, Balance sheet reports are generated from GL.
Profit and Loss, Balance Sheet report requirement differ from all countries, companies and type of business, so either we output FA report to excel format and modifying from it, or customize the 2 reports.
49 07/04/2020 02:46:51 am
Re: Retained Earnings and Profit/Loss Year issue (23 replies, posted in Setup)
Hi, I am only a FA user, those experts in accounting and FA please correct me if I am wrong.
In computerized accounting system, the Profit & Loss year a/c is mainly for keeping the profit or loss in the fiscal year.
I think what you mentioned P&L account is credit income debit expenses is for manual accounting system.
The COA in FA are template, you have to setup COA according to your country standard and company need.
The Romania COA should be wrong, just follow the FA standard, set Profit and Loss Year Account to Expenses class.
50 07/03/2020 12:20:26 pm
Re: Retained Earnings and Profit/Loss Year issue (23 replies, posted in Setup)
Sorry should be:
if (!is_account_balancesheet(get_post('retained_earnings_act'))
display_error(_("The Retained Earnings Account should be a Balance Account ))
if (is_account_balancesheet(get_post('profit_loss_year_act'))
display_error(_("The profit and loss should not be a Balance Account ))