Skip to Content
author's profile photo Former Member
Former Member

[NNM1] , 'No matching records found (ODBC -2028)'

Hi,

We have recently upgraded SBO 6.5 to SAP 2004. Now we are getting the following error when try to add invoice/order/incomming payments using the DI API 2004.

Err Msg:- [NNM1] , 'No matching records found (ODBC -2028)'

It would be wonderful if anyone could help us to solve this issue.

Thanks

Ajith

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2005 at 06:25 PM

    Hello Ajith

    Business One document numbering mechanism in release 2004 changed as follows: The table NNM1 defines the document series characteristic (without relation to the object). The table NNM3 defines the Object to Series relation.

    The primary key in NNM1 until version 2004 was the object name and the series ID. In order to support the new concept of the series, the primary key is only the series due to this fact the values of the series was changed so it can be unique.

    Set oDoc = oCompany.GetBusinessObject(oInvoices)

    oDoc.Series = 2

    Until Business One release 2004, the code lines above referred to series no. 2 of the Invoice business object (in NNM1):

    ObjectCode = 13 (object code of Invoice)

    Series=2

    From release Business One 2004 code lines above will refer to an absolute code – series no. 2

    NNM1 table was changed in the upgrade process in order to have unique values for the series, for example:

    ObjectCode Series ==> Series

    -


    ....---- -......... -----

    13..............0...............1000

    13..............1...............1001

    13..............2...............1002

    17..............0...............1003

    …...............…...............…

    This is the reason your add-on has compatibility problems

    If the code includes hard coded assignment to the Series property of the Document object, it should be changed to the new unique key of the series

    SAP recommendation is to avoid use of any field value hard coded in add-on code.

    Regards, Avi.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi ,

      Thanks a lot for the help. As per your suggestion, we have assigned the new unique key of the series for the Invoice document.

      It works fine only when the Tax code given is 0. In all the other cases, we are getting the following error.

      Err Message: Invalid total [OINV.DocNum] , 'USD'.

      It would be nice if somebody could help us.

      Thanks,

      Ajith

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.