You can simply find and replace your currency symbol or code.
E.g. in my case the currency code is “BHD” so after I copy to spreadsheet:
I press Ctrl + H (may vary depending on your OS/Office suite)
Find “BHD” and replace with nothing.
Press Replace All and the currency column is now number instead of text
hi i have tried more on my own to create the report since to no avail i wanted the report just as i wanted.
What i need is a report exactly just like the Customer Statements (Unpaid Invoices) but with additional grouping of the sales invoice total by a custom field.
my trial so far:
im getting frustrated now. can someone help me.
I am not sure why there is not any details under all the columns. I can see detail under all columns when I use the same parameters that you have.
Anyway, a report based on Custom fields will probably not produce what you want.
Changes to Custom fields and Custom Reports have been promised by the developer
to improve this. It has been some time though and difficult to know when improvements will happen.
i have tried your method, but its not working out as i need.
I can work out the custom field grouping. I just need to make the report to be like Customer Statements (Unpaid Invoices).
What you want will not be achievable, as at present each custom field is specific to a transaction and has to be defined separately (which results in many columns or many groups which would make the report difficult to read and understand).
I believe that the new functionality will remedy this (when it is implemented).
It is difficult to give help when you only show part of the details each time you post.
Each time you post you should show the following:
I don’t think you can join the Transactions table that contains AccountAmount with Sales Invoice. Instead, Sales Invoices are already joined with the transactions table using SalesInvoiceAsTransaction.
If you replace Sales InvoiceSalesInvoiceAsTransaction in your Select criteria, that should solve your empty columns issue as a start.
