G/L Acc not appear in SO/DO/INV

[Former Member]

Dear Experts,

After upgraded from version 2007A to 8.8 PL21, the G/L Account field in Sales Order, Delivery & AR Inv modules doesn't appear even though the G/L Account Determination in  Adminstration->Setup->Financial have been set/mapped.

Anyone facing this problem before?

Your reply is highly appreciated.

Regards,

Danny

[Former Member]

Hi Danny,

Try a simple query to see what you get:

SELECT T1.DocNum, T0.ItemCode,T0.AcctCode From RDR1 T0

JOIN ORDR T1 ON T1.DocEntry=T0.DocEntry

WHERE T1.DocNum='[%1]'

Thanks,

Gordon

[former_member186095]

Hi,

The column should be filled automatically with revenue account either for non inventory item or inventory item.

The system check the G/L account determnation for item or general.

Check if you have set the account to be confidential to the user.

have you checked if the same issue happened in all other users ?

probably it is current system definition of SBO 8.8 PL21 or its bugs.

Check if the same issue occurred by upgrade to SBO 8.82 PL06 in test server

Jimm

[Former Member]

hi

I think you 'Set the GL Accounts ' by 'Item Level'.

As a test,map all the accounts(Dont Leave any blank account) to that item,and check the accounts filled for that particular warehouse which selected in those documents.

[Former Member]

HI

You need to check the form setting whether 'GL Account' field is ticked for visible or not.

then goto file->exit.

then only the changes will get saved.

[Former Member]

Hi kamba Dasan,

Thanks for reply. Yes, the GL Account field is ticked and it is visible but it is empty, nothing show.

Regards,

Danny

[Former Member]

Hi Danny,

What have you set in the item defaults 'Set G/L account by'?? if it by warehouse, by item, or by item group. Check whether those has an Accounts.

Regards,

Lean

[Former Member]

Hi Lean,

Thanks for reply. It is by item. Before upgrade all is ok, no problem.

After upgraded, the G/L Account field is empty, nothing show. i had confirmed that all account has been mapped in G/L Account Detemination.

Regards,

Danny

[former_member541807]

hi,

you may check your form setting, maybe it is unchecked. please see image below to set form setting

regards,

Fidel

[Former Member]

Hi Fidel,

Thanks for reply. the G/L AAccount field is empty, show nothing.

Regards,

Danny