26

(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.

27

(4 replies, posted in Accounts Receivable)

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

28

(4 replies, posted in Accounts Receivable)

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

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

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.

@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.

32

(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.

33

(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.

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

Download and install from the below link

https://frontaccounting.com/wbt/pages/download/downloads-for-release-2.3fonts.php

36

(1 replies, posted in Accounts Receivable)

Please list your Setup->Transaction References

37

(3 replies, posted in Report Bugs here)

@sulheen,

Your (Egyptian Arabic) ar_EG.utf-8 locale is not installed on your Linux system. You need to install it.
We will take it from there if still Arabic is not showing..but I see some (not all)  Arabic strings are translated already which shows your Arabic Translation files (.po and .mo) do not contain the proper Translation. Better if u list your ../lang/installed_languages.inc

You need to find the tax_group_id for the exempt customer. This can be done by browsing the database (with phpmyadmin for example) and displaying the content of (x_cust_branch) of the exempt customer. There you will find the tax_group_id that you will need to use in the above code. As I said mine is 2. Yours could be the same or different,

Note: You can also find the group_id from x_tax_groups table in the database.


Good luck.

Its not the same code. tax_included == 0  is not the same as Tax Exempt.

@msuhail197

I am not a php programmer at all. I can barely make sense of the code. Below is my only assessment of what could be done. Please dont take it for granted as it could all be wrong. One thing of caution here is
'tax_group_id' for exempt customers is unique to every installation. in my case its 2. In your case it could be different.

Insert after line 165 in rep111.php

if ($myrow['tax_group_id'] == 2) {
        $rep->TextCol(3, 6, _("TOTAL ORDER"), - 2);
        $rep->TextCol(6, 7,    $DisplayTotal, -2);
        $rep->NewLine();
        continue;
        } 

Please test on a test environment and advise result.

@msuhail197

This needs modifications to rep111 which is beyond my scope. Hope someone can help with this. I agree the narrative is confusing and there is no need for it if the customer is exempt.

Better if you have an example. If truly your customer is Tax Exempt in the system then these should not appear on the quote.
Try Setup->Company Setup->Put alternative Tax Include on Docs    (unticked)
It might help you.

@moiz74,
This is a very difficult thing to crack if you don't have full access to the server.

I recommend :

https://www.howtogeek.com/357785/what-is-a-403-forbidden-error-and-how-can-i-fix-it/

Good luck.

If you want to use 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 relevant 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.
If you still facing problems try debug on and look to see if any errors.

You seem to have done all OK. The only thing you need to make sure is the Reference
(must match pattern in Setup->Transaction References). You should be flying then.

Sorry..I meant to clear the cache. Which is to remove the files in company/x/js _cache/x/*.js
Logoff and login again. You also might have folder permission problems. Review permissions as in

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

My last thoughts is to clear company/x/js _cache/x/*.js
This should not be a live system though.
where x is the company number.

Try a different browser and see if it works.

Preferences->Use Date Picker
update

Setup->Company Setup->Suppress Tax Rates on Docs (ticked).