1,026 Reply by joe

(23 replies, posted in Report Bugs here)

Hello boxygen,

There is a flag in config.php, called $use_costed_values that is set to 0 by default. In that case the standard cost set in the stock_master table (the last average standard cost) is used all over the period. This is only used in rep301.php

If this flag is set to 1, it will use the costed values all over the period, and the total will be the same as in the Costed Inventory Movements.

The reason for setting this variable $use_costed_values to 0 (default) is that this also can cope with manual changes in the standard costs.

I guess we use the same algorithms for Costed Values in both rep 301 and 308. Right?

/Joe

Go to forum: Report Bugs here

1,027 Reply by joe

(23 replies, posted in Report Bugs here)

Yes, I have been looking into this also tonight and think you are right. What you mean is to  use to the stock_moves standard_cost instead of calcutating from the purchase price, right?

I guess your idea is better. The question is if we should change rep301 too in accordance to this. What do you think?

I have changed the copyright to FrontAccounting LLC and inserted your name as the creator. I have also optimized the report.

Please rename the file to extension php.

Can I commit this report and also in 2.4?

/Joe

Go to forum: Report Bugs here

1,028 Reply by joe

(23 replies, posted in Report Bugs here)

The change in currency rates can change the value of the stock so that the value at the end is not the same as in the General Ledger.

To compensate for this you may enter a Journal Voucher.

This report gives you a more adequate value than the report on the average standard costs over time.

/Joe

Go to forum: Report Bugs here

1,029 Reply by joe

(23 replies, posted in Report Bugs here)

The report is in the file /reporting/rep308.php.

You see the algorithms here. Can you advise me how you would implement this report in detail. As I told I didn't create this report. So I would appreciate if you will help.

Joe

Go to forum: Report Bugs here

1,030 Reply by joe

(13 replies, posted in Report Bugs here)

Hello again Alaa,

In the file
/reporting/includes/class.graphics.inc

I have increased the font size with 2 pixels. And the space between works has been replaced by two spaces .

Was the font too big or is it ok? And was the space between words better now.

The php GD library doesn't support RTL languages, so we had to fix the strings to do so, but we could not change the graphics itself.

I guess this is the best we can do for now. Maybe there are some skilled developers that can help us in the future. This can always be worked on between releases. It doesn't require any database update.

Please replace the file /reporting/includes/class.graphics.inc with this one.

/Joe

Go to forum: Report Bugs here

1,031 Reply by joe

(13 replies, posted in Report Bugs here)

Hello Alaa,

I see you are using the Arabic language and this is good test for me.

A couple of years ago I helped another guy with Arabic language to get a suitable font to be used in the Graphics.
We found some, but I had to fix the leadings and other things with the fonts. I did that and we got some usable fonts.

In the config.php file, there is a variable called
    $UTF8_fontfile    = "FreeSans.ttf";
This fontfile doesn't work with the Arabic language. I have listed some utf8 fonts that can be used with the Arabic language.

Will you help and test them and give me a high five (1 - 5) character of the usability of the fonts?

Remember to spell the font names exactly. The smaller the file is the better, but it should be usable of course.

I will then incorporate one of the fonts in the default package, and change the variable in the config.default.php.

/Joe

Go to forum: Report Bugs here

1,032 Reply by joe

(23 replies, posted in Report Bugs here)

Hello again,

I didn't create this report. So I had to go into the source code.

As I can see, the rate is based on
1. Initial values is based on the rate on the beginning date.
2. Incoming values are based on the average rate during the period.
3. The same for outgoing values.
4. The end values are based on the average values for the whole period.

The guy who wrote this report are not reachable at present.

Can you use some of the other reports if this is not adequate.

Joe

Go to forum: Report Bugs here

1,033 Reply by joe

(12 replies, posted in Reporting)

Please use this link for customer balance.

https://sourceforge.net/p/frontaccounting/git/ci/unstable/tree/reporting/rep101.php

Abd this link for supplier balance

https://sourceforge.net/p/frontaccounting/git/ci/unstable/tree/reporting/rep201.php

Please be aware that these links are for 2.4

Joe

Go to forum: Reporting

1,034 Reply by joe

