Construction

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 and escal

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 instead set up task codes for each phase.  But, when I look at the Project re

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 

Good day,I am getting an error message (with no information) when I tried to delete an in planning project,  The trace is showing some issues with table.  I am unfamiliar with troubleshooting these types of issues.  Please see the trace details below.Any assistance we would greatly appreciated.  These are projects entered prior to the upgrade to 2023R2.Thank you.EvanSystem.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.   at System.ThrowHelper.ThrowKeyNotFoundException()   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IEnumerable`1 mergingTypes, Func`2 getReferencesFor, Boolean childrenSubstitution)   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IReadOnlyDictionary`2 collectedReferences)   at PX.Data.ReferentialIntegrity.Merging.TableMergedReferencesInspector.<>c__DisplayClass3_0.<.ctor>b__0(Task _)   at System.Threa

hello all,I am looking for ways to let Acumatica run the Reverse Allocation automatically whenever an AR Invoice is generated or released. I setup the following allocation rule, but I am not able to see if any reversal trxn has been generated anywhere. I would like to run the reversal automatically like it does to create an allocation Project trxn.

Hi!I’ve edited the project profile name to say “Project Hub” similar to the construction presales engineer demo:I noticed this shows up fine in some areas but in other areas it shows up as the original name “projects” when i drill into a specific project, we noticed that it only says Projects, not Project Hub (the link works fine, just visually I would like to see the updated name): this is what it looks like in the construction golden demo video: Am i missing a step or is this done via customization? I appreciate your help in advance!

I have a local instance set up with Sales demo data and in the projects dashboard, there is a jobsite camera (Truelook) but all it shows is a gray/black screen.  Is there an example where I could see what a job site camera would look like in the sales demo? Here’s what it looks like for me:  

Hello, is it possible to use a project attribute in a approval mapping? Below are some screenshots of the approval mapping, the attribute is a field with entry mask as number.  Approval mapping:Attribute setup:Thank you,Kage

Hello all,Do we have an GI or Report for check out the logs for Change Management? Thanks.