Construction

We have a workflow in which once a Subcontract has been fullly Billed, we create an invoice in our system to release the retainage.  There is usually no progress billing on that bill, and we are looking to release all retainage for that contract.It appears that there is a way to release retainage for a single bill at a time, but if I have a scenario like this:Subcontract total value: $10000Bill 1: $5000, with $500 retainageBill 2: $2500, with $250 retainageBill 3: $2500, with $250 retainageOnce that last bill is out, we create a ‘Retainage Release’ of $1000.  Is there any way to do this efficiently in the Acumatica API, other than finding all the Bills against a subcontract and looping through, releasing against each Bill?Or can I somehow release the full $1000 against the Subcontract in a single call?

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

We are currently on 2025R1 and noticed this week that we are unable to add a new record from the Subcontracts primary list. When it was reported by a user, I checked user rights and this individual has full access to that screen.  I as an admin also am no longer able to see the ‘+’ sign to add a new record form the SC3010PL screen.   As a workaround we are able to add a new record by opening an existing record and clicking the ‘+’ from there, or from the Commitments screen of a project. Our production instance is: Build 25.101.0153.9 + Our Sandbox, which is build Build 25.101.0153.2 +, has the ‘+’ on the pl list.  I even made a copy of the Subcontracts PL in our Sandbox, ex

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

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 cor

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 S

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

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 Pur

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

Team - one of our customers wants to limit the characters used for Project Tasks.  This is simple enough.  However, it turns out that the consultant who originally configured this customer somehow (???) added a Task to Project X.  To make matters more unnecessarily inconvenient, they used the maximum characters allowed by the segmented key.  I can neither open this task (on Project Tasks), delete the tasks using a Mass Update, or Update the Task ID (also using a Mass Update).  I’ve also tried renaming the Non-Project Code, but this isn’t helpful either. Is there a way, short of using a customization, that I can access this task to delete it? How in the world was this able to be done in the first place? Thanks in advance!

Anyone have a working import scenario to delete Project Template Tasks?Due to how the template format is in the screen, it seems that it cannot find the Project Template.  I tried a few ways even using the description, but it is unable to find the record. Client uses two segments for their project task record, and it looks like the screen only shows the first segment and this might be part of the problem.When you pass the template ID with two segments it says it doesnt exist.I can use the GI but as there is about 2800 records this takes some time.

Having a tough time getting the Purchase Receipts to default the Warehouse and Location.  It is defaulting the warehouse but the location just shows <Split> and won’t fill in the default from the Item Warehouse Record.Here’s the scenarios:When doing a Purchase Receipt you have multiple options to enter the Detail Lines on the Receipt.<Enter Receipt> from the PO Screen – this builds the Receipt entry from the PO and does all the settings.  Detail Lines to not have a Default Location.  They do have a Default Warehouse   Manual Entry – this seems to work properly when you enter the Detail line with Inventory ID, the Warehouse and then the Location Defaults from the Item Warehouse default Receiving Location   On a Manually Created PO Receipt – select the <Add PO> button which will show a list of POs from this Vendor which you can select and will fill the Detail Lines – no Default Location.  They do have a Default

Hello everyone! Do you have a business cases when you need to include control AR account in Account Group?Could you please share your experience?I know it is not recommended setup, but I try to find out what the problems can occuer? Best Regards,Irina Kateneva,Project/Construction team 

Hey, gang - I’ve got a client who uses Project Quotes extensively.  It’s not common but they have some quotes that require 1000+ estimation lines.  One thing they became accustomed to with the Classic UI was the ability to right click + insert. However, with the Modern UI, there is no longer any Acumatica-specific right click options, just the browser options.  I’ve tested this in both Edge and Chrome and got the same result.  Is there a way around this?  Something I’m missing?  Thanks! 

Hi everyone, I wanted to check if there is an existing standard report or Generic Inquiry that allows users to search vendor or sub contractor invoices and view related payment details, specifically:Amount paid Payment date Associated cheque number or EFT referenceIf not available out of the box, I would appreciate guidance on:Which tables or data sources to use (e.g., APInvoice, APPayment, etc.) Any recommended approach to linking invoices to payments within a GIThank you in advance for your help!

Hello!  For those who deal with projects/construction and have to a) procure project materials and b) pull inventory from warehouse stock… what methods are you using to accomplish this? How are you communicating to warehouse staff members a “project pick list”? Are individuals creating POs from the project directly?  OPTION A - POs are cut from the Project directly. Warehouse staff review the Cost Budget and create an IN Issue directly. (which in older versions still requires a transfer to the project first) OPTION B - Sales Orders are created as the “project pick list”. Warehouse staff “Mark for PO” in the Sales Order anything that is not in stock. They pull from stock and “Create Shipment” which in turn issues the inventory to the project. OTHER - what alternative methods are you using to accomplish this?  The biggest gaps I see is the identification of inventory

Hello, I have a scenario where in the classic UI am able to add the Inventory ID Description Field for the Modern UI am unable to add the Inventory ID description Classic UIModern UI How to add Inventory ID description field to the Cost budget in Modern UI Please let me know

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? 

Hello Team,We have a client requirement to control or validate the posting/ creation of time entries against project budgets. Specifically, they would like the system to generate a warning notification when a user selects a project and task in a time entry and the recorded time exceeds the allocated budget. Ideally, the requirement is similar to the budget overrun notification that appears in the Purchase Order screen.   Can anyone please advise if there are any out-of-the-box configurations or possible workarounds that can be used to achieve this requirement?Thank you in advance for your guidance.-Yasali-