<?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>
									Everything Else - Acumatica User Group Forums				            </title>
            <link>https://www.augforums.com/forums/everything-else/</link>
            <description>Acumatica User Group Forums</description>
            <language>en-US</language>
            <lastBuildDate>Wed, 11 Nov 2026 20:20:01 +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/everything-else/">Everything Else</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>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/everything-else/">Everything Else</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/everything-else/">Everything Else</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>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/everything-else/">Everything Else</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/everything-else/">Everything Else</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>What Triggers a Customization to need a Restart?</title>
                        <link>https://www.augforums.com/forums/everything-else/what-triggers-a-customization-to-need-a-restart/</link>
                        <pubDate>Thu, 07 Aug 2025 17:54:27 +0000</pubDate>
                        <description><![CDATA[It seems like every technical question I ask on the official Acumatica forums gets met with crickets, and I know everybody here is smarter than I am. :)
Is there any rule of thumb of what w...]]></description>
                        <content:encoded><![CDATA[<p>It seems like every technical question I ask on the official Acumatica forums gets met with crickets, and I know everybody here is smarter than I am. :)</p>
<p>Is there any rule of thumb of what within a customization that will cause it to trigger a restart, vs. publishing in real time?  I have read that there is a web.config option (we're hosted, so I don't have direct access) that will cause any Publish to cause a restart.  </p>
<p>I'm running into a really strange issue and Acumatica support hasn't been able to help out at all.  I have a few customizations that I'm attempting to roll out updates for.  None of them are invasive; I have three standard packages that I use in our business for:</p>
<p>* User Fields (adding to database, and if it's a basic DAC addition, adding to the DAC)</p>
<p>* Code (75% of this is more advanced DAC additions, like tying the schema of a user field to a selector)</p>
<p>* UI Changes, such as sidepanels on forms, adding user fields to forms, updating workflows, etc.</p>
<p>This week I tried publishing these, and after it completed and I did a restart in the Apply Updates screen, my Process node was not accessible (for the most part--I could sign in, and get the banner at the top of the screen, but no screens would open and no scheduled jobs would run).  I backed out the customization updates and the process node was accessible again.</p>
<p>Last night I tried publishing one of these at a time (in the order above), and the Process node was accessible up until the final one.  Backing out the final customization didn't make it accessible, but when I backed out the Code package it became accessible again.  My theory is that, if a customization tells everything behind the scenes "You need to restart", it makes the process node accessible, and the UI Changes customization doesn't trigger that.  I'm thinking of putting some sort of code change in the UI Changes package to see if that triggers the "You need to restart" rule, but that's just a guess.</p>
<p>I will say that this update to the UI Changes package is the most complex I've done; I've started doing more in the Workflow editor to do things like set default values on fields when orders are created, released from hold, etc.  But all of those changes test in our sandbox cleanly and even work on the main front end node in Production.</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/everything-else/">Everything Else</category>                        <dc:creator>Tim Laird</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/what-triggers-a-customization-to-need-a-restart/</guid>
                    </item>
				                    <item>
                        <title>Conditionally create new Stock Items&#039; cross-reference record with an import scenario</title>
                        <link>https://www.augforums.com/forums/everything-else/conditionally-create-new-stock-items-cross-reference-record-with-an-import-scenario/</link>
                        <pubDate>Thu, 24 Jul 2025 17:40:23 +0000</pubDate>
                        <description><![CDATA[I&#039;m preparing for a large conversion of Stock Items. Mostly to save on transaction count, I&#039;m looking to do many things all during the initial import, such as adding Cross Reference records ...]]></description>
                        <content:encoded><![CDATA[<p>I'm preparing for a large conversion of Stock Items. Mostly to save on transaction count, I'm looking to do many things all during the initial import, such as adding Cross Reference records for the Vendor Part Number. Unfortunately, not every Stock Item to be created has a Vendor Part Number and, when this is the case, the import will error saying 'Alternate ID is required' and the whole record will fail. I'd prefer to avoid multiple different import scenarios.</p>
<p><br /><br />What I would <em>like</em> is to have a &lt;Line Number&gt; statement to conditionally delete the cross-reference record if the Alternate ID is empty, but I don't know of a way to recreate the Delete Row action (usually &lt;Line Number&gt; =-2) when there is a formula involved. If anyone knows how to accomplish this, I'd appreciate your sharing.<br /><br />What I <em>don't like </em>is the solution I discovered:</p>
3638
<p>My initial idea was to add another blank record after adding the potentially erroneous record. Then it would selectively delete either that blank record if the original record won't cause an error, or the original if it would result in an error. Blank records seem to delete themselves if they aren't committed, so I'd either end up with nothing or a valid Vendor Part Number record. Now, the above import scenario works, but not how I expected and only when there aren't any existing cross-reference records.<br />&lt;Line Number&gt; | =iif(=null, -1, -2)<br />This line will either select the last record or second to last record based on if there's an Alternate ID. I thought that I would need the condition reversed, expecting the blank record to be after the populated one. But since I never actually made an initial record, I don't know what order these records are being sorted into. That initial record seems to be existing in a weird state where I never explicitly added a new record, but populated something.</p>
<p>&nbsp;</p>
<p>Can anyone explain this eldritch import scenario situation that I have stumbled upon? I'd like to be able to generalize this so that it can be used when there are existing records to conditionally add on more. The main issue is that if there is an existing record, say, a UPC, then that UPC gets overwritten.</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/everything-else/">Everything Else</category>                        <dc:creator>Paul Lambert</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/conditionally-create-new-stock-items-cross-reference-record-with-an-import-scenario/</guid>
                    </item>
				                    <item>
                        <title>API &amp; Customer Discounts</title>
                        <link>https://www.augforums.com/forums/everything-else/api-customer-discounts/</link>
                        <pubDate>Wed, 28 May 2025 16:12:01 +0000</pubDate>
                        <description><![CDATA[I am creating invoices (SO303000) via REST API.  I am successfully adding lines to the invoice but the Document Level discounts are not being calculated nor added to the &quot;Discounts&quot; tab of t...]]></description>
                        <content:encoded><![CDATA[<p>I am creating invoices (SO303000) via REST API.  I am successfully adding lines to the invoice but the Document Level discounts are not being calculated nor added to the "Discounts" tab of the SOInvoice.  Any recommendation on firing the discountengine after the last line is added?</p>
<p>&nbsp;</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/everything-else/">Everything Else</category>                        <dc:creator>Scott Stephenson</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/api-customer-discounts/</guid>
                    </item>
				                    <item>
                        <title>Hello Everyone ,</title>
                        <link>https://www.augforums.com/forums/everything-else/hello-everyone/</link>
                        <pubDate>Wed, 21 May 2025 18:18:25 +0000</pubDate>
                        <description><![CDATA[Hello Everyone, I am an Acumatica Consultant and actively looking for part-time or full-time roles. If you or anyone you know have Acumatica opportunities , please reach me out at saravana40...]]></description>
                        <content:encoded><![CDATA[<p>Hello Everyone, I am an Acumatica Consultant and actively looking for part-time or full-time roles. If you or anyone you know have Acumatica opportunities , please reach me out at saravana4098@gmail.com or on my LinkedIn profile. Thank you for you kind attention.</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/everything-else/">Everything Else</category>                        <dc:creator>Saravana Kumar</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/hello-everyone/</guid>
                    </item>
				                    <item>
                        <title>Python Script Ignoring Report Global Sorting in Acumatica // Returning Incorrect Values from Endpoints</title>
                        <link>https://www.augforums.com/forums/everything-else/python-script-ignoring-report-global-sorting-in-acumatica-returning-incorrect-values-from-endpoints/</link>
                        <pubDate>Wed, 07 May 2025 15:49:16 +0000</pubDate>
                        <description><![CDATA[Here’s some more color:

Using three separate reports that are based off of GIs. These reports in Acumatica are being called to via endpoint to get the correct values (called via python sc...]]></description>
                        <content:encoded><![CDATA[<p>Here’s some more color:</p>
<ul>
<li>Using three separate reports that are based off of GIs. These reports in Acumatica are being called to via endpoint to get the correct values (called via python script)</li>
<li>In of the reports, there is global sorting applied in the report. This is being ignored sporadically across the report.</li>
<li>When comparing the python generated excel report to the exports from the GIs and the Acumatica reports, the Acumatica reports are returning the correct values.</li>
<li>The generated report is not honoring the sorting logic from the Acumatica report in some cases for each SKU, for some but not others and it seems when there are multiple lots with different values, that it's not picking the lowest value (as it does in Acunmatica report). </li>
<li>It’s not for every SKU, just sporadic SKUs when there are multiple lots with different test results/THC values</li>
</ul>
Is anyone familiar with why the python script would sporadically ignore the applied global sort in the generated excel file? Does anyone have any familiarlity with this? Asking or a friend or a life line here. Mycoworker has put a lot of energy and time into this report, and this was found in the final stages of QA.]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/everything-else/">Everything Else</category>                        <dc:creator>Ellie C.</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/everything-else/python-script-ignoring-report-global-sorting-in-acumatica-returning-incorrect-values-from-endpoints/</guid>
                    </item>
							        </channel>
        </rss>
		