Database table for Account determination

[former_member617690]

Hello everybody,

For data validation purposes I'm trying to find the business one database table where the G/L account determination setup is stored, does anyone know which table is it ?

Thanks in advance.

[felipe_loyolarodriguez · Accepted solution]

Hi Ernest

You must look OACT table for G/L account determination setup in SAP Business One.

Best regards

Felipe

[felipe_loyolarodriguez · Accepted solution]

Sorry for the mistake, the correct table is OACP table.

Thanks

FLR

[former_member617690 · Accepted solution]

Hi Felipe,

Thanks for your fast reply!, actually table OACT contains the chart of accounts info, what I need is, as an example, know which is the sales account, or the exchange rate gains account.. etc..

Do you know where is it stored ? If it's really stored in OACT, I really don't know how to find out "who is who", for example, can you tell me how to know the sales account ?

Thanks!

[former_member617690 · Accepted solution]

Great! this one looks good

Thanks again and Best Regards!