Get AR Customer Total Outstanding Balance 1

[bodlela]

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.

 

[ettienne]

ARCUS.AMTBALDUET or AMTBALDUEH

 

[bodlela]

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

 

[Jay Converse]

Sum ARIBH.AMTINVCTOT where DATEBUS=0, and OEORDH.ORDTOTAL where COMPLETE<3

 

[bodlela]

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.

PLease advice

 

[Jay Converse]

I have no idea, I can't see your data. You need to study it more.

 

[DjangMan]

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.

 

[bodlela]

Hi DjangMan,
You are the man. Thanks a lot
BR