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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Sudatta,

How you resolve this issue??

Gretings!

[Former Member]

Even I have got the same error when adding Ougoing Excise Invoice based upon Delivery.

This error I got inspite of being mentioning Rounding Accounts in G/L Account Determination.

None of the solution is working.Kindly Resolve the issue.

Khushwant

sansowa_ks@yahoo.co.in

[Former Member]

I have the same problem

And I have already fill all the Accounts on G/L Determination account, but no success

I still have the error

No matching records found  'G/L Accounts' (OACT) (ODBC -2028)  [Message 131-183]

Message Id -1

[Former Member]

hi

Please check your 'Set G/L account' whether it set to item groups or item level or warehouse.

see all the accounts have been defined in the category to which this 'Set GL Account' is set.

[Former Member]

HI

Please check all the tax related and Outgoing cenvat clearing accounts in the particular screen like GL Account detemination,Tax code(Purchase and sale tax account)

[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

[Former Member]

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.

[former_member583013]

Hi Sudatta,

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

Check link <a href="https://service.sap.com/sap/support/notes/874131">https://service.sap.com/sap/support/notes/874131</a>

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

[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.