Kind Attn.: No Matching Records Found G/L Accounts

[Former Member]

Hi Experts,

I am stuck up in an Issue.I add a new Sales Order.Convert the sales order to delivery.When I try to add the delivery document,i get an error message saying "No Matching Records found G/L Accounts (OACT).My configurations are as below,

G/L Accounts are set up by Item Group.

I have also linked all the accounts to the respective Item Group and also in G/L Account determination including Rounding account.

I am not sure, whether am i missing anything here.

And for your information....the delivery document contains 2 items,one in Moving Average and the other in FIFO.

Regards

Deepak

[Former Member]

Hi Experts,

I have similar message while converting Purchase Order to A/P Invoice. Document type is Service. Tried possibilities already in the discussions.

But doesn't work.

Any further information in this regard!! !

[former_member708266]

Dear,

Kindly check if the variance account, and the negative stock adjust

account and exchange rate difference account are defined.

Please check all the necessary accounts defined in Item Group, Ware

house, and in GL account determination under Administration.

In addition, kindly define a Tax code for the document.

Regards

Apple

[former_member708266]

Dear,

If the information above could not solve your issue, you could also refer to the following tread:

PS: You could also refer to the Expert Empowerment Session on 'G/L Accounts Missing' in the following URL:

https://websmp201.sap-ag.de/~sapidb/011000358700000894772007E/FIN_CW39_ErrorGLAccMissing.wrf

Also check for the PDF of the same at

https://websmp201.sap-ag.de/~sapidb/011000358700000894762007E/FIN_CW39_ErrorGLAccMissing.pdf

Regards

Apple

[Former Member]

Hurray.....

Issue Resolved........Thanks a Lot to each one of U.

Regards

Deepak

[former_member187989]

hi deepak,

Use this query to find out which fields FMS is activated.

select cshs.formid,  cshs.itemid, cshs.colid, cshs.actiont, cshs.queryid,
ouqr.Qname,cshs.indexid, cshs.refresh, cshs.fieldid, cshs.frcerfrsh, cshs.byfield,
ouqr.QString
from cshs left outer join ouqr on cshs.queryid = ouqr.intrnalkey

Jeyakanthan

[former_member187989]

hi,

Have you tested this case in demo database ?

Whether it's happening for other items in delivery document ?

Whether you changed Set G/L accounts in item master after creation of delivery document ?

Cancel sales order if you create delivery from sales order.

Create a fresh sales order,delivery documents.

Hope problem solves.

Jeyakanthan

[Former Member]

Hi Jeyakanth,

The issue was resolved temporarily.When we raise a standalone Delivery,i am able to add the document successfully.But i cannot propose this solution to my clients.

I also found that for some sale orders,the screen is in the update mode by default.I feel that the Formatted searches are creating a problem.How can i solve this.Any suggestions pls....

Regards

Deepak

[Former Member]

Hi Deepak

The Formatted Search is defined to 'Auto Refresh'.

If the field on which the formatted search is defined is either not visible or visible and not active, the activation of the formatted search can cause unexpected behavior.

As a workaround, you can set the field on which the FMS is defined as Visible and Active.

Thanks

Rizz

[Former Member]

Hi Deepak,

Have you checked the Item setup? Some times the problem is from there.

Check if Item is in the right Item Group.

Check Set G/L Accounts By option in Inventory Tab. It should be setup by Item Group.

If it is not working display the G/L Account field in Delivery to see what account populated and dig into from there.

Edited by: Ben Zhao on Apr 7, 2009 7:54 PM

[former_member187989]

hi,

Check any formatted search is applied in delivery document ?

Jeyakanthan

[Former Member]

for delivery doc, sys basically needs two gl accounts - 1) COGS - Cost of Goods Sold & 2) Inventory Account.

In ur doc, just check if both of these are set in the GL determination for the items' corresponding groups. Admin-Setup-Inventory-Item Groups- Accounting Tab

[Former Member]

Dear Experts,

Thanks for all ur replies.But unfortunately all the above said settings were already been made.Still the problem persists.

Any other area which i have missed out.....pls help...

Regards

Deepak

[Former Member]

hii Deepak

Does your system uses User Defined Chart Of Accounts..?

in that case this Note may be helpfull to you

While adding the marketing document into the system error message [OACT] 'No matching records found - 'G/L Accounts' '(ODBC 2028)' appears. When the user checks all definitions it looks like all accounts are defined.

Reason and Prerequisites

The User Defined Chart of Accounts is used.

Solution

When the user chooses User Defined Chart of Accounts under Administration -> System Initialization -> Company details -> Basis Initialization tab , the default accounts remain in the "G/L Account Determination", "Define Tax", "Define Warehouse" windows under Administration -> Definitions -> Financials and Administration -> Definitions -> Inventory. User has to check and define all accounts.

Rizz

[Former Member]

Dear All,

Thanks for your concerns.

Inspite of undergoing all the prescribed steps,i am not successful.Any other solutions pls.

Its very critical.

Thanks

Deepak

[Former Member]

Hii Deepak

All the settings you have checked, there must be something wrong within your environment

Now i advise you to log a support ticket with SAP ,

that could only be the possible solution for you

Rizz

[Former Member]

Hii Deepak

please check your settings with the help of this link

https://websmp201.sap-ag.de/~sapidb/011000358700000894762007E/FIN_CW39_ErrorGLAccMissing.pdf

Good Luck

Rizz

[Former Member]

You may check SAP Note 874131 to see if that is the case.

Thanks,

Gordon

[former_member187989]

hi giridharan,

check AR tax accounts are defined in tax codes of 2 items ?

Jeykaanthan