1 Reply by rafat

(3 replies, posted in Translations)

.../lang/new_language_template/LC_MESSAGES/empty.po has all the translatable strings.

Go to forum: Translations

2 Reply by rafat

(2 replies, posted in Banking and General Ledger)

IMHO the best way to do what @diventi.enterprises needs is to follow the wiki as in
https://frontaccounting.com/fawiki/index.php?n=Main.TaxSystem
Study whats in Using the Tax System. You will find what you looking for with an example.

Go to forum: Banking and General Ledger

3 Reply by rafat

(2 replies, posted in Report Bugs here)

Try Setup>Company Setup and tick Search Customer List and Seach Suppliers List and see if it helps.

Go to forum: Report Bugs here

4 Reply by rafat

(7 replies, posted in Report Bugs here)

https://frontaccounting.com/punbb/viewtopic.php?id=8700

Go to forum: Report Bugs here

5 Reply by rafat

(1 replies, posted in Setup)

I recommend you issue a bug report in Mantis.  This looks like a bug to me.

Go to forum: Setup

6 Reply by rafat

(2 replies, posted in Installation)

@msuhail197
You have already encountered this problem a long time ago as in:
https://frontaccounting.com/punbb/viewtopic.php?id=8220&p=2
How did you resolve it?
Just follow the same route.

Go to forum: Installation

7 Reply by rafat

(2 replies, posted in Setup)

Enable debug and look at the contents of errors.log

Go to forum: Setup

8 Reply by rafat

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

Yes it did. For me it did not make sense as the error was coming from outside the Module and I think it is from the core. If you look at it the insert fields do not tally with what is in the csv file. Here is the error:

10-Nov-2023 01:31:32 Europe/Berlin] <b>DATABASE ERROR :</b> order Cannot be Added<br>error code : 1265<br>error message : Data truncated for column 'prep_amount' at row 1<br>sql that failed was : INSERT INTO 0_sales_orders (order_no, type, debtor_no, trans_type, branch_code, customer_ref, reference, comments, ord_date,
        order_type, ship_via, deliver_to, delivery_address, contact_phone,
        freight_cost, from_stk_loc, delivery_date, payment_terms, total, prep_amount)
        VALUES ('9','0','1', '30','1', '009/2017','auto','','2017-12-20', '1', '1','Donald Easter LLC','N/A', '', '0', 'DEF', '2017-12-20','4','70','')<br><br><br>

And here's the contents of the csv file

customer_id,branch_No,reference,date,payment_id,sales_type_name,dimension_id,dimension2_id,item_code,item_description,quantity,unit,price,discountpercentage,freightcost,delfrom,deldate,delto,deladdress,contactphone,email,custref,shipvia,comments,ex_rate
1,1,009/2017,2017/12/20,4,Retail,,,202,Maintenance,2,Each,35,0,,DEF,2017/12/20,Mr A,1 Abe Street Glasgow G32 FHT,984578545,customer@example.in,,,,
1,1,010/2017,2017/12/21,4,Retail,,,202,Maintenance,2,Each,15,0,,DEF,2017/12/21,Mr A,1 Abe Street Glasgow G32 FHT,984578545,customer@example.in,,,,

Go to forum: Modules/Add-on's

9 Reply by rafat

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

I looked at apmuthu file. It did work for FA 2.4.4 after that I tested at 2.4.8 it did not and nothing after that. Not at 2.4.17. I dont know why. Could not figure it out.

Go to forum: Modules/Add-on's

10 Reply by rafat

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

@poncho1234
Yes the Allow Entry on non closed Fiscal Years is found in Access Setup under Banking and GL configuration.
I will take a look at apmuthu file and revert back here.

Go to forum: Modules/Add-on's

11 Reply by rafat

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

@pstevens
I have to admit its not easy to crack Import Transactions module. But once you link all fields correctly then its a piece of cake and you will be proud of yourself. From experience and maybe you have done this already you have to:

Reference should tally i.e If you want to import 004/2022 then your pattern should be {001}/{YYYY} and you make sure 004/2022 does not exist in the system. Also the system will not accept blank reference. It accepts a space (NULL). All fields in the spreadsheet should also be formatted accordingly..i.e Reference is General and Date is Date with the identical date format...etc..Also make sure the Fiscal Year that you are posting into is active and the Banking and GL Configuration has the Allow entry on non closed Fiscal years ticked.

