Bug 19125 - [Report- Item]- Incorrect Data Formatting and Calculations in Open Item Report When Generating TXT and CSV Files
Summary: [Report- Item]- Incorrect Data Formatting and Calculations in Open Item Repor...
Status: CLOSED
Alias: None
Product: ML_DB 64-bit Mac
Classification: Unclassified
Component: Item Reports (show other bugs)
Version: 2026-14.0.22 + 26.0.1 Ver 03
Hardware: MAC All
: Medium Major
Assignee: Nandhini
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2026-04-14 14:57 IST by Nandhini
Modified: 2026-05-07 18:21 IST (History)
3 users (show)



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nandhini 2026-04-14 14:57:17 IST
1. Create basic setup- assign coa's and customers, vendors, items, then save
2. Create multiple invoices and purchases, then save the open item report screen, generate text and CSV files for the following options: sales summary and sales detail, purchase detail, and purchase summary.

Issue #1: Quantity Multiplied and Sales Balance Zero in Sales Detail, also, total item details alignment issues.
*Report Type: Sales Detail
*Formats Affected: TXT, CSV.

*Description: The total balance for each item is displayed in an incorrect format, Quantity values are multiplied by 100, and the sales balance is displayed as zero
. screenshot1:
https://drive.google.com/file/d/1wbmVpfyFdCo6yrmwLz5vh5hJvAgZa75v/view?usp=sharing
screenshot2:
https://drive.google.com/file/d/1e_4OT6R8VmP9SyyWF4n0k0_-lzt5Niia/view?usp=sharing

Issue #2: Cost Balance Showing Zero in Sales Summary CSV
* Report Type: Sales Summary
* Format Affected: CSV
* Description:
Cost balances are displayed as zero instead of reflecting the actual calculated values.
screenshot:
https://drive.google.com/file/d/1ZzktW6OJ32ZI9hkXhQygtRmmYxN3LkII/view?usp=sharing

Issue #3: Incorrect Total Balance Format in Purchase Summary
* Report Type: Purchase Summary
* Format Affected: CSV
* Description:
Total balances are incorrectly formatted, leading to misinterpretation of values.
screenshot:
https://drive.google.com/file/d/1TkCohMyqEN87xgdnFE7iHErzR_gH8SBR/view?usp=sharing

Issue #4: Quantity and Unit Cost Errors in Purchase Detail
* Report Type: Purchase Detail
* Formats Affected: TXT, CSV
* Description:
    * Quantity values are incorrectly multiplied by 100.
    * Unit cost shows zero balances instead of the correct value.
screenshot:
https://drive.google.com/file/d/1LvTuFgwAJ3dTp3zOPYKI5ZzRpJiafAg9/view?usp=sharing
Comment 1 Bhavani 2026-04-23 16:09:11 IST
Fixed, Available in next build
Comment 2 Nandhini 2026-04-27 18:36:20 IST
Issue#1: The issue still exists 
sales details issue in both text and CSV
screenshot:
https://drive.google.com/file/d/1EAa8cbTiOxv8wzDpD3ye5a6R2bPBhDgt/view?usp=sharing
screenshot: purchase detail issue in CSV file
https://drive.google.com/file/d/19Rd_icgx1ZxdwWOzk_Pzgn2dB5nZdFx8/view?usp=sharing

Issue#2: Cost Balance Showing, but here multiplied by 100 issue getting in the Sales Summary CSV
screenshot:
https://drive.google.com/file/d/16NtvkpHFYINr6YlXzo9rlv_PnykXWXMW/view?usp=sharing

Issue#3: working as expected
https://prnt.sc/W8AMEVAWpO-R

