Outgoing Payments not populating any invoices for a vendor

[Former Member]

It seems I have an issue with Outgoing Payments after the turn of the fiscal year.

I have vendors that have invoices due this month and when I enter their vendor code in Outgoing payments, none of the invoices appear. Here are the things I verified:

All invoices have NO payment block checked - this is good

All posting periods have the correct dates for all periods - including doc dates and due dates

No periods are closed, I tried both closing period and unlocked as options

Payment methods are correct including banking info

The fiscal year is properly set in GL determination

I have upgraded to 8.81 p09 to see if this was a patch issue

Payment wizard does not even pull these vendors, though it does pull some and those all are due dates of earlier than Dec 2011

I have tried changing the due dates to be Nov 2011on the invoice, but it still will not show the vendors in outgoing payments

Nothing shows in the payment wizard for Non-incl. transactions

Authorizations are correct and I am signing on using a manager log on w pro license

This issue was not present until Jan 2012, all invoices were entered in Dec 2011

Are there any other areas I am missing to look? Is there something in the tables that would flag these invoices to not show?

Any idea what I can do?? HELP!!

Edited by: Joanne Pencola on Jan 20, 2012 1:54 PM

[jitin_chawla · Accepted solution]

Hi,

Check the detect query in the Note No. : 1041101.

Also, check whether you detect any of the reported invoices in the following detect query :

SELECT t2.cardcode,T2.docNum, T1.docentry, T1.status, T2.docstatus,T1.reserved ,T2.reserve FROM
pch6 T1 inner join opch T2 on T2.docentry = T1.docentry Where T1.reserved = 'Y' and T2.docstatus = 'O'
and T1.reserved !=T2.reserve 

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Gordon, the copying to a test DB did not help, thanks anyways

Hendry, I checked all those and the tax one was a good place and I did add some dates, but it did not help. Thanks

Jitin, I ran both queries...the one from the note did not return anything; your query did return every BP I am having issues with and those are the ones I cannot pay in outgoing payments. Since I returned some data using your query, any thought as to what in the world is causing this and how to fix?

Is there a flag on the tables that I need to fix?

[jitin_chawla · Accepted solution]

Hi,

The issue is caused as the same documents have been reserved (how it happened is not known)

You should log a message to get the issue investigated by SAP Support and get the issue fixed.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

OMG thank you Jintin!!!

I figured it out; for some reason the flag was set for Y on the reserved field in the pch6 table and I ahve no idea why. I cannot imagine that I entered reserved invoices for the entire month of December (ongoing), but I am not going to rack my brain over this, as long as it is fixed I am back to normal.

Thank you so much for at least giving me some idea with your query. I will for sure save this one for future use (but hope I never need it!) LOL

[Former Member]

Hi,

Do you use series so that new year has new series link to new period indicator?

Thanks,

Gordon

[Former Member]

Unless there is someplace else I am to link the period indicator to this I beleive I have everything set up properly. All posting periods, document numbering all point to the current posting periods which is 2012 fiscal year.

I will take any place else I should look, just send me brief info as to where to check.

Thanks for your help.

[Former Member]

In this case, you will not be able to get last year's posting.

[Former Member]

I missed something...in what case?

This is extremely odd and never had this issue at all, not even with clients. (this is my internal account) and it seems to be only happening with vendord I added in December becasue I can use Outgoing Payments for any document that was not entered in December.

I have not done year end yet and will not be doing this until sometime in Feb.

Thanks for your help

[Former Member]

Restore this db to test environment to do more testing. Something may be wrong in numbering or series.

[Former Member]

Hi Joanne,

I'm not sure if this is related to your case, but have you checked the active / in-active status of your vendor? And also the date range of active status? Have you checked the withholding tax definition and the date range?