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