Hi All
I wonder how Accpac calculates the Total Outstanding Balance we see on the "AR Customer Inquiry - Credit Status Tab". I need to be able to get the same figure from SQL queries.
Please advice.
Hi Ettiene
Thanks for replying. I understand ARCUS.AMTBALDUET/AMTBALDUEH refers to Outstanding AR Balance but I need the Total Outstanding Balance which include the AMTBALDUEH/AR/OE/Other pending balance.
Please advice
Hi Tuba2007
Thanks for responding. I am following your suggestion but I still cannot get the same figure as the Accpac is showing for O/E pending balance.
"select * from ARIBH where IDCUST='XXX' and DATEBUS=0" retuns no rows.
"select SUM (ordtotal) from OEORDH where customer='XXX' and COMPLETE<3" returns a value different from O/E pending balance showed on that screen.
Another way to tackle this is to create a new customer in sample data and add a transaction in OE. Then start rvSpy with dbSpy and open the screen showing the balance that you're trying to get.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.