SAP B1 Incoming/Outgoing Payment Crystal Report Draft is wrong

[Former Member]

I am using SAP B1 9.0. When I try to preview/print the SAP B1 Incoming/Outgoing payment draft by crystal report, it show the wrong record.

For example if I select the first record in payment draft report, and the draft PV no is 210.  But when preview, it always show the record in PV1 in OVPM.  not from OPDF.

Unlike the Sales Invoice, even in draft, the system still able to show the correct draft invoice from ODRF table.

[BattleshipCobra]

After taking a look at this in 9.0 it uses the same layout for the draft as the real form.  So this is the first problem.

Secondly, the table you are looking for is OPDF not ODRF.  OPDF is for payment drafts.

And lastly, in 9.0 PL14 you can't even print the payment drafts.

So you have a couple of problems in front of you.

My suggestion would be to do a Crystal Report that just lists out the draft payments for approval all in one report.  Just use OPDF / PDF1 and then make a nice landscape report.  Then the user can make all of their payments and then print off the signoff sheet which would have all the details.  Then if approved the user can go and add them.

Mike

[former_member209066]

Hi,

Please Post the Query.

Thanks,

Nithi