cancel
Showing results for 
Search instead for 
Did you mean: 

Account information

Former Member
0 Kudos

Hi

how many G/L Account use as internal procedure (Means which is automatically debit and credit ) for whole cycle of transaction ?

Edited by: Krishna Gopal Krishna on Oct 18, 2008 12:56 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Krishna,

There are no specific numbers for your question. It is all depending on your CoA. As you know, every companies may have their own CoA, how can anybody know numbers of your accounts meet your requirement?

Try a query below to see how many accounts you have:


Select Distinct T2.AcctName From JDT1 T0
Inner Join OJDT T1 On T1.TransID = T0.TransID
Inner Join OACT T2 On T2.AcctCode = T0.ContraAct
Where T1.TransType != 30

This list only take out all Manual Jornal Entries Transactions. If you have different requirements from this, let me know.

Thanks,

Gordon

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Krishna

As you know the Automatic postings is based on your G/L account determination

You can do the G/L determination as follows

1. Item Level

2.Item Group level

3.Warehouse Level

and Company level ( G/L account determination)

It will vary according to your G/L determination

Regards

Rashid

Former Member
0 Kudos

as

Former Member
0 Kudos

Hi,

Can you give some more details for your issue, if possible with example?

Regards,

Abhishek

Edited by: Abhishek A on Oct 18, 2008 1:20 PM