Construction

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.

I have DocuSign configured and working.  Here is my question - when processing a document, such as Subcontracts, do I have to print the subcontract to a .pdf, then attach the file to the form in Acumatica, then click Files, then Edit then ESIGN?Is there an easier way to get the document attached to the Files without saving as a pdf first? 

Hi,I configured an automation schedule for the Run Project Billing process. However, several of the projects that were completed still generated an invoice even though the items were billed already. I did know for several line items this happened on after Run Billing was done the completed % column like below increased from 100% to 200% causing an invoice to happen. The billing rule is set to Time & Material .Here is the billing rule for Time & Material: This billing rule also includes a progress billing:  Could the billing rules be causing an issue. Some parts of the revenue are T&E and others progress. Let me know or if you need more detail.Thanks,Frances

Hi EveryoneI noticed that when we generate project billing to create a pro forma invoice, the change order line items do not have tax category assigned. Although the associated project task does. I am wondering if this is similar to the situation described in this thread below, when commitment does not have a non-stock item, tax category is blank despite project task. Since this discussion was from two years ago, has there been any changes to this?Anyone got any suggestion on how to improve this? It’s painful to assign tax category manually on the pro forma for change order items after generation.Thanks.

We are using Role Level Security to provide specific users with access to specific projects (Group Type A), which works.  However, this configuration requires us to update the role level security with each job that is created.   Is there a way to associate role level security with a employee workgroup, rather than an individual user?

Hi everyone,I'm trying to create a simple import scenario to release Proforma invoices. However, I consistently receive the error:"0 records of 1 have been processed. The last error was: Another process has updated the 'PMProforma' record. Your changes will be lost."What’s strange is that it seems to perform the Release from Hold action, as the AR invoice is created — but the Proforma itself remains in Open status instead of moving to Closed.Could it be that I’m doing this the wrong way? Any ideas or recommendations would be greatly appreciated!    Import scenarioBefore B.E. After B.E.B.E. ConditionsERROR 

How do I release AR Retainage  Sue

We just recently upgraded to 24R2 and noticed a few hyperlinks that used to open in the same tab, now open in new tabs.  For example, in projects, if we click on the hyperlink to get to the pro forma, it opens in a new tab.  Is there an easy way to revert this back to where the hyperlink opens in the existing tab? Thanks! 

NEW - Construction Micro Discussions - Union, Non-UnionThis idea stems from conversations with customers and product teams looking for a way to have discussions around more specific sets of topics. Two of the areas were: Union Construction and Non-Union Construction. We have decided to pilot these two for now but plan to expand to other topic areas and forums.So how does it work?If you want to have a discussion (or ask a question) that’s Union or Non-Union related, just use the Tags to add Union + Construction or Non-Union + Construction. You can see how I have done that with this post. Note that the discussions themselves look the same except will be tagged with either union or non-union at the bottom. This is just a way of filtering everything else out and just seeing topics tagged with those tags.Those looking for a discussions on Union Construction or Non-Union Construction, can then just click pre-setup links we have created:Union ConstructionNon-Union ConstructionPlease check it

In project accounting, is there a report that shows employee hours and the corresponding billed amount by project? On our billing rule, we are generating a billing detail for each time detail. Ie. no aggregating.On the AR invoice, we see individual details corresponding to each time activity; however, it does not contain the employee ID/information. Does anyone have a way of showing the hours and amounts information on one report?

 Hi,I'm experimenting with moving transactions from Project A to Project B.However, as soon as I enable POST transaction to GL, it gives me an error.Yet the project and tasks exist, and the accounts in the original transaction belong to account groups. As a trial and error, I tried to do the following for the accounts:[debit account]  & [credit account] "use source" & "use source","use source" & "Debit source""Credit source" and "use source","Debit source" "Credit source"This didn't work either way.What am i doing wrong?     

many of our construction clients want to be able to use advanced warehouse management features like scanning, receiving, transferring material to projects / returning items from job sites.  Currently the only way I’ve been able to make this work with construction is via the incredibly clunky project location process that requires assigning each project to a unique warehouse location. Reason I've needed to do this is that the mobile issue, receipt, or transfer items simply do NOT allow you to code entries to project, project task, or cost code, and you are forced to have the warehouse fill that information for you. How are other people handling these needs? customization? Third party?

Is there a way to restrict access so that Project Managers can add projects and project tasks, but cannot change the status of the Task or Project to Complete?  We want the project and tasks status to be changed only by accounting.  I have tried to restrict this with the Access Rights by Role by changing the Project Management access to Insert for the Project and Project Tasks, but even after this change, it is still allowing them to change the project status.  Thank you!

Hi everyone,I’m looking for some community feedback on a challenge I’ve been encountering. I’ve tried to get this working 2–3 times without success.I’ve been trying to set up an Automation Schedule for the Run Project Billing (PM503000) screen to automatically bill certain Time & Material (T&M) projects — and to be honest, I find the process a bit tricky.Issues I'm facing: Either too many projects are being billed (not just the ones I intend to include), Or the schedule runs, but nothing happens — no projects get billed at all. I’m aiming to target specific projects only, and ideally, I’d like to achieve this without any customization or Business Events (at least not as a first step).Here’s how I currently understand the logic: The selection of projects for billing seems to be driven by the Billing Cycle set on each project. If a project has a cycle set to On Demand, it appears to be considered a manual billing project. When set to On Demand, the Next Billing Date is c

Hi there,I want to import data using excel file into Document Template.So, I trying to setup 'Load Records from File' button on screen SM209020 (Document Templates)I click upload for Excel but nothing happen ?ScreenId=SM209020 > tab Tasks ( Allow upload = true) https://stackoverflow.com/questions/45048040/nothing-happen-after-click-upload-excel/45059835#45059835 I have looked at this link. However, I still do not understand clearly about the public place PXSelectJoin<PMTask,....Please help me understand the problem I am having?

Hi all, I have a prospect who uses Exaktime for time reporting and imports that data via AccountLynx into ADP for payroll, he says this “connection is unreliable.” Has anyone experienced issues with data import from Exaktime to Acumatica? Any help/feedback is greatly appreciated, thanks in advance!

GC here, implementing a prequalification program for vendor onboarding. We’re running prequalification outside Acumatica and want to reflect the following in Acumatica, ideally on the header area of a Vendor’s directory page: Prequalification status Single Project Limit Max total capacity v total in current open commitmentsCurious if others have done similarly? Would love to hear what ended up being feasible within Acumatica and what approach you took. 

The use case is:  The customer requires 2 locations one is ship to a plant to modify/build the item and after it is shipped to a job site for sub projects 

Hi,I created a business event for a client to alert users when their project quotes have been approved. It’s working but many users will have to make edits on a regular basis and the business event triggers an e-mail again after making edits. What condition can I use to trigger the e-mail to be sent once and not after each edit. Here is my configuration: Let me know.Thank you,Frances