Discussion Forums

Hi, I’m not the most versed with the Project module, but I have a customer who uses projects and has some restriction groups configured to limit access to projects, mostly along branch lines, they have several branches. That part seems to be working, users are only seeing projects that they are assigned to in the restriction group (via project groups).  What he is reporting however is that on the Project Transaction screen, users can see and call up transactions tied to projects that they don’t have access to otherwise.  And his biggest issue is that they can actually Release these transactions as well.   It also looks like they are using that Project Transaction Visibility by Account group and again, that part is working in that it is blocking access to some transaction lines, but he’s saying even with that, it still allows the user to call up the transaction and release it.   I haven’t gone through a full test on this, although I did confirm that I can see the transa

Hi everyone, I've hit a strange issue with copying Generic Inquiries (GIs) on our production site (v2024.1).The Issue: When copying certain GIs using the standard Copy/Paste from Template function, several table Aliases fail to paste through into the new GI's Tables tab. This results in the error: “a table with the alias [name of alias] cannot be found” because the fields in the Results/Conditions tabs lose their table reference.What I've Ruled Out (or think I have): I recognize the common causes (Copy/Paste bug, Custom DAC synchronization, Site Map conflict). However, the critical and confusing finding is: The issue occurs consistently in the Production Site where certain Alias names are in play, e.g. “WIP”, “DTC”, “TimeActivity” as example. The exact same action, using the same GI on a Sandbox environment

We have a business event that notifies the salesperson every time they are added as a salesperson to a customer. This business event is sending an email notification to the salesperson with the customer that has been assigned to them. The salesperson is currently on the “To” list on the email template, however, they are not receiving the email. Below is an email that was processed: The person on copy is only receiving emails. We are using Users table to pull the salesperson’s email addressNot sure what is causing this to appear blank. I have attached the xml file of the GI, BE to this thread. Please advise, what am I missing here. Appreciate your help in advance. thank you.

Hey Acumatica Community!As we know, he construction industry is evolving rapidly, and digital transformation is no longer optional.From equipment utilization and ROI tracking to telematics and automation, the need for connected, data-driven workflows has never been greater.That’s why we’re thrilled to announce an upcoming live webinar featuring Acumatica’s own Joel Hoffman and Mike Gillum, who will be showcasing the latest advancements in Acumatica Construction Edition alongside the official launch of IIG’s new Construction Equipment Management solution.📅 Date: Wednesday, October 22🕘 Time: 9:00 AM PT / 12:00 PM ET💡 Why AttendWhether you’re a partner, customer, or prospect, this session is designed to empower you with actionable insights:For Partners: Learn how to position and demonstrate

Hello Expert, i am getting stuck in on of the business event scenarios i.e once sales order is created business event will get trigger and create a commission sales for that sales order. I have created business event and import scenario for the same but was unable to trigger the business event.Please have a review and let me know if i am missing out something

Hi Acumatica, I would like to show the report results for only a specific set of subaccounts. A comma separated list as input would be ideal. Is there a way to achieve this? It seems if I enter a start and end subaccount that only shows the numerical order but Id like to have the report shown for a grouping of non-sequential subaccounts.Thanks!!!!  

When I click on CUSTOMIZATION, it doesn't show the standard 'Edit Generic Inquiry' option. How can I modify it to add two additional columns? 

Is it possible to change the background color of a field in a report based on its value ?The values are predefined in a dropdown, such as 1, 2, 3, and 4, with corresponding labels.I need the field background color to change as follows:For value 1, set the background color to red. For value 2, set the background color to green. For value 3, set the background color to yellow.How can this be achieved?When the value changes, the color should also change accordingly. 

We are looking to utilize our company credit cards more to accumulate rewards.  My issue is - I do not want to lose the vendor history.  For example, we have used a vendor for many years and have always paid by check.  Now we want to pay with a credit card.  How can I do this?  The library says the “vendor” needs to be the credit card company.  But I want the vendor to stay as it has been.  Can I add “Credit Card” as a payment option?  And if so, then how does it work when I need to pay the credit card balance?  Thank you in advance for any insight!!

We’re excited to announce the new Project Planning & Resource Management Badge — built to empower Acumatica Value Added Resellers (VARs) to master the ProjectManager + Acumatica integration.Quick background: Last year, Acumatica introduced the Professional Services Edition. As part of that launch, ProjectManager was added to give firms both within and beyond Professional Services powerful resource planning and project management capabilities. This badge equips your team to deploy those capabilities confidently and consistently.What’s the PM Badge All About?This certification focuses on equipping your team with the in-depth knowledge needed for successful deployments. It covers:ProjectManager Essentials: Get a solid foundation on ProjectManager’s background, key features, and core benefits. ProjectManager Overview: Dive deep into how ProjectManager works, including user setup, project creation/management, and critical repo

We are using only the distribution edition of Acumatica, and our pick list does not print the components for kits. Is there any setting, like enable or disable, to activate the option? 

