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

[Former Member]

Hi Experts,

I was trying to add an AP invoice copied from a GRPO and this error occurred:

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

GRPO is on USD for 46 exchange rate

AP is for USD 46.85

local currency used is PHP. There's a set up for Price difference account so why this error happened?

[Former Member · Accepted solution]

This is solved by putting account on Exchange Rate Difference account in G/L Determination.

[Former Member]

Now the error is item not found

[former_member198649]

Dear Marjie,

Is this a error or you solved your problem?

[Former Member]

I'm using advance GL determination, and both field have accounts

[former_member198649]

Dear Marjie,

The system will check the necessary g/l account code consists of :

1. G/L account code for revenue

2. G/L account code for a/r

3. G/L account code for freight if the invoice using freight

4. G/L account code for Down Payment if the invoice is using down payment

5. G/L account code for rounding account

6. G/L account code for inventory account if the invoice created by copying from sales order, so no delivery order

7. G/L account code for tax if there is applied tax.

8. G/L account code for price difference account between good receipt PO and a/ p invoice if you want to add a/p invoice

9. G/L account code for exchange rate difference

So, you must check if the above g/l account code exists or has been defined in the following setups window:

1. Inventory item group if your item using item group in the  g/l account determination or g/l account by

2. warehouse setup if your item using warehouse in the g/l account by

3. g/l account codes in the tab inventory of item master data if your item is using item level

4. freight setup i.e. expense or revenue account

5. tax setup i.e. tax account code

6. g/l account determination --> tab general

7. d/p account codes in the bp master data --> accounting tab

[former_member198649]

Dear Marjie,

Please also check the Rounding Account too (in the General tab of the GL Determination.)

[former_member185296]

Hi,

If you are using warehouse level account determination then in the warehouse setup accounting tab define a g/l for price difference account.

if you are using item group level account determination then in the item group setup accounting tab define the g/l for price difference account.

Regards,

Vinoth