Issue#4: working as expected
https://prnt.sc/RHdZcaCaAQin
Comment 3 Nandhini 2026-04-29 11:23:57 IST
Issue#1: The issue still exists 
sales details issue in both text and CSV
screenshot:
https://drive.google.com/file/d/1EAa8cbTiOxv8wzDpD3ye5a6R2bPBhDgt/view?usp=sharing
screenshot: purchase detail issue in CSV file
https://drive.google.com/file/d/19Rd_icgx1ZxdwWOzk_Pzgn2dB5nZdFx8/view?usp=sharing

Issue#2: Cost Balance Showing, but here multiplied by 100 issue getting in the Sales Summary CSV
screenshot:
https://drive.google.com/file/d/16NtvkpHFYINr6YlXzo9rlv_PnykXWXMW/view?usp=sharing

Issue#3: Unit cost and total cost columns are misaligned in txt file
* Report Type: Purchase Summary
* Formats Affected: TXT
screenshot:
https://drive.google.com/file/d/1FvdYbELJOWliBsCuQ4rCAa_FwH7cG4hX/view?usp=sharing

Issue#4: still the qty balances are misaligned 
* Report Type: Purchase Detail
* Formats Affected: TXT, CSV
screenshot:
https://drive.google.com/file/d/1xLokrqR7eA_vgf0PJFRKyKToBm9GVzl6/view?usp=sharing

DB:
https://drive.google.com/file/d/13WQZyR3mqqARO1WlE0ULYJl4wWEfB3lH/view?usp=sharing
Comment 4 pmyadav 2026-05-01 13:42:14 IST
fixed available in next build
Comment 5 Nandhini 2026-05-05 16:58:52 IST
#1: In the text files, it's working fine, but there's an issue with the CSV file
Sales detail: Total quantity amounts are not showing
screenshot:
https://drive.google.com/file/d/1w3gDKghyMhPB8oede1WXN4HdCn3saO45/view?usp=sharing
Purchase detail: Total Qty amounts reflecting in the previous column
screenshot:
https://drive.google.com/file/d/13-oLfQR5wOKb_LzlOifeKO8Ibs4WwpAF/view?usp=sharing

#2: working as expected
https://prnt.sc/XGVG0qw352Kf

#3. Still having the column misalignment issue in the txt file
screenshot:
https://drive.google.com/file/d/17xzwHb_OX2N4KQOVqqlDQCEO00735D32/view?usp=sharing

#4. Still, the issue exists
screenshot:
https://drive.google.com/file/d/1G8S5KEsgGI-ijfuT8PSHlE2KVdnASFZS/view?usp=sharing

DB:
https://drive.google.com/file/d/1NY85Bn34tjVcsg-HCsVK049iOWxyL09R/view?usp=sharing
Comment 6 Bhavani 2026-05-05 23:22:18 IST
#1 - Fixed
#3 - based on the text length it will be delimitation will be coming. i don't know what sort of alignment you are looking.
#4 - Fixed
Comment 7 Nandhini 2026-05-07 10:57:23 IST
#1. Working as expected
https://prnt.sc/1ZWYMCCx1ysW
Purchase details: CSV FILE: Total Qty amounts are reflected in the previous column
screenshot:
https://drive.google.com/file/d/13qAkZZX_HiuSFk7KakKdNl3FvK0nWwCp/view?usp=sharing


#3. Issue#3: Unit cost and total cost columns are mismatched in the TXT file. The column details are mapped incorrectly. 
* Report Type: Purchase Summary
* Formats Affected: TXT
screenshot:
https://drive.google.com/file/d/19r0CyxNMp3xvOPkTZW9MsOn7c9a5e4PR/view?usp=sharing

#4. Working fine in the replaced build 26.0.1-03
https://prnt.sc/Vm4xcqV6FF0P
Comment 8 pmyadav 2026-05-07 11:27:50 IST
Fixed available in next build
Comment 9 Nandhini 2026-05-07 18:21:36 IST
#1. working as expected
https://prnt.sc/BDsZgcUaNn9n

#3. working as expected
https://prnt.sc/vuVmkmfVCmvX