4,451

(4 replies, posted in Reporting)

Thanks. If you use the Letter format, you can change the pagewidth and pageheight in the file /reporting/includes/pdf_report.inc on line 93 and 94.

You change the dpcument forms in the file /reporting/includes/header2.inc. This file creates the form.

Unfortunately we don't have the resources to help you, but maybe some from the community can help you.

Best regards

/Joe

4,452

(7 replies, posted in Report Bugs here)

Hello again. A minor error during upload of image together with new item insertation. (empty file .jpg). Fixed now with a rerun to the CVS repository main. Also fixed so the image ratio is shown better.

/Joe

4,453

(7 replies, posted in Report Bugs here)

Hello,
I guess you mean 2.1. The bugs are here too. Fixed bugs in 2.1 will later be merged into 2.2.
I will fix this. Wait a while for CVS Main update. File /inventory/manage/items.php

/Joe

4,454

(1 replies, posted in Accounts Payable)

Yes you are right. Also problem in 2.1 final. CVS MAIN repository updated. Affected file /purchasing/manage/suppliers.php

Thanks.

/Joe

In the file, installed_lanugages.php, there is a new variable, $dflt_lang='en_GB'. If you use your old installed_languages.php this variable is missing.
Login as super admin. Go into Setup, Install/Update Languages. Select your language and select 'Default Language'. Save and the warning should disappear.

/Joe

You cannot delete an account as long as there are transactions on it.
In the next release of FA, you can mark the account as inactive, and this way you will never see this account when the select box shows the accounts.
If the account opening balance is zero and there are no period transactions it will never show up on reports (balance sheetand PL statements).

/Joe

4,457

(4 replies, posted in FA Modifications)

Okay, Tu, you got your wishes. CVS updated. Affected file /includes/banking.inc. If you use release 2.0.7, you can copy the lines inside the function exchange_variances.

/Joe

4,458

(4 replies, posted in FA Modifications)

Ok, after looking at this, it is possible to put the variance JE on the invoice JE instead of the payment JE if the payment is done before the invoice date. I will try to change that in 2.1.0 RC.

/Joe

4,459

(4 replies, posted in FA Modifications)

Tu, you have paid (in advance) for the inventory and you have an invoice date at a later time. Even if this is a backward operation, FA handles it correctly. It is always the payment date that creates the variances, so in these cases you should wait with the closure of the fisscal year until these operations are gone. It is just that you can't calculate the variances before you have the supplier invoice.
So in my opinion everything is handled correctly.

/Joe

When the PO is received (GRN), the stock is updated with stock purchase prices. When the supplier invoice is received the prices are regulated and the JE entry is made into stock and AP. When the delivery is done the stock is credited and purchase is debited. If there are deliveries during the time between GRN and supplier invoice and there are differences in price, the delivery JE are adjusted. Every detail is taken care of, even currency variances.
So while you have traffice over two fiscal years, you should wait with the closing of the former year until done.

/Joe

4,461

(3 replies, posted in Installation)

Hello,
It comes from the language po file in /lang/xx_YY/LC_MESSAGES/xx_YY.po.
This language file has it's text extracted from the source code.
The language en_GB should be default, and fi the en_US.po have som texts translated, but the texts in the source might have a bad translation, because it is called VAT in Britain, right?

/Joe

The bug is now fixed and the CVS repository is updated. Affected files:
/gl/includes/ui/gl_bank_ui.inc
/gl/includes/ui/gl_journal_ui.inc
/includes/ui/items_cart.inc

Thanks for finding this bug.

/Joe

No, you detected a bug in 2.1.0RC. We will look into it.

/Joe

Not a bad ides. Would be a 2.2 issue.

/Jow

FA is a fully automatic system. The Journal Entries are created automatically. So you should not worry about that. Just make sure that your setup is done correctly.

/Joe

There will be no database change during the 2.1.X releases. Only bugfixes.

/Joe

4,467

(20 replies, posted in Setup)

Hello again,
Now this is fixed. The CVS repository is updated. Only one file affected. /gl/includes/db/gl_db_banking.inc

Thanks again MozMan

/Joe

4,468

(20 replies, posted in Setup)

Oops!

Thank you so much for finding this bug. We did some change in the Bank Account and transaction tables to release 2.1.0, and this bug slipped through.
I will be back when the CVS repository is updated.

/Joe

4,469

(3 replies, posted in Accounts Receivable)

In release 1.16 you will have to set the user item decimals in the display setup in Setup tab. This will be for all units.

/Joe

There is already a table, X_purch_data, in the database. This table contains all the information regarding the suppliers data, so this should be very simple to implement. Today these entries are updated every time GRNs and Supplier Invoices are entered.
In the beginning, however, the items have to inserted in some way with the whole list of items. But with a flag in setup, you might be able to select that you only want the supplier's items.
So, yes, this is a candidate for 2.2.

4,471

(3 replies, posted in Accounts Receivable)

Hi,

It is quite easy. Go into tab Items and Inventory. Select Units of Measure. Change the decimals to 1 for the item unit you are using on the item. That's it.

/Joe

4,472

(4 replies, posted in Items and Inventory)

Are you referring to release 2.0.X or 2.1.0 beta 2?
You can enter up to 20 characters in the stock id field, so this should be ok. I guess others have used this approach too.
I cannot tell you why nothing shows up. Haven't heard of any problems here.
You can temporary set the $go_debug flag in config.php to 1 to try to catch some errors or warnings.

/Joe

4,473

(5 replies, posted in Items and Inventory)

Hello,
This is the type relating to systypes. You can see the types in file /includes/types.inc

/Joe

Hello and thanks.
The trans_no is an auto_incremented value for the debtor_trans table. This auto_incremental value, that should get you the next number, is probably set wrong in the table.
You can fix that in phpMyAdmin.
If you by trans_no = 5 mean, that the next reference number is 5, then you can move the next reference number in Setup tab, form setup.

4,475

(6 replies, posted in Wish List)

Personly, I don't like the PEAR approach. I have been looking at a SF project called Excel Writer (XML) for PHP.
This is was they claim:

Set of classes for PHP that allow Excel XML files to be generated dynamically. Nearly a full implementation of the MS XML architecture. Requires PHP 5+ Does not require any XML libraries

It is very small and elegant. It is written in PHP 5.0 but as it is very small it is easy to fix so it runs in both 4 and 5.
It creates XML files, which of course is a good thing, especially for the XBRML standard. A standard for Accounting applications. This implementation is also for the future.
And it is easy to later create a class like pdf_report.inc, where similar routines are created. Then we only have to switch to the right include pdf_report or excel_report.
This is what I think we should do.
I will do some further research on this one. Please have a look and comment on this.

/Joe