SageForum for UK versions of Sage 50- Help and support.

Hi Bruce,
Just wanted to ask for advice regarding Customer Statements as per below.
So my customer statements all say "Goods/Services" against each invoice listed. Is it possible to change the "audit_split" "STMT_Text" variable by utilising the invoice "TYPE" variable SI, SC, PA etc. and have it replace the contents of the STMT_Text variable with either “Service Invoice, Service Credit, Payment on Account etc.” based on the variable "TYPE" for each line in the statement.
I'm aware if you swap the variable to 'AUDIT_SPLIT.DETAILS' or 'AUDIT_HEADER.DETAILS', then the statement will show the details of the actual transaction but I just want the transaction type to show instead. Hope this makes sense.
My Sage is V24 (Sage 50)
Thanks
Raph

You can do it several ways, you could put a bit of text for each transaction type on the line with the suppress print flag set, they use conditional formatting to enable printing of the appropriate text for each transaction type.

You could also write an expression that results in the appropriate text for each transaction type.

You can also set the predefined text for the 4 transaction types on statements in Settings>Customer Defaults>Statements

Thanks Bruce for your suggestions.
Much appreciated