Discussion Forums

Hello - We are creating a generic inquiry to be able to search for Freight values by vendor and/or property, and want to be able to have the system generate the Total Freight amount depending on the filters the user selects. We have experimented with adding the ‘Sum’ to the Aggregate Function column for the Data Field usrTotalFreight, but that does not seem to be generating anything. Am I missing a step? Attached is the GI for reference as well. Thank you!!  

Hello All,I have been working on trying to disable the Lot/Serial Nbr. selector field on the grid section of the Inventory Receipts screen (IN301000) through code, but it’s not working as expected.I was able to successfully disable the unitCost field on the same grid, so I’m not sure what is preventing the Lot/Serial Nbr. selector field itself from being disabled/enabled. Here is the code I am using: public class INReceiptEntry_Ext : PXGraphExtension<INReceiptEntry>{    protected void _(Events.RowSelected<INTran> e, PXRowSelected baseHandler)    {        baseHandler?.Invoke(e.Cache, e.Args);        if (e.Row == null) return;        PXUIFieldAttribute.SetEnabled<INTran.lotSerialNbr>(e.Cache, e.Row, false);    }} If anyone could help me with this, it would be really helpful.​@darylbowman ​@Naveen Boga 

Hello all,We are having issues when creating a move transaction for a production order, even though all materials have been allocated to the production order, when we try to release the move transaction we get a backflush error : “Backflush material shortage was found for the item in the 1 line of the operation in the order.”.Error MessageTraceWe noticed that this happens when we allocate material, by clicking Line Details on Production Order Details and checking the allocated box, and the available quantity in that location is less than the material required. Allocate materialInventory summary says we don’t have any availableProduction order details says we do have quantity availableOur workaround is to not allocate the material , however, this causes problems with our inventory because it takes material from other locations and not the ones specified on the BOM.All of our items are manufactured on a various work centers, an item can only be manufactured on one work center. We created

Hi there, We are considering using Smarty Address Verification via API. Has anyone here had success with this integration? It would be very helpful to know if someone out there has already made this work and, if so, whether they are happy with it or not.  Thank you!Jon Hunsicker

Hi, I have changed the description. I want to know where the previous value is store. OldValue = ‘RMA-3693 - General Returns’NewValue = ‘RMA-3693 - General Returns- AAA’It’s a record from ScreenID = ‘SO301000’  

Hi,Does anyone know if there are any Acumatica resellers in France, and is the Acumatica product compliant with French fiscal requirements ?Many thanks

I’m struggling with a problem.  Whenever our Internal Sales Order (repurposed the regular SO form) goes to a page 2, we lose Order No, Order Date and Customer ID value.I am running it with the parameters for a single invoice.  Thoughts?Page 1Page 2  

We started looking at Dataself recently.  We have been doing a “roll your own” data warehouse for reporting with PowerBI, and it’s been painful.  The PowerBI side is great, but we’re working with our MSP who has some knowledge of ETL and data warehousing, but no knowledge of Acumatica dataWe have a Dataself demo later this week, but I’m curious about the communities thoughts.

