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:
Appreciate any help!
Best answer by jhouserView original