Search options (Page 2 of 22)

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.

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

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.

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:

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

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

Please list your Setup->Transaction References

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.

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

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.

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.

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