1 Reply by dz

(4 replies, posted in Reporting)

yes it is designed this way, though it should display the previous entry aswell, FA currently does not stores it in the audit trail table. You might need some modification to store the all historical values in audit trail table.

Go to forum: Reporting

2 Reply by dz

(1 replies, posted in Setup)

you can try enabling debug mode and see wht it shows, alternatively it could be something with the hosting provider, you can check if they have changed the supported PHP version

Go to forum: Setup

3 Reply by dz

(2 replies, posted in Fixed Assets)

1. Create a new supplier (say opening balance equity) link it with equity account instead of accounts payable.
2. Now purchase the fixed asset from this supplier, the GL entry will be as follows
Fixed asset Dr
Opening balance equity Cr
3. Repeat the same for all opening fixed assets.

Go to forum: Fixed Assets

4 Reply by dz

(1 replies, posted in Items and Inventory)

i think the only way right now is to add a service item (link it with freigh GL accounts) and use this as a line item in direct purchase invoice

Go to forum: Items and Inventory

5 Reply by dz

(4 replies, posted in Banking and General Ledger)

@joe you mean to say function write_journal_entries (instead of write_journal_transaction)

Go to forum: Banking and General Ledger

6 Reply by dz

(1 replies, posted in Report Bugs here)

Closing period (at a certain date) and closing a whole fiscal year are both different in FA. The screenshot you shared is for closing a period (which can not necessarily be a FY). Closing fiscal year auto calculates the profit and posts it in the equity and also posts a JV

Profit and loss DR
Retained Earning/Equity CR

While on the other side closing the period only locks entries at and before the given date.

If you are looking for the FY closure
1. please goto to Setup->Fiscal year
2. Click on the edit button of the fiscal year you cant to close
3. Set Is Closed: as YES
4. and Upodate

this will close the fiscal year and post the JV aswell

Go to forum: Report Bugs here

7 Reply by dz

(1 replies, posted in Items and Inventory)

you will have to define them separately to distinguish between new and old ones and check the inventory status

Go to forum: Items and Inventory

8 Reply by dz

(2 replies, posted in Accounts Payable)

you can inactive this supplier and add a new one with tax included settings set to NO

Go to forum: Accounts Payable

9 Reply by dz

(2 replies, posted in Report Bugs here)

Thanks !

Go to forum: Report Bugs here

10 Topic by dz

(2 replies, posted in Report Bugs here)

The audit trail report is showing double entries for Payment and Deposit for Customer/Suppllier entries.

If the payment/deposits are made to Misc. than there is single entry posting in audit trail, but if we select customer/supplier it loads add_audit_trail therefore i have added the following in

1: For customer trans
/sales/includes/db/cust_trans_db.inc

Under write_customer_trans function i have replaced
    if ($trans_type != ST_JOURNAL) // skip for journal entries

with

    if ($trans_type != ST_JOURNAL && $trans_type != ST_BANKDEPOSIT && $trans_type != ST_BANKPAYMENT) // skip for journal entries

