nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Export display for sales reports

SharonMaguire

How do I customise the reports so that each column holds data ie the Customer Name and Debtor ID are in seperate columns not above the information. Please see attached.

Sales Detail Report.PNG

Find more posts tagged with

customise

Export to Excel

sales reports

Accepted answers

Mike_James

Hi @SharonMaguire , I see your Card ID values are numeric, so you need a different formula in each column:

A2: =IF(IFERROR(FIND("/",D3),0),A2,C3)

B2: =IF(IFERROR(FIND("/",D3),0),B2,D3)

and copy these down. These formulae check the values in the date column for a "/", which must be a date, as long as you don't use that symbol in a card ID.

All comments

SharonMaguire

Hi Mike

Thank you, however if I delete column A I will loose the customers name. I think I'm missing something.

Mike_James

Hi @SharonMaguire , that can't be done in AccountRight itself, but it is possible in Excel.

I've attached a small example. If you modify your report columns and rows to match*, then set up the formulae in teh first two rows, and copy the second row down to the last report row. Then you should have the customer name and card ID in every row.

* Delete row 11 (the blank row between the column headings and the first row of data, then delete column A and insert 2 fresh columns. Format those as General before adding formulae.

report layout changes.jpg