Skip to main content
Solved

Expense Claim Total NOT matching total of expense line items

  • 9 January 2024
  • 3 replies
  • 75 views

Forum|alt.badge.img

I have the expense claim below in the screenshot.  There is MAJOR issue here where I cannot figure out why the Expense Claim Total equals 1,043.86 but when I add up the line item totals it ONLY amounts to 929.56!  Why is there a 114.30 difference??  Note that 114.30 is exactly the same amount if you add line items of 24.30 and 90.00 together.  It looks like Acumatica is DOUBLING those two line items.  But why??

 

 

 

Best answer by Laura02

Hello @NetAdmin42 ,

I notice there is a known issue that seems to match your situation.

https://community.acumatica.com/known-issues-232/known-issue-on-the-expense-claims-ep301000-form-the-amount-in-the-claim-total-box-in-the-summary-area-was-not-equal-to-the-sum-of-amounts-in-the-claim-amount-column-of-the-detail-lines-17542

In case you can’t access the Known Issue (not everyone can see every post), here is the information.

Issue description

On the Details tab of the Expense Claims (EP301000) form, if a user added both taxable and non-taxable lines, saved the claim, and subsequently modified the details of the claim (for example, added new lines, or changed the date or tax category), then the amount in the Claim Total box in the Summary area did not match the sum of the amounts in the Claim Amount column of the detail lines.

Solution

Update to one of the following builds of Acumatica ERP:

  • 2023 R1 Update 6 (23.106.0050) or later
  • 2022 R2 Update 15 (22.215.0056) or later
  • 2022 R1 Update 21 (22.121.0026) or later
  • 2021 R2 Update 24 (21.224.0015) or later

Workaround

Contact your Acumatica support provider to receive the workaround instructions and any assistance with using them.

Laura

View original
Did this topic help you find an answer to your question?

3 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3101 replies
  • Answer
  • January 10, 2024

Hello @NetAdmin42 ,

I notice there is a known issue that seems to match your situation.

https://community.acumatica.com/known-issues-232/known-issue-on-the-expense-claims-ep301000-form-the-amount-in-the-claim-total-box-in-the-summary-area-was-not-equal-to-the-sum-of-amounts-in-the-claim-amount-column-of-the-detail-lines-17542

In case you can’t access the Known Issue (not everyone can see every post), here is the information.

Issue description

On the Details tab of the Expense Claims (EP301000) form, if a user added both taxable and non-taxable lines, saved the claim, and subsequently modified the details of the claim (for example, added new lines, or changed the date or tax category), then the amount in the Claim Total box in the Summary area did not match the sum of the amounts in the Claim Amount column of the detail lines.

Solution

Update to one of the following builds of Acumatica ERP:

  • 2023 R1 Update 6 (23.106.0050) or later
  • 2022 R2 Update 15 (22.215.0056) or later
  • 2022 R1 Update 21 (22.121.0026) or later
  • 2021 R2 Update 24 (21.224.0015) or later

Workaround

Contact your Acumatica support provider to receive the workaround instructions and any assistance with using them.

Laura


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 62 replies
  • January 10, 2024

@Laura02 Thank you for the iink.  I had not been able to look that up.

Question : Is there a way for me to correct this and/or any other Expense reports that may have this issue that are there now until I can have this version updated?  SQL script?  Any other method that I might use to correct it?


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3101 replies
  • January 10, 2024

Hello,

I expect that there could be a script that Acumatica can provide to you and/or to your VAR when you open a support ticket.  The script is not included in the post.

 

Laura


Reply


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