Solved

I would like to get a clarification regarding inventory transaction data in Acumatica. We are currently trying to identify whether there is a single table or a recommended data source that can be used to retrieve all types of inventory transactions, such as inventory issues, receipts, transfers, and adjustments, in a unified manner.From our understanding, tables like INTran, INRegister, and INTranSplit are involved in storing inventory-related data. However, we would like to confirm the following:Is INTran the correct and complete source to capture all inventory movements (issues, receipts, transfers, adjustments)? Are there any additional tables or views that should be considered to ensure no transactions are missed? Is there a recommended approach (or standard Generic Inquiry structure) to retrieve all inventory transactions accurately for reporting purposes? Are there any specific conditions, flags, or transaction types we should consider when filtering this data?Additionally, we ha

When importing historic balances into the GL, one was imported into an Asset account with an incorrect branch.The asset account was subsequently used for a cash account and, after recalculating the balance, it was discovered that the offending transaction did not appear in the reconciliation.I am now unable to reclassify or journal the transaction out and replace it with one in the correct branch because the branch does not match the branch associated with the Cash Account.  We have already imported transactions into the Cash account so I can’t delete it and start again either.  It would appear that I am stuck between a rock and a hard place.Does anyone have any bright ideas on how to resolve or work around this? Thanks in advance…   John