How do I translate the ContextScreenId from the resource governor into an actual Screen ID? I have a user who is making the resource governor trigger and I cannot find what screen is causing the issue.  Data from Resource Governor:ContextScreenId = ~/GENERICINQUIRY/GENERICINQUIRY.ASPX?ID=B65DA13B-32EF-4C2F-8772-E545BB718F76ContextUserIdentity = <REDACTED>CurrentCompany = <REDACTED>EventID = ResourceGovernor_RequestTerminatedEventIdSourceContext = ResourceGovernorCustomData =[  {    "ContextID": "D5B4327E5D066E8311F0850A30104E5C",    "Screen": "~/genericinquiry/genericinquiry.aspx?id=b65da13b-32ef-4c2f-8772-e545bb718f76",    "ElapsedSeconds": "53",    "TypeOfRequest": "UI-GI",    "ErrorType": "UIRequestDisconnected",    "CurrentCompany": "<REDACTED>",    "CustomMessage": "Denial Code 527- The operation was cancelled because a client was disconnected. Contact your provider for further assistance. CorrelationID: 8DDE72E391364E9; Timestamp: 2025-08-29T18:59:46.8562665Z" 

Hi has anyone managed to get the PDF Annotator to work with the GI. As in when we open the AP Bill we can click on the View PDF and see the file attachments on the bill.I want to move this up a level to the Bills and Adjustments GI so that as you select a row you can view the PDF without opening the bill. I tried doing the followingI get this error.  

Hello all,I am attempting to recreate managing security across multiple tenants and am getting an error every time I try to add screens. These are the guides I’m referencing:https://www.loganconsulting.com/blog/moving-user-security-from-one-tenant-to-another-in-acumatica/ https://www.augforums.com/forums/everything-else/moving-acumatica-user-security-user-roles-between-tenants-companiesI tried typing in a specific screen (SO301000) and it still freezes and then eventually closes.I get the same error trying in multiple tenants, browsers, computers and users. Other customizations seem to be working fine. Does anyone have a solution, or another way to get security across to different tenants?

I am attempting to create a generic inquiry to feed into a dashboard. We are wanting this GI to show the balance of our cash account as of @Today - the only thing we can get to show is the period end balance. I’ve attempted to recreate the transactions by period filters/parameters but have been unsuccessful. Any insight would be greatly appreciated.

We run manufacturing operations at multiple warehouses. We use the same BOMs at all warehouses because the same materials are consumed. However, due to much higher manufacturing volume at our main facility, there are materials that are stocked at that warehouse, but are custom order at the lowest volume facility. Acumatica has the “Dflt. Mark For” checkbox on the stock item level which, when the “Purchase” option is selected for an item, then system will suggest a purchase order when that item appears on a production order. However, I don’t see this option on the Item Warehouse Detail level, which we really need for those items that are regularly stocked at some warehouses, but only ordered on an as-needed basis at other warehouses. Am I missing something, or is Acumatica missing this simple feature?

Hi,I’ve created a customization on the AP Bills screen, adding a custom field Project/Events (dropdown list). The customization is working perfectly on the AP Bills screen. However, when I try to display this field in the APTran GI result grid, it appears blank.For reference, I’ve attached the customization for your review. Please note that the client recently upgraded to MYOB Acumatica 2024.2 version.Does anyone have an idea of what might be causing this, or could someone please assist with resolving this issue?  

Hello everyone,Has anyone attempted mapping Cycle Description (or a similar field) instead of an ID in Shopify metafields? How do you approach syncing it? 

Hi everyoneHoping someone can help.  We have a staff member who is going on 6 months leave.  So he doesn't accrue and leave etc, how do I set that up in Myob Acumatica, in Australia.thanks heaps E 

Good day,I know something is wrong with my Business event/export scenario.  The processing schedule works.  I get an email with a file attachment.  The issue it is first fille; the original data.  However, on subsequent run, i get the same file not an updated exported file..  I am not getting new file with updated rows.  The export is being processed on schedule and the results are updated.  The email is being sent on schedule; email received.  The only issue the file is old.  How do get the new file attached?  I added this to my business event this morning.  Who knows if this work?Everything works except the export file is old; the same file sent during testing.Any ideas, assistance would be much appreciated.Evan 

Hey Team,I made a nice little dashboard for the storemen to reference. Then i noticed it wasn;t showing for them, it just shows padlocks. I’ve tried all of the access by … Rights/user/role - But cannot seem to make it visable for them. I essentially use one GI for the whole dashboard. AttachedCan anyone shed some light, i can;t see why they wouldn’t be able to see this data given they have full use of the salesorder/shipments area.   

In researching the high number of ERP transactions, we seem to be incurring, the EDI transactions are counting as ERP transactions along with the transaction cost with SPS and EDI? These significantly pump up the ERP transactions since a majority of our business is EDI based. Something as simple as updating statuses, runs the entire file every time and is counting each line as an ERP transaction. Since these Mapadoc reports tend to be suspect, sometimes this can get run multiple times per week. SO we pay for each part of the SPS transaction and add to the ERP transactions every time we run anything in SPS. Why are we paying twice since this is an Acumatica add-on and integrated - shouldn’t there be an advantage?

I am very new to Acumatica, requirement is to hit an 3rd Party Endpoint and save the data into the SalesOrder in Acumatica. here are the things I did: 1. got the community edition https://acumatica-builds.s3.amazonaws.com/index.html?prefix=builds/25.1/25.100.0054/AcumaticaERP/ 2. got the all the 3 test data setup in db 3. able to login and play around 4. while trying to login using the api.. (reference docs: Sign In to the Service)curl --location 'http://localhost/AcumaticaERP/entity/auth/login' \--header 'Content-Type: application/json' \--header 'Cookie: CompanyID=EvU100; Locale=Culture=en-US&TimeZone=GMTM0500G; UserBranch=; requestid=EE8D2DC0BF1C7DA211F0873A7C4D3F9F; requeststat=+st:833+sc:~/entity/auth/login+start:638923313721775647+tg:' \--data '{ "name": "admin", "password": "admin", "tenant": "EvU100", "branch": "EVU100"}'I am getting the Invalid credentials5. next wanted to the right documentation if possible to connect with external api, do i need to enable something f

Our Distribution Center Operators keep reporting that certain Stock Items are being altered unexpectedly:The Default Issue From Location is being removed The Lot/Serial Class is being changed The UOM and Conversions are being modified etc.When I check the Audit History, it always shows “last modified by admin,” but no one is acknowledging making any changes.My questions:Is there a way to drill down deeper than “admin” in the audit history to see which user or process actually made the change? Could this be caused by an integration (SPS, import scenarios, etc.) or only by direct user edits? What tools, logs, or setting should I be looking at in Acumatica to track down the source of these modification?

Our Purchasing Department has put notes in each line of a test Purchase Order. When using CTRL+Alt the Inspect Element shows that the field is POLine.Transactions, but, in the Report Designer POLine.Transactions does not appear and there are not child alias’ by the same name. I have been through every Note field that the Report Designer has in the tables that come with PO641000 and none of them has the data that was put into the Note fields.

Hi All! I had a good question that came to me today and it would be nice if this is possible with Generic Inquiry advanced filters. Is it possible to change what fields get displayed on each of the tabs that’s created using advanced filters? For example, in the screenshot below, on All Records, I would like to see all the fields that are currently here. But on the Complete Orders tab, I would like to only display certain fields. I know there is Column Configurator, but it seems like the column configurator setting applies to the whole GI, not individual tabs.  Thanks!

I have a GI that outputs SOOrder information.In the GI settings I use two date fields to do SO Created Date is between two dates. If I enter 9/11 and 9/15, sales orders created from 9/11 through 9/14 are returned, when I would expect SO's from 9/11 to 9/15 to be returned.If I do the same filtering using the column header in the report, I enter 9/11 and 9/15, sales orders created from 9/11 through 9/15 are returned, as expected.I believe the 'between' in the GI is broken. 

We are finding the tax calculating on the opportunity is not correct.  Once converted to a service order it calculates correctly.  If we enter Ship Via: Local then the tax does calculate correctly.   Do you know why it isn't calculating correctly on the opportunity Can we default opportunities to have ship via filled in if we cant get this resolved