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

Error: No matching record found 'G/L Account (OACT)(ODBC -2028)

This is the error that I got while trying to update the Sales Order with my add-ons.

All the required details were filled in the columns including the delivery date.

PLEASE REPLY SOON.

Thank You

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2007 at 10:10 PM

    Hi Sudatta,

    It seems to be a error relating to Rounding Account as per the note I read.

    Check link https://service.sap.com/sap/support/notes/874131https://service.sap.com/sap/support/notes/874131">https://service.sap.com/sap/support/notes/874131>

    In case you are not able to login to read the Note.

    Symptom

    When attempting to add a marketing document with rounding, the following error message appears: "No matching record found 'G/L Accounts' [ODBC 2028]"

    Other terms

    Rounding, G/L account, error message, marketing documents, matching record, account, missing, SAP Business One

    Reason and Prerequisites

    There is no rounding account defined.

    Solution

    Define a rounding account under:

    'Administration' > 'System Initialization' ->'G/L Account Determination' -> 'General' tab page under "RoundingAccount" field.

    Regards

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you Suda,

      But that was closer. Actually, there has to be a G/L account mentioned in the line level of the Sales Order. Do I have to mention any aco\count number in G/L Increase and G/L Decrease?

      It is in the G/L Account Determination field.

      Admin->Setup->Financials->G/L Determination.

      Please reply.

      Thanks a million.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2007 at 10:31 AM

    I got the answer to this question by R&D.

    If we go into the form settings, we can find a row where we have to mention the G/L Account number. This will solve the issue.

    Thanks for your support.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2007 at 11:22 AM

    This issue was resolved, details could be found in my latest reply.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      It really depends on how you have defined your Inventory Account Management, for example on this eniroment I had to check Inventories Account Management

      and the Account my users ahve erased was Sales Returns Account

      Once I defined an account!

      started working!!!

      KR

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.