Skip to main content
Solved

Negatives not appearing correctly in Excel export. Seen this before?


jhouser
Captain II
Forum|alt.badge.img+1

I wrote a new P&L in ARM with expense rows coded to show as negative. It works correctly in the report, but when exported to Excel I have the problems below:

  1. Amounts appearing as positive in Excel but negative in the formula bar (i.e. Excel treating as negative but appears as positive)
  2. Amounts appearing as positive when they are actually negative (opposite of #1)
  3. Amount showing as negative in both Acumatica and Excel (correct) but in formula bar it’s actually pulling through as a positive number

Basically the negatives are all wrong in Excel, but not consistently so 🙃 I’ve looked extensively online and in the community but haven’t found a solution. An example of the row format is below:

 

 

Appreciate any help! 

Best answer by jhouser

I found the solution here: ARM reports FAQs: Common questions | Community (acumatica.com)

 

Multiplied by -1 in Value column and removed coding from row format:

 

 

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

2 replies

jhouser
Captain II
Forum|alt.badge.img+1
  • Author
  • Captain II
  • 103 replies
  • Answer
  • April 20, 2023

I found the solution here: ARM reports FAQs: Common questions | Community (acumatica.com)

 

Multiplied by -1 in Value column and removed coding from row format:

 

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2642 replies
  • April 20, 2023

Thank you for sharing your solution with the community @jhouser !


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