Skip to Content
0
Former Member
Mar 30, 2010 at 08:25 PM

BP Internal Reconciliations

102 Views

Hi,

I'm using SAP B1 2007B, and i got a issue with BP Internal Reconciliation, i'll be grateful if someone could help me. Here's the case...

It was made a outgoing payment of several notes containing Withholding Tax on Payment that generated the Journal Entry:

Debit - Vendor

Credit - Bank

Credit - WithHolding Tax

Then it was found that an A/P invoice was incorrect and had to be canceled, so i cancelled the payment that created the Journal Entry.

Credit - Provider

Debit - Bank

Debit - WithHolding Tax

The note in question was canceled, but when i see the reconciliation performed in each case, i observed the following scenario:

Payment Reconciliation

Origin From Value Value applied

PS Vendor R$ 498.65 R$ 498.65

PU Vendor R$ (498.65) R$ (498.65)

Reconciliation of Payment Cancellation

Origin From Value Value applied

PS Vendor R$ 498.65 R$ -498.65

PU Vendor R$ (498.65) R$ (-498.65)

Reconciliation of Invoice Cancellation

Origin From Value Value applied

PU Vendor R$ 498.65 R$ 495.66

PC Vendor R$ (498.65) R$ (495.66)

The invoice has closed status, but the difference between the Value and Value applied (R$ 2.99) continues to appear on the screen of BP internal reconciliation, but does not appear on Outgoing Payment.

The negative value on the cancellation appears on Outgoing Payment and reconciliation, but does not allow me to pay or reconcile both values.

Someone could tell me why the system has made reconciliation with a lowest value applied, if the A/P Credit was done with total value? And what can I do to make a full reconciliation of values?

Regards,

Lucas Sigaki