Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Search found 4 matches

by AJFIELD
15 Feb 2018, 13:57
Forum: Sage 50 Report Designer
Topic: TOTAL VALUES BASED ON DISPUTED
Replies: 6
Views: 4177

Re: TOTAL VALUES BASED ON DISPUTED

Hi Bruce
Thanks for the time taken.

Much appreciated.
by AJFIELD
12 Feb 2018, 15:53
Forum: Sage 50 Report Designer
Topic: TOTAL VALUES BASED ON DISPUTED
Replies: 6
Views: 4177

Re: TOTAL VALUES BASED ON DISPUTED

Thanks Bruce
I have attached the file as I am not familiar with the if functions or expressions.
by AJFIELD
12 Feb 2018, 09:59
Forum: Sage 50 Report Designer
Topic: TOTAL VALUES BASED ON DISPUTED
Replies: 6
Views: 4177

Re: TOTAL VALUES BASED ON DISPUTED

Hi Bruce
Thanks for taking the time to reply.

I don't understand what you mean by set it to 0 for non disputed transactions?

I have added a variable in the account ref footer (audit.split.disputed) and set the function to sum?

Thanks
by AJFIELD
09 Feb 2018, 13:36
Forum: Sage 50 Report Designer
Topic: TOTAL VALUES BASED ON DISPUTED
Replies: 6
Views: 4177

TOTAL VALUES BASED ON DISPUTED

Hi I have created a report that we send out to our suppliers showing what invoices are on our system and what is approved for payment and what is in dispute and the dispute code/reason. I am unable to add total boxes to identify the approved value for the month and the disputed value for the month. ...