Construction

Hi All-- I have been searching for various process methods to accrue costs on a project until we’re ready to invoice and so far I’ve found (1) best outcome and another (2) that semi-works but realizing day by day, it’s not going to work. (1)This method will have users create a Project with Inventory Tracking = ‘Track by Project Quantity and Cost’ Then create PO using STOCK items, this is a must, where Type = ‘Normal’Then create PO Receipt, this will DEBIT INV and CREDIT ACCRUE PURCHThen create AP Bill, this will DEBIT ACCRUE PURCH and CREDIT APThen create Issue, where Cost Layer = ‘Project’, this will DEBIT COGS and CREDIT INV (Sweet spot)Then create AR Invoice, where DEBIT AR and CREDIT SALES (2)This method will have users create a Project with Inventory Tracking = ‘Tracking by Project Quantity’ or ‘Track by Location’ .. meaning ‘Track by Project Quantity and Cost’ will cause an error Then create PO using NON-STOCK items where Type = ‘Normal’Then create PO Receipt, this will DEBIT INV

I attempted to enter a negative A/P billing but got an error.  Then I tried entering a Debit Adjustment but it disables the retainage field.

Can someone explain the purpose and use of the non-stock inventory items in Acumatica? Our organization owns a diverse quantity of equipment (heavy machinery, testing, mechanical) that we use on projects and need to be able to charge each job for the use of this equipment for AR invoicing purposes.  We are trying to process these pieces of equipment to projects for AR Invoicing using the Equipment Time Card in Acumatica.We are being told that they only way to accomplish this is by listing these equipment items as non-stock inventory in Acumatica. Is this correct, or how should we go about this?

Hi everyone,When our employee makes a prepayment for a project, how do I record this transaction into project for tracking?I don’t know why it’s not appear in project transaction.

Do you use the Project Quote in Acumatica or you use a ISV? Do you like it?Thanks

Just experienced that we are no longer able to run our over/under project transactions against closed tasks. All business units are needing to re-open tasks to get through the August close whereas this has not been required in the past and we cannot see where this is controlled or determine causality. We are helping where asked to mass activate tasks, but that’s not a long term solution.We are self-hosted on 2021R2 with no recent software updates and no known related configuration changes.Any ideas including whether you are able to project transaction against closed tasks would be great!

Client is using 2021R1 and Projects allows an Inactive Customer Location to be selected in Project Quotes and Allows the Quote to be converted to a Project.  Is this an oversight or is this working as designed?  Does the Construction Edition operate in the same way?   

We have specified a default task at the Construction > Project level so that individuals entering time don’t have to bother with a task.However this delegates to everything. Our accounts payable team has to manually tab back after selecting the project and change the task in modules such as Bills and Adjustments.I know there is coding that tells it to look for default task selection and insert if yes but don’t have experience with modifying to that degree.

Ask Me Anything: Construction EditionWednesday, November 02, 2022 11:00 AM Pacific Daylight Time 30 minutes You've seen how Acumatica Construction Edition supports various business processes anytime, anywhere in a product demo.What burning questions do you still have about the solution? Register now to access insights on Acumatica Construction Edition.

Hello: Whot do I need to setup to be shown the projects in the tab location:Please Could you support me? 

Hi,I’m trying to revoke access to below fields in the task form. But I’m unable to find node to do the access restriction in the access rights by screen form. Can anyone help ? Thanks,Dulanjana

We were just told by Procore that we must upgrade our Procore customization in Acumatica or the integration will fail on Monday.Would like to know if anyone else has taken this upgrade especially if they switched from Acumatica’s to Procore’s customization to synchronize between Acumatica and Procore.Our instance is self-hosted in Azure and self-maintained. The instance is comprised of Acumatica 2021 R2 Build 21.212.0039 with customizations only for ProcoreBuiltCustomizationPackage2021R2V3 and VelixoConnectedAppConfig (v6).

We would like to see the ability to report prior period WIP reports that include open commitments and change orders by period.  Another way of saying this is period sensitive reports for POs and COs.

