3,301

(8 replies, posted in Modules Add-on's)

I have sent you the package by email. The repository is not updated yet.

/Joe

3,302

(4 replies, posted in Installation)

Depending on if you selected demo data, the file is /sql/en_US-demo.sql, otherwise, en_US-new.sql.

/Joe

3,303

(4 replies, posted in Installation)

I guess you are using a new MySQL database version. Open the SQL script in a text editor and replace 'TYPE=' with 'ENGINE='

MySql is no longer backwards compatible in newer versions.

/Joe

The back link in various windows should be translated.

/Joe

No these are special kind of characters for a new line, new page and tab. You should just use the same characters, i.e. \n

/Joe

3,306

(1 replies, posted in Reporting)

You can set the default $fontsize = 9 to another value (take care of the column margins) in the constructor function FrontReport in file /reporting/includes/pdf_report.inc.

/Joe

3,307

(2 replies, posted in Accounts Payable)

Please check that you don't have the checkbox marked in Company Setup, Search Supplier List. In that case you see no suppliers but have to search for them (with space bar and fragments).

/Joe

Please make a forum search about this. This has been handled in several places. Search on Open balance or something like that.
Also look in the https://frontaccounting.com/fawiki

/Joe

Please try for yourself on the Training Co.
It is ok with back date and invoices can be edited in certain situations. You will see in Customer Transactions which invoices are editable.

/Joe

3,310

(4 replies, posted in Modules Add-on's)

Hi Dennis,

Thanks for your contributions. However there are some issues with the module.

1. In the hooks.php the link should be $path_to_root . "/modules/requisition_details.php"
2. In the /sql/update.sql file, the IF EXISTS after DROP FUNCTION should be there.
3. In the /sql/update.sql file, the table prefix should be for function get_item_tax
4. In the /sql/update.sql file, the reference in 0_generate_po to get_item_tax should have a table prefix.

Could you describe how to use this module, because I couldn't get it to work. I first entered a requisition and then moved to Requisition Allocation and added a new. When Generating PO nothing happened.

Anyhow the module looks promissing, but please tell us a little about what and how this module operates.

/Joe

We have an estimate of one week or so.

/Joe

You are right. This test should never be done on WIN OS. This will be fixed in 2.3.3.

/Joe

3,313

(3 replies, posted in Manufactoring)

I cannot reproduce this error in 2.3.2. Which version of MySQL are you using?

/Joe

3,314

(3 replies, posted in Setup)

I cannot reproduce this error in 2.3.2. Which version of MySQL are you using?

/Joe

3,315

(1 replies, posted in Reporting)

There are no plans for having the debtor transactions to be by Branches.

/Joe

In some cases FA will print both an CN and SI. This is the way we have developed it. And the reason for having descend sorting is that you often want to print the latest ones.

/Joe

3,317

(1 replies, posted in Dimensions)

The option for dimension on Items is only for they who has specific need to track items on certain dimension. You don't need this and leave them empty.

/Joe

I have sent you a newer file by private email. Please try again.

/Joe

3,319

(1 replies, posted in Modules Add-on's)

The module you have downloaded is for an earlier release.
From release 2.3.0 you should be able to install it from our central repository instead.
First remove the old installation and then install from the central repository.

/Joe

I cannot reproduce this. If you change the payment terms it should give you the right due date when saving.

/Joe

This topic has been duplicated. It was also in the bug forum. See the comments there.

/Joe

This is NOT a bug. It really shouldn't be needed to extend the Location id. You always see the description so you could probably use the description field to do this instead.

/Joe

No, but you can use one of the COAs from the repository (in setup tab) as a template and when you are satisfied you can do a backup and download the sql script and use this as your COA.

You cannot delete products with stock movements, but you can inactivate the item.

/Joe

3,325

(2 replies, posted in Dimensions)

You shoould create 7 different dimensions (of type 1, you don't need type 2) for your branches.

Everytime you deliver/invoice your customer, remember to select the dimension for the invoice.
The delivery phase will handle the purchase and the invoice phase will handle the sales.
You can try this on the Training Company and look at the GL trans for the delivery and the invoice.

If you have other expenses from Bank Payments, just put the dimension on the line here.

Finally you will have a very good fascility for reports by dimension.

/Joe