<?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>
									Acumatica User Group Forums - Recent Topics				            </title>
            <link>https://www.augforums.com/forums/</link>
            <description>Acumatica User Group Forums</description>
            <language>en-US</language>
            <lastBuildDate>Fri, 03 Apr 2026 22:01:07 +0000</lastBuildDate>
            <generator>wpForo</generator>
            <ttl>60</ttl>
							                    <item>
                        <title>Limited or no support from Acumatica?</title>
                        <link>https://www.augforums.com/forums/everything-else/limited-or-no-support-from-acumatica/</link>
                        <pubDate>Tue, 24 Mar 2026 16:46:34 +0000</pubDate>
                        <description><![CDATA[Our VAR, a large, well established and very reputable Acumatica VAR, is telling me that Acumatica has all but shut off VARs from technical assistance. They indicated that as Acumatica has gr...]]></description>
                        <content:encoded><![CDATA[<p>Our VAR, a large, well established and very reputable Acumatica VAR, is telling me that Acumatica has all but shut off VARs from technical assistance. They indicated that as Acumatica has grown they have experienced diminishing support to VARs and essentially can not get direct questions on Acumatica functionality answered by Acumatica now. They are very frustrated since Acumatica previously was one of the best in their view.  </p>
<p>Has anyone else experienced this situation? </p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/"></category>                        <dc:creator>Ed Dolan</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/limited-or-no-support-from-acumatica/</guid>
                    </item>
				                    <item>
                        <title>Upgrade to 2025.2 Custom Report Run Report is missing</title>
                        <link>https://www.augforums.com/forums/acumatica-report-designer/upgrade-to-2025-2-custom-report-run-report-is-missing/</link>
                        <pubDate>Tue, 24 Mar 2026 13:16:13 +0000</pubDate>
                        <description><![CDATA[We just upgraded a client to 2025.2 Modern UI from 2025.1.
Custom reports will only run in Classic UI.
Run report is not available as an option in Modern UI.
I&#039;m logging in as Admin.
Any...]]></description>
                        <content:encoded><![CDATA[<p>We just upgraded a client to 2025.2 Modern UI from 2025.1.</p>
<p>Custom reports will only run in Classic UI.</p>
<p>Run report is not available as an option in Modern UI.</p>
<p>I'm logging in as Admin.</p>
<p>Anyone else having this issue?<br /><br />Please let me know.</p>
<p>&nbsp;</p>
<p>Thank you.</p>
3660
<p>Wendy</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/"></category>                        <dc:creator>wpratley</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-report-designer/upgrade-to-2025-2-custom-report-run-report-is-missing/</guid>
                    </item>
				                    <item>
                        <title>Negative/Credit Inventory Value?</title>
                        <link>https://www.augforums.com/forums/everything-else/negative-credit-inventory-value/</link>
                        <pubDate>Fri, 20 Mar 2026 14:42:08 +0000</pubDate>
                        <description><![CDATA[We are starting a new line of business to recycle construction and demolition debris (divert from landfills). The issue we are having is that we are being paid to take in the material so the...]]></description>
                        <content:encoded><![CDATA[<p>We are starting a new line of business to recycle construction and demolition debris (divert from landfills). The issue we are having is that we are being paid to take in the material so the resulting value of the inventory is a credit(negative). Can Acumatica allow for a credit value of inventory? </p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/"></category>                        <dc:creator>Ed Dolan</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/negative-credit-inventory-value/</guid>
                    </item>
				                    <item>
                        <title>Update the Unit Rate for Existing Project Templates</title>
                        <link>https://www.augforums.com/forums/everything-else/update-the-unit-rate-for-existing-project-templates/</link>
                        <pubDate>Fri, 06 Mar 2026 10:00:31 +0000</pubDate>
                        <description><![CDATA[I want to update the Unit Rate for Existing Project Templates.
Update done to screen ID pm208000, Project Template
Only require update to the Revenue Budget Tab
The result is that the Pro...]]></description>
                        <content:encoded><![CDATA[<p><span>I want to update the Unit Rate for Existing Project Templates.</span></p>
<p><span>Update done to screen ID pm208000, Project Template</span></p>
<p><span>Only require update to the Revenue Budget Tab</span></p>
<p><span>The result is that the Project template is updated with the Revenue budget Project task, but a new Inventory ID is created with the new rate. Hence, I am unable to update the Project Task and Inventory ID combination</span></p>
<p>Example of import scenario. </p>
<p>&nbsp;</p>
<p><span>Error on import: </span></p>
<p>Violation of PRIMARY KEY constraint 'PMBudget_PK'. Cannot insert duplicate key in object 'dbo.PMBudget'. </p>
<p>Any suggestions?</p>
3651
<p><span> </span></p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/"></category>                        <dc:creator>Retha</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/update-the-unit-rate-for-existing-project-templates/</guid>
                    </item>
				                    <item>
                        <title>Tax on Inventory Transfer</title>
                        <link>https://www.augforums.com/forums/acumatica-accounting/tax-on-inventory-transfer/</link>
                        <pubDate>Mon, 19 Jan 2026 15:05:46 +0000</pubDate>
                        <description><![CDATA[Our clients are in the Oil &amp; Gas industry. There are scenarios when they do not pay Federal Excise tax at the time of purchase, but later when they actually move the product - pull it fr...]]></description>
                        <content:encoded><![CDATA[<p>Our clients are in the Oil &amp; Gas industry. There are scenarios when they do not pay Federal Excise tax at the time of purchase, but later when they actually move the product - pull it from the Bulk Transfer System in to a truck. Has anyone else dealt with some thing like this?</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/"></category>                        <dc:creator>John Rygielski</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-accounting/tax-on-inventory-transfer/</guid>
                    </item>
				                    <item>
                        <title>Can&#039;t export GI&#039;s to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min</title>
                        <link>https://www.augforums.com/forums/acumatica-generic-inquiries/cant-export-gis-to-excel-that-contain-the-fatrans-dac-after-upgrade-to-2025-r1-in-less-than-25-min/</link>
                        <pubDate>Tue, 13 Jan 2026 06:24:44 +0000</pubDate>
                        <description><![CDATA[Hi,
We have a Fixed Asset Generic Inquiry that combines the GL Posting in the CIP account with the FATran table to show what is reconciled and what isn&#039;t. The report typically has 46K recor...]]></description>
                        <content:encoded><![CDATA[<p>Hi,</p>
<p>We have a Fixed Asset Generic Inquiry that combines the GL Posting in the CIP account with the FATran table to show what is reconciled and what isn't. The report typically has 46K records. Prior to upgrading to 2025 R1 it took a minute or so to export to excel, but now takes 25+ min or dies trying.</p>
<p>Has anyone else run into export issues after the 2025 R1 Upgrade? If so, how was it reconciled? We sent it to our VAR and they sent it to Acumatica. Acumatica says it works fine for them (30 seconds.)</p>
<p>Thanks,</p>
<p>Brynn</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/"></category>                        <dc:creator>Brynn Rutherford</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-generic-inquiries/cant-export-gis-to-excel-that-contain-the-fatrans-dac-after-upgrade-to-2025-r1-in-less-than-25-min/</guid>
                    </item>
				                    <item>
                        <title>Invoice subreport for line-level tax breakdown not tieing to taxes subtotal</title>
                        <link>https://www.augforums.com/forums/acumatica-report-designer/invoice-subreport-for-line-level-tax-breakdown-not-tieing-to-taxes-subtotal/</link>
                        <pubDate>Fri, 05 Dec 2025 15:03:18 +0000</pubDate>
                        <description><![CDATA[We have a customer with a modified SO invoice form that includes a subreport based on ARTax table. It generally works well but occasionally has rounding differences because the main report s...]]></description>
                        <content:encoded><![CDATA[<p>We have a customer with a modified SO invoice form that includes a subreport based on ARTax table. It generally works well but occasionally has rounding differences because the main report shows subtotals by line.  The tax for the subtotal ties to the breakdown of the tax subreport, but the total of those subtotals do not tie to the main invoice tax total.  In the screenshot here, the red outlined areas show the issue.  I added a calculated field (outlined in blue) to display the subreports line-level taxes more detailed, which reduced the frequency of the issue, but it still happens occasionally.  Has anyone dealt with anything like this?  Our current workarounds include changing the invoice's main tax (in the invoice subtotal section) to be a sum of all the subreport's taxes, and when customer pay the invoice, just writing off the difference (or scheduling an automated write-off).  Or manually adding a non-printing line to force the tax subtotal to match, but that would still leave the printed invoice inaccurate.  </p>
<p>All ideas welcome and appreciated!</p>
3649]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/"></category>                        <dc:creator>Rob Neal</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-report-designer/invoice-subreport-for-line-level-tax-breakdown-not-tieing-to-taxes-subtotal/</guid>
                    </item>
				                    <item>
                        <title>How to make Customer Class ID available in Business Events for AR302000 (Payments and Applications)</title>
                        <link>https://www.augforums.com/forums/everything-else/how-to-make-customer-class-id-available-in-business-events-for-ar302000-payments-and-applications/</link>
                        <pubDate>Mon, 08 Sep 2025 14:49:47 +0000</pubDate>
                        <description><![CDATA[Hi everyone,
I’m trying to create a Business Event for the Payments and Applications screen (AR302000) in Acumatica, and I need to use Customer Class ID as a trigger/filter. Here’s my situa...]]></description>
                        <content:encoded><![CDATA[<p data-start="327" data-end="341">Hi everyone,</p>
<p data-start="343" data-end="538">I’m trying to create a <strong data-start="366" data-end="384">Business Event</strong> for the <strong data-start="393" data-end="422">Payments and Applications</strong> screen (AR302000) in Acumatica, and I need to use <strong data-start="473" data-end="494">Customer Class ID</strong> as a trigger/filter. Here’s my situation:</p>
<ol data-start="540" data-end="2316">
<li data-start="540" data-end="1093">
<p data-start="543" data-end="563"><strong data-start="543" data-end="561">Current setup:</strong></p>
<ul data-start="567" data-end="681">
<li data-start="567" data-end="681">
<p data-start="569" data-end="681">I extended the <strong data-start="584" data-end="601">ARPayment DAC</strong> with a runtime-only field (PXFormula) to retrieve <code data-start="652" data-end="678">Customer.CustomerClassID</code>:</p>
</li>
</ul>
<div class="contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary">
<div class="sticky top-9">
<div class="absolute end-0 bottom-0 flex h-9 items-center pe-2">
<div class="bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs"> </div>
</div>
</div>
<div class="overflow-y-auto p-4" dir="ltr"><code class="whitespace-pre! language-csharp"><span>


<span class="hljs-keyword">public</span> <span class="hljs-built_in">string</span> UsrCustomerClassID { <span class="hljs-keyword">get</span>; <span class="hljs-keyword">set</span>; }
</span></code></div>
</div>
<ul data-start="944" data-end="1093">
<li data-start="944" data-end="1007">
<p data-start="946" data-end="1007">The field shows up in <strong data-start="968" data-end="983">DAC Browser</strong> under <code data-start="990" data-end="1004">ARPaymentExt</code>.</p>
</li>
<li data-start="1011" data-end="1093">
<p data-start="1013" data-end="1093">It works at runtime in the UI, and I can see the correct value when debugging.</p>
</li>
</ul>
</li>
<li data-start="1095" data-end="1624">
<p data-start="1098" data-end="1112"><strong data-start="1098" data-end="1110">Problem:</strong></p>
<ul data-start="1116" data-end="1624">
<li data-start="1116" data-end="1264">
<p data-start="1118" data-end="1264">In <strong data-start="1121" data-end="1140">Business Events</strong>, when I select the <strong data-start="1160" data-end="1192">Table = Document (ARPayment)</strong>, my field <code data-start="1203" data-end="1223">UsrCustomerClassID</code> does <strong data-start="1229" data-end="1243">not appear</strong> in the field list.</p>
</li>
<li data-start="1268" data-end="1413">
<p data-start="1270" data-end="1413">I understand this is because the field is <strong data-start="1312" data-end="1337">calculated at runtime</strong> and <strong data-start="1342" data-end="1376">does not exist in the database</strong>, so the BE engine cannot query it.</p>
</li>
<li data-start="1417" data-end="1624">
<p data-start="1419" data-end="1476">Attempts to use <code data-start="1435" data-end="1449"></code> failed with errors like:</p>
<div class="contain-inline-size rounded-2xl relative bg-token-sidebar-surface-primary">
<div class="sticky top-9">
<div class="absolute end-0 bottom-0 flex h-9 items-center pe-2">
<div class="bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs"> </div>
</div>
</div>
<div class="overflow-y-auto p-4" dir="ltr"><code class="whitespace-pre!"><span><span class="hljs-literal">Unknown</span> <span class="hljs-keyword">column</span> <span class="hljs-string">'ARPayment_ARPayment.CustomerID'</span> <span class="hljs-keyword">in</span> <span class="hljs-string">'where clause'</span>
</span></code></div>
</div>
<p data-start="1573" data-end="1624">due to table aliasing issues in the BE SQL query.</p>
</li>
</ul>
</li>
</ol>
<p>&nbsp;</p>
<p data-start="2050" data-end="2211">Has anyone found a <strong data-start="2069" data-end="2096">supported or easier way</strong> to make <code data-start="2105" data-end="2122">CustomerClassID</code> accessible in Business Events for ARPayment (AR302000) <strong data-start="2178" data-end="2208">without adding a DB column</strong>?</p>
<p data-start="2217" data-end="2316">Is there a workaround to either expose calculated fields or join Customer table in the BE engine?</p>
3641
<p>&nbsp;</p>
<p>Thanks</p>
<p>Jacky</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/"></category>                        <dc:creator>Jacky Mao</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/how-to-make-customer-class-id-available-in-business-events-for-ar302000-payments-and-applications/</guid>
                    </item>
				                    <item>
                        <title>Feeling Stuck on Making a Sandbox of our Database</title>
                        <link>https://www.augforums.com/forums/everything-else/feeling-stuck-on-making-a-sandbox-of-our-database/</link>
                        <pubDate>Fri, 22 Aug 2025 15:50:35 +0000</pubDate>
                        <description><![CDATA[Hi all! Hope your day is going well!
It&#039;s finally the slow season at my company and I wanna jump into the long list of customization projects that have been put on hold. There&#039;s only one is...]]></description>
                        <content:encoded><![CDATA[<p>Hi all! Hope your day is going well!</p>
<p>It's finally the slow season at my company and I wanna jump into the long list of customization projects that have been put on hold. There's only one issue: <br /><br />I can't get our information into any of the DB's I create through the Acumatica ERP Configuration Wizard due to the Snapshot being 6GB and the limit of 1.5 for restoring snapshots in the created DB. <br /><br />I found this post from four years ago: https://community.acumatica.com/configuration-and-installation-114/import-snapshot-into-test-environment-6303?postid=128322#post128322<br /><br />But I don't understand how I would Backup the DB and the Restore it this way due to not being familiar with those processes listed.  <br /><br />Could someone help with a more dumbed down version of how to get my Company's data into a sandbox instance? I don't care what method so long as it works reliably. </p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/"></category>                        <dc:creator>Lunar Windbloom</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/feeling-stuck-on-making-a-sandbox-of-our-database/</guid>
                    </item>
				                    <item>
                        <title>Sums accruing from both manufacturing and Payroll</title>
                        <link>https://www.augforums.com/forums/acumatica-accounting/sums-accruing-from-both-manufacturing-and-payroll/</link>
                        <pubDate>Thu, 07 Aug 2025 23:00:08 +0000</pubDate>
                        <description><![CDATA[Hi all,
Would anyone be familiar with why our balance sheet debits the value from both the manufacturing module as well as the payroll module?
We are currently adjusting the manufacturing ...]]></description>
                        <content:encoded><![CDATA[<p>Hi all,</p>
<p>Would anyone be familiar with why our balance sheet debits the value from both the manufacturing module as well as the payroll module?</p>
<p>We are currently adjusting the manufacturing data out via journal entries so that it does not double up on the P&amp;L, we still want to capture this data so we can check the variance.</p>
<p>&nbsp;</p>
<p>Is it as simple as creating different types of accounts and diverting via there or is there a setting I am missing?</p>
3639
<p>Thanks in advance!</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/"></category>                        <dc:creator>Dominic Boullé</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-accounting/sums-accruing-from-both-manufacturing-and-payroll/</guid>
                    </item>
							        </channel>
        </rss>
		