Dear All,Our business case is we will deliver material to the site and after finishing the installation, we will calculate the actual quantity of material to issue an invoice to the customer. The actual material quantity is less than the budget quantity.Current process:Set up a warehouse called Pending Sale and use order type TR on Sales Orders, transfer material to Pending Sale warehouse with a specific location linked to a specific project. (Each project has 1 location in Pending Sale warehouse) after finishing the installation, use order type SO on Sales Orders with actual quantity to issue an invoice.Issue: On Project PM301000, we can't track how many materials we already delivered to the site (TR or SO historical transaction).Question: do we have any function on Project that allows us to create a delivery transaction and it can be shown on Project PM301000 tooThanks in advance,Yên Chi

Hello,In creating a SO for a project, I have found that when Project-Specific Inventory is enabled that only inventory assigned to the project is available for issue. What I am seeing in the SO screen is that the availability is X for the item and then as soon as I select the project the availability goes to zero. Most of my inventory is not project specific, so I would assume that it would be available to any project, however this is not the case. Can this be adjusted with a setting, allowing reserved/assigned inventory to only be sold to the appropriate project while unassigned/unreserved inventory also be available.From what I can tell its seems this feature may be all or nothing, all inventory is tracked/assigned or non, I am looking for both. Example of no project with inventory available Example after a project is selected 

Hi,  Once we close and open the project balances. This Raw material values is not showing in project Level.There are Few questions. (01). What are the double entries, when Raw material(Stock Items) transfer to Project site?(02). Why Those work order Stock Items(Raw Material) transfer to Project?  

Is there a way in Purchase Order or on AP bills to default the GL account by selecting the project and project task?

Hi,I need to setup 2 different type of projects, one that sends all the project transactions to a WIP account (this is the current setup) and a second type that send all the transactions to another GL. Right now the GL settings on the items dictates where the amounts are posted, is there a way to bypass that setting for a specific project. Keep in mind, we have different items that hit different account groups on the same project.

Looking for anyone in the Construction Industry that is charging projects a “Billable Rate”.We are moving into acumatica and are looking to use the timesheet entry screen for timesheets but need the system to be able to charge the jobs a billable rate from the hours on the timesheets. Then be able to see the actual “cost rate” on the project to see profitability on the projects.Has anyone come across this?

Both Project Tasks and Cost Codes provide ways to break out project transactions into data subsets.  To better understand Acumatica’s design, would love some forum user feedback as to real world examples of the following:Project Tasks Cost CodesAny explanation of the difference between these two data elements would be most helpful.Additionally:Are there instances where a single Project Task might be sufficient?Our company is not engaged in vertical construction projects, so looking to better understand the difference between these two data elements and how they might be applied to natural gas pipeline installation projects (labor, equipment rental, materials), natural gas pipeline repair projects (labor & equipment rental), and billable service projects (labor only). 

Hi:Is there in the Acumatica Construction project management module a project planning and status board where one sees in calendar/Gantt format all the projects, and where one can schedule a new project using drag and drop? Somewhat similar as in Field Services edition or now in Acumatica Manufacturing Edition -Advanced Planning and Scheduling - Visual graphic.This is so basic to project management.I hope that SmartSheet has it. I have to check it out.Or does Procore have it?I appreciate your help.Toon SixToonSix@intercs.com

Is there ‘a movement in saving or <overrun>’ or similar column available for the project cost budget screen? Or a column for Movement in Estimated Final Cost? This would = last cost at completion - cost at completion. Thanks,  

HiCreated a GI showing lots of details on projects and their cost and revenue budgets.    I can pick up the last invoice date ok but now looking for the date of the last cost transaction on the project anyone managed to populate this date?

Hi,I’m almost new in Acumatica. Is it possible to add a column in order to group or to sort items for a project quote or a project?My target is to distinguish between different parts of my project (not phases).Thanks 

Has anyone successfully created a dashboard widget to show open expense receipts (screen ID EP301010) that have not been claimed without creating a custom GI?