Construction

Is there a project summary table by period?   Currently using PMTaskTotal  for a backlog GI but it is project to date and I am looking for a summary table by period.     

I find it cumbersome to have to open each project and update the % complete on each task, then move to the next project, so I want to make sure that I am not missing something obvious.  Questions:Is there a way for the system to automatically calculate and update % complete based on actual costs/budgeted costs?   Most project accounting systems seem to have that feature out of the box. Is there a way to update % complete for multiple projects/tasks at a time?  Perhaps via some sort of importing function?Thanks in advance!

Is it possible to add multiple tasks to a revenue line on a project? For example one revenue line consists of a quantity of 5 and there are 5 tasks that need to be completed to fulfill it. As they are completed project billing would be run to capture the payment and update the revenue budget  We are new to Acumatica and trying to trying to take advantage of the project functionality any guidance or suggestions would be greatly appreciated. 

Hopefully I am missing something obvious - Is there a report or GI that can show unbilled project lines for all projects and their expected billing amount when project billing is run?   I supposed I can build a new GI or modify existing Project Transaction Details GI to allow filtering on the Billable and billed fields, but don’t see a way to show the expected billing amount based on billing rule and rate table on each task.Also I need to see available Progress Billing lines too, which are available in Project Transaction DetailsThanks in advance.

After running allocation, the user finds out that they didn’t update/enter certain rates in the rate table.  Once they fix that, is there is a way to correct previously calculated allocation results?  Or does that have to be done manually?This question would apply to changes made to Allocation methods after the run as well. Thanks.

Is it possible to generate an invoice out of Receivables and code against a project BUT to a different customer than the project is setup to?  Right now it appears there is a hard restriction that only the customer on the project can be selected in Receivables invoice screen in order to charge to that project.Our use case as a contractor is that we occasionally do additional T&M on-site work that one of the other subcontractors request of us ( hauling off their debris in addition to ours or digging a quick trench for them) We generally like to tie any billing/revenue for this type of one-off T&M work back to the project, since its generally small and our costs for us to do the T&M work are generally lumped in within larger scope of work for the main Project/Customer.   As noted above we would generate this T&M invoice, and receive payment from the third party subcontractor and NOT the customer listed on the project.  Any suggestions on how we could do t

I am getting an error when trying to delete an On Hold AR Invoice that’s created from a pro forma invoice.  See below.  The message seems incomplete and makes no sense.  I need to recreate the proforma invoice to factor in the updated bill rate.Does anyone know why and how to resolve?BTW, is deleting and regenerating the pro forma invoice the best way to correct billing rates?   In my example, some rates have been changed and added in the rate table after the proforma invoice was processed. Thanks for your time and input in advance. 

Just upgraded from 2022R2 to 2023R2 as we were pressed that our current version was rolling out of support.  We use the Construction Edition, 2023R2, 23.208.0026 upgraded to this build on 5/14/24.PROBLEM: Inventory Module, Recalculate Inventory Process.  Enter the Warehouse, Inventory ID, Item Class of the item, and check the Rebuild Item History Since box and enter your desired date from which to recalculate.  Next, select the "SELECTED" checkbox in the grid next to your listed inventory item(s) that you wish to recalculate the inventory for.  Select the "PROCESS" button to execute the recalculate inventory process.  The process displays a “Failed” error notification panel.  Error message says: “Operand data type NULL is invalid for max operator.”  All of the Qty information display in the error panel is incorrect as well. (Screenshot inserted, but error message provided in case the image doesn’t get included).  Opened a case with our Partner.  They could not figure this out

Our client came across a scenario where they marked several daily field reports as complete, but didn’t un-check the “hold” box on the labor time and activities. This prevented the labor from appearing in any “mass release” workflows and, ultimately, from posting to the projects. I would anticipate that being an automatic link - when the daily field report is complete, so is the labor time and activity. But this appears not to be the case. Has anyone else come across this? If so, what workflows have you used to monitor and/or prevent it?

Project Stock for Serial Items.We need to show the Project Stock for Serial Items.I have the INCostCenter and INCostStatus to get the project stock. The INCostStatus has a lotSerialNbr field but with no value.The serial number is available in the INLotSerialStatusByCostLayerType DACThe DAC INLotSerialStatusByCostLayerType contain no incoming or outgoing referencesWe want to show in a GI the details as per the Inventory Summary but add in the Project IDThe following link give me the stock but duplicate the Serial numbers. What am I missingRetha

I have a customer that paints the lines on roads that is using the construction edition that wants to know for billing purposes how much material he has used by the meter so he knows how much to bill. They also want to track this material costs and labor out in the field so they can track actuals against the estiamte/budget. Does anyone know how Acumatica can handle this or a if there us a 3rd party solution out their that might be able to help

