Construction

Hello,I am trying to put a negative quantity in a subcontract line item, but it errors out.Anyone have a work around for this that doesn’t require a debit adjustments.  I am trying to keep all the details on one invoice. We create the invoice for subcontractors and tie them off to each pay applications.  If we create multiple invoices it creates confusion. I found I can put a negative dollar value which makes the $ side work, but i don’t think it will work on the total qty side. Thanks,Jeremy  

I am posing this as a question to see if there is anyone who is using Acumatica Compliance to meet DOT requirements.  Use case is a field service company, approximately 250 trucks and crews.  I do not have all of the specifics, and I am learning about the requirements at this point, some of the requirement areas are:Driver Certifications DOT Records for Fleet DOT Driver Maintenance MVR Drug Screen Phyicals  + may be othersSome of these items are documents with occurence date and/or expiration date.  I am also certain that there would need to be some level of reporting required. There is a DOT software in place today but the desire is to use Acumatica if it is feasible. The feedback I am seeking is as follows:Experience shares from SME’s knowledgealbe of DOT requirements Usage of Acumatica compliance for DOT requirements Gaps that have to be covered

Hi everyone,I’m trying to import rate tables using the import scenario and getting the following error:I have configured the Sequence for each Rate Table and Rate Type under the Rate Lookup Rules screen.Note: The same import scenario worked for a client on 24R1, but I'm experiencing this error on 24R2.I've attached the XML file for the import scenario I'm using. I’d appreciate any insights or suggestions to resolve this issue.Happy to provide any additional details if needed. Thanks in advance!Regards,Raj

Can anyone share how they get a zero dollar pro forma invoice on a project if it has an on demand billing period? And how you create your AIA invoice showing all retainage released on invoices? Thank you!! 

i.m currently on an older version of Acumatica, testing in the sandbox for version 2024R1. I am using the Construction module and crated an invoice for a project. The invoice appears in all of the modules correctly, however, the issue i am having is with the Project WIP Report and Project WIP Detail Report. The Project WIP Report headings Revenue Recognized and Billings in Excess of Costs is showing the correct amount but the Period Billings and Billings to Period are showing credit amounts.In the two test scenario billings created and posted for the two projects, there were no debit or credit memos to cause a credit balance. It appears the credit balance is equal to the tax amount on each billing. In reading through the notes this is a known problem after the 2023R1 release. The proposed solution to run Recalculate Project Balances doesn’t seem to be working.Any ideas as to whatelse i could try?

Dear community!This customization package is applicable to Acumatica 25R1 and later versions.The package includes a generic inquiry that demonstrates the new project & construction reporting capabilities. The inquiry is provided “as is”.After publication of the customization package, in order to view the data for the existing projects, you need to run the recalculate project balances process.This customization package contains 3 generic inquiries. Two of them are used in the third generic inquiry “Project Bdg vs Actuals Through Date”, which gets added to the menu once you publish the package.This generic inquiry allows the user to see the date-through actuals and review the budget performance for a specific date (as the screenshot below illustrates). More information and demo will be provided

Hello,  Our project IDs have - between numbers and I want to display them on a report designer report without the dashes.  Example, 25-36-010 would display as 2536010 in the report.  Is there a way to do this with a formula in a report?  The current formula is : ='REQUEST FOR INFORMATION # '+[RequestForInformation.ProjectId]+'-'+[RequestForInformation.RFIID_Attributes]   I need to keep the first and last expression, but make it so the Project ID only displays numbers and not dashes.  Thank you! 

I’ve looked around and just cannot locate an article on this.  Can someone point me in the right direction for best practice on loading (migrating) unreleased AR retention? Thanks 

I have received a check from a customer and there are a couple of back charges listed on the check stub that need to be applied to make the payment amount show correctly.   I have attempted to do a credit adjustment but that does not balance the transaction.  I was told to process the credit adjustment against an open invoice but that does not help me out either when I need to apply that amount back into the payment somehow.   What am I missing here?

Does anybody know if there is a native integration between Acumatica & Gusto HR? I have a potential prospect tracking time for construction projects in Gusto & they’re curious if there’s an integration, rather than doing CSV uploads

A positive inventory adjustment made directly to a project/task hits the project ledger as a negative qty/cost on the project ledger….  everything else in the GL and IN modules appears correct, but the project ledger is wrong. the workaround it to do the adjustment to project X (this avoiding the incorrect project transaction) and doing a transfer into the project… but in current release of Acumatica (22R1 and prior) this doesn’t completely solve the issue from a reporting standpoint, since transfers still don’t hit the project ledger at all….  would be nice to have that fixed btw… I have a business event setup to properly create a project transaction after the transfer.But this seems to be a legit a bug unless I’m missing something obvious… -Matt 

