| Summary: | [Report- Item]- Incorrect Data Formatting and Calculations in Open Item Report When Generating TXT and CSV Files | ||
|---|---|---|---|
| Product: | ML_DB 64-bit Mac | Reporter: | Nandhini <bnandhini> |
| Component: | Item Reports | Assignee: | Nandhini <bnandhini> |
| Status: | CLOSED --- | ||
| Severity: | Major | CC: | dharisha, ksagarika, pmyadav |
| Priority: | Medium | ||
| Version: | 2026-14.0.22 + 26.0.1 Ver 03 | ||
| Hardware: | MAC | ||
| OS: | All | ||
|
Description
Nandhini
2026-04-14 14:57:17 IST
Fixed, Available in next build 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 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 fixed available in next build #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 #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 #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 Fixed available in next build #1. working as expected https://prnt.sc/BDsZgcUaNn9n #3. working as expected https://prnt.sc/vuVmkmfVCmvX |