Hi,
I added the criteria AUDIT_SPLIT.DETAILS to the Supplier Activity report, so for example I can filter only "payments on account".
At the moment when entering the criteria i have to enter [Details IS "payments on account"] to list only the payments on account, but can I use wildcards to enter just "payments" for example ?
Thanks,
Sam
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
Wildcards
- brucedenney
- Site Admin
- Posts: 4629
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Wildcards
The answer to your question is
BUT
The text in the details does on a payment on account or a purchase payment does not have to contain the word "payment" it can have anything in it.
There is a better way and that is to use the Transaction Type field in the header this is 100% reliable.
The Transaction type wants to be "PP" or "PA" to list all your payments.
This sort of comparison is also less hard work for the computer, so should run a bit faster.
The filter would be
Code: Select all
Contains(AUDIT_SPLIT.DETAILS, "Payment")
The text in the details does on a payment on account or a purchase payment does not have to contain the word "payment" it can have anything in it.
There is a better way and that is to use the Transaction Type field in the header this is 100% reliable.
The Transaction type wants to be "PP" or "PA" to list all your payments.
This sort of comparison is also less hard work for the computer, so should run a bit faster.
The filter would be
Code: Select all
AUDIT_HEADER.TYPE = "PP" OR AUDIT_HEADER.TYPE = "PA"
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 6 guests