Unanswered questions

Hey everyone! 👋Quick question — what's the exact navigation path to access the tool Customization Project Editor in Acumatica?For context, I need to open and edit my customization projects, manage access rights, generic inquiries, and other project components.Could someone share the step-by-step menu navigation?Thanks in advance! 🙏

I’ve got a custom field that is Int64. It’s holding a key value from another application. It’s correctly stored in the DB as 16 digits, but the UI only displays 14. This was the same in Classic UI, but I could force it to use display as a string and all was well (it’s rarely if ever entered by anything than the integration code or an Admin, so digit checking not important.)I was *hoping* that modern UI would ditch the 14 char limits, but seems like no. How do I make modern UI display all the digits?Thanks in Advance!

public class BZCustomerAttribute : CustomerAttribute{ public BZCustomerAttribute(Type search) : this(search, typeof(Customer.acctCD), typeof(Customer.acctName), typeof(Contact.phone1), typeof(Customer.primaryContactID), typeof(Customer.customerClassID), typeof(Address.addressLine1), typeof(Address.addressLine2), typeof(Address.postalCode), typeof(Address.city), typeof(Address.countryID), typeof(Location.taxRegistrationID), typeof(Customer.curyID), typeof(Contact.attention), typeof(Customer.customerClassID), typeof(Customer.status)) { } private readonly Type[] _fields; [PXHidden] [PXProjection(typeof(Select<Contact>))] public class Contact2 : Contact { } public BZCustomerAttribute(Type search, params Type[] fields) { Type genericTypeDefinition = search.GetGenericTypeDefinition(); Type[] genericArguments = search.GetGenericArguments(); Type type; if (genericTypeDefinition ==

This should be easy but just can’t figure it out. How do I initiate a full database export of my acumatica instnace? 

Hi All,As per our requirement I have created a new COA 20040 - while creating the same selected use default sub account check box and saved.  At the same time while creating Non Stock Items selected this sales account and updating  default sub account.  it is not allowing me to save and showing an error as below 'Sales Sub.' cannot be found in the system. Please verify whether you have proper access rights to this object.  I have verified all access rights and provided necessary accounts.  Stil showing same error.  Please help me how to fix this issue.  

I want to raise the question here. Can we run npm build in local development in folder FrontendSources and add build file to production? Like this How can we include the build file to my customization ui file. Because when I browse from file or moder ui file I cannot see it. But in file I can see development file in screen folders. Please guide me. 

I recently created a pivot table off a GI that shows unit inventory and sales. The inventory piece is a bit challenging in that the Qty Available is correct, but on some lines it’s showing up as two separate numbers - always double what the actual available amount is.I’ve checked the GI and it shows the correct value, so I’m wondering why it’s doubling in the pivot table.not all records are like this. only a few. see below. Is there something wrong with the inquiry or is this a bug in the system?thanks!Joseph

Has anyone successfully used the AI Assistant in 26R1 beta? I obtained a license key for it and am able to access the assistant, but when I ask it questions it just spins. Things I tried:Opened browser console and found this error: Warning: No client method with the name 'usermessagesent' found.Cleared browser cache.Exposed a GI to AI Assistant, then located AI Assistant Data Processing screen (ML503010) to process it. Got the error in screenshot below. Is AI Assistant not intended to work in beta version?  

Issue Description: We have locked down the Stock Item screen to prevent users from adding/modifying vendors on inventory items. However, we've discovered that users can bypass this restriction through the Purchase Order workflow:User creates a PO with a Stock Item and adds a vendor that isn't currently associated with that item When the PO is received, the system automatically adds the vendor to the Stock Item's vendor list This circumvents our intended security controls on Stock Item vendor managementCurrent Setup:Stock Item screen access is properly restricted for regular users Users have appropriate rights to create and receive POs This appears to be happening during the standard PO receipt processQuestion: What's the recommended approach to prevent vendors from being automatically added to Stock Items during PO receipt when users don't have direct rights to modify Stock Item vendors?I've considered:Purchase Order Preferences settings (but haven't found the right option) Stock Item

In 25R2, I have exposed custom generic inquiries via OData, set up a connected application, and can call the OData endpoints from Postman.  I handed-off the initial collection to our MS dev lead so that he could wire them into a custom application.  He is attempting to generate T4 templates against the v3 metadata using a VS extension tool, but the metadata is not well-formed according to the schema referenced.  First, all of the standard GIs exposed via OData have naming validation errors with dashes or spaces in the names, so I removed the OData checkbox and republished them.  Second, it appears that Acumatica does not add Nullable="false" to the fields in the Keys sections, no matter what the underlying field definition is, and thus there is a generation error for every key field indicating “All parts of the key must be non-nullable.”.  So, he is downloading the metadata file, scripting the addition of the attribute to every key field and then generating against the local copy of th

Hello, is there a way to change the Shipping destination Type under Requests? Currently it seems to default to Branch, we’d like it to default to Warehouse. Is this possible?” Thank You!

We are almost ready for Go-live and the customer noticed that the description from the change request isn’t carried over to the Change Order. The process:Change request creation 00001 Click on the Create Change Order button to create the Change Order  While looking at the cost budget it’s empty. As seen on the screenshot below: 

At summit I seen a few cool examples of people using business scenarios/recurring tasks for month end checklists etc. I am not finding a lot of guidance on the web or in the documentation.Anyone have good examples and/or a good place to go learn more?Anyone using these for sop’s?Screens WZ201000/WZ202000.   

Hi Team,  Bright Side's orders aren't automatically invoicing like they should. When I go to manually invoice them I get an error related to Pacejet. Can you help look into what is going on? Below are the two shipments currently needing to be invoiced.I tried to correct the shipment to see if I could send it back through but since it has been too long since confirmation it wouldn't let me. The problem is, even though it wouldn't pull it back from Pacejet into Acumatica, it still deleted the shipment from the Pacejet side. So now its busted even more.

I have created a Daily Order Entry report to compare January 2025 and January 2026 side by side.My requirement is to group the data only by Day (1–31) and combine both years into a single row per day.In the report I have attached when I apply the year filter then in 2025 section I am getting the 2026 records as well and vice versa for 2026I have already: Updated the grouping conditions Modified the date field formulas Adjusted sorting Has anyone faced this issue? What is the correct way to group by day only and compare two years side by side without getting duplicate rows?I am attaching the screenshot and report file for reference.Thanks.

Hello Experts, I am unbale to figure out how to view the total number of production order with ageing category. I Tried creating GI but still facing problem how to group .Please let me know where am i missing .So my output result should look like:- 

Hi Community,We are working with a customer where the AuditHistory table has grown significantly (currently around 387 GB), and we are evaluating cleanup and retention options.Background: The client wants to reduce database size and improve manageability. Similar cleanup work was performed several years ago for this same customer. Client Requirements: Separate Financial audit logs from CRM audit logs. Remove all CRM audit logs. Retain only the last 7 years of Financial audit logs. Information received from Acumatica Support: Financial and CRM audit logs are stored together in the same AuditHistory table. There are no built-in retention settings for specific audit log types.     Questions: Has anyone implemented a workaround or customization to separate Financial vs CRM audit logs? Any best practices for managing large AuditHistory tables in similar scenarios? Any insights or recommendations would be greatly appreciated.Thanks in advance!

I have a strange problem that bugged me for ages. For certain records there is a mismatch with the number of attached files vs the count of files. In the example below, you can see it has one file, but states two for the count. I’ve come across a similar thing in the Companies screen on the Visualization Tab, where the Logo File file URL has remained. In this instance, it is fixed by clicking Upload, which ‘nulls’ the path name due to no file being there.In this example though that little trick doesn’t work. Please, any advice would be great, as it is confusing to see a file in the screen, but have no actual linked.

We have items we stock and count in whole eaches. We buy those items in pounds. Pounds can be a smaller unit than eaches, but we don’t want partial eaches in stock. We had our Company’s Quantity Decimal Places set to 0 and this worked fine. We assumed the risk of minor rounding errors during receipt, they never caused a problem.Recently we increased our Company’s Quantity Decimal Places to 2 to support other items. Now we cannot receive parts in pounds unless we uncheck the Divisible Base Unit box, but we don’t want partial eaches in stock. How can we get the system to round like it did when we had Quantity Precision at 0? 

Hello!  Do any of you know how to run a general ledger for all accounts for a range of dates (most commonly quarter or year) with a beginning and an ending balance showing all account detail for the period selected? Thanks,Kay HoweJackson, OH 740-418-5250

Hello, with Entra ID SSO, if a user attempts to log into a tenant they don't have access to, Acumatica will create a record in the Users table for that user with no roles assigned.  They will receive an error and are unable to log in, but the user creation is a compliance issue for some clients.  Is there a way to prevent this from happening?For clients with SOC 2 Type 2 and other security certifications, how are you managing this?Thank you,

We have a need to completely isolate data between tenants into separate MS-SQL databases. As an example Company A and B cannot share a database due to parent company regulations. The two tenants will share a single instance and each set of tenant data will reside in a separate DB, e.g. DBA and DBB.The installation documentation reads: “ The following diagram shows an architecture with multiple application instances. Each instance has multiple tenants, and each tenant has its own database.”Here is the documentation link: https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=4b65b79b-e09d-46bd-9a85-7c1c0bb4eba5I see that instances are tied to a single database and I do not see a way to get the desired configuration as described in the documentation.Can someone please help me? Either how to get the desired configuration or a concrete refutation of the documentation.Thank you

Hi AllFor the last few days I have been getting the error shown in the screenshot below in my Production environment which causes the application to be stuck on a loading screen. Any ideas on what cuases this and how to have it fixed, please? Currently to fix it, I restart the server because I’m not sure where else to check. My version is 25R1 and it is a PCS deployment. 

Hi.  Our client is looking for best practices in tracking vehicle and equipment loans.  How have you addressed this?   Do you create a separate GL account for each loan?  Have you found a way to tie it to the Fixed Asset in the FA module?  Has anyone successfully used subaccounts to make 1 GL account and then use subaccounts to distinguish between particular loans?I know there is this idea out there.  If you need this as well, you can go to the post below and upvoteFixed asset Loan Tracking | Community

Hi All,I’ve installed Acumatica multiple times, but I’m still encountering an HTTP 404 error when trying to access my local instance. Could someone please advise on how I can resolve this issue?