Search options (Page 3 of 5)

Thanks apmuthu for updating the wiki.

What is not clear is that apart from the PDF file that I placed in reporting/forms do I have to create another headerX.inc file with code to add my PDF file?

Would I be asking too much if you could add some simple code example in the wiki?

Thanks in advance
Carmelo

Thanks Joe, right to the point.
Carmelo

Hi Janusz,
This method of reversal you are proposing is very good.
The International Financial Reporting Standards (IFRS) require that no transaction is deleted from the journal but instead a mistaken transaction should be reversed.
Therefore by adding the functionality you mention just improved the level of standard for Frontaccounting.

Perhaps while you are at it, you might also visit the voiding method of Invoices and other similar transactions.

It is quite tedious to notice that you had the date wrong after entering a batch of invoices. Voiding each one and re-entering them again. In this case, enabling only a change of date (as long as the period has not been closed) might save a ton of work correcting date mistakes.

Cheers, Carmelo

Hi Joe,
Having a flag in the config file would be nice.
I did the necessary changes to have the image link to a url. The following are the changes I did. Two files were affected.

I hope this is considered useful and implemented in the core for version 2.4 (or before)

-----------------------------------------------------------------------------------------------
    Change Item Image to URL
-----------------------------------------------------------------------------------------------
fa/inventory/manage/items.php

Insert in Line 54 right after: $Ajax->activate('details');

if (isset($_POST['url']) && $_POST['url'] != '')
{
    $url = trim($_POST['url']);
    if (strpos($url, 'http') !== false)
    {
        $stock_id = $_POST['NewStockID'];
        $upload_file = 'Yes'; //Assume all is well to start off with
        $filename = company_path().'/images';
        if (!file_exists($filename))
        {
            mkdir($filename);
        }   
        $filename .= "/".item_img_name($stock_id).".url";
        $handle = fopen($filename, 'w');
        fwrite($handle, $url);
        $result=fclose($handle);
        if (!$result)
        {
            display_error(_('The link could not be saved'));
            $upload_file ='No';
        }
    }
}

--------------------------------------------------
~ Line 199 : REPLACE
            $filename = company_path().'/images/'.item_img_name($_POST['NewStockID']).".jpg";
            if (file_exists($filename))
                unlink($filename);

WITH:
            $filename = company_path().'/images/'.item_img_name($_POST['NewStockID']).".jpg";
            if (file_exists($filename))
                unlink($filename);
            $filename = company_path().'/images/'.item_img_name($_POST['NewStockID']).".url";
            if (file_exists($filename))
                unlink($filename);
               
--------------------------------------------------
~ Line 276 : REPLACE
        $filename = company_path().'/images/'.item_img_name($stock_id).".jpg";
        if (file_exists($filename))
            unlink($filename);

WITH:
        $filename = company_path().'/images/'.item_img_name($stock_id).".jpg";
        if (file_exists($filename))
            unlink($filename);
        $filename = company_path().'/images/'.item_img_name($stock_id).".url";
        if (file_exists($filename))
            unlink($filename);

-------------------------------------------------   
around line 418 REPLACE:
        // Add image upload for New Item  - by Joe
        file_row(_("Image File (.jpg)") . ":", 'pic', 'pic');
        // Add Image upload for New Item  - by Joe
        $stock_img_link = "";
        $check_remove_image = false;
        if (isset($_POST['NewStockID']) && file_exists(company_path().'/images/'
            .item_img_name($_POST['NewStockID']).".jpg"))
        {
         // 31/08/08 - rand() call is necessary here to avoid caching problems. Thanks to Peter D.
            $stock_img_link .= "<img id='item_img' alt = '[".$_POST['NewStockID'].".jpg".
                "]' src='".company_path().'/images/'.item_img_name($_POST['NewStockID']).
                ".jpg?nocache=".rand()."'"." height='$pic_height' border='0'>";
            $check_remove_image = true;
        }
        else
        {
            $stock_img_link .= _("No image");
        }

