thread Re: Deleting Rows Custom Report in Archived Discussions (Read Only)

Deleting Rows Custom Report

jgorman0 — Sun, 01 May 2022 21:08:25 GMT

I am creating a Custom Report. I've deselected some rows in the Sales Summary that we don't use, but they still display in the Report when I Export it. Is that something I just have to live with, or am I doing something wrong? Thank you.

Re: Deleting Rows Custom Report

Candlestore — Mon, 02 May 2022 14:26:19 GMT

@jgorman0 ;

It might be something you have to live with from Squares Export. Now to get around that if you use Excel, you could after download move that file to another folder. Then In excels Power Query write a one time simple procedure that would remove those rows if they are always the same rows. I do this for Columns for my Import to QuickBooks file. I down load 2 files from Square as csv files, move them to another folder, open my excel program that has the Power Query formula saved, click REFRESH Data or Links and bamm all my columns I do not need get removed, Headers get changed, and some math gets done to get price per Item sold not just the Total sale. use to take 1 hr for me to do this all and now its under 5 min and this includes the import to QuickBooks. You may want to look into this with Excel 365 or newer versions.

Re: Deleting Rows Custom Report

jgorman0 — Tue, 03 May 2022 13:15:15 GMT

Thank you

Re: Deleting Rows Custom Report

Candlestore — Tue, 03 May 2022 14:24:29 GMT

You are welcome