Is there a way to limit a Project Task and Cost Code combination to only those that exist on a Project Cost Budget?

  • 5 November 2020
  • 11 replies
  • 787 views
T
Rank
Userlevel 4
Badge +1

In many screens, such as PO, Issue, AP Bill, Receipt, even Project Transactions, the system allows a user to choose an existing Project Task and then apply any Cost Code existing on the project to that Task even if that combination of Project Task/Cost Code does not exist on the Project Cost Budget.

The system currently adds a new row in the Cost Budget, which to my client is a real issue.

Furthermore, it would be additionally helpful to NOT allow new Task/Cost Code/Account Group combinations beyond what exists on the Cost Budget.

Has anyone else ran across this issue and were you able to prevent it from happening?

Tammy Snyder

11 replies

V
Rank
Userlevel 7
Badge +11

Hi @tsnyder16 

Here is the Budget control option what we have on Document entry (documentation link below). You may post a feature request on our Product idea page (https://community.acumatica.com/ideas) to extend the functionality to meet your requirement. I don't see an option to restrict use of Project Task/Cost Code combination based on budget.

https://help-2020r2.acumatica.com/(W(11))/Help?ScreenId=ShowWiki&pageid=c17cd234-2ac9-1488-a687-fa3ccdaa1e16

 

Hope this helps,

Regards,

VijayKumarU
P
Rank
Userlevel 3
Badge

I agree that this would be very convenient. In fact, I have noticed this myself during demos and I’ve had questions about it.

This would require a controlled addition of a task, phase, cost code and perhaps start the change order process.

sroberts29
Rank
Userlevel 3
Badge +1

Please upvote this ‘idea’!

https://community.acumatica.com/ideas/selecting-cost-code-for-project-related-transactions-only-shows-a-warning-if-no-budget-line-exists-we-need-an-option-setting-to-have-this-be-an-error-3747

C
Rank
Userlevel 3
Badge

The link appears to be different now:

 

kristianharianja
Rank
Userlevel 5
Badge +3

I have come across this request recently and am keen to see if someone has ever built a customization to prevent cost cost selected in Purchase Order if the cost code is not present in Project Cost Budget.

I am also interested with workaround such as business event to send notification if someone has entered a un-budgeted cost code. 

Kristian Harianja
sean21
Rank
Userlevel 4
Badge +1

^I’m trying to do the same thing for service orders, but ideally this functionality exists across all relevant screens. 

If a service order is created for a project and I add a service line item to the details, I should only be able to select project tasks and subsequent cost codes that exist in that project. This is the case for the project task, but not for the cost codes. In the web version, there is a tab for “project codes” only, but techs in the field using the mobile app to log time have access to the entire list. 

Even as a tech creating time activities directly to projects via time cards in the mobile app, they have access to the entire list of cost codes and there is no tab for “project codes” only. 

Sean Reeves | Practice Director - Solutions Architecture | Presales Leader
aaghaei
Rank
Userlevel 7
Badge +8

This can be achieved by using PXRestrictorAttribute on each data entry screen. See below for more information

 

https://asiablog.acumatica.com/2016/08/using-of-pxrestrictorattribute.html

Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
greglang
Rank
Userlevel 3
Badge

Anyone get this working and willing to share the code?  I’ve played around with it a bit with no luck...

Greg Lang
K
Rank

Has there been any development to this inquiry? 

Not having this capability is causing issues with creating meaningful data reports.

J
Rank

The fact that limiting task+cost code combinations to what we set up in the project  is not an option is so surprising to me.  It creates so much extra work and confusion.  I really hope this gets added (and I have voted).

J
Rank
Userlevel 4
Badge

This is a constant request across implementations in any level of the construction vertical. Real estate developers, GC’s, specialty subs. All require this feature. 

We’ve resorted to very complex and expensive customization to solve. 

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved