Discussion Forums

We are using Version 23.211.0017 22R2.  This upgrade changed the way retention was released.  When we upgraded, we had some open invoices that did not have retention released.  We released retention in this new version.  Once that retention was eventually paid for those existing invoices, the original invoice (not the retention invoice) never closed.  The whole project has a Zero AR Balance but it is still showing Open Invoices.  Any ideas?  It won’t let me write it off because there are no open line items and that is required for the write-off.  

 Hi there,I’ve been trying to test allocations following the video on YouTube:Set up Allocation Rules to Recognize Revenue - Acumatica Construction EditionI used REVREC allocation rule and UNRECREV billing rule in the demo tenant. It works fine, billing reduces 21050 as shown on the video and other steps are good. However, when it comes to out of the box reporting it doesn’t work well. For example, Construction Bonding Report shows revenue recognized (earned revenue) as Earned Revenue = % Complete * Contract Amount. I guess that makes sense as it’s just multiples total % complete by the total contract amount. But it does look weird and inconsistent. In this example below, the system automatically recognized 25% of task revenue based on the 25%cost task completion. 

Mail sent by Automation schedule is still in pending process and not processed why?How to overcome this issue? I need your inputs to resolve this issue.

How do we reverse an invoice or bill that has data in custom fields in the transition details. We can reverse an invoice or bill that does not have data in the custom fields, but an transaction that has data in our custom fields we cannot use the reverse button under corrections. This is the error message that displays.  Was something missed during initial set up of the custom fields? 

Hello all. I am using an import scenario tied to a Business event to update Project tasks. If task A gets completed, tasks B,C and D get completed as well.  This works great except not all Projects have task B,C and D. If I run it and a task is not there it errors our.  Is there a way to suppress the error and continue? Is there a way to see if the tasks exists first and if not skip?I unchecked the “Break on” Check boxes but it still does not work.My rules for task completion are long, and creating filter/rule and scenario for each possible combination would be almost impossible. Thank you all  

Hi all,I am trying to publish a customisation with a custom table, but keep encountering the error in the screenshot attached. There is a column in the custom table named ‘InvCNModule’, but I have no idea why ‘RemovedInvCNModule’ is being defined as the column name. Is this something Acumatica does to keep track of column changes?Cheers,Ben.

I created a view using the AMProdItem and AMMTran DACs with the following code and added it to the summary area of a form. In this scenario, fields from the AMMTran DAC are editable, but fields from the AMProdItem DAC are not editable.        public PXSelectJoin<AMMTran,    LeftJoinSingleTable<AMProdItem,        On<AMProdItem.orderType, Equal<AMMTran.orderType>,        And<AMProdItem.prodOrdID, Equal<AMMTran.prodOrdID>>>>>    Document1;Later, I created another view using the SOOrder and Customer DACs with the following code. When I added this view to a form, all fields from both DACs were editable.        public PXSelectJoin<SOOrder,            LeftJoinSingleTable<Customer, On<Customer.bAccountID, Equal<SOOrder.customerID>>>,            Where<SOOrder.orderType, Equal<Optional<SOOrder.orderType>>,            And<Where<Customer.bAccountID,

I’m trying to create a generic inquiry for all related activities in my leads but only the work items shows. I’ve tried to use the Activities module but only my activities for both “all activities” and “my activities” shows. 

2024R1 Unable to locate Construction>Transactions>Subcontracts>Form Toolbar: Delete on Access Rights by role description   Restriction to “Revoked” Delete action on the Subcontracts form must apply to a specific access rights by role 

Hi:Our Acumatica Hackathon 2025 team 10 aka Funnel Cake plans to create an application that will enable a construction/field service company to create a site and then for each site the required projects.From my observations, construction companies have several projects on a site. For instance, a college campus needs two new buildings: one for the dept of engineering and one for the dept of mathematics. The college campus is a site and there is a project for each building. The construction company wants to see the total actual revenue and the total actual cost of the site. It wants to see the status ( in process, on hold, completed, cancelled). It wants to see the address, contact information, start date, target end date, etc. of the site.This will be an application that will be free on Github. Any Acumatica Partners and customers will benefit from it.Please give me your feedback asap since the Hackathon starts on 1/24/25 at noon.Thanks.

I am testing the import of historical fixed asset data. Client uses SL with Mid Month convention. We do not want historical depreciation adjusted in the first month depreciation is run in Acumatica so all historical assets are imported using the RV method. The problem I am running into is that there are assets depreciating to a negative value and some assets that will not fully depreciate. I have used RV plenty of times however this is the first time I am running into this. My understanding is the RV method with historical assets should ignore what the system thinks should be the correct A/D and depreciate the remaining value of the remaining life. I thought that RV may only work with full period Averaging Conventions so ran another test asset using the same values however the remaining months were not calculated equally.  Any ideas if my theory is correct or why this may be occurring? 24R2 Build 24.204.0004

