Hi,

In the selectboxes for rep109 (print orders) all/most orders also called 'auto-DebtorName'.

If a customer has several orders, they are all called 'auto-DebtorName'.

You can't select on orderno.

That makes it impossible to select the one you want to print because the are all called 'auto' (reference).

Rep110 (deliveries) does is right.

Kind regards,
F.

Hi kvvaradha,

It seems to me you are a developer yourself.

What should it cost to make it happen ?

Kind regards,
F

28

(12 replies, posted in Report Bugs here)

Hi Joe,

A better approach that also works if allocations are shown :

        if ($email == 1)   
        {
            if (($CustomerRecord["Balance"]) != ($CustomerRecord["Balance"] - $CustomerRecord["Due"]))
                $rep->End($email, _("Statement") . " " . _("as of") . " " . sql2date($date) . " " . _("from") . " " . get_company_pref('coy_name'));
            else
                display_notification(sprintf(_("Customer %s has no overdue debs. No e-mail is send."), $myrow["DebtorName"]));       
        }

Notification is also more clear : No e-mail is send.

*.po-file needs to be updated :
-'from'
-'Customer %s has no overdue debs. No e-mail is send.'

Thanks !
F.

29

(12 replies, posted in Report Bugs here)

There is also another not-translatable string string in rep108 :

            $rep->filename = "Statement" . $myrow['debtor_no'] . ".pdf";

Should be :

            $rep->filename = _("Statement") . $myrow['debtor_no'] . ".pdf";

Kind regards,

F.

30

(12 replies, posted in Report Bugs here)

Hi,

'Name' should be 'DebtorName'

F.

31

(12 replies, posted in Report Bugs here)

@Joe

When there are no overdue-debts :

Undefined index: name in bestand: /var/lib/(...)/vhost/(...)/frontaccounting/reporting/rep108.php op regel 186

Kind regards,
F.

32

(12 replies, posted in Report Bugs here)

Thanks Joe !

I also have a suggestion for rep108 to NOT mail statements if there are no overdue debs :

        if (($email == 1) AND ((($CustomerRecord["Due"]-$CustomerRecord["Overdue1"]) <> 0) OR (($CustomerRecord["Overdue1"]-$CustomerRecord["Overdue2"]) <> 0) OR ($CustomerRecord["Overdue2"] <> 0)))
            $rep->End($email, _("Statement") . " " . _("as of") . " " . sql2date($date));
        else if ($email == 1)
            display_notification (_("Customer(s) has(have) no overdue debs."));

Needs also updated *.po-file.

F.

33

(12 replies, posted in Report Bugs here)

Hi,

Rep108 has a not-translatable string : display_notification ("No customers with outstanding balances found");

It should be : display_notification (_("No customers with outstanding balances found"));

Also po- en mo-files need to be updated.

Kind regards,
F.

SOLVED
Thanks !
F.

Hi

If a cost update is made, in the automatic comment 'Cost was %s changed to %s x quantity on hand of %s', the second '%s' only gives a rounded amount, not the real amount with decimals.

Kind Regards,
F.

Of course I understand !  Thank you for the good work !

F.

Ok, it seems OK now but I can't modify or void 'Cost Updates'. Is there a way to change or void them ?

F.

The same for Customer Credit Note, no project(s)/dimension(s) on bookings on stockaccount.

Kind regards,
F.

Also the automatic 'Cost Udate' doesn't have (a) project(s)/dimension(s) on bookings on the stockaccount.  I guess it should have the project(s)/dimension(s) of the product like with stockajustments.  'Cost Update' has (a) project(s)/dimension(s) on the costaccount, but not on the stockaccount ...

Kind regards,
F.

I escaped some code in customer_delivery.php :

//    if (!$_SESSION['Items']->prepaid && $_SESSION['Items']->count_items() == 0) {
//        hyperlink_params($path_to_root . "/sales/inquiry/sales_orders_view.php",
//            _("Select a different delivery"), "OutstandingOnly=1");
//        echo "<br><center><b>" . _("This delivery has all items invoiced. There is nothing to modify.") .
//            "</center></b>";
//        display_footer_exit();
//    }


So I can change the deliveries anyway.

F.

No, no changes if invoiced.

F.

How can I correct the booked deliveries when the are invoiced ?

Kind regards,
F.

Thanks Joe !
SOLVED

Hi,

When a delivery of a product (not for a service) is made to a customer an automatic booking is made : costaccount (D) against stockaccount (C).  The product gets out of stock and represents a cost booked on the costaccount.

The costaccount gets the project(s) mentioned on the deliveryform, but the stockaccount doesn't.

Both accounts should get the project(s).

Idem dito for stockchanges.

Kind regards,
F.

45

(0 replies, posted in Reporting)

Hi,

How can I prevent that users with readrights can mail reports ?

Kind regards
F.

46

(4 replies, posted in Dimensions)

Hi,

I see the dimensions of deliveries in the debtor_trans table.

I can code selectboxes for the dimensions in '/sales/inquiry/sales_deliveries_view.php'

Could somebody help me with making the selection of the deliveries on their dimension ?

I want to batch-invoice deliveries by dimension.

Thanks !

F.

Hi,

When I want to make a batch-invoice of deliveries, and before making the invoice, I remove a delivery-row with the provided 'remove'-link, that delivery cannot be voided any more : "This delivery cannot be voided because it was already invoiced."

Well, that 'removed' delivery isn't invoiced, but there seems to be a link with the invoice of the other deliveries that are invoiced.

Removing a delivery-row should also remove the link between the invoice and the 'removed' delivery.

Kind regards,

F.

48

(22 replies, posted in Report Bugs here)

Dear Itronics,

May I bring this bug back to your attention ?

Especially report 108 is of interest (statements).

However, not only reports are affected by this bug, but also Dashboard Sales and Customer_Inquiry.  Also not only prepayments are affected (also totals and aging, in general).

Thanks !

F.

49

(11 replies, posted in Reporting)

Hi,

I think this is the same problem that was solved :

https://frontaccounting.com/punbb/viewtopic.php?id=9768

Kind regards,
F.

50

(22 replies, posted in Report Bugs here)

Hi Itronics,

You can find new screenshots in : https://cloud.fiftyonetielt.be/index.php/s/Gy8ZQ8Kr47rnozE

Rep101 is OK
Rep102 without allocations is OK
Rep102 with allocations is not OK
Rep108 without allocations is not OK : the amount of the prepayment invoice = the amount of the prepayment order (850), but there is only a prepayment-invoice of 250 = partial payment. But totals are correct.
Rep108 with allocations is not OK : idem + Totals are not correct.
Rep115 is OK

Kind regards,
F.