GL report columns

How can I configure GL reports to separate info in the 'Description' column?

If you notice in the attached image (blotted for confidentiality), the customer/vendor name is always preceded by their cheque/cash number and comma.

Can these not be separated?  Later, when exported to XL for instance, it's very annoying and time-consuming to have to manually remove the payment info, comma, to achieve the Name only - which is what I'm often sorting for other reports.

Parents
  • 0

    One way to get around this - but more work for you - is to enter the customer/vendor invoices as Pay Later. then enter the payments thru the receipt/payment module.

    I'm not that advanced in using Excel but you might be able to select info in a column using a query that is text only and ignores numbers.

Reply
  • 0

    One way to get around this - but more work for you - is to enter the customer/vendor invoices as Pay Later. then enter the payments thru the receipt/payment module.

    I'm not that advanced in using Excel but you might be able to select info in a column using a query that is text only and ignores numbers.

Children
No Data