05-30-2014, 10:57 PM,
|
|
agaluski
Senior Member
|
Posts: 326
Threads: 74
Joined: Jan 2014
|
|
RE: Customer Item Functionality
Hello Exson. I did not update the invoice file in the trunk because we have made so many modification to the invoice file it wouldn't make sense. I think forms are something that are very customized company to company.
But basically to include this data in the final form the following changes need to be made. Maybe Hello Exson. I did not update the invoice file in the trunk because we have made so many modification to the invoice file it wouldn't make sense. I think forms are something that are very customized company to company.
But basically to include this data in the final form the following changes need to be made. If companies wish to include they can.
Quote:PrintCustTransPortrait.php
Add highlighted code:
if ($InvOrCredit == 'Invoice') {
$sql = "SELECT stockmoves.stockid,
stockmaster.description,
-stockmoves.qty as quantity,
stockmoves.discountpercent,
((1 - stockmoves.discountpercent) * stockmoves.price * " . $ExchRate . "* -stockmoves.qty) AS fxnet,
(stockmoves.price * " . $ExchRate . ") AS fxprice,
stockmoves.narrative,
stockmaster.controlled,
stockmaster.serialised,
stockmaster.units,
stockmoves.stkmoveno,
stockmaster.decimalplaces,
custitem.cust_part,
custitem.cust_description
FROM stockmoves INNER JOIN stockmaster
ON stockmoves.stockid = stockmaster.stockid
LEFT OUTER JOIN custitem
ON custitem.debtorno='" . $myrow['debtorno'] . "'
AND custitem.stockid=stockmoves.stockid
WHERE stockmoves.type=10
AND stockmoves.transno='" . $FromTransNo . "'
AND stockmoves.show_on_inv_crds=1";
} else {
/* only credit notes to be retrieved */
$sql = "SELECT stockmoves.stockid,
stockmaster.description,
stockmoves.qty as quantity,
stockmoves.discountpercent,
((1 - stockmoves.discountpercent) * stockmoves.price * " . $ExchRate . " * stockmoves.qty) AS fxnet,
(stockmoves.price * " . $ExchRate . ") AS fxprice,
stockmoves.narrative,
stockmaster.controlled,
stockmaster.serialised,
stockmaster.units,
stockmoves.stkmoveno,
stockmaster.decimalplaces,
custitem.cust_part,
custitem.cust_description
FROM stockmoves INNER JOIN stockmaster
ON stockmoves.stockid = stockmaster.stockid
LEFT OUTER JOIN custitem
ON custitem.debtorno='" . $myrow['debtorno'] . "'
AND custitem.stockid=stockmoves.stockid
WHERE stockmoves.type=11
AND stockmoves.transno='" . $FromTransNo . "'
AND stockmoves.show_on_inv_crds=1";
} // end else
'Around' line 368
Quote:if ($myrow2['cust_part'] > '') {
$YPos -= (10*$lines);
$LeftOvers = $pdf->addTextWrap($Left_Margin+15,$YPos,186,$FontSize,$myrow2['cust_part']);
$LeftOvers = $pdf->addTextWrap($Left_Margin+80,$YPos,186,$FontSize,$myrow2['cust_description']);
}
|
|
|