Gift certificates reports multiply by -1

V5 Question
5

Yea I was just testing using Customers and not Gift Certificates but they are the same thing just difference Entities: The syntax below works for me BUT I do not have any other Entities with Accounts, just Customers. I cannot see why you can not substitute for Entity Gift Certificates. No custom fields just Customer with an Account created, just as Gift Card with Account created.

[List:1,1]
{REPORT ENTITY DETAILS:
	E.Name,
	([E.Balance]*-1);P0.00;N-0.00;Z0.00:
	(ET=Customers) and E.AccountId>0:
	{0} | ${1}}

Using the “.sum” makes no difference WHEN specifying a mutli-column report but if you just list the 1 field it will give you the Total of all Gift Card Accounts - to which I think is not what you desire.

The tricky syntax delving into emre’s mind (oh save me) is the qualifier is at the end of the Syntax as below:

([E.Balance]*-1);P0.00;N-0.00;Z0.00:(ET=Customers) and E.AccountId>0:

The middle stuff is just me seeing how the Positive;Negative;Zero formats work. Thinking as I just wrote this you probably do not need the “*-1”, maybe just use 0.00 for the negative position?

Try without using multiplier:

>Balances x 0
[List:1,1]
{REPORT ENTITY DETAILS:
	E.Name,
	([E.Balance]);P0.00;N0.00;Z0.00:
	(ET=Customers) and E.AccountId>0:
	{0} | ${1}}

No need for “*-1” you can just use the formatting option as above, I have taken out the “N-0.00” and replaced with just “N0.00”.

You can just use E.Balance and ditch the Brackets as no need to multiply by “-1”. The issue is filtering report to just Balances >0 and I think E.balance has an issue. :smiley:

Must run but found the link I was looking for with regards using “E.Balance>0”:

1 Like