We deal with quite a bit of prepayments (actually milestone payments on long lead items) in our business and in testing the prepayment process I have noticed that I am unable to apply retainage to a prepayment request.  Is there a process for being able to do this?  Is there a fix or enhancement that is coming?  We are currently on 2023R2 but planning on upgrading to 2025R1 when available. Since it is related, I have also seen where it is not possible to apply retainage to a foreign currency PO/Bill.  Is there a roadmap for including this functionality?

Hello all,Can anyone let me know if there’s a specific field where I can find the original cost of the subcontract?In the above screenshot, the ext cost column get updated if there’s an increase/decrease in the amount.

Dear partners and customers,Please share with us how are you using Project Drop-Shipment feature in Acumatica. Do you need a receiving document for the order in case of project drop-ship (Generate Receipt option) or not (Skip Receipt Generation option)? Can you share your use cases when receiving document (receipt) is required? We would really appreciate your feedback!Daria Chuprova,Business Analyst Project&Construction

We have had requests from clients to add information to the header of the AIA Report but are unable to connect the tables due to the way the report is designed. One example was to add the Primary Contact from the Customer screen which does not work. This is due to the way the report is structured. You can only use the available tables because the report was designed to not edit beyond the available tables. This should have been an Idea and I am adding as an Idea.  

Acumatica has partnered with JobPlanner and STACK to deliver end-to-end construction project lifecycle support. As a result of these new strategic partnerships, both ISVs are now available with Acumatica Construction Edition.JobPlanner is a powerful project management solution that allows collaboration between general contractors, subcontractors, and vendors.STACK offers one of the most intuitive and highly collaborative preconstruction platforms on the market, designed to help contractors drive growth and boost profitability through hyper-accurate takeoffs and customizable estimates. Learn more on the associated Acumatica Marketplace listings and contact your Acumatica VAR for demos or pricing information.

Some online services like Facebook and Amazon give users a choice, when clicking on their URLs contained within emails, of navigating to the pages in a browser or choosing to view them in their mobile app. Is there a way to accomplish this with Acumatica?  We've configured notifications containing URLs providing quick and easy access to forms in Acumatica.  For example, an email notifying someone that a subcontract awaits their approval contains a link to the subcontract in Acumatica.  We would prefer, when a user clicks on such a link in an email on their mobile device, to be given the option to open it in the Acumatica app instead of the browser.

Hi,We are a construction company that job costs everything. We were set-up to have our non-stock items like Materials and Equipment to require receipt and shipment but it seems like it would be easier since we job cost everything to take off those requirements and just create an AP bill against the PO when it’s received.Is that what other construction companies are doing and/or is that best practice? Any adverse consequences that I’m not thinking about changing our set-up/process?Thanks for any insight anyone can provide.

We’ve had a request from our QS to see all new change orders in a period.  We wants this in addtional to the substantiated billing report.  But, I can’t find anything that does this.  Do I have to manually find each change order created in a period and then print them out to a PDF one at a time?This kinda feels like something most QS’s might want and I’m a bit surprised I can’t find anything to produce this.  It must be a user problem, right?

I have a question regarding the capabilities of the Manufacturing version of Acumatica. Specifically, I am interested in knowing if it is possible to create progress invoicing and job costing within this module.In my search, I often find guidance pointing towards the Construction module for these features. Can anyone confirm if these functionalities are available in the Manufacturing version. Thank you in advance for your assistance ! 

Is there anyway out of the box to have subtotals show up on the AIA Continuation Sheet for the Original Contract and then the Change Orders? This is what our AIAs looked like out of our old system:Thanks!

We have a client on 2022 R2 that has the Construction module. Under Projects in the Cost Budget, users are able to delete a line item that has amounts reflected under the Actual Amount Column and Save without any warning messages. Is this a known issue or possible bug? Any insight would be greatly appreciated. Thank you,Frances  

Looking for tips/help on updating the default Empty Item UOM from HOUR to EA. When we try and change it we get errors but can’t find where it’s pulling the errors from - our templates all have branch/billing rule/allocation rules filled out (as do our projects). And there isn’t anywhere to select defaults for those on the preferences page.  here is the error we get: Is this a customization?

Each time we add a new scope (task) to our projects or make tasks that were in planning active, it makes all of the scopes in projects invisible in our time tracking in WFG. The work around is to make ALL scopes inactive and save. Wait for it to sync to WFG and then make them all active, save and wait for it to sync.  It seems each should sync independently of each other.