How to flip account balance [Solved]

V5 Question
1

When I use the account balance if they have credit it lists as -30.00 whilst if they have debit it would list as 30.00 Is there anyway to flip that around so that credit would be 30.00 and debit would be -30.00 It’s a bit confusing on the receitps when the customer sees
Account Balance: -30.00 They think they have 30.00 owing to use whilst when it says
Account Balance 30.00 They think they have 30.00 to use

2

xxxx * -1 for both cases will do the trick…

G.

1 Like
3

You dont want to change the accounting because it is correct but you could reword your receipts and use formatting to show what you want.

4

he wont be able to change that in the account… he will be able to * -1 in reports or tickets… i think, LOL

G.

5

Yeah Im nto trying to change the receipts, I udnerstand the accounts show what is owing to the terminal. What do you mean @gerlandog? In my template where I have ENTITY ACCOUNT BALANCE:$ what should I have?

6

What im saying is you can format it to strip negatives and title it whatever you want. You can multiply by -1 for example

7

Could you possibly show me an example of how to format in print templates? Im guessing you need to use a function
So something like this?
[=FN({ENTITY ACCOUNT BALANCE:$} * -1)]

Would that work?

8

No you can use simple expressions. Its hard to type them up frpm a phone.

Edit: yes but thats not a function its an expression.

9

Show what you currently use now, then we can show how to reverse it.

1 Like
10 
<h4>Balance: {ENTITY BALANCE}  </h4>
11 
<h4>Balance: [=F(TN('{ENTITY BALANCE}') * -1)]  </h4>
1 Like
12

Cool Thanks Q :)… Works

2 Likes
13

Can someone briefly tell me the what some of the symbols here actually so, what their purpose is?
Like what is that expression that qmckay used mean?

14

[=...] … expression, used to do calculations, concatenations, etc.
F() … Format a number using system regional settings
TN() … convert To Number

More…

2 Likes