2. For Supplier trans
and in /purchasing/includes/db/supp_trans_db.inc
under write_supp_trans function i have added this line

    if ($type != ST_JOURNAL && $type != ST_BANKDEPOSIT && $type != ST_BANKPAYMENT // skip for journal entries
above
    add_audit_trail($type, $trans_no, $date_,"Added",$amount);

This fixes the double posting of the same transactions in audit_trail table

Go to forum: Report Bugs here

11 Reply by dz

(3 replies, posted in Reporting)

check if your browser is blocking pop-ups

Go to forum: Reporting

12 Topic by dz

(3 replies, posted in Report Bugs here)

If Search Customer List is checked in company setup, than customer credit note can be posted with blank customers in FA's previous builds. I have added following lines in /sales/credit_note_entry.php under can_process() function to fix this

    if (!get_post('customer_id'))
    {
        display_error(_("There is no customer selected."));
        set_focus('customer_id');
        return false;
    }
   
    if (!get_post('branch_id'))
    {
        display_error(_("This customer has no branch defined."));
        set_focus('branch_id');
        return false;
    }


Thanks

Go to forum: Report Bugs here

13 Reply by dz

(5 replies, posted in Reporting)

rep111.php for sales quotation

Go to forum: Reporting

14 Reply by dz

(5 replies, posted in Report Bugs here)

ok great !
let me check, thanks again smile

Go to forum: Report Bugs here

15 Reply by dz

(5 replies, posted in Report Bugs here)

ok Thanks joe, let me check that smile

Go to forum: Report Bugs here

16 Reply by dz

(5 replies, posted in Report Bugs here)

@joe Kindly advise

Go to forum: Report Bugs here

17 Topic by dz

(5 replies, posted in Report Bugs here)

While converting the delivery note to the invoice the system is showing the following error:

Selected quantity cannot be less than quantity credited nor more than quantity not invoiced yet.

To re-produce
1 i created an SO and DN of 28 pieces.
2. Invoiced 19.60 pcs
3. and now while invoicing the remaining 8.40 pcs i get the above error.

I have checked the above in FA's latest build as well.

While investigating i found that in the following function in data_checks.inc, the $num>$max is going true. please note that both $num and $max are both 8.4, and $num can not be greater than $max.

But if i subtract $num-$max it gives me 1.7763568394003E-15(which should be zero). I googled it and found out that this is due to the shortcoming of floating point arithmetic.

Reference Function
function check_num($postname, $min=null, $max=null, $dflt=0) {
    if(!isset($_POST[$postname]))
      return 0;
    $num = input_num($postname, $dflt);
    if ($num === false || $num === null)
      return 0;
    if (isset($min) && ($num<$min))
      return 0;
    if (isset($max) && ($num>$max))
      return 0;
    return 1;
}

Should i add a rounding value like 0.00001 in $num for comparing it with $min and $max?

Kindly advise.

Go to forum: Report Bugs here

18 Reply by dz

(1 replies, posted in Report Bugs here)

Yes categories needed to be added first

Go to forum: Report Bugs here

19 Reply by dz

(6 replies, posted in Translations)

You can try DejaVuSans.ttf

Go to forum: Translations

20 Reply by dz

(28 replies, posted in Items and Inventory)

Please refer my reply on https://frontaccounting.com/punbb/viewtopic.php?id=9786

popsicles12 wrote:

Hello All,

Thanks for your reponses so far.

@ Apmuthu, you suggested I do a new Installation and see if this Standard Cost Alteration still persist. I have installed version 2.4.11 and it still persist.

Please this might sound stupid. How do I enter cost of Good so that when I do Inventory Valuation Report, It uses the standard cost to calculate and not average cost.
Cost when I got value different from my Standard cost which I know is average cost, I updated the Standard Cost but its not reflected in the Report.
Please help out.

Thanks

Popsicles12

Go to forum: Items and Inventory

21 Reply by dz

(8 replies, posted in Reporting)

In config.php look for following, and set $use_costed_values as 0, it will show the standard cost instead of weighted average.

    /* Show average costed values instead of fixed standard cost in report, Inventory Valuation Report */
    $use_costed_values = 1;   

popsicles12 wrote:

Hello All,

Thanks for all responses on the Inventory Valuation Report.

Please is there anyway that it can be made to use standard cost instead of average cost for this report. I believe this is very important.

Thanks in advance for a positive response.

Popsicles12

Go to forum: Reporting

22 Reply by dz

(3 replies, posted in Reporting)

1. You can make a copy of header2.inc file (say header107.inc), now do all the changes sledge did on that file
2. Create a new function in reporting/includes/pdf_report.inc (say function Header107() ), include the above header107.inc e.g given below

    function Header107()
    {
        global $dflt_lang; // FIXME should be passed as params

        $this->SetLang(@$this->formData['rep_lang'] ? $this->formData['rep_lang'] : $dflt_lang);
        $doctype = $this->formData['doctype'];
        $header2type = true;

        $lang = user_language();
        $this->SetLang(@$this->formData['rep_lang'] ? $this->formData['rep_lang']
            : ( $lang ? $lang : $dflt_lang));

         // leave layout files names without path to enable including
         // modified versions from company/x/reporting directory
        include("includes/doctext.inc");
        include("includes/header107.inc");

        $this->row = $temp;
    }

3. Now rename SetHeaderType on line 141 for calling Header107 function in rep107.php
            $rep->SetHeaderType('Header107');
4. Now this will make a custom header for specific for invoice pdf.

Go to forum: Reporting

23 Reply by dz

(5 replies, posted in Setup)

check if "Remember last document date:"  is checked?
in Setup->Company Setup->Display Setup

Try unchecking and see it fixes

Go to forum: Setup

24 Reply by dz

(5 replies, posted in Reporting)

yes you will have modify the relevant report files
e.g for invoices you can modify
1. reporting/rep107.php,
2. reporting/includes/header.inc,
3.reporting/includes/doctext.inc

Go to forum: Reporting

25 Reply by dz

(5 replies, posted in Items and Inventory)

What is the GL entry of your Payment?(petty cash one)

Go to forum: Items and Inventory