<?xml version="1.0" encoding="UTF-8"?>        <rss version="2.0"
             xmlns:atom="http://www.w3.org/2005/Atom"
             xmlns:dc="http://purl.org/dc/elements/1.1/"
             xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
             xmlns:admin="http://webns.net/mvcb/"
             xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
             xmlns:content="http://purl.org/rss/1.0/modules/content/">
        <channel>
            <title>
									Printing Product Labels from Purchase Receipt - Acumatica Report Designer				            </title>
            <link>https://www.augforums.com/forums/acumatica-report-designer/printing-product-labels-from-purchase-receipt/</link>
            <description>Acumatica User Group Forums</description>
            <language>en-US</language>
            <lastBuildDate>Sat, 14 Nov 2026 02:25:03 +0000</lastBuildDate>
            <generator>wpForo</generator>
            <ttl>60</ttl>
							                    <item>
                        <title>RE: Printing Product Labels from Purchase Receipt</title>
                        <link>https://www.augforums.com/forums/acumatica-report-designer/printing-product-labels-from-purchase-receipt/#post-11613</link>
                        <pubDate>Tue, 09 Sep 2025 16:40:56 +0000</pubDate>
                        <description><![CDATA[I have read the article on the How to print multiple product labels based on a line item- Very nice. Question will this also work for the scenario:
Batch Labels to be able to split qty’s as...]]></description>
                        <content:encoded><![CDATA[<p>I have read the article on the <strong>How to print multiple product labels based on a line item- Very nice. Question will this also work for the scenario:</strong></p>
<p>Batch Labels to be able to split qty’s as preferred.</p>
<p>Example: Qty Received = 1000</p>
<p>Will be packaged in packages of 20 x items.</p>
<p>Conclusion:  50 x labels to be printed indicating 20 x per label.</p>
<p>&nbsp;</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-report-designer/">Acumatica Report Designer</category>                        <dc:creator>Retha</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-report-designer/printing-product-labels-from-purchase-receipt/#post-11613</guid>
                    </item>
				                    <item>
                        <title>RE: Printing Product Labels from Purchase Receipt</title>
                        <link>https://www.augforums.com/forums/acumatica-report-designer/printing-product-labels-from-purchase-receipt/#post-8653</link>
                        <pubDate>Fri, 23 Apr 2021 17:00:28 +0000</pubDate>
                        <description><![CDATA[@lauraj46 just solved this without a Customization Project and solved it in style. It&#039;s a brilliantly creative solution that is simple and clean. I&#039;m adding it to this Discussion Topic on he...]]></description>
                        <content:encoded><![CDATA[<p>@<span>lauraj46</span> just solved this without a Customization Project and solved it in style. It's a brilliantly creative solution that is simple and clean. I'm adding it to this Discussion Topic on her behalf:</p>
<p><strong><a href="https://www.linkedin.com/pulse/acumatica-tips-tricks-how-print-multiple-product-labels-laura-jaffe" target="true">https://www.linkedin.com/pulse/acumatica-tips-tricks-how-print-multiple-product-labels-laura-jaffe</a></strong></p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-report-designer/">Acumatica Report Designer</category>                        <dc:creator>Tim Rodman</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-report-designer/printing-product-labels-from-purchase-receipt/#post-8653</guid>
                    </item>
				                    <item>
                        <title>RE: Printing Product Labels from Purchase Receipt</title>
                        <link>https://www.augforums.com/forums/acumatica-report-designer/printing-product-labels-from-purchase-receipt/#post-3895</link>
                        <pubDate>Wed, 20 Mar 2019 00:51:18 +0000</pubDate>
                        <description><![CDATA[I just noticed this on GitHub which might be pretty useful for printing multiple product labels]]></description>
                        <content:encoded><![CDATA[<p>I just noticed this on GitHub which might be pretty useful for printing multiple product labels:</p><p><strong><a href="https://github.com/Acumatica/Acumatica-InventoryLabelReportPerQty" target="true">https://github.com/Acumatica/Acumatica-InventoryLabelReportPerQty</a></strong></p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-report-designer/">Acumatica Report Designer</category>                        <dc:creator>Tim Rodman</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-report-designer/printing-product-labels-from-purchase-receipt/#post-3895</guid>
                    </item>
				                    <item>
                        <title>RE: Printing Product Labels from Purchase Receipt</title>
                        <link>https://www.augforums.com/forums/acumatica-report-designer/printing-product-labels-from-purchase-receipt/#post-447</link>
                        <pubDate>Wed, 20 Sep 2017 12:31:54 +0000</pubDate>
                        <description><![CDATA[I had a similar request from a client who wanted to print price labels for orders, but wanted to print a label for each item so we had to multiply the item by the quantity.  I did this with ...]]></description>
                        <content:encoded><![CDATA[<p>I had a similar request from a client who wanted to print price labels for orders, but wanted to print a label for each item so we had to multiply the item by the quantity.  I did this with a customization, as Tim has suggested.  The basic idea is you need a SQL numbers table (google it) to multiply out your quantity and produce the number of lines needed.  Here is a brief overview of what I did, but if it doesn't make sense I may be able to put together a customization.</p><p>1. Create a numbers table in SQL.  This is a simple table that has a number column that counts up.  The table below allows you to work with quantities up to 1000.  If you have larger order quantities then increment the number</p><p>SELECT TOP 1000 IDENTITY(int,1,1) AS Number INTO NumbersTable FROM sys.objects s1 CROSS JOIN sys.objects s2 ALTER TABLE NumbersTable ADD CONSTRAINT PK_NumbersTable PRIMARY KEY CLUSTERED (Number)<br /><br />2. Create a SQL view to pull together the data based on the SQL select below. I believe this will work, but it may need some tweaking. I also use CompanyID &gt; 1 to limit the view to real companies and not snapshots.</p><p><br />SELECT CompanyID,Number,ShipmentNbr,LineNbr,SplitLineNbr,InventoryID,LotSerialNbr,ExpireDate FROM SOShipLineSplit INNER JOIN NumbersTable ON Number &lt;= SOShipLineSplit.Qty WHERE CompanyID &gt; 1</p><p>3. Create a new customization package and create your new DAC based off your view in Step 2.</p><p>4. Publish and then the DAC will be accessible to the report.</p><p>Thanks,</p><p>Kurt</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-report-designer/">Acumatica Report Designer</category>                        <dc:creator>Kurt Bauer</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-report-designer/printing-product-labels-from-purchase-receipt/#post-447</guid>
                    </item>
				                    <item>
                        <title>RE: Printing Product Labels from Purchase Receipt</title>
                        <link>https://www.augforums.com/forums/acumatica-report-designer/printing-product-labels-from-purchase-receipt/#post-422</link>
                        <pubDate>Wed, 13 Sep 2017 02:50:35 +0000</pubDate>
                        <description><![CDATA[It&#039;s a good question. I&#039;m not sure how to do it with customization. The problem is that Report Designer will only generate multiple rows if there are multiple rows in the database table. But...]]></description>
                        <content:encoded><![CDATA[<p>It's a good question. I'm not sure how to do it with customization. The problem is that Report Designer will only generate multiple rows if there are multiple rows in the database table. But 10 units of one lot or not lots will all be one row in the table with a value of 10 in the quantity column. We need a way to turn that one row into 10 rows. I'm not sure how to do it without doing some kind of DAC customization.</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-report-designer/">Acumatica Report Designer</category>                        <dc:creator>Tim Rodman</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-report-designer/printing-product-labels-from-purchase-receipt/#post-422</guid>
                    </item>
				                    <item>
                        <title>Printing Product Labels from Purchase Receipt</title>
                        <link>https://www.augforums.com/forums/acumatica-report-designer/printing-product-labels-from-purchase-receipt/#post-419</link>
                        <pubDate>Tue, 12 Sep 2017 21:36:37 +0000</pubDate>
                        <description><![CDATA[I have a report design that prints a product barcode, product code, expiry date, and lot number. This works fine for single items or items with unique batches/serials. But I would like it to...]]></description>
                        <content:encoded><![CDATA[<p>I have a report design that prints a product barcode, product code, expiry date, and lot number. This works fine for single items or items with unique batches/serials. But I would like it to print 10 labels if 10 units are receipted on the same batch.</p><p>Any idea on report configuration to achieve this?</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-report-designer/">Acumatica Report Designer</category>                        <dc:creator>Nwood</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-report-designer/printing-product-labels-from-purchase-receipt/#post-419</guid>
                    </item>
							        </channel>
        </rss>
		