Create a New Customised Report

Oct 13, 2025 by wbrum.org 94 views

Outbound Shipment Detail View: Sell Price Values of 0,00 Displayed as NAN

What Went Wrong?

The issue at hand is a peculiar one, where sell price values of 0,00 are displayed as NAN (Not a Number) in the Outbound Shipment Detail View. This is a significant problem, as it can lead to confusion and errors in inventory management. Furthermore, the decimal point is displayed as a dot instead of a comma for Tax % value, which is a formatting issue that needs to be addressed.

Additional Context

The issue is not limited to the display of sell price values. The logo used in the Outbound Shipment Detail View is also a point of contention. The question arises as to which logo is used: the store logo from the store window and OG (Open Graph) or the organisation logo from the Preference window in OG. In the case of Ivory Coast, there is no specific store logo, only the one in the Preference window.

Expected Behaviour

The expected behaviour is for the sell price values to be displayed correctly, without any errors or formatting issues. The logo used in the Outbound Shipment Detail View should be the organisation logo from the Preference window in OG.

How to Reproduce

To reproduce the behaviour, follow these steps:

Create a New Customised Report: Go to Distribution > Requisition and create a new requisition.
Set Regional Format: Set your windows to Ivory Coast regional format or Canadian English Regional format.
Create an Outbound Shipment: Create an outbound shipment and issue stock.
Print Report: Print the report and observe the error.

Your Environment

The issue is being reported in the following environment:

Open mSupply Version: v2.6.1RC2
Legacy mSupply Central Server Version: v8-00-17
Platform: OMS desktop
Database Type: SQLite

Screenshots

A screenshot of the issue can be found here: https://drive.google.com/file/d/16JkI77kdHsYwxmfc24TYjG0_x13-8TiT/view?usp=sharing

Conclusion

The issue of sell price values being displayed as NAN in the Outbound Shipment Detail View is a significant problem that needs to be addressed. The decimal point being displayed as a dot instead of a comma for Tax % value is also a formatting issue that needs to be fixed. The logo used in the Outbound Shipment Detail View should be the organisation logo from the Preference window in OG. To reproduce the behaviour, follow the steps outlined above.

Possible Solutions

Update the Code: Update the code to correctly display sell price values and use the organisation logo from the Preference window in OG.
Fix Regional Format: Fix the regional format to display the decimal point correctly.
Test and Validate: Test and validate the changes to ensure that the issue is resolved.

Future Development

In the future, it would be beneficial to:

Improve Error Handling: Improve error handling to prevent similar issues from arising in the future.
Enhance User Experience: Enhance the user experience by providing clear and concise error messages.
Increase Test Coverage: Increase test coverage to ensure that the issue is caught early and resolved quickly.

Recommendations

Based on the analysis, the following recommendations are made:

Update the Code: Update the code to correctly display sell price values and use the organisation logo from the Preference window in OG.
Fix Regional Format: Fix the regional format to display the decimal point correctly.
Test and Validate: Test and validate the changes to ensure that the issue is resolved.

By following these recommendations, the issue of sell price values being displayed as NAN in the Outbound Shipment Detail View can be resolved, and the user experience can be improved.
Outbound Shipment Detail View: Sell Price Values of 0,00 Displayed as NAN - Q&A

Q: What is the issue with the Outbound Shipment Detail View?

A: The issue is that sell price values of 0,00 are displayed as NAN (Not a Number) in the Outbound Shipment Detail View. This is a significant problem, as it can lead to confusion and errors in inventory management.

Q: Why is the decimal point displayed as a dot instead of a comma for Tax % value?

A: The decimal point is displayed as a dot instead of a comma for Tax % value due to a formatting issue. This is a separate problem that needs to be addressed.

Q: Which logo is used in the Outbound Shipment Detail View?

A: The logo used in the Outbound Shipment Detail View is the organisation logo from the Preference window in OG. However, in the case of Ivory Coast, there is no specific store logo, only the one in the Preference window.

Q: How can I reproduce the issue?

A: To reproduce the issue, follow these steps:

Create a New Customised Report: Go to Distribution > Requisition and create a new requisition.
Set Regional Format: Set your windows to Ivory Coast regional format or Canadian English Regional format.
Create an Outbound Shipment: Create an outbound shipment and issue stock.
Print Report: Print the report and observe the error.

Q: What is the expected behaviour?

A: The expected behaviour is for the sell price values to be displayed correctly, without any errors or formatting issues. The logo used in the Outbound Shipment Detail View should be the organisation logo from the Preference window in OG.

Q: What is the current environment?

A: The issue is being reported in the following environment:

Open mSupply Version: v2.6.1RC2
Legacy mSupply Central Server Version: v8-00-17
Platform: OMS desktop
Database Type: SQLite

Q: Can I see a screenshot of the issue?

A: Yes, a screenshot of the issue can be found here: https://drive.google.com/file/d/16JkI77kdHsYwxmfc24TYjG0_x13-8TiT/view?usp=sharing

Q: What are the possible solutions?

A: The possible solutions are:

Update the Code: Update the code to correctly display sell price values and use the organisation logo from the Preference window in OG.
Fix Regional Format: Fix the regional format to display the decimal point correctly.
Test and Validate: Test and validate the changes to ensure that the issue is resolved.

Q: What are the recommendations?

A: Based on the analysis, the following recommendations are made:

Update the Code: Update the code to correctly display sell price values and use the organisation logo from the Preference window in OG.
Fix Regional Format: Fix the regional format to display the decimal point correctly.
Test and Validate: Test and validate the changes to ensure that the issue is resolved.

Q: What is the conclusion?

A: The issue of sell price values being displayed as NAN in the Outbound Shipment Detail View is a significant problem that needs to be addressed. The decimal point being displayed as a dot instead of a comma for Tax % value is also a formatting issue that needs to be fixed. The logo used in the Outbound Shipment Detail View should be the organisation logo from the Preference window in OG. To reproduce the behaviour, follow the steps outlined above.

Q: What is the future development plan?

A: In the future, it would be beneficial to:

Improve Error Handling: Improve error handling to prevent similar issues from arising in the future.
Enhance User Experience: Enhance the user experience by providing clear and concise error messages.
Increase Test Coverage: Increase test coverage to ensure that the issue is caught early and resolved quickly.