cancel
Showing results for 
Search instead for 
Did you mean: 

How to clear balance on AR Customer Deposit

Former Member
0 Kudos

Have an "open to apply" balance on a customer deposit which is not accessible from the invoice screen for selection - how can I clear this out?

Accepted Solutions (0)

Answers (2)

Answers (2)

jitin_chawla
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Can you provide with some screenshot to better understand the issue?

Kind regards,

Jitin

SAP Business One Forum Team

Former Member
0 Kudos

1.  Invoice Entry - When attempting to create a dummy invoice to select the Down Payment with intentions of doing a JE to clear out the Invoice I get the message at the bottom of the screen in red - "You cannot choose "Total Down Payment" browse button: first create a down Payment."

2.  Open Item List - AR Down Payment Not Yet Fully Applied - does not list the open amount in question - Total of this report $263,750.51.

3.  A query of Open Customer Deposits which list the amount in question - note the total of this report is $263,774.51 which matches the General Ledger Customer Deposit Balance.

4.  Looks to me as if an indicator or "switch" is marking this balance as closed making it inaccessible to select and clear out - but it is open and reflects such in the GL and from the query.

jitin_chawla
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Do you get any result from the following query :

SELECT T0.DocNum, T1.Status, *

FROM ODPI T0

INNER JOIN DPI6 T1

ON T0.DocEntry=T1.DocEntry

WHERE T0.DocStatus<>T1.Status

Kind regards,

Jitin

SAP Business One Forum Team

Former Member
0 Kudos

Doc Status and Status both show "C"

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try below  thread:

http://scn.sap.com/thread/2107557

Thanks & Regards,

Nagarajan