In Short: The issue I am having is upgrading in Trial Mode. I am wondering if my account just does not have access to the “Download Package” function (because I don’t have an account). Which would be an easy answer, but not good news for my pre-implementation testing scenario.Longer version for anyone interested in offering reply. I have been reviewing Acumatica software...in Trial Mode (pre-implementation). I have installed locally from Open University provided software. I have gone through setup, import data, set up some minor customizations (new columns that move data from SO to SO.Invoice...and created those same columns in AR.Invoice for customized reporting...I set up and tested the custom reporting...systems works great! But I wanted to test going through upgrades. I Snapshot’d the tenant, created new instance (sandbox), customizations tested fine, I turned off the customizations in the tenant, went to maintenance mode, downloaded the package in Apply Updates, and attempted to i

I'm working on creating a report that contains all of the contact information for the other trades we typically coordinate with onsite. Information would be found in the Construction module under Projects and the Contacts tab. I'm having trouble getting the coding to pull the correct information. Right now, it's pulling in a random contact that isn't associated with the project I am using for testing. I'm sure there is a table or relation that I am missing, but every time I make a change it gives me a new error. The other thing is each project could have several contacts associated with it that I would need to break out per role on the report. I would think that I could add some type of if/then statement for each role to pull to a different designated location on the report, but want to make sure this is even feasible before I invest too much time into trial and error.Element Properties for Contacts:Current Relationships: Current String: =[ProjectContact.ContactId_Contact_displayName] 

Hello, How can I solve this error when trying to create a generic inquiry and display the site, but encountering the message: "generic inquiry This field will not be displayed for the current user because the user has insufficient access rights or the required feature is disabled"? Thank you in advance.

I upgraded my system from 25R1 to 25R2, and I have a snapshot of the old 25R1 system.In 25R1, on the Invoice and Memos screen, when I printed a report, it used the report ID from the Customer Class.Now, in the new version, it always uses the standard ‘AR641000’ and does not pick up any other report.I verified that my custom report ‘AR641001’ works correctly. It also works properly when printing from the SO Invoice screen.

I have a scenario where the several pieces of equipment that need to be serviced and all the equipments are company owned and all in company location not in customer location. We have created these machines as Equipment records. However, when creating a Service Order, I am able to select this Equipment anywhere in the service Order.Is it possible to perform service for company-owned equipment through a Service Order and Appointment?

Hello,             Previously, AP505000 (process payments/print checks) are sorted by Reference Nbr. field. Now, we find in 2024R2 ,it changed to sort by Vendor ID/Vendor Name.             Is there a way to overwrite the default sort ,can we change back to sort by “Reference Nbr.”?             I prefer the way without code modification, that just using the tool Acumatica provided. But, if code customization is a must, please help.

Why does Service Time get deleted from the log when reopened? Specifically, when a person other than the individual assigned to the appointment uncloses or reopens the appointment. Is there a way to keep this from occurring?

Hello Community,Have a small issue - when trying to send an AR invoice we have placed 2 email addresses in the Account Email Field under “Additional Account Info”.  The address are separated by a semi colon ;   I cannot change this to a comma, it defaults to a semi.When sending emails, it will only send to the first email and not both emails.  I have found a couple similar issues here:https://community.acumatica.com/distribution-6/send-po-to-multiple-email-addresses-8956?postid=31480#post31480https://community.acumatica.com/distribution-6/sales-order-notifications-not-sending-to-all-emails-listed-to-send-to-7564 I have looked into both of these solutions, however I’m not sure which BUILD is being referred to in thread one.  In thread 2 removing the field in the “TO” field results in an error saying there is no Email address to send the notification to. Hoping someone may have insight?Cheers,​​​​​​​K2

We are considering changing from Shopify POS to Clover.Is anyone using Clover for POS, and if so is there a preference for which 3rd party connector is used?Thank you

I have the following issue with Modern UI:In one package I create a column.In another package I add a field / logic that depends on that column.Everything works fine when I develop Modern UI in Visual Studio — after build, all changes are visible on the screen and work correctly.But when I add Modern UI files into packages and publish them in another instance of Acumatica ERP, I get errors (field/column not found).I understand that this approach is not recommended, but I still need to make it work.Is there any way to handle this scenario? [2026-03-26 14:54:27.199] npm run build failed with output:> screen@0.1.0 build> cross-env node --max_old_space_size=6144 --optimize_for_size --stack_size=6144 --trace-warnings ./node_modules/webpack/bin/webpack -- --env production --env tenant=Company screenIds=AR301000,AR303000,BZ101001,BZ101007,BZ201520,BZ401005,BZ401022,BZ501011,BZ501012,BZ501013,BZ501014,BZ501015,BZ501017,BZ501041,BZ501066,BZ501071,BZIMAGES,CR302000,IN202000,IN202500,IN2030

I am creating a purchase order approval workflow for a client. They previously used Purchase Requests with an approval workflow and are wanting to replace this with Purchase Order approvals.Their Request Approval Workflow conditions are based off Department and $ amount.  Currently it is not possible to setup Purchase Order workflows in the same way, as the Department Entity is not available.Can we add the department field to the Purchase Order header and add the department entity to the Purchase Order workflow?Additionally we would probably get the Purchase Order department field to default to the PO Owner (employee’s) department but they could select any department, as it will not always be the same department as the user who is creating the PO.Has anyone implemented a customisation like this before?

Good day,I wrote the attached WO Import Scenario.  It is said it processed without issue.  However, it not producing the write off document from the scenario.  I think it has to do with the selection/process action not working.Any assistance would be greatly appreciated.Thank you.Evan

There are a built in plug ins for both EasyPost and Ship EngineDoes Acumatica recommend one vs the other ?At one point I thought EasyPost was the go to integration that Acuamtica was developing but I do not see EasyPost set up as part of the Sale Demo...Suggestions?  Only looking at one of these two since the integration is “built in”   

We are adding drawing files for requested customizations to our open Opportunity File.  Once we have the drawing on file, we reach out to the customer for their approval, using create email selecting email template, from the Opportunity file.Is there an easy way to get the file document on the opportunity to be included on the Email being created from the same document, without having to download the file and then import it directly to the email?Surely having to download in order to then turn around and upload to an activity on the same document is not the intending process flow, correct?

I am currently working on printing the Purchase Order in line sequence based on Sort Order instead of Line Number.I attempted to use POLine.SortOrder with ascending sorting in the report; however, the sorting does not appear to be working as expected.Could you please advise if there are any additional configurations required or if there are any limitations with using SortOrder for this purpose?Thank you in advance for your guidance. 

We have a situation where a B2B shopify order gets sync’ed into Acumatica from Shopify.  The order is on terms (IE - Net 30) so no payment records comes with the shopify record.   Shopify order is fulfilled inside Acumatica and Invoice is generated for sales order.  Some time later, customer pays the invoice and invoice is closed in Acumatica but the original order in shopify remains open instead of closed.   Is there a way to close that B2B (Terms) order in shopify when payment is completed in Acumatica?

Hello! The below code is running great in 25R1. It tells the system to look at the UsrQUOTECOST field on SOLine when create a PO through Create Purchase Order. If UsrQUOTECOST is empty, then system should behave the same, if user inputs value in UsrQUOTECOST, then when PO is created, the unit cost field should pull from this udf.The issue I am running into is that when I try to publish this code in a 25R2 tenant, I get the following error: The PX.Objects.PO.POLine FindOrCreatePOLine(PX.Objects.PO.POOrderEntry, PX.Objects.CS.DocumentList`1[PX.Objects.PO.POLine], System.String, PX.Objects.PO.POFixedDemand, SOLineSplit3, FindOrCreatePOLineDelegate) method in the PX.Objects.PO.POCreate_Extension graph extension is marked as [PXOverride], but no original method with this name has been found in PXGraph.And per the 25R2 developer release notes, looks like the FindOrCreatePOLine method was removed. Any ideas around what the alternative method would be to make this code work? Open to any sugges

Hi All,Has anyone successfully used an Import Scenario to automatically convert purchases to Fixed Assets in Acumatica?I have been testing the Convert Purchases to Assets screen with a Business Event + Import Scenario approach. The scenario runs successfully without errors, but no Fixed Asset is created in the end.My understanding is that this screen relies on UI behavior:select the transaction in the top grid the detail line appears in the bottom grid fill in Asset Class and Department mark Create Asset then click ProcessThe reason I am trying to automate this is because I want the FA number to be available immediately when the stock is issued/shipped out. My warehouse team needs to attach the FA code to the item at the time of issue, so I need the purchase-to-FA conversion to happen automatically and the FA code to be created right away during the issue-out process.In my tests, the Import Scenario can run successfully, but it seems the asset is still not actually created.Any advice o

Hello, I created this year over year variance report for qty sold of a stock item. As you will see in the screen shot below, the calculations in the QTY % VAR column are correct. However, the manager would like to see it as follows: Row 1 (for the 021 stock item) the % VAR shows -62.86 (round to 63). He would like to see it as 37% instead of -63%. Is there any way to accomplish this? Here is the formula used for the % VAR column: =IIf(     Sum(IIf(Year([ARTran.TranDate]) = Year(Today()) - 1, [ARTran.Qty], 0)) = 0,      0,      (Sum(IIf(Year([ARTran.TranDate]) = Year(Today()), [ARTran.Qty], 0)) - Sum(IIf(Year([ARTran.TranDate]) = Year(Today()) - 1, [ARTran.Qty], 0)))      /      Sum(IIf(Year([ARTran.TranDate]) = Year(Today()) - 1, [ARTran.Qty], 0)) )*100  

Hello Acumatica comunity,i have many customers. i have a question if somehow i need to increase customer number more than (10digit) 1000000000 + 1. how we can modify or the customerid field to accept more than 10.Currently acumatica with default settings accpets only 10 Digit CustomerID 

Has anyone successfully configured a ShipStation connection with 25R2?  I imported the customization package, entered the configuration in Acumatica, then created a store in ShipStation. I received the message that the connection was successful, but no shipments are imported even for a manual refresh.  In fact, I don’t even see login activity in the request profiler.  The account information and credentials are correct, and I can hit the web service endpoint from Postman to receive shipment details for the date range.  I am working with ShipStation Support, but response time is slow with little helpful information provided.  I’m aware of the currency rate issue that can break the connection attempt from ShipStation if not configured, so that’s not the issue.  I don’t know if it’s a design flaw or a bug, but if you attempt to edit the connection details after setting up a successful connection, the screen is blank.  I’ve repopulated it many times and each time it comes back blank.Here i

Hi,I have an SO Order Type that is Invoice and there is the Mark for PO box, but it is greyed out. I have created a new item with no items in stock and made the replenishment warehouse the same as on the order. There is also a default vendor for that item. Does anyone have a workaround or thoughts? 

I cannot seem to resolve the error ‘The Submit button is disabled’.If the Submit action is removed, the time card Save creates and saves the time card as expected.I have tried many options in the scenario to continue to Submit without any luck (different flags, different Submit action, etc.). Any suggestions on how to resolve? Attaching the XML also.