151 Reply by rafat

(20 replies, posted in Banking and General Ledger)

See Warning:
Try this and use with your own discretion.
Close the year and reopen it again. You should be able to void the TXN.
Warning: Two GL Accounts are affected when one closes a fiscal year 3590-Retained Earnings and 9990-Profit/Loss
You might need to void these two automatically updated GL transactions when you close the fiscal year.
Try it with a staging system before the live system.

Go to forum: Banking and General Ledger

152 Reply by rafat

(4 replies, posted in Banking and General Ledger)

Hi @said.omn

The wiki clearly recommends that you have a third account called Accrued Tax (or similar) in order to consolidate  your taxes.
So basically at the end of your tax period you need to zero your tax accounts by counter booking them in the accrued account and then you pay or deposit from the Accrued Account.  To make it simple I used your two accounts and I created a third account (2190 Accrued Tax). I used your figures to demonstrate how I would do it.

Take a look at the attached file.

Regards..

Go to forum: Banking and General Ledger

153 Reply by rafat

(4 replies, posted in Banking and General Ledger)

Hi,

https://www.frontaccounting.com/fawiki/index.php?n=Main.TaxSystem

Under Using the Tax System

It has very helpful info on how to book these figures.

Go to forum: Banking and General Ledger

154 Reply by rafat

(11 replies, posted in Report Bugs here)

Also attached GL Setup Screen.

Go to forum: Report Bugs here

155 Reply by rafat

(11 replies, posted in Report Bugs here)

I run 2.4.11 as attached.

Go to forum: Report Bugs here

156 Reply by rafat

(11 replies, posted in Report Bugs here)

Works well for me.. See attached.

Go to forum: Report Bugs here

157 Reply by rafat

(9 replies, posted in Setup)

Just google
"FrontAccounting 2.4.x - Login"
Where x is 0 to 11 (FA release)
You will get some of the companies using FA.

Go to forum: Setup

158 Reply by rafat

(11 replies, posted in Report Bugs here)

One thing :

1. The Delivery Required by should be more than 1 day.


Then you should be able to edit the Quote.

Setup->System and GL Setup has the two parameters Quote Valid Days and Delivery Required by. Take a look at them.

(Sorry I edited my response too many times, Some of the initial responses were wrong).

Go to forum: Report Bugs here

159 Reply by rafat

(11 replies, posted in Setup)

https://frontaccounting.com/punbb/viewtopic.php?id=8166
Lists the right steps.

One last thing before you venture into this. Are you 100% sure that Contacts Categories you listed above are active?

/rafat

Go to forum: Setup

160 Reply by rafat

(11 replies, posted in Setup)

Sorry @hassii but I dont have a clue then. Not sure if someone else has faced this before ..but of course your FA version is too old.

Good luck..

Go to forum: Setup

161 Reply by rafat

(11 replies, posted in Setup)

Does:

Setup->Contact Categories

Show anything?

If nothing is shown tick Show also inactive at the bottom left to see if the categories are inactivated.

Tell us what you see.

You might need to mention your working environment..i.e FA version and OS ..etc..

Go to forum: Setup

162 Reply by rafat

(10 replies, posted in Report Bugs here)

Yes sir @joe. Its working as expected. Thanks for your efforts.

Go to forum: Report Bugs here

163 Reply by rafat

(10 replies, posted in Report Bugs here)

One last thing @Joe and hopefully we will be out of the woods:
The tax within the QE in the Supplier Invoice (GL Items for this invoice) is accounted for in the report but in in the Inquiry.
So either we remove from Report or add to Inquiry. (I prefer add to Inquiry)...It depends of course on the requirement of different users.

Go to forum: Report Bugs here

164 Reply by rafat

(10 replies, posted in Report Bugs here)

@Joe

The Tax report now shows Tax on Bank Payments, Customer Credit Notes ...etc. I believe this should not be the case because now the Inquiry and the Report don't tally. Of course I prefer these to be included but then both the Inquiry and Report should be the same.

I think we should stick to the previous version of rep709 if we are not introducing Tax on Bank Payments ..etc...

Go to forum: Report Bugs here

165 Reply by rafat

(5 replies, posted in Banking and General Ledger)

After you Direct Invoice the $10 then Receive the $50 ...Go
Banking and General Ledger ->Journal Entry

Journal Date    Account Code    Account Name                                Debit           Credit      Memo
01/11/2021    1060    Checking Account                                      50.00       
01/11/2021    1200 00001    Accounts Receivables: Donald Easter             10.00   
01/11/2021    2100 00001    Accounts Payable: Dino Saurius                     40.00   
                                                                                   Total          50.00            50.00

You then can go to Customer Payments and allocate the $10.
Then go to Payments to Suppliers and allocate the $40.

Go to forum: Banking and General Ledger

166 Reply by rafat

(10 replies, posted in Report Bugs here)

This might be a stupid question. But are you sure you are running 2.4.10?
I tell you why.. I am running 2.4.4 and 2.4.10 on the same database. The problem only shows on 2.4.4 and not 2.4.10.

Go to forum: Report Bugs here

167 Reply by rafat

(12 replies, posted in Setup)

May I ask what software the front server is using and if it is chargeable.?

Go to forum: Setup

168 Reply by rafat

(5 replies, posted in Report Bugs here)

Thanks @kvvaradha

You meant

open the rep109.php and find this line

$rep = new FrontReport("", "", user_pagesize(), 9, $orientation);

and replace with a title like this

$rep = new FrontReport(_('SALES ORDER'), "SalesOrderBulk", user_pagesize(), 9, $orientation);

and it will work for you.

@joe consider updating the FrontReport Headers same for email and non email headers

Go to forum: Report Bugs here

169 Reply by rafat

(5 replies, posted in Report Bugs here)

Hi @kvvaradha
Any suggestion on how to repair this?

Go to forum: Report Bugs here

170 Topic by rafat

(5 replies, posted in Report Bugs here)

I am not sure if this is a bug but would like to know why this looks the way it is. Rep109 works perfectly though.
But in FA2.4.10

Setup->Print profiles

Produces ???1) in the description field against Report Id 109.
Whereas ???1) means  - no title was found in this report definition file.

Can someone explain why this is the case? I went thru rep109 code but could not find the problem.

Note: I copied rep109 from 2.4.8 and the display is as expected (SALES ORDERS)

Please see attached screen shot from fa2.4.10.

Go to forum: Report Bugs here

171 Reply by rafat

(9 replies, posted in Report Bugs here)

Hi, I decided to help out so I set up the following environment.
FA2.4.10
Linux Mint 19
MySql 5.7
Php 7.2
Apache 2.4
Postfix 3.3.0

I also setup Mail Relay thru gmail SMTP [smtp.gmail.com]:587

1. With no change to Code:

Setup Company name Tegusad Õpilased & Tudengid
Created Invoice to Customer Donlad Easter
Emaild the invoice. to user@example.com

Finding:

Mail is sent and received.
In the company Name the & is displayed as &(Tegusad Õpilased & Tudengid)
The from field is displayed as Tegusad@zkbts, Õpilased@zkbts, &amp@zkbts, Tudengid <>

2. With no change to code but user is user<user@example.com>

Mail is not sent. Error in postfix log (bad address syntax). the < and > are translated into <user&lt;user@example.com&gt;>

3. With changes incorporated as in peacecop suggestions and user is user@example.com

Mail is sent and received, The Subject header (Invoice 17 from Tegusad Õpilased &amp; Tudengid) still show &amp; in all other places its correctly &.

4. With changes incorporated as in peacecop suggestions and user is user<user@example.com>

Mail is not sent. <user@example.com>> (bad address syntax) Extra > in the address.

Go to forum: Report Bugs here

172 Reply by rafat

(6 replies, posted in Setup)

In ../config_db
$tb_pref_counter = 1;

Go to forum: Setup

173 Reply by rafat

(16 replies, posted in Announcements)

Unless I misunderstood the question.
But Sorry guys.. one can attach files, screenshots and code. The forum is full of such attachments. The only restriction is you need to be a senior member to do that. Its easily achievable by posting more than 50 posts and then automatically one is a senior member and can use attachments.

Go to forum: Announcements

174 Reply by rafat

(7 replies, posted in Report Bugs here)

@cedricktshiyoyo,
I think the developers are looking at experienced programmers like you to suggest a solution, This is what open source is all about. A community collaboration. So if you think you have a solution then suggest it. If they see it feasible they will include it. Also Fixed Assets is an optional module and the usage is not as much as Sales or Purchase..Its normal to have more focus on widely used modules. I don't see any bias between any of FA modules.

Go to forum: Report Bugs here

175 Reply by rafat

(11 replies, posted in Installation)

Strange the restore of the backup did not resolve the issue..unless the backup also contains the corrupted data..then you are restoring what is already corrupted. Anyway "DROP TABLE IF EXISTS" is important to have and it is inserted by the FA backup routines.. I guess you are exporting via phpmyadmin or mysql command line which does not have the DROP command.

Now I am concerned even if you reinstall xampp and restored the bad backup then you will end up in the same situation as before. You might want to try and restore an older backup to start with ..just to eliminate the chance that the one your are working with is not the problem.

If you do XAMPP fresh install you can import the DB from your exported data without the DROP command , but that should be to an empty DB.

Go to forum: Installation