/Joe

Link to repository for Release 2.3.25:

Release 2.3.25

Link to reporitory for Release 2.4 RC1:

Release 2.4 RC1

/Joe

Joe

$result = get_gl_trans($_GET['type_id'], $_GET['trans_no']);

In the case of the Invoice View, the $supp_trans gets passed by reference through line 36 in purchasing/view/view_supp_invoice.php:

read_supp_invoice($trans_no, ST_SUPPINVOICE, $supp_trans);

The function read_supp_invoice() is in purchasing/includes/db/invoice_db.inc and it does not have any dimension data and hence the absence of values in the dimension columns in the Invoice View!

Also, for each sales invoice item line, all entries pertaining to the gl_trans table will get pulled in if it is joined and records taken. Otherwise, the default value of dimension data in the suppliers table get sucked in erroneously if taken from there.

Sample sql taken from the function read_supp_invoice() and modified to join the gl_trans table :

SELECT supp_trans.*, supp_name, gl.dimension_id, gl.dimension2_id
FROM 1_supp_trans supp_trans LEFT JOIN 1_suppliers USING (supplier_id)
    LEFT JOIN 1_gl_trans gl ON (supp_trans.type=gl.type AND supp_trans.trans_no=gl.type_no)
WHERE supp_trans.trans_no = 11 AND supp_trans.type = 20;

will erroneously produce multiple records for each line item entry of the sales invoice display.

Hence the Dimension column in the Sales Invoice View should be removed - pictures 07 and 08 in the attachment illustrate it.

I will now test the Supplier Invoice.

Before you Login View this screen shot

http://prnt.sc/bwx3l3

Click below to login

http://fa.boxygen.biz/fa2325/purchasing/supplier_invoice.php?AddedID=9

Username: aeronvista
pass: usayed2005

After you Login Please

1. Click View this Invoice
Under the 3rd Column name Dimension you will find No Value but it should have "PNG Job NO 2" as defined in the above screen shot.

2. Click View the General Entry of this invoice
Under the 3rd Column named Dimension you will find value "PNG Job No2" in Second Row.

I hope its clear.

@Apmuthu, i think you have mixed up Supplier Invoices with Direct Invoice. The problem I am reporting is of Supplier Invoice in which a Direct GL entry can be passed against as supplier. While in Direct Invoice Inventory Item needs to be selected.

Regards.

What theme are you using - any changes in it's template you have done that may be erroneous or missing data? The standard FA 2.3 theme does not even display the Dimension column for the Supplier Invoice. Please use the Training Co (en_US-demo.sql Chart) for testing and comparing with your specific installs.

I cannot reproduce this error. I am testing on 2.3.25.
If you have done some specific entry or changed the entry please advice.

/Joe

Line 288 of purchasing/includes/ui/invoice_ui.inc below is responsible for display of Dimension 1:

                   label_cell(get_dimension_string($entered_gl_code->gl_dim, true));

@joe: is this an error?

http://prnt.sc/bwsarq (Supplier Invoice)

http://prnt.sc/bwsam2 (Journal Entry of Supplier Invoice)

You can see that the Dimension is appearing in Journal Entry View but not in Supplier Invoice View.