- $rep->AmountCol(3, 4, $trans['quantity_received'], $qdec);
- $rep->AmountCol(4, 5, $trans['unit_price'], $dec);
- $rep->AmountCol(5, 6, $trans['act_price'], $dec);
- $amt = round2($trans['quantity_received'] * $trans['act_price'], $dec);
- $rep->AmountCol(6, 7, $amt, $dec);
- $total += $amt;
- $qtotal += $trans['quantity_received'];
- $grandtotal += $amt;
+ $rep->TextCol(3, 4, $trans['batch_no']);\r
+ \r
+ if ($trans['quantity_inv'])\r
+ {\r
+ $suppinv = getSuppInvDetails($trans['grn_item_id']);\r
+ while ($inv=db_fetch($suppinv))\r
+ { \r
+ $inv['inv_price'] *= $rate;\r
+ $rep->TextCol(4, 5, $inv['inv_no']);\r
+ $rep->AmountCol(5, 6, $inv['inv_qty'], $qdec);\r
+ $rep->AmountCol(6, 7, $inv['inv_price'], $dec);\r
+ $rep->AmountCol(7, 8, $trans['unit_price'], $dec);\r
+ $amt = round2($inv['inv_qty'] * $inv['inv_price'], $dec);\r
+ $rep->AmountCol(8, 9, $amt, $dec);\r
+ $rep->NewLine();\r
+ $total += $amt;\r
+ $qtotal += $inv['inv_qty'];\r
+ $grandtotal += $amt;\r
+ }\r
+ }\r
+ \r
+ if ($trans['qty_recd'] - $trans['quantity_inv'] !=0 )\r
+ {\r
+ $rep->TextCol(4, 5, "--");\r
+ $rep->AmountCol(5, 6, $trans['qty_recd'] - $trans['quantity_inv'], $qdec);\r
+ $rep->AmountCol(7, 8, $trans['unit_price'], $dec);\r
+ $amt = round2(($trans['qty_recd'] - $trans['quantity_inv']) * $trans['unit_price'], $dec);\r
+ $rep->AmountCol(8, 9, $amt, $dec);\r
+ $total += $amt;\r
+ $qtotal += $trans['qty_recd'] - $trans['quantity_inv'];\r
+ $grandtotal += $amt;\r
+ }\r
+ else\r
+ $rep->NewLine(-1);\r