Skip to main content
Question

Budget vs Actual by Cost Code Report issue - Duplication of Actual Hours for Certified projects

M
Freshman I

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?

M
1 person likes this
  • M
    MBillRJT050619

iqraharrison
Captain II
Forum|alt.badge.img+8

@MBillRJT050619 what version are you on and is this a custom report? 

Iqra ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*. Proud Acumatica MVP (2024, 2025) - See my journey here: https://community.acumatica.com/community-site-discussions-150/iqra-harrison-acumatica-mvp-2025-28977
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
M
Freshman I

@iqraharrison We are running 2023 R1 Build 23.113.0042. This is an out-of-the-box report.

iqraharrison
Captain II
Forum|alt.badge.img+8

@MBillRJT050619 i’m not seeing this in my sales demo.  do you mind exporting the report and attaching it here? i can add it to my sales demo and see if i can help figure out why there are duplicates or maybe set up some condition to exclude the hours for fringe benefits. 

Iqra ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*. Proud Acumatica MVP (2024, 2025) - See my journey here: https://community.acumatica.com/community-site-discussions-150/iqra-harrison-acumatica-mvp-2025-28977
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
M
Freshman I

@iqraharrison Do I need to export it as an excel file because I am unable to attach the rps file to this thread?

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • July 2, 2024

Hi @MBillRJT050619  were you able to find a solution? Note if you wish to upload a file you need to zip it first. Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
M
Freshman I

Hi @Chris Hackett no I have not found a solution. I have not received an answer to my question regarding how to export the report. Do I zip the rps file or what do I need to do?

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • July 3, 2024

Hi @MBillRJT050619 - I can’t help you with exporting but if you have the .rps file you would zip it and attach it to a post you make here. The community platform doesn’t support attaching .rps files which is why you have to make it .zip. 

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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