(23 replies, posted in Report Bugs here)

Ah, I see. 2.3. Will have a look into this.

Joe

Go to forum: Report Bugs here

1,035 Reply by joe

(23 replies, posted in Report Bugs here)

Are you referring to 2.3 or 2.4 or maybe both?

Joe

Go to forum: Report Bugs here

1,036 Reply by joe

(12 replies, posted in Reporting)

This has now been fixed in both the 2.3 stable repo as well as the 2.4 unstable repo.

In the allocated columns a correct - sign is shown for credit allocations and the summations are now also correctly done.

/Joe

Go to forum: Reporting

1,037 Reply by joe

(12 replies, posted in Reporting)

The allocated column should only be seen isolated for each record.
The mistake here is, that the column has been totalized. This should not have been done. Or it should show a minus sign for payments so the totalisation would be correctly presented.

Will fix this.

Joe

Go to forum: Reporting

1,038 Reply by joe

(2 replies, posted in Accounts Receivable)

No this is not a duplicate code. This is an outgoing and an ingoing stamp with writeoff reference. These 2 transactions is not seen in the stock movements transactions.

So you will not see anything in the stock movements. Only when looking into the database.

This has been changed slightly in 2.4.

Due to no sideeffects in 2.3 as it is now, we will not change anything here.

/Joe

Go to forum: Accounts Receivable

1,039 Reply by joe

(9 replies, posted in Announcements)

@infotechaccountant

Glad to hear that you are back. I guess that you was the father of a chart of account based on the IFRS standard.

We are about to release a final 2.3 release and shipping the new 2.4.0 release.

We are just fixing some bugs that have arisen during the release candidate period.

Great to do some creative work with you.

/Joe

Go to forum: Announcements

1,040 Reply by joe

(5 replies, posted in Reporting)

This is not straight possible, because the CompanyLogoEnable can only be set for custom reports, where the headertype is set to header3. The report headers other fields are different too.

Of course it is possible to use this in the standard headertype 'header1' as well. You will have to change the /reporting/includes/pdf_report.inc file in the header1 memberfunction. You can look in header3 memberfunction how this is handled.

Joe

Go to forum: Reporting

1,041 Reply by joe

(20 replies, posted in Report Bugs here)

I have talked with Janusz and he claims that this bug has already been fixed.
And this is correct. Look into the sql in the committed rep709 and you will see the correction.

Joe

Go to forum: Report Bugs here

1,042 Reply by joe

(4 replies, posted in Reporting)

Dimensions should be ok.

Joe

Go to forum: Reporting

1,043 Reply by joe

(4 replies, posted in Setup)

You should use dimensions for this. Please read in the wiki how dimensions work.

Joe

Go to forum: Setup

1,044 Reply by joe

(1 replies, posted in Accounts Receivable)

Check to see if you have enabled 'Search Customer List' in Company Setup. Uncheck it and you should be able to see the customers. How to use the 'Search Customer List' can be found in the Fawiki.

/Joe

Go to forum: Accounts Receivable

1,045 Reply by joe

(6 replies, posted in Report Bugs here)

Hello,

I will ask Janusz to look into this asap.
@apmuthu.
Just put this into the list of items for 2.4 release. Ev. backport to 2.3 if needed.

/Joe

Go to forum: Report Bugs here

1,046 Reply by joe

(2 replies, posted in Accounts Receivable)

Please use English language in these Forums.

Joe

Go to forum: Accounts Receivable

1,047 Reply by joe

(4 replies, posted in Setup)

You are welcome, @davidkumi. Glad that we solved the issue smile

/Joe

Go to forum: Setup

1,048 Reply by joe

(4 replies, posted in Setup)

Use dimensions for the branches. It will work fine for you.

Joe

Go to forum: Setup

1,049 Reply by joe

(2 replies, posted in Report Bugs here)

All fixed in repository. Both 2.3 and 2.4.

/Joe

Go to forum: Report Bugs here

1,050 Reply by joe

(2 replies, posted in Report Bugs here)

There is also an instance in includes/main.inc on line 421 in 2.4.

I will fix this asap.

/Joe

Go to forum: Report Bugs here