Outgoing Payment Issue

[Former Member]

We have a client that has two outstanding AP invoices that show up as open. When he goes through the payment wizard or directly from the outgoing payments, he cannot see the open invoices to pay.

Our research showed that for that particular AP vendor, there is an amount exactly the same as the open invoice "On Account". However we have gone through the system and cannot find any credit memos, any payments associated with that vendor that could explain the "On Account" Amount.

The client is using 2005. Has anyone ever come across this situation?

Thanks,

Rene

[Former Member · Accepted solution]

Since you have exact Payment on Account amount in the system, you can reconcile your AP invoice with those amounts. However, if those amounts are wrong, you should not check credit memo but all outgoing payments to that Vendor. You must cancel those wrong payments in order to show these 2 invoices on the payment windows.

Thanks,

Gordon

[Former Member · Accepted solution]

Thanks Gordon but the point is that the payments "On Account" are not showing up anywhere. the amount is not even reducing the business partner's balance.

Here's the situation in details:

AP Invoice shows Open for $569.00

I can do search by the AP invoice and am able to find it

When we go into the outgoing payment to pay the invoice, we do not see the invoice on the list to be paid, however at the bottom where the payment on accounts are listed, I can see a total of $569.00

We've looked at all payments and cannot identify where the "on account" payment was ever posted.

We tried to go into the "link invoice" and do not find anything, we tried to go into reconciliation and we do see the invoice but we do not see a payment. For some reason the invoice appears to have been paid but it is still in open status?

I hope this clarifies my question a bit. Thanks,

Rene

[Former Member · Accepted solution]

Hi Ramak Soussani

Could you check the AP Invoice Table using Query Generator whether Payment has made,Using corresponding Field Amount paid.

By

Kart

[former_member583013 · Accepted solution]

Ramak,

Are you using Consolidated BP? Please check the Jounal lines table using a query like this. It is also possible the a JE was posted on this BP.

SELECT T0.[TransId] AS 'Transaction Key', T0.[Debit] AS 'Debit Amount', 
T0.[Credit] AS 'Credit Amount', T0.[ContraAct] AS 'Offset Account' FROM  [dbo].[JDT1] T0  
WHERE T0.[ContraAct] = 'V10000'

Change the V10000 with the vendor code you are looking for.

Suda

[Former Member · Accepted solution]

Thanks everyone however I still don't seem to be able find as to why I am not seeing my open AP invoice on the Outgoing payment.

I have run several queries from the AP invoice and the outgoing payment tables and I cannot find an associated payment with this particular invoice. Thanks anyways.

[jitin_chawla · Accepted solution]

Hi Rene,

Check Note No. [1041101|https://websmp130.sap-ag.de/sap(bD1odSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1041101] and see if the query results in any documents and if any documents are resulted check if your AP Invoice is there or not.

Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Thanks I tried this too and did not get any feedback. Even though this issue seemed very close to the issue we are experiencing. At this time I have cut a ticket with SAP directly. Thank you.

[Former Member]

You need to query the Outgoing Payment table (OVPM) directly to find all payments related to this Vendor.