3,226

(10 replies, posted in Setup)

There seems to be a missing table in your sql script. 0_sys_types.

Please try a new installation.

/Joe

To nofear. Yes you are right. We are investigating this.

To ericta. If this is the same problem as nofear, then there is a problem. Your data should still be there however. We are investigating.

/Joe

When removing GRNs from the Supplier Invoice, everything is taking care of.

/Joe

3,229

(3 replies, posted in Accounts Payable)

Just do this:

Go into Supplier Invoice entry (the right part of the Suppliers Tab). Choose the Supplier. You will see wchich items you want to remove. Remember to be logged in as an administrator. Remove the lines you want to delete. That's it.

/Joe

The sales quotation doesn't print tax info, but Sales Orders do.

/Joe

The COGS for inventory items is first activaded on deliveries.

/Joe

The rules follows the company. You must go into Access Level Setup in Setup tab and activate it.

/Joe

To handle FIFO we need an extra field in stock_moves indicating how many of the items have been checked out/in.
If you have any other suggestions for this please advice here or in the developers mailing list.
Maybe we can find out something to the next major release, 2.4.

/Joe

3,234

(4 replies, posted in Items and Inventory)

We are investigating this.

/Joe

Try to empty the browser cache and/or logout/login again to start a fresh session.

/Joe

3,236

(2 replies, posted in Reporting)

The document layouts can be changed in /reporting/includes/header2.inc

/Joe

Hello Albert,

I think I know why this happened. When you made your merge and copied it to language folder, it was overwritten by the install/Update Language. The files were taken from the central repository during update.

Hopefully you still have your translated files. Just copy them to the language folder again, and DON'T do an update from the repository.

/Joe
Please share the translated files with us so we can update the repository smile

3,238

(7 replies, posted in Report Bugs here)

This bug has been fixed. Two affected files: /purchasing/includes/db/grn_db.inc and /purchasing/includes/db/invoice_db.inc.

The files can be downloaded at Mantis, http://mantis.frontaccounting.com, bug report [0000714].

/Joe

3,239

(7 replies, posted in Report Bugs here)

Yes, there are something strange here. I will have a look.

/Joe

3,240

(5 replies, posted in Installation)

Go into Company Setup in Setup tab. Uncheck the 'Search Customer List'. If this is checked, you can search customers by using the space character on the keyboard when you are in the customer list field.

/Joe

3,241

(5 replies, posted in Installation)

You can start by looking at the Training Co., if you installed such a one.

You can also do the following changes in config.php to get help from our central wiki. About line 101.

    // $help_base_url = 'https://frontaccounting.com/fawiki/index.php?n=Help.';
    //     not used
    $help_base_url = null;

You simply uncomment line 101 (take away the // in front. and insted comment line 103 with // in front.

/Joe

3,242

(10 replies, posted in Manufactoring)

Maybe a small module, Tom?

/Joe

3,243

(1 replies, posted in Setup)

Yes, this seems like a good idea. Will be included in next minor release, 2.3.4.

/Joe

3,244

(23 replies, posted in Misc. Charts of Accounts)

I am not sure how this works in UTF8. The field len for account name is 50. I thought that MySql extended it, but if it doesn't, yes I guess we have to shorten the names.

The orange triangle is a javascript time-out. It maybe an error. More info could be found if the javascript is turned off.

/Joe

3,245

(6 replies, posted in Reporting)

I will have a look at it today.

/Joe

Yes please. You can see the contribution email at the website, Contact Us.

/Joe

3,247

(6 replies, posted in Reporting)

Hello again. This has now been fixed. HG repository updated. Will be included in 2.3.4.

You can change the following in /reporting/includes/excel_report.inc:

Add Line 698
 
     function End($email=0, $subject=null, $myrow=null, $doctype = 0)
     {
Line 698->        global $path_to_root;
        ++$this->y;
         for ($i = 0; $i < $this->numcols; $i++)
             $this->sheet->writeBlank($this->y, $i, $this->formatFooter);
---
         }
         closedir($d);
             }
Delete line 718
Line 718->        meta_forward($_SERVER['PHP_SELF'], "xls=1&filename=$this->filename&unique=$this->unique_name");
And add instead line 718
Line 718->        meta_forward($path_to_root.'/reporting/prn_redirect.php', "xls=1&filename=$this->filename&unique=$this->unique_name");
         exit();
     }
 }

/Joe

3,248

(10 replies, posted in Manufactoring)

I guess the Inventory Valuation Report. Maybe you can select a category if you have categoriced it.

/Joe

3,249

(6 replies, posted in Reporting)

Yes you are right. We will  have a look into this.

/Joe

3,250

(10 replies, posted in Manufactoring)

Can't you just export the reports to Excel (Destination)?

/Joe