cancel
Showing results for 
Search instead for 
Did you mean: 

Open AP Invoice does not display in Outgoing Payments

Former Member
0 Kudos

SAP Business One 2007. I have open AP Invoice that appears in the Vendor Balance and aging. The invoice is open but does not display in the Outgoing Payments Window. The AP invoice is using a BP currency Euros. The invoice has an open status and not applied transactions

Any suggestions

Dennis

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Can you tell me the tables that are used to display the AP invoices in the Outgoing Payments is it just  OPCH and ORPC?

Former Member
0 Kudos

It takes also open journal entries - JDT1.

Can u port a scrren shots of both - the invoice and the payment forms?

Beni.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Tables that are linked AP with outgoing payment is  OVPM and  VPM2

OVPM -Outgoing payment table

VPM2 - Outgoing payment invoice

Use below query to find whether outgoing payment document created or not.

SELECT T1.[DocNum], T0.[DocNum], T0.[DocDate] FROM OVPM T0  INNER JOIN VPM2 T1 ON T0.DocEntry = T1.DocNum WHERE T0.[CardCode] = 'XXX'

XXX- replace with customer code that need to be checked

Thanks & Regards,

Nagarajan

KennedyT21
Active Contributor
0 Kudos

Hi Dennis...

Check with Ovpm & VPM1  for the outgoing payments

Regards

Kennedy

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Dennis,

What is this BP's currency?

Thanks,

Gordon

Former Member
0 Kudos

Hi Dennis,

The Outgoing Payments window shows only invoice which their DueDate is included in the payment's Date.

Try changing the Date in the form and see if your invoice shows up.

Beni.

Former Member
0 Kudos

The date is correct. The document and posting date are 03/11/2013 and the Due date is 05/26/2013. I think the issue is with the BP currency Euro?