Get Advance Amount for a Particular Customer 1

[PrisWine]

I'm creating a csharp application to input Customer number and get the Advance Payment Amount from Sage ACCPAC 6.0

I'm referring the below SQL for getting the value

SELECT SUM(AMTEXTNDHC) AS AMTEXTNDHC, IDCUST, IDRMIT
FROM ARPJD
WHERE (ACCTTYPE = 1) AND (IDCUST = '???')
GROUP BY IDCUST, IDRMIT

BUT THE CUSTOMER INQUIRY SCREEN VALUES AND THE QUERY RETURNED VALUES NOT MATCHING , so how will I able to compare to make to correct

Please help me on the SQL Query

 

[ettienne]

Which field on which screen are you looking at for the Advance Payment Amount?
Be specific.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[Jay Converse]

You need to select the IDRMIT value, too if you want to see one payment.

 

[PrisWine]

@ettienne

I have included the screen in ACCPAC 6.0 , the values are not matching with the above mentioned query I need a help on the SQL Query , may be I'm referring to wrong table

 

[Jay Converse]

Payments are in AROBP.

 

[PrisWine]

this was my final solution and working fine
SELECT SUM(AMTPAYMTC) AS AMTPAYMTC, IDCUST, IDRMIT FROM AROBP
WHERE TRANSTYPE = 11 AND IDINVC LIKE 'PY%'

 

[DjangMan]

Just to add to this, reporting off of ARPJD is risky because posting journals can be cleared. Most companies don't because hard drive space is cheap but sometimes people invoke functions that they shouldn't.