19125 2026-04-14 14:57:17 +0530 [Report- Item]- Incorrect Data Formatting and Calculations in Open Item Report When Generating TXT and CSV Files 2026-05-07 18:21:36 +0530 1 1 1 Unclassified ML_DB 64-bit Mac Item Reports 2026-14.0.22 + 26.0.1 Ver 03 MAC All CLOSED Medium Major --- 1 bnandhini bnandhini dharisha ksagarika pmyadav oldest_to_newest 72849 0 bnandhini 2026-04-14 14:57:17 +0530 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 73533 1 btadepalli 2026-04-23 16:09:11 +0530 Fixed, Available in next build 73859 2 bnandhini 2026-04-27 18:36:20 +0530 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 73942 3 bnandhini 2026-04-29 11:23:57 +0530 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 74079 4 pmyadav 2026-05-01 13:42:14 +0530 fixed available in next build 74340 5 bnandhini 2026-05-05 16:58:52 +0530 #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 74361 6 btadepalli 2026-05-05 23:22:18 +0530 #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 74442 7 bnandhini 2026-05-07 10:57:23 +0530 #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 74452 8 pmyadav 2026-05-07 11:27:50 +0530 Fixed available in next build 74504 9 bnandhini 2026-05-07 18:21:36 +0530 #1. working as expected https://prnt.sc/BDsZgcUaNn9n #3. working as expected https://prnt.sc/vuVmkmfVCmvX