Construction

We have a client running Acumatica 26R1 that operates as an Engineer-to-Order (ETO) manufacturer. Their projects often contain hundreds of budget lines, and they are utilizing the new Revenue % Complete calculation method for project billing.One challenge we are encountering is preventing the revenue-side % Complete calculation from exceeding 100% of the revenue budget when actual costs exceed the original cost budget. In these scenarios, the project may legitimately run over budget on costs, but we do not want the Revenue % Complete billing calculation to generate billings beyond 100% of the contract/revenue budget.Has anyone found a standard Acumatica solution to cap the Revenue % Complete calculation at 100%? I have experimented with billing formulas but have not found a reliable way to prevent over-recognition when costs exceed budget.At this point, I am considering a custom Generic Inquiry with a Business Event and automation process to calculate and update the revenue-side comple

Hi, In the project record, I configured the Project Group with the intention of limiting visibility so that not all users with project access can see the project records. Specifically, each project manager has their own group, and only members of that group—such as the project administrator and coordinator—are allowed to view their respective projects.Additionally, I enabled the Restrict to Employees option for the foreman role. and set up their name under the Employees tab. Please note that foremen do not have access to the project record itself. The purpose of this setting is to ensure that foremen can only select projects in the Daily Field Report (DFR) that are assigned to them.Based on my understanding:Project Access controls visibility and access to the project record. Restrict to Employees controls access related to time activities (e.g., DFR and timecard entry).However, based on my testing, when Project Access settings are enabled, the Restrict to Employees functionality does n

I’ve generated my T5018 efile and while reviewing it there is a vendor who shouldn’t be on the report as they only supply materials.  I’ve reviewed their vendor record and confirmed that they are set up as “none” under CRA Reporting Type.  Is there any where else that I should be looking?

I just wanted to take a moment to share with everyone about Acumatica’s first industry focused customer user group. This is a group focused on the construction industry and it’s unique needs and challenges.The plan is to hold virtual meetings during the upcoming year and in-person meetups at Acumatica Summits in the future. Thank you to ​@APistorius and ​@LaurenOHara20 for kicking this off!Stay tuned for great things!Request to Join here! Construction Customer User Group

Hello Community!As we broaden and simplify functionality, we would like to confirm our ideas and hear how your workflow may be improved within Acumatica.We kindly ask you to spend a few minutes to fill out a survey:  https://www.surveymonkey.com/r/QMTHXV6Thank You.

The new Project Address fields implemented in 2020 R2 to replace the single Project Site field is definitely an improvement.  But I wonder why it isn't configured as a selector whereby the user can select from the customer's locations, like the Default Location.  Have others encountered this?  How are you handling it if so?  

The Project is a field in the POReceipt table - but it appears after upgrading to 25R2 from 24R2 it is no longer visible and can not be added via screen configuration. Is this true?We got our total cost back - now the Project is gone :/

Has anyone modified the AIA report to allow for parameters?  Also, can a modified report be set up on the project>mailing & printing tab to be the default format?

We’re about to start a construction project for a third party.  We’ll be billing them all construction costs (without mark up) plus a management fee.  We will be providing them Cost Reports on a monthly basis and need the management fee to show as a cost of the project.  All of our other projects have been in house so we record the management fee twice - once to the developer as revenue (through an invoice) and then a second time as WIP to the property company (through a bill).  Only the WIP gets the project details. Since this is an external client we don’t have access to that second entry.It “feels” like I should be able to put the project related info on the AR line of the invoice so that it will be picked up on the cost reports.  But, that doesn't seem to work.I can’t believe we’re the only builder using Acumatica for external clients.I’ve also thought about recording the invoice with three lines so that it looks like thisdr A/R    cr fee revenue, proj xdr COGS, Proj external, task

Following an upgrade to 25R2 Build 25.201.0213.3 this Known Issue is still occurring. The current Solution indicates updating to 24R1 or new for the fix…. is there a solution for 25R2 that anyone is aware of? This error occurs when a Requisition has an attachment at the line level, preventing the PO from being generated. The workaround requires users to remove attached documents from the document line level prior to creating a PO. This is problematic because File Attachments added to a Requisition at the Document level do not get attached to the related PO.  

I am using the above reference to implement this. On the Projects screen, I have two tabs: BTC and HWP. The HWP tab contains multiple UDF fields that should be visible only when the HWP branch is selected; otherwise, they need to be hidden.  After implementing this, the fields are not showing under any condition. Whether I select the HWP branch, BTC branch, or any other branch, they remain hidden. Could you please guide me if I am approaching this correctly?

Hi, we have a subcontract that incurred backcharges for scope that was bought out by another company that ran the subcontract total amount into the negative. We recently changed our ERP to Acumatica and we are looking to track this backcharge but cannot process the change orders that run the subcontract into the negative.How can I track this negative commitment amount for my project buyout summary?ex. Subcontract A issued for $5,000. Subcontractor A failed to perform work and another Subcontractor B bought their contract for $5,100. We need to process a deductive change order for the buyout amount to accurately track the money owed to us by Subcontractor A for the increased cost of Subcontractor B.

We’re looking for a way to track which Invoice or Proforma a specific Change Order was billed on in the Project module. Specifically: Is there a field within the change order,  or a report that shows which Proforma or AR Invoice includes a Change Order? If the Change Order was partially billed, is there a way to see the amount invoiced to date and what remains? What’s the best practice for tracking Change Order billing in Acumatica? Any tips, custom reports, or screen references would be much appreciated!