WITH:
       
    // URL link for images added by Carmelo Romano on 25/07/2013
    $stock_img_link = "";
    $check_remove_image = false;
    url_row(_("Image Link") . ":", 'url', 'url');
    if (isset($_POST['NewStockID']) && file_exists(company_path().'/images/'
        .item_img_name($_POST['NewStockID']).".url"))
    {
        $url="";
        $filename=company_path().'/images/'.item_img_name($_POST['NewStockID']).".url";
        $handle = @fopen($filename, r);
       
        if ($handle) {
            $url = fgets($handle, 1024);
        }
       
        if (!empty($url)) {
            $stock_img_link .= "<a href='".$url."' target='_766266'>
                                <img id='item_img' alt = '[".$_POST["NewStockID"].".jpg"."]'
                                    src='".$url."'"." height='$pic_height' border='0'><br>
                                        Open image in New Window</a>";
           
            $check_remove_image = true;
        }
        fclose($handle);
    }
    else
    {   
        // Add image upload for New Item  - by Joe
        file_row(_("Image File (.jpg)") . ":", 'pic', 'pic');
        // Add Image upload for New Item  - by Joe
        $stock_img_link = "";
        $check_remove_image = false;
        if (isset($_POST['NewStockID']) && file_exists(company_path().'/images/'
            .item_img_name($_POST['NewStockID']).".jpg"))
        {
         // 31/08/08 - rand() call is necessary here to avoid caching problems. Thanks to Peter D.
            $stock_img_link .= "<img id='item_img' alt = '[".$_POST['NewStockID'].".jpg".
                "]' src='".company_path().'/images/'.item_img_name($_POST['NewStockID']).
                ".jpg?nocache=".rand()."'"." height='$pic_height' border='0'>";
            $check_remove_image = true;
        }
        else
        {
            $stock_img_link .= _("No image");
        }
    }

------------------------------------------------   
fa/includes/ui/ui_input.inc

ADD:
//-----------------------------------------------------------------------------------
function url_cells($label, $name, $id="")
{
    if ($id != "")
        $id = "id='$id'";
    label_cells($label, "<input type='text' name='$name' size='35' />");
}       
function url_row($label, $name, $id = "")
{
    echo "<tr><td class='label'>$label</td>";
    url_cells(null, $name, $id);
    echo "</tr>\n";
}   

Regards, carmelo

Thanks Joe,

Actually this may require less intervention than it seems. Instead of saving a .jpg file I manage to save a url written in a text file saved as .txt. Then when the image is called the file is opened and the url used as part of a <img src=URL />.

What do you think?

Thanks, Carmelo

Hi Itronics,
Is the release of 2.4 with all the goodies still in the pipeline? Is there a target date?

Thanks
Carmelo

Hi,
In Malta and perhaps the rest of Europe, we have the same issue with the Zero % VAT. I think the way I setup FA, I get the reports correctly. I did the following:

1. Create a GL Acount ex 2220 VAT - Exempt without Credit (you have to create an account for each different type of VAT)
2. in Tax Types (under Setup) create the Tax Type you need to follow, for the above example:
VAT (Ex w Credit)     0.0     2220 VAT - Exempt with Credit/Exports     2229 VAT - Exempt Purchases for re-sale
3. In Tax Groups place this VAT into either the Domestic VAT or the Intra-Community & Non-EU Trade Group
4. In Item Tax Type create an entry such as: VAT Exempt w/o Credit and uncheck the box that is relevant to this entry.
5. It is important that you set up your Customers and Suppliers in the correct group for TAX type
6. Also items have to be placed in the correct type of VAT category.

The only problem I found with the above is when an item that is placed in the group to be charged VAT for sale, but is bought as a capital expense. In this case the use of Direct Invoice does not produce the correct results.

Please note: I am not an accountant and although I have checked the above with my accountant, I might be missing something important. So please check thoroughly the above and if possible report back with success or failure.

Carmelo

Anyone with a hint on how to duplicate the Sales Order Entry to provide another link on the Sales Tab named Request for Payment?

TIA
Carmelo

I'm not sure what you have in mind when you said using the "statements report".
The Request for Payment (RFP) should be accessible like an invoice or a purchase order.

What I tried was to modify rep109.php around lines 80 to 90.
Here the $print_as_quote is used to print a Quote if it is set to 1 or a Sales Order otherwise.
But I could not find the source of $print_as_quote to set it as 2 and have the title set to "REQUEST FOR PAYMENT".

Ideally I would like to have a new link "Request for Payment" on the Sales Tab right under Sales Order Entry.

It seems to be a simple matter, but all my attempts failed.

Would appreciate anyone helping with this.
Cheers
Carmelo

Now works like a dream .... thanks a million

Carmelo