Hi everyone,
I’m working on an Acumatica Report (Label printing) and I’m trying to achieve a layout where each row contains 2 label items side by side, instead of the default behavior where each item is rendered on its own row.
What I have done so far
-
I created a SQL View that:
-
Expands Sales Order Lines by quantity (1 row per label).
-
Includes barcode, customer part number, MAP price, etc.
-
-
I exposed the SQL View to Generic Inquiry.
-
I built the Report using that GI as the data source.
-
In the Report Designer:
-
I set
detailSection.ColumnCount = 2 -
Adjusted
ColumnSpacing,Height, and layout settings -
Each label (InventoryCD, Price, Barcode) is grouped inside the detail section
-
Expected result
-
Row 1 → Item 1 | Item 2
-
Row 2 → Item 3 | Item 4
-
Row 3 → Item 5 | Item 6
(similar to standard retail barcode label sheets)
Actual result
-
The report still renders 1 item per row, even when
ColumnCount = 2 -
Sometimes only the left column is used
-
Layout becomes inconsistent when data grows
Question
What is the correct / recommended approach in Acumatica to print 2 items per row in a report?
Any best practices or real-world examples would be greatly appreciated
Thanks in advance!
