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:
- Amounts appearing as positive in Excel but negative in the formula bar (i.e. Excel treating as negative but appears as positive)
- Amounts appearing as positive when they are actually negative (opposite of #1)
- 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:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/d0c6ebcb-9b7d-4a96-a7f6-56e9e60a3e25.png)
Appreciate any help!
Best answer by jhouser
View original