Construction

Hello,I want to add some data fields to the fop of the project form, but I am not sure where to get the data.  I figured out how to add the data in a customization project, but I am not sure where to get the data.  Any suggestions on how to find the following data? I want to add 3 columns, one for current totals, pending AR and Pending APCurrent Totals AddActual Subcontract AmountUnreleased RetainageOpen Amount duePending ARPending invoice amountPending RetainagePending amount duePending APPending APPending SubcontractsSimilar to this, a financial summary tab would also be nice, almost a dashboard page.This data would be nice because non-financial literate people can see the status of the project, is retain still released, etc.  When working through payments, there is a lot of time we have pending subcontracts for approvals, its a good way to see what is sitting out waiting for approval.  Gives a better read of the project. Thanks for the help!

I am working on an implementation that involves Non stock items on Sales Orders.There are two workflows involved Counter sales and Project Sales.We have 2 different order types setup; one with Invoicing for Counter sales and one WITHOUT  Invoicing for Project sales (material issue only).The system is set to assign the cost on sales.It appears that the cost side of the transaction gets generated when the Invoice is processed, si this works for the Contract Sales.For Project Sales order no cost transaction are ever created.How do I get the cost of the nonstock item to hit the project without Invoicing?.There was a change in the Service module that seems to have address this process for a service Order and this functionality seems to be missing from the Sales Order workflow  

Hi, I’m trying to customize the lien waiver report Partial Conditional report CL642001 to add a section that shows the details of the total amount of the lien waiver, i.e., the list of the bills being paid. There is a details section on the report that I made visible and added a couple of APInvoice fields but I don’t get anything as a result. Any ideas would be greatly appreciated. Thanks, Scott

Step 1: I am looking for a way to create a receivable invoice to a customer other than the customer for the project for material sold.Step 2: How to credit project for amount of receivable invoice for material sold.

Hello, I would like to know if it would be possible to create a new account group that would only be available to selected projects (therefore, restrict the account group or GL account to specific projects).  For example, I would like to create the account group X (GL 9999) that would only be used in project ABC. The accountant would only be able to select the account group X (GL 9999) when they are recording a transaction in the ABC project. If they record a transaction in project DEF, the account group X (GL 9999) would not be possible to select (ideally, it would not even show up). Is there a way to do that?Thank you!

Hi everyone,I’m looking for some advice on how to handle a Max Cost issue in Acumatica related to a bad receipt entry.Here’s the situation: We use Max Cost for quoting purposes in our system. Unfortunately, one part was received with an incorrect unit cost (~$1,041 instead of ~$45), and this error was not corrected at the time.  Long story short, someone used the wrong part number to order a part and receive.  As a result, our Max Cost is now significantly inflated, and we need to correct this so our quoting reflects the true cost. I experimented with doing a return on that po receipt, hoping that would purge it from the list of actual costs but that did not seem to do the trick.  Appreciate the help!

Hi,We have a client who has the project and payroll module activated within Acumatica’s tenant. Originally, they had the payroll preferences to only post payroll actual costs to project. The issue with this setup is having sensitive payroll data being posted to project transactions and employees are now able to view this data. Even if we “Hide Employee Name” within the payroll preferences, it is still possible to figure out who this employee is. We want to be able to post the labor rates, defined within the labor rates table, to the associated projects and also showing it in the “Actual Expenses” within the projects. Currently, I’ve been testing this type of scenario but the only option I have within the Payroll Preferences (Posting Settings) is Post PM Transactions from Time Activities using an Off-Balance Account Group. This type of setup doesn’t show the labor rates hitting within the Actual Expense. Would it be possible within Acumatica to have the Time Activities create a project

Hi, a client is running 23.210.0017 and is having a strange behavior in PO entry: The default project (X) disappears from the field when a GL account associated with an Account Group is entered in the Account field. In production, when the project is put in again, the subaccount field empties and has to be reentered to get all three to be complete. If a valid project is entered, no issue. If a GL account unassociated with an account group is entered, no issue.I ran it in a local instance with no customizations published and the only change was the subaccount didn’t disappear.We tested it in an more recent instance with sales demo data and it didn’t occur. I don’t know if it’s a config issue, or a glitch?

Is it possible to import multiple Purchase Orders from Excel? Cant seem to find this option. Thanks.

Was doing a little cruising and was wondering what the purpose of rental groups were? What is it?What would the benefit be to use it?

At present, in order to generate expense claims from expense receipts, the claim option on the expense receipts form, automatically groups receipts by customer if the expense receipt is linked to a project/ service order or if a customer is selected. This results in an employee having different claims for each customer. I would like to get your thoughts on this topic. Your responses will greatly help our engineering team in building the right solution.Would you rather prefer if receipts were grouped by employee only irrespective of customer? Is there any other criteria by which you would like to group expense receipts automatically ? How often do you use the automatic claim option to group expense receipts ? If you are currently grouping receipts by customer, how does this benefit you? What don’t you like about the automatic grouping of expense receipts by customer?Thank you!

