on 07-18-2013 7:52 PM
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
Can you tell me the tables that are used to display the AP invoices in the Outgoing Payments is it just OPCH and ORPC?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi Dennis,
What is this BP's currency?
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.