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; } } }

how to get running balance of sales orders outstanding

Tracy M

I am trying to find/run a report that gives me a by customer breakdown of sales orders lines and what is still on back order. Nothing seems to be working for me to show this. It only comes up with opens sales orders but the invoices are not showing as coming off this in the hosted reports.

Comments

Acctd4

Hi Tracy

The “Open Sales Orders by Item” report will show the order “Qty” v the “Invoiced” Qty. You can also add the “Amount” & “Open Balance” columns to reflect the $ values of these too. Unfortunately though, it can’t be subtotalled by customer.

Alternatively, you can tweak the “Open Sales Orders by Customer” report to show the order “Qty” & “Open Balance” ($ amount), but the “Invoiced” Qty is not an available column option for this one

Shaz Hughes Dip(Fin) ACQ NSW, MICB

Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)

Accounted 4 Bookkeeping Services

Ballajura, WA

0422 886 003

shazinoz2@bigpond.com

www.accounted4bs.com

Tracy M

Hi Shaz
I had already worked all of the above out and just really frustrated that I cannot create a report that shows back orders per customer showing items and quantity as well as $value. May have to look for another program that provides this detail.....

cosmic

Hello Tracey
CAL ME see if we can help you . Chandra 0407068942

Reckon Accounts Hosted Announcements & Important Info

Check out the latest important info & announcements for Reckon Accounts Hosted

Button

View all Reckon software categories 🗃️

Each Reckon software has its own dedicated category on the Community. Click below to browse all categories.

Explore all categories