From a60c544f80deb747c2f39d638b7f1f9600ca7eb2 Mon Sep 17 00:00:00 2001
From: root <root@prod-erp-indoteknikcom.c.project-indoteknik-com.internal>
Date: Fri, 2 Jun 2023 15:47:31 +0700
Subject: fix onhand in picking list report

---
 jasper_reports/custom_reports/PickingList.jrxml | 32 ++++++++++++++-----------
 1 file changed, 18 insertions(+), 14 deletions(-)

(limited to 'jasper_reports')

diff --git a/jasper_reports/custom_reports/PickingList.jrxml b/jasper_reports/custom_reports/PickingList.jrxml
index aaba91e..6ee9d43 100755
--- a/jasper_reports/custom_reports/PickingList.jrxml
+++ b/jasper_reports/custom_reports/PickingList.jrxml
@@ -93,6 +93,10 @@
 		<property name="net.sf.jasperreports.xpath.field.expression" value="Weight_unit_of_measure_label-weight_uom_name"/>
 		<fieldDescription><![CDATA[Weight_unit_of_measure_label-weight_uom_name]]></fieldDescription>
 	</field>
+	<field name="qty_reserved" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Quantity_Reserved-reserved_availability"/>
+		<fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Quantity_Reserved-reserved_availability]]></fieldDescription>
+	</field>
 	<variable name="SumQty" class="java.math.BigDecimal" calculation="Sum">
 		<variableExpression><![CDATA[$F{Demand-product_uom_qty}]]></variableExpression>
 	</variable>
@@ -101,19 +105,19 @@
 	</variable>
 	<variable name="PartnerName" class="java.lang.String"/>
 	<variable name="status" class="java.lang.String">
-		<variableExpression><![CDATA[$F{status_state}.equals("assigned")
-	? "Ready" 
-	: $F{status_state}.equals("confirmed")
-		? "Waiting" 
-		: $F{status_state}.equals("waiting")
-			? "Waiting Another Operation"
+		<variableExpression><![CDATA[$F{status_state}.equals("assigned")
+	? "Ready" 
+	: $F{status_state}.equals("confirmed")
+		? "Waiting" 
+		: $F{status_state}.equals("waiting")
+			? "Waiting Another Operation"
 			: $F{status_state}]]></variableExpression>
-		<initialValueExpression><![CDATA[$F{status_state}.equals("assigned")
-	? "Ready" 
-	: $F{status_state}.equals("confirmed")
-		? "Waiting" 
-		: $F{status_state}.equals("waiting")
-			? "Waiting Another Operation"
+		<initialValueExpression><![CDATA[$F{status_state}.equals("assigned")
+	? "Ready" 
+	: $F{status_state}.equals("confirmed")
+		? "Waiting" 
+		: $F{status_state}.equals("waiting")
+			? "Waiting Another Operation"
 			: $F{status_state}]]></initialValueExpression>
 	</variable>
 	<background>
@@ -346,7 +350,7 @@
 				<textElement textAlignment="Center" verticalAlignment="Middle">
 					<font size="8"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$F{forecast_qty}]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$F{qty_reserved}]]></textFieldExpression>
 			</textField>
 			<textField pattern="#,##0.###;(#,##0.###-)">
 				<reportElement x="230" y="0" width="30" height="20" uuid="3f804d35-b770-4dcf-87c7-e59777dd8fe8">
@@ -376,7 +380,7 @@
 				<textElement textAlignment="Center" verticalAlignment="Middle">
 					<font size="8"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$F{forecast_qty}]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$F{Quantity_On_Hand-qty_available}]]></textFieldExpression>
 			</textField>
 			<textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true">
 				<reportElement x="340" y="0" width="40" height="20" uuid="cc2740a0-4bc7-426d-b145-9e2b4ffeda60">
-- 
cgit v1.2.3