Hello all.  We are currently about to roll out the Request and Requisiton process for Purchase Orders.  I’ve been trying to figure out how to link the Requested By of the Request to the PO.  We want to see who submitted the request on the Purchase Order screen and the Purchase Order Report.  But I am having a hard time figuring out the connections.  Has anyone does this before?

I need to union Customer Details and Vendor Details at one table(by business account). How i can do this?  

Hello Is it possible to create a GI with a union on 2025 R2, given that it now permits the following. 

Hello !   My client produces custom unit and the components used will be fairly new and would not have purchased it earlier. So there is no history or the costing saved in Acumatica.They will use Estimation module to estimate for all components and will convert the Estimate to BOM. I was expecting that the unit Cost from estimate will be transferred atleast to the planned cost field in BOM. But it updates to 0 as there is no average cost in the inventory. so when the Production order is created the Planned material cost will be 0. Has anyone run into this situation? Do you have any ideas of how this can be handled?

Hello! I am no expert in C# in customization projects so all my knowledge is based on ChatGPT, which has been super helpful so far. We have a UDF currently made available on the SOLine on Details tab. It is a string data type and is a drop-down combo box. The goal: this UDF should only be editable when the item on this SO is in a specific item class (CUSTOMNS). If the item is not in this item class, then the field should be locked and not editable.I have pasted the codes below, open to any suggestions. I am able to publish the project, but with what I have, the field is locked and not editable regardless of the item class. Thanks in advance! The UDF code is:[PXMergeAttributes(Method = MergeMethod.Merge)][PXStringList(    new string[] { "MCC", "FORMENS", "JTex", "HongKong" },    new string[] { "MCC", "Formens", "JTex", "HongKong" })][PXUIField(DisplayName = "Factory ID", Enabled = false

We’re struggling with visibility around international shipments in our Distribution Center. Right now, both the supervisor creating the pick lists and the pickers themselves often don’t realize an order is international until it’s too late. As a result, shipments sometimes leave without the proper customs paperwork.Most of the time, our pickup drivers are good at catching this when they load their trucks, but I’d like to eliminate the risk before it gets that far.What I’d like to do is:On the Create Pick Lists screen: make international shipments stand out more clearly (e.g., highlight the line a different color or display an icon/flag). On the Pick List report: add a bold header message like “INTERNATIONAL SHIPMENT--CUSTOMS PAPERWORK REQUIRED” that only appears when applicable.I’m not sure if this is best handled through Report Designer (and if so, which field to pull from--Shi

So i am build this report in the report designer.On this report the data type of {SOPackegeDetailEx.CustomRefNbr1} is a ‘string’.For some reason it's not working in the ‘sting’ mode but the moment I change the data type to “integer” it works.I check the data source of the data and it is “string”.I am not sure what i am doing wrong.this is the data source. 

Hello All, I am trying to add a GI to the side panel of the Customers screen. The goal is, when a customer is selected, then the inventory totals that customer has purchased show on the side panel. I know this is possible, as we already have something similar setup.  I have setup the GI for Customer screen the same way as the other side panel setup, but I am not getting the required result. Please help!

Hello all,I have a scenario where I would like to record a payment against a PO via credit card as the vendor required upfront costs. We then have the AMEX defined as a liability for this so, then we pay the AMEX. So its like instead of debiting the record again I would like to debit the liability.How can I achieve this? Is it like under the I define the AMEX as a cash A/c under a liability GL account?Let me know your thoughts on this.Thanks.

Hello all,the customer would like to put an hyperlink into a word, in an predefined text element. He wishes to set an sentence like “… klick here...” and the “here” should contain the link.I tried as follows, but when i click “insert it just puts the full link in and not the link in the word:marked the word insert->link from web put in link insertThe happens: Is it possible to put the link into the word and if yes how?Greetings

After a recent upgrade I’ve noticed that the two checkboxes for Require Receipt and Require Shipment are missing from our Non-Stock ItemsThe fields are still populated with a value and I can see those values through a GI, but there are no fields to edit or modify on the Non-Stock item itself, nor can I access them via a mass records update or import scenarioWe have a few minor customizations to Non-Stock items but nothing that should impact these fields Is there anything I’m missing from a settings or configuration stand-point that might be causing this?  

Hi, I am a Newbie in AcumaticaI need to export in an excel format the full General Ledger, please can somebody tell me how?Regards 

Hello,I’ve added a user-defined field to the Journal Transactions screen and would like to move it to the Document tab. We previously opened a case with customer support, and they confirmed that this isn’t currently supported - but mentioned it may be available in future versions.Our client is using Acumatica 2025 R1. Is there any known workaround or customization approach that would allow us to reposition the field to the Document tab?Any insights or suggestions would be greatly appreciated.Thank you!

Hi All,Here is my superficially simple question. For an import scenario that I have with the Item Warehouse Details screen, IN204500, I am getting this error: Field: Default Issue From, Value: M      , Error: 'Default Issue From' cannot be found in the system. Can you modify my import scenario so that it does not throw an error and properly loads a record to the item warehouse details screen? Our warehouse locations have 4 segments (1 char, 2 char, 2 char, 2 char)Here is a screenshot of the import scenario:     I have attached the import scenario as well.