Hello - most of the work we do is cost plus so we need supporting documentation to send with our invoice to our customer to be reimbursed. Our jobs consist of reimbursable items like employee travel that is loaded into the system via cash purchases, billable hours at a rate * quantity, and vendor invoices processed via AP. This leads to quite a few line items that are translated to the monthly billing. When creating a proforma, I thought the system would generate a compilation of files attached to all transactions that are reimbursable on the proforma. It doesn’t seem to do this for the printed version of the proforma or for the substantiated billing that for the proforma. Am I just missing a setting or something to be able to accomplish this? Not sure how the system could generate T&M billings but not have the backup for the T&M billing. Our VAR has of course offered a customization at a hefty price but I expect the system should be able to do this. If anyone else has went thr

We purchase stock materials directly for our projects. Often the materials come in with freight bills, which we historically have added as a separate line item & recognized as a separate account group to the project. However, we are looking at using landed costs to get the actual cost of an inventory item tied to that item - as sometimes we move that item into Free Stock. The question is, is there a report or clear way to show the landed cost variance just on project inventory? We would like to have a clear way to audit why materials are over budget if it is due to inbound inventory freight.

Hello all,How much time does it take to implement & migrate the data into Acumatica for Construction Foundation license?

Is there a way to copy and paste the previous Daily Field Report (DFR)? In our scenario, the foreman is responsible for entering the DFR for all field staff, including labor time and activities. Having to manually re‑enter the same information for all staff every day is time‑consuming.We attempted to use the copy‑and‑paste function for the DFR, but it results in the following error: “Sequence contains more than one matching element.”It would also be helpful if there were an option to upload the DFR instead.Thanks

We are looking for advice on how to handle custom-configured instruments in Acumatica.We purchase assemblies/instruments where the hardware may share the same base inventory ID or vendor part number, but each unit has a project-specific tag or configuration known at the time of purchase. Today, we can assign serial/lot information at receipt, but we have not found a good way to capture the tag/configuration at PO creation so it stays tied to the PO line through receiving.Example:We may order three pressure transmitter assemblies from the same vendor.All three use the same Acumatica inventory ID:ASH ASSEMBLYHowever, each assembly is configured for a different project tag: PO Line Inventory ID Project Tag / Configuration Real Serial Number 1 ASH ASSEMBLY 2593001 PT-101 Unknown until receipt 2 ASH ASSEMBLY 2593001 PT-102 Unknown until receipt 3 ASH ASSEMBLY

It would be really helpful on the Project Cost Budget & Revenue Budget tabs to also be able to Group by Cost Code & Account Group. When summarizing by Task, the GI very conveniently gives a total row. I’m also putting out there the suggestion to have it total without the summarization, because right now it will not total unless the task box is checked (second Screen shot) 

Hi There,I’ve encountered an issue with retainage behavior during AP bill reclassification in Acumatica ERP and would like to confirm whether this is expected or a configuration issue.Scenario:An AP bill is created with a project, task, and retainage applied. The bill is released, and retainage is tracked correctly under the project. Later, I perform a reclassification on one of the bill lines to another project (using the reclass functionality). The original line was code to wrong project about (10% of total cost) The 90%cost  is under project A, and AP retainage is under project AIssue:The expense is reclassified correctly to the new project. In the AP Retainage Register, the original retainage disappear from Project A,  but appears under a non-project code (empty project / X).Expected Behavior:I would not expect the AP Retainage register change the project code but remains under same project codeQuestions:Is this the intended behavior in Acumatica? Are there specific configurations

I am reviewing the Project 360 Dashboards and came across a tile that I don’t have access to. I cannot find where to provide or grant access either.  On the Project Status Screen (PM301500) form the Documents to Approve widget is showing as below and states that I do not have enough permission to view this,  (I am an admin account)  If you click into the “Unpaid AP bills” tile it takes you to the Approvals page, where I have access to. And the “Potential Change Orders” tile takes you to the “Change Orders “ screen which I also have access to. I reviewed the Site Map, Class Dashboards, and Dashboards screens, Access Rights by Screen menu and could not find the correct area to update permissions.  Would anyone know where I would go to update the permissions? Is this a potential bug? 

Here is a real world scenario that I have experienced many times. In this actual case there are obvious low process maturity issues here - company leadership, change management and job roles and responsibilities not being followed.  Not looking to discuss or debate those issues as that is internal to the company to resolve, rather experiences and outcomes, ease of use and lowering friction to increase user adoption on Acumatica processes that are stated to have too many clicks and are too rigid from a customers point of view.CustomerThe customer is a mid-market utility/civil contractor running Acumatica Construction Edition with a major disconnect between what the PO-to-payment process requires and what Project Managers are actually willing to do.The Designed Process1. PM creates POs for materials, rentals, fuel, equipment, etc., (all non-stock items)2. Materials are delivered to the job site3. PM enters a Purchase Receipt against the PO confirming what was delivered4. Accounting recei

Hello guys, our receiver accidentally receive 1 item 2 times and I try to return it in the system. However, it show me The Original Inventory Receipt must be release prior to return.Can some support me with this issue.Thanks  

Has AvidXchange launched end to end Purchase to Pay Integration with Acumatica?

How is everyone monitoring project inventory costs through their balances/cost budgets? Our issue is that the cost of inventory when ordered will appear on a Committed or Open committed column, but once that project inventory is received (or transferred directly) onto the project, it does not appear in the balances UNTIL those inventory items are issued.We need a way to reflect project inventory balances on the Balances tab, ideally on the Actual + Open Committed amount column.Example below. You will see we ordered $303k worth of inventory. It is all received and sitting on the project inventory. But it is not reflected in the Actual +Open Committed amount and is actually showing as a major variance. Between transfers & PO orders, there is $307k worth of materials sitting on this job that are not being accurately reflected at this WIP state of the project.How is everyone handling project inventory for budgeting/cost tracking?