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.

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