Hi Bruce
Thanks for the time taken.
Much appreciated.
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
- - - - - - - - - - - - - - - - - - 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
- 15 Feb 2018, 13:57
- Forum: Sage 50 Report Designer
- Topic: TOTAL VALUES BASED ON DISPUTED
- Replies: 6
- Views: 4177
- 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.
I have attached the file as I am not familiar with the if functions or expressions.
- 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
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
- 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. ...