Hope this will help.

Go to forum: Modules/Add-on's

12 Reply by rafat

(7 replies, posted in Report Bugs here)

Create a 2023 fiscal year and try again. No need for it to be the current. Try with active and not active 2023.
Good luck.

Go to forum: Report Bugs here

13 Reply by rafat

(7 replies, posted in Report Bugs here)

@yubrajkafle99

You need to describe in details what you did to reach this stage. The error clearly mentions a problem in fiscal years for the date entered. So please list your fiscal years opened/closed and your current fiscal year. and to what date you are changing the transaction date.

Go to forum: Report Bugs here

14 Reply by rafat

(2 replies, posted in Setup)

Just enter 1001/23 manually in the reference field.  The next quote will automatically be 1002/23.

Go to forum: Setup

15 Reply by rafat

(7 replies, posted in Wish List)

Thanks @joe for all of your efforts.

Go to forum: Wish List

16 Reply by rafat

(7 replies, posted in Wish List)

@joe,

I think the one who asked this wants to search for invoices by Reference No. He does not want to go thru a list of invoices looking for that specific one. Especially when this list is too big.

Go to forum: Wish List

17 Reply by rafat

(7 replies, posted in Wish List)

Banking and General Ledger
Journal Inquiry
Reference ->enter invoice ref here
Type -> Sales Invoice
Make sure its within the dates or extend the From to a much longer period.
Search

You are right btw. We have Sales Order and Quotation Inquiry but not Sales Invoice. I don't know know why.

This might help.

Go to forum: Wish List

18 Reply by rafat

(4 replies, posted in Accounts Receivable)

To me this looks like a non standard FA code. @kvvaradha might be able to help you here.

Go to forum: Accounts Receivable

19 Reply by rafat

(4 replies, posted in Accounts Receivable)

Look at the logs and see if any errors.
Does print from the Reports page?

Go to forum: Accounts Receivable

20 Reply by rafat

(10 replies, posted in Accounts Payable)

Try false instead of _false (remove the underscore).
Depending on your PHP version this could be the problem.

Go to forum: Accounts Payable

21 Reply by rafat

(10 replies, posted in Accounts Payable)

You have a ' that needs to be removed. Paste line 483 here if you face troubles.
Also state your FA version and other environment parameters.

Go to forum: Accounts Payable

22 Reply by rafat

(10 replies, posted in Accounts Payable)

@Marc
It is possible to do what you asked but you need to change the core a little bit.
in .../purchasing/po_entry_items.php around line 485 remove _('Delayed') so its like this:

 if ($_SESSION['PO']->trans_type == ST_SUPPINVOICE) {
    cash_accounts_list_row(_("Payment:"), 'cash_account', null, false,);
}

This will give you the list of your cash accounts with the default the first one in alphabetical order if you have more than one.
Beware the debit of the account is immediate and there is no need to go to Supplier Payment screen to pay your Suppliers.

Test it first and then use it if it serves your need.

Go to forum: Accounts Payable

23 Reply by rafat

(12 replies, posted in Banking and General Ledger)

I understand your concern regarding the procedure. It would be nice to have the installation process to prompt the installer for their current fiscal year. This way its easy to start working immediately instead of meddling around fiscal years. Anyway the wiki also suggests an easy and direct way as below:

Tips and Tricks
In a newly setup company, we can change the fiscal year in the table X_fiscal_year where X is the company index number in the array $db_connections in the config_db.php. This can be done using any MySQL client like phpMyAdmin, SQLyog, etc.,.

As for your second concern about Bank Statement I did not exactly understand your question. Can you explain.

Go to forum: Banking and General Ledger

24 Reply by rafat

(12 replies, posted in Banking and General Ledger)

https://frontaccounting.com/fawiki/index.php?n=Help.FiscalYears
Will guide you exactly how to do it.

Go to forum: Banking and General Ledger

25 Reply by rafat

(2 replies, posted in Accounts Receivable)

You might want to take a look at Prepaid Orders. Try to experiment with it and you might find what you need.

Go to forum: Accounts Receivable