AR Down payment usage

[tgjaneesh]

Hai Experts,

I want to know about particular AR Down payment Invoice , to which transaction that particular AR DPI used.any query is available for knowing the same...?

Regards

Janeesh

[Former Member]

HI Tgjaneesh,

General Definition:

u2022Down Payment is the term used when receiving or requesting an advanced portion of a payment through a legal document

Purpose

u2022There is a business need for companies to issue and receive documents for down payments. The recording of the payment requires an invoice.

Hope it helps you to better understand

Regards,

Anish

[tgjaneesh]

Hai Anish,

I am not bothered about its definition .my question is how to identify the document to which AR DP applied .

to be clear , suppose AR DP No.18 applied to AR Invoice Doc No. 230 , any query or standard in SAP B1 available to get the list of AR DP with its applied document no.

ARDP No. AR Inv.DocNo.

01 200

02 211

03 215

Regards

Janeesh

Edited by: tgjaneesh on Aug 31, 2011 9:54 AM

[Former Member]

Hi Janeesh....

Please check this....

http://www.orchestrateam.com/video/sap-businessone-video-ar-down-payment

For Query report you may refer....

SELECT T0.[DocNum], T0.[DocDate], T0.[CardName], T0.[DpmAmnt], T0.[DpmAppl],

T0.[DpmPrcnt], T0.[DpmDrawn] FROM OINV T0

Regards,

Rahul

[tgjaneesh]

Hi Rahul,

Query is ok...but my problem is to identify the DocNo of ARDP with amount...can I get AR DP no. in this query report ? If it is possible my problem will solve.

Regards

Janeesh

[Former Member]

Hi Janeesh...

Try this....

SELECT T0.[DocNum], T0.[DocDate], T0.[DocDueDate], T0.[CardCode], T0.[CardName], 
T2.[DocNum] FROM ODPI T0  INNER JOIN DPI1 T1 ON T0.DocEntry = T1.DocEntry 
LEFT Join OINV T2 On T2.DocEntry=T1.TrgetEntry WHERE T1.[TargetType] =13

Regards,

Rahul