Hello all,I thought it will be beneficial to share the below yesterday drove me crazy. We have configured the Inventory Code to be 20 unicode character. We imported the stock items without any issues. When we tried to import our opening inventory we started receiving some wierd errors like “the record couldn’t be imported due to an error in the next record” and this would repeat until the very last record in the import file. We tried importing through the upload button in “IN Purchase” but there we received an error that “Inventory ID can not be null” and we had no null value in the file.Long story short I did a lots of trial and error to figure out the errors all are misleading. What has happened we had “/” and “\” in our part numbers. Although we had successfuly imported them as Stock Items but the other import referencing them was failing to import. When we changed these two charcters to “-” all worked out just fine. There could be other special characters potetiall

Currently, when we process payments in the Process Payments/Print Check, it defaults to Check Form. We want to print the Remittance as well. Is there a way to change the process to default to Check Form with Remittance?

Efficiency of Picking and Packing I am looking about a Generic inquiry that gives the same information to Efficiency of Picking and Packing. Any suggestions on this.

Our company uses ACU for walk in sales. We are just starting to incorporate hand held scanners to scan items that come up to the register. Is there a way trigger a new line on an SO after an item has been scanned so that the next item can be scanned without having to touch a keyboard key or mouse?

I created a DAC field in a custom DAC as follows.#region ParameterNbr[PXDBString(15, IsKey = true, IsUnicode = true, InputMask = "")][PXUIField(DisplayName = "Parameter Nbr")][PXSelector(typeof(customDAC.parameterNbr), SubstituteKey = typeof(customDAC.description))]public virtual string ParameterNbr { get; set; }public abstract class parameterNbr : PX.Data.BQL.BqlString.Field<parameterNbr> { }#endregionWhen the length of the customDAC.description, which is the substitute key, exceeds 15, the description value is saved in the database instead of the customDAC.parameterNbr. If the length is equal to or less than 15, the     customDAC.parameterNbr is saved as usual. I changed the length to 10, but the same behavior persisted. I want to show the customDAC.description value in the user interface and save the customDAC.parameterNbr value in the DAC.How can I solve this?Any detailed instructions, tips, or code sn

We are trying to close an order and the following error is generated “The status of the production order cannot be changed because it has related transactions that are not released.”  We have ran all product we needed and returned any material that needed to and we are ready to close this work order.I have referenced other related topics and we have reviewed all transaction related to the work order and all show released and posted. This order does not prevent us from closing the month which further validated all transactions have been released and posted. Any help is appreciated.

Can anyone confirm if there is a limit of the number of returns created in a Shopify Plus order that the 2024R2 connector will let sync back to the same Acumatica order.   Our testing seems to suggest you only get one?

Exciting news! Between February 3rd - 7th, we will be upgrading your community to the new enhanced search experience. This update is designed to make finding answers faster and easier for your community members, improving their overall self-service experience.What's Changing?Relevancy-Based Results: Search results will now be ranked by relevancy, not source, bringing the most helpful content to the top.Streamlined Navigation: Consolidated tabs make it easier to toggle between native community content and federated content from external sources.Dynamic Filters: Advanced filters are now embedded within categories, making it simpler to refine results and find exactly what’s needed.Simplified User Interface: Cleaner search results with content type avatars and key details like posting date and author.

Is there a way to change an item from stock to non stock?Thanks!

If you have more than two variant attributes, is there a way to create all possible variant combinations at once?From what I can tell, you have to select a value for each of the non-Column/Row Attribute IDs (in the additional attributes table) and create those matrix items, then change one of those additional attribute values and create those matrix items, then change one of those additional attribute values again and create those matrix items, etc. I’m looking for a way to generate every possible variation without having to go through the tedious process of selecting each combination of additional attribute values.

Hi,I have a customer scenario where they are trying to allocate stock through the Manage Sales Allocation screen (SO501010). Is there an option in the system to allocate stock only in the Base/Sales UOM or to prevent the allocation of partial inventory?

I have a use case where we do not want to update the ShipDate and RequestDate fields on the SOLines when the Requested On date in the header is changed.When an order is shipped and lines are placed on Backorder, the SO is changed to status of Backorder and the Requested On date in the header gets changed, and it automatically updates the fields in the Lines.Here is what I have tried.  When the Requested On date in the SO header is updated, I store the original values of the ship and request dates in a dictionary.Then when the SOLine is updated, I am trying to set the dates back to the original dates from the dictionary.However, the SOLine_RowUpdated (and SOLine_RowUpdating) events do not fire.  I think this is because the SOLines are not being updated in the graph, but through some other code, maybe a graph extension?I tried to do an override on public virtual void SOOrder_ShipDate_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) to try to st

I have not experienced this before.  I am logged in as ADMIN with customizer etc. roles.I cannot get anything to come up in the DAC browser.This is just an example.  I cannot open any DAC.Click here: 

Does the latest version of Acumatica support having separate Charts of Accounts (COA) for different branches or companies within the same tenant? If not, are there plans to introduce this feature in future releases? Additionally, is it currently possible to limit GL Account access to specific branches or companies, and what configurations or best practices would you recommend for this scenario?