Account Outgoing Payment PLD error

[Former Member]

Hi,

We cannot print/preview any Account Outgoing Payment, there is an error message: No matching records found 'Payment Terms' (OCTG) (ODBC -2028) [Message 131-183].

We're using SB1 8.82 PL 10.

Any ideas?

Regards.

[Former Member · Accepted solution]

Hi Maria,

you should check the SAP Note 1555242. It should solve your problem.

Cheers Steffen

Symptom

When you print or print preview an Outgoing / Incoming Payment (using system or customized template) the system returns an error and does not complete the request:

No matching records found  'Payment Terms' (OCTG) (ODBC -2028)  [Message 131-183]

Cause

Application Error

Solution

Run the following query:

If not exists (select 1 from OCTG where groupnum = '-1')

select 'TRUE' from OCRD where GroupNum ='-1'

union

select 'TRUE' from OVPM where doctype = 'A'

union

select 'TRUE' from ORCT where doctype = 'A'

If the above Select query retrieves results ('TRUE'), log a support message through SAP Service Marketplace referring to this note and include all relevant information.

Message was edited by: Steffen Kamphoff

[Former Member · Accepted solution]

Hi,

Thanks for your replies,

The query result is TRUE.

Is this something related to the version? We've using SB1 for years, and this is the first time we cannot print or preview an Account ongoing Payment. We've had plenty of application errors with our latest version (SB1 8.82 PL 10).

Regards.

Thanks.

[kothandaraman_nagarajan · Accepted solution]

Hi Maria,

Please raise to ticket to SAP to solve above error.

To remove all your application errors, try to upgrade to latest versions.

Thanks & Regards,

Nagarajan

[jitin_chawla · Accepted solution]

Hi,

Has this issue happened after a recent upgrade from a patch to another patch?

As other experts mentioned, you should log a support ticket in order to get the issue investigated further. The issue is a suspected database corruption issue.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member · Accepted solution]

Hi,

Thanks for all your replies.

One thing I noticed: we might have deleted payment conditions in Setup (right click->Delete), because we don't have any payment term starting in '-1'. Now they begin at 8 (OCTG.GroupNum). The system allows deletion as long as the payment term has not been used.

This issue has happened since we upgraded the version from 2007 A PL:10 to 8.82 PL:10.

Regards.

Maria

[KennedyT21 · Accepted solution]

Hi Maria Quintero

If that is case you can create the same Payment term once again  and try ...

Try to backup the system and do it in the Test environment..... If works you can do the same in the Live

Hope helpful

Regards

Kennedy

[KennedyT21]

Hi Maria...

If the above Select query retrieves results ('TRUE'), log a support message

through SAP Service Marketplace referring to this note and include all relevant

information.

I think this happens due to payment terms  check what you have change at last with it..

Regards

Kennedy

[kothandaraman_nagarajan]

Hi Maria,

It is an application error; Please refer below SAP notes:

Symptom

When you print or print preview an Outgoing / Incoming Payment (using
system or customized template) the system returns an error and does not complete
the request:

No matching records found  'Payment Terms' (OCTG)
(ODBC -2028)  [Message 131-183]

Cause

Application Error

Solution

Run the following query:

If not exists (select 1 from OCTG where
groupnum = '-1')

select 'TRUE' from OCRD where GroupNum
='-1'

union

select 'TRUE' from OVPM where doctype =
'A'

union

select 'TRUE' from ORCT where doctype =
'A'

If the above Select query retrieves results ('TRUE'), log a support message
through SAP Service Marketplace referring to this note and include all relevant
information.

This messages should be logged under the component
SBO-GEN-PRT.

Other terms

Print Layout Designer, Layout, Template, PLD, Payment Terms, Missing Group,
crystal reports, CR, ORCT, OVPM, account, Cash Basic

Thanks & Regards,

Nagarajan