I have a customer that paints the lines on roads that is using the construction edition that wants to know for billing purposes how much material he has used by the meter so he knows how much to bill. They also want to track this material costs and labor out in the field so they can track actuals against the estiamte/budget. Does anyone know how Acumatica can handle this or a if there us a 3rd party solution out their that might be able to help

How is everyone handling retention billings with the Acumatica generated AIA billing form?  It is my understanding that if you have several periods of billing, you will get a separate billing form for each one. Is there a way to get one retention bill?  

We’re about to start our first phased construction project & I’m struggling to figure out how to get it set up.  We use (what I think) is a pretty standard NAHB set of cost codes that follow a 5 digit format where the first two digits are the major categories and the last three are the detail description of the cost.  So we have:01-000 general requirements 01-310 project management 01-510 temp power 02-000 site works 02-100 demolitionand so on.  The major categories from 01 thru 29 are hard costs.  30 is land costs.  40 and beyond are soft costs.At present we enter all five digits into the costcode field and duplicate the first two digits into the projectTask field.  This allows us to get subtotals for the major categories (but we can’t get totals for hard costs, soft costs & land costs).As we start planning on an upcoming phased project I want to drop the redundant data entry into the projectTask and

Hello all, For those of you using Procore, where are your invoice approvals?  In Procore or Acumatica?  I’m trying to figure out which is best. We currently use Timberscan Titanium for invoice approvals but Procore doesn’t integrate with Timberscan yet, even though it’s on their radar.  I would appreciate your thoughts! :) Thanks!Kay HoweJackson, Ohiokhowe@stockmeister.com

Hi Acumatica and Procore users, Do any of you know when the release is coming out where Contract and Sales amounts feed from Procore to Acumatica?  I understand that it’s Q1 2023, but when? Thanks, Kay  

Is there any way to customize Acumatica’s pages .cs code inside the customization projects or VS? For starter I would like to get rid eye hurting red color of Approvals screen.

Hello, we have found that the Budget vs Actual by Cost Code report (PM625000) is duplicating the Actual hours for certified jobs because Acumatica adds a 2nd line item for the fringe rates with the same amount of hours on Employees’ earnings tab of their Paycheck.Has anyone found an easy work around for this or is there another out of the box report that would complement this report to get the correct Actual certified hours?

I need help reversing a time and material invoice which has an incorrect date.   When I go to the ProForma invoice to do a correction, it is telling me “You cannot make corrections to the pro forma invoice because it has at least one time and material line”.  All lines are time and material.  How do I reverse this invoice, is there another way?  I have looked everywhere for an answer, please help. 

I need to write off a portion of an invoice however the system only allows me to write off the entire invoice. Is there any workaround to this? Thank you

Hello,I have a client using Acumatica payroll and Construction. The client also has Union payroll. On T&M billed projects, they bill labor dependent on the 3 below items:Labor item (Journeyman, Foreman, General Foreman) Earning Type (RG, OT, DT) Union (SheetMetal, Carpenters, etc)The current Rate Tables in Acumatica only go as far as Inventory item. I know I could create a non-stock item for each rate type and union, but that’s not feasible for this client.I have created a very long IIF statement in the billing rule that works but it’s too long, the system cuts it off after 4000 characters. Is there a way to create a Rate table based off of these 3 items that I’m not seeing?

After upgrading to 2023 R2, our Subcontract Audit report now adds Debit Adjustments to Paid to Date totals in addition to reducing Billed to Date total. Therefore, outstanding balance calculates incorrectly because it’s duplicating the reductions. Our implementation partner does not know when this will be fixed and is asking us to pay for them to modify the report. I don’t think we should be paying for something that was incorrectly programmed by the developers.Has anyone had the same issue? Were you able to fix it without paying a third party? If you did, would you be willing to share the fix?

HiI have a client who will be using ADP for payroll that plans on bringing in project related details using Project transactions.  The client has project specific rates for items and that works great for regular hours but occasionally they have overtime rates that need to be billed to the client.  What would be the best practice to accommodate the different billable rate? is it possible to have more than one rate on a rate table for the same item? One thought was to create a second non-stock item for each of their labor items to account for the overtime rate.  The client and I weren’t loving this option but were willing to explore. i’d love to hear what the community's thoughts are and what you may have done in the past? I appreciate your help in advance!

HiCan I Restrict Labor Item on Employee Time Cards for Project and Project Task.Note I have Selecting the check box : Restrict Employees on Project Properties SectionThis restrict Ilse to capture time to the project.Now we need to ensure that she only capture time for a specific labor item specified to the Project and Project Task?The Labor Rate (ScreenId=PM209900) has been defined per Project for the employee and per employee not linked to the project.Retha 

Is it possible to create a transfer order in Sales Order for the supply of inventory for a project?The transfer form allows for a warehouse to be selected and then the field below is “project” but it seems to accept nothing bu project X.Project inventory is enabled and the project setting for inventory tracking is by location. Thanks James