You should vote for this enhancement on the Ideas site: www11.v1ideas.com/.../2498

Thanks,

Jennifer Pitt

Thanks Jennifer, I did vote for it actually. I see it was asked for over a year ago, not sure if Sage is doing anything about it or not, so figured I'd ask here in case anyone had come up with a workaround.

trodman is a pretty good go to person for reports.  Tim?

Thanks,

Jennifer Pitt

This is not very difficult for a SQL person.  Probably 15 to 30 minutes to whip out a view (at least glancing at it).  Maybe you could ask your reseller to do it and throw them a bone.

@Jennifer - Thanks for the kind words.

@tcoult - I agree with you that this seems very similar to Sales Clearing and Purchases Clearing. I've looked at the details behind the Purchases Clearing report to find an alternative way to reconcile because our Purchases Clearing report was frequently out of balance with the GL:

www.linkedin.com/.../Purchases-Clearing-Reconciliation-1425997.S.5851466254237327360

@John - Were you using the Sales Order line as the basis to tie everything together? I would probably start with AR Invoice Lines and AP Voucher Lines and join them back to the Sales Order line so you could see which sales order lines still have a balance.

I haven't written it so I'm not sure of the best place to start but tsoSOLine has the POlineKey.  It won't be difficult which ever way someone goes.  

Ya, not difficult in theory, but, as you know, it always takes longer than you expect it to.

When I first started working on Purchases Clearing, I thought it would be simple, but reconciliations have a tendency to get messy and the reports that support them have to account for all the different things that can go wrong.

But if tcoult can get a fixed price quote from their reseller, then they could decide if it's worth the price.