diff options
| author | root <root@prod-erp-indoteknikcom.c.project-indoteknik-com.internal> | 2023-06-02 15:47:31 +0700 |
|---|---|---|
| committer | root <root@prod-erp-indoteknikcom.c.project-indoteknik-com.internal> | 2023-06-02 15:47:31 +0700 |
| commit | a60c544f80deb747c2f39d638b7f1f9600ca7eb2 (patch) | |
| tree | e078947507322c276e9451435c7ec0f6d3d4d190 | |
| parent | d3d4d9c04eb53c6a810936e440be184e6690fef3 (diff) | |
fix onhand in picking list report
| -rwxr-xr-x | jasper_reports/custom_reports/PickingList.jrxml | 32 |
1 files changed, 18 insertions, 14 deletions
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"> |