Hi, Can anyone provide to me step by step instructions in how to remove an inventory stock item that posted to a project using a PO of the normal type. Any guidance would be appreciated. Thanks, Frances    

Is it possible to add a line to an existing Purchase Order while creating a Change Order?  We have Purchase Orders that have previously gone through our approvals process that need a line added to them for an additional scope of work.  We would like to avoid putting the Purchase Order back On Hold to edit it because it removes the commitment from the project until it has been approved and is back Open again.

Hello,I am noticing that by default if an AR invoice has retainage specified, then this will go directly into Income upon release of the original document. Shouldn’t this be handled differently? I would assume that Retainage Income wouldn’t be recognized until the release of the AR Retainage? Let me know if you have any ideas or can better explain. Thank you!    

Is there any way to make project recipients in the mailing & printing settings default from the customer? From what I see, mailing & printing settings come from project preferences, and there is no way to set them to pull from the customer. TLDR; Make project mailing & printing settings default from customer and not project preferences.

Getting an error “The @Rate is not defined for the 10 step of the EQUIP Allocation rule. What could we be missing?Thanks,          

This is a weird question: does anyone know what level of bandwidth is necessary for reasonable performance with the Acumatica mobile app?  I’ve had a couple reports from my users where they can’t get the app to load over cellular connection.  Admittedly, they’re in remote areas, but are able to do everything they want on other apps.

Mid-market Commercial Construction company new to Acumatica - Live 1/1/25.  1 Entity with 7 Branches.  We are struggling a bit in learning Acumatica and recovering some operating efficiencies, particularly in project accounting - budgeting - subcontracting workflows- and accounts payable management.  Interested in a connection-conversation with a construction company a little further down the road using Acumatica Construction Edition happily and successfuly to manage project finance, or those who have been down our path and done something different for project accounting (Procore Integration?)

Hi We would like to know how to business manages with Blank PO,  Essentially we would like to have a lean process of which everyone goes througe a request process, and then it is the purchasing department that manages the rest. In certain cases, there are blank PO that are arranged with certain supplyers. What i would like to know is from the request, is there a way to link that request line to a blank PO Line, to it would deduct the total quantityfrom the blank PO. The inly way i have found for now is that from the request, i would have a quantity with a price of 1$. We thansform the request to a purchase requsition, and then a purchase order. From that order, we put the item price at 0 so there is no cost involved in that line transaction, and then in the same PO, in add the blank PO Line, and input the same quantity as the Request line, but at a 1$ unit price. This gives me the final amount identical from the request, and the “infant” PO is still attached to the request (so i have a

We are having difficulty finding a paid invoice report by vendor per project and given a certain payment date range.  Does anyone have a solution for this problem.  

In the Acumatica produced YouTube video Set up Allocation Rules to Recognize Revenue - Acumatica Construction Edition from April of 2020 viewers are cautioned against using Auto Completion of the Cost Budget if there is more than one cost line per task: Is this still a limitation?If not, in which release was it resolved?If so, is it dependent upon the selection of Completion Method (Budgeted Amount or Budgeted Quantity)?

I’m trying to figure out why we can enter only one AP bill per line on Purchase Orders. Is that how they’re supposed to work? Is there a setting we can change? The scenario is this. A materials quote for a construction project has been entered with lump sum totals in each of 4 different cost codes. A single PO with 4 lines. But the amounts in each line will not be billed all at once. Several AP bills will be entered and eventually consume the total amount of that line. Our problem is I can enter only 1 AP bill applied to line #2. When I try to enter a 2nd AP bill, the system locks out line #2. I can’t apply any more bills on line #2. Why is that? I realize that using a subcontract instead of a PO would circumvent the issue. But since this is for materials only, isn’t the PO option more appropriate?  Things to know that might impact replies…Our line type is Service, and the Inventory ID is a non-stock item.The self help training guides hint towards a “Purchase Receipt” screen, but It’s

Good day,As the administrator, I should be able to run the Project Overview Dashboards.  All the security rights are ok.  I don’t see any issues with how it set up.  I can’t get it to work.  Any thoughts?  I am thinking that this dashboard is not for the Project Module but for Construction hence the reason it is locked.Any assistance would be greatly appreciated.  

We are transferring inventory from a non-project to a project within the same warehouse (same location). The quantity is moving correctly, but the cost is not following — instead, it's being posted to the PPV (Purchase Price Variance) account.Later, when we invoice the project (sales invoice), revenue is booked, but no cost appears, resulting in inaccurate margin reporting.Has anyone faced a similar issue? Could this be related to how the project account groups or inventory posting classes are set up? The  cost is not getting capitalized into the project correctly during the transfer.Would appreciate feedback or best practices for handling inventory transfers into projects to ensure costs are correctly posted and reflected in project billing/COGS.

We are receiving error on billing rule after creating new tenant by restoring snapshopt of the business accounts and settings of the previous. We dont have any problems encountered when time activities are released but when attempted to run proforma billing, this error keeps on showing. Failed to calculate the amount using the 1 step of the TM billing rule. Line Amount Formula: =[PMTran.BillableQty]*@Price Error: Object reference not set to an instance of an object.  Thank you.