Bug 21013

Summary:	[Report- Item]- Inconsistent Item Code Position and Line Formatting in Item Report
Product:	ML DB 64-bit Mac 2027	Reporter:	Nandhini <bnandhini>
Component:	Item Reports	Assignee:	Nandhini <bnandhini>
Status:	RE-OPEN ---	QA Contact:
Severity:	Minor
Priority:	Low	CC:	pmyadav
Version:	27.0.0 Ver-03
Target Milestone:	---
Hardware:	MAC
OS:	All

Description Nandhini 2026-08-14 17:55:28 IST

Complete required details for items with item codes.
Create and save multiple purchases and invoices.
Enable Show Code Field on Report in View Preferences.
Open the Item Report.
Select Inventory Current and Inventory Selected.
Generate the available report formats.
Compare the item code position and item details across the formats.

Issue#1: The item code should appear in the same position across all available report formats. 
Screenshot: https://prnt.sc/40xhRLZNWSWd

Issue #2: Each item detail in the Text file should be displayed on a separate single line.
screenshot: 
https://drive.google.com/file/d/1OeH9VkyVmXN2px2m5AVx0Z4xe2BWVA-P/view?usp=sharing

Comment 1 Bhavani 2026-09-09 17:31:15 IST

Fixed, Available in next build

Comment 2 Bhavani 2026-09-09 17:31:15 IST

Fixed, Available in next build

Comment 3 Nandhini 2026-09-11 18:37:06 IST

#1: For the view, print is showing in the first column; it's fine
CSV file - it's showing in the 2nd column, along with the item name in the 1st column.
Text file - In a single line, the item's respective details should be displayed
Screenshot: https://prnt.sc/Beh_GBaMg7Sk

#2. By selecting the inventory-selected date in the CSV and text files, extra zeros are shown before the total amounts row.
Screenshot: https://prnt.sc/69sE8Ouznqt4

Comment 4 Bhavani 2026-09-15 19:46:58 IST

Fixed, Available in next build

Comment 5 Nandhini 2026-09-16 16:29:01 IST

#1. For the current inventory, in the text and CSV file, the code field appears separately in the first column, but in the second column it appears alongside the item name. Please make this change so the format is consistent across all formats.
Screenshot: https://prnt.sc/SVGv-E7cQw9V

#2. Still, By selecting the inventory-selected date in the CSV and text files, extra zeros are shown before the total amounts row.
Screenshot: https://prnt.sc/0fI2C-Q1NNUy

Comment 6 Nandhini 2026-09-17 17:14:41 IST

#1. For the current inventory, in the text and CSV file, the code field appears separately in the first column, but in the second column it appears alongside the item name. Please make this change so the format is consistent across all formats.
Screenshot: https://prnt.sc/SVGv-E7cQw9V

#2. Still, by selecting the inventory-selected date in the CSV and text files, extra zeros are shown before the total amounts row.
Screenshot: https://prnt.sc/0fI2C-Q1NNUy

#3. Select the price list option:
With code selection in preferences: In the text and CSV files, the item name and code are shown together; in the CSV code column, displaying with empty.
Without selection: In the text and CSV files, the code column should be first, then the item name column, as per all report types.
Screenshot: without code
https://drive.google.com/file/d/1bzNIEhWocQEk0EUwCI-2JaBGRnLruZt9/view?usp=sharing
Screenshot with code
https://drive.google.com/file/d/1mA8ZgBsGfyanc-AqoSrLsH50Fjt2uvNt/view?usp=sharing