Skip to Content
0
Former Member
Nov 27, 2009 at 06:37 AM

Deposit Detail

333 Views

Hi Experts,

I'm using SAP B1 2007 B PL10.

I need to get certain report which displays all check deposits made to a bank on a particular day along with the name of the party whose checks are being deposited which includes cancelled deposits as well. As far as I understand, need to join the journal detail table and the deposit detail table for this. System Information for detail grid in Deposit screen says the table referred to is OCHH, but once the deposit is cancelled, DPSTABS field which stores the deposit id in OCHH table is reset to 0.

1) So how can I get the details of checks deposited if I get the deposit Id of a cancelled deposit.

2) For each check in a deposit transaction, there are 2 rows added to JDT1(one debit and the other credit). If the deposit transaction has more than one (say 2) checks, how to map which line is for which check.

Please advise on the above issues

Thanks & Regards

Jaics