Solved

Hello!We are calculating Depreciation for number of days from the Placed-in Service Date. I want to know how the depreciation is calculated as seems it does not calculate depreciation based on 365-day calendar. Depreciation per Day = Acquistion value / (365 * number of years)First, I thought of above but seems is takes days around 371. Can anyone please help me with this?Thank You! 

Hello,We are a construction subcontractor looking at this platform. It appears Acumatica is geared more towards operations at the GC level. Are there any subcontractors, construction or other trades, currently using the system that could offer and insight/pro’s, con’s, etc.?Thanks,Jeff

Hi, I have added a condition under row style to highlight records based on the profit margin. However, I have noticed that this condition is not working for those lines where revenue budget exists, but it is working fine if revenue budget doesn't exist under the project's Revenue Budget. For instance, in the below attached screenshot, you can see that the revenue to date is 0 for project P10221, and the cost to date is 487.50 which is highter than revenue to date. However, it is not highlighting this record based on the row style condition set under the GI. attached GI for your reference. 

Is it possible to use a GI as part of the data source / table in another GI.Background:We sell our products in an online store, we also have a customer that sells our products on their online store and we fulfill and ship these orders. This customer is also a distributer for us. At the end of each month we report the total sales (wholesale and online store) for this customer. The issue is the Online store orders come into our system as retail orders. We currently manually combine the sales numbers at the end of each month. I have a GI that pulls the Wholesale sales and a separate GI that pulls the online (retail) sales numbers.Is there a way that I can use the online (retail) GI as one of the data sources (tables) in the wholesale GI, similar to a nested query in SQL, so we just have one GI to run that give us the combined sales numbers?Thank you!

We currently have our Empty Item UOM in our Project Preferences as HOUR. We are trying to change this so our Empty Item UOM will be EA. When we try changing this, we get an error message saying that the Project records could not be updated due to at least three fields being empty; Allocation Rule, Billing Rule, and Branch.Going through all our projects, the only project with empty values is Project X, the Non-Project code Project.We are unable to update the fields of project X since it is a non-project, and were unsuccessful in trying to make the three fields not required through a customization project by both removing the PXDefault from the fields and trying PersistingCheck = PXPersistingCheck.Nothing. Any help would be appreciated, our next step is putting in a ticket.

Hello Everyone,We have a scenario where our client has multiple Companies within a tenant and processes invoices for Vendors across these Companies. When making a payment in the "Checks and Payments" screen, the "Reference Nbr." finder under the "DOCUMENT TO APPLY" tab currently displays all open bills for the selected Vendor across all Companies.The client would like the system to show only the open bills related to the Company/Branch they are currently working in (as selected in the top menu).Although the filter option is available on the "Reference Nbr." finder , managing it becomes impractical since the client operates over 20 companies, requiring them to set up and maintain more than 20 filters. Ideally, the "Reference Nbr." finder should automatically display only the open documents for the currently selected Company/Branch.is there any way to restrict the "Reference Nbr." finder to show only open bills for the active Company/Branch?Any suggestions on system configurations or alt

Any ideas on this one?  I’m trying to login to Report Designer and getting this error: Client found response content type of 'text/html', but expected 'text/xml'  

I appears that the Report Designers for 2024R2 is not backward compatible. This means a VAR that supports multiple version needs to reinstall Report Designed based on the customer version since you can not have multiple versions of Report Designer installed.

I have found this similar error for other transactions but has anyone specific seen it when Confirming a Shipment? i have only had this issue with production parts and recalculating the inventory does not remove the negative qty in our shipping location.   

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.   However, on the bonding report it calculates the earned revenue using total contract (not task revenue or sum of income recorded).  Question, is it possible to design an allocation rule that will actually calculate recogniz

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.

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. ToonSix@intercs.com

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.

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 snippets would be greatly appreciated. Thank you!

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?

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 stop it from happening.  But my override

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?