sales invoice lines connection to GL entry

suvidha

Hi,
I am working on 3.7 DB.

For eg.
If i have a document no. XYZ (sales invoice doc)
when i navigate this document no. i get
1. Posted sales invoice with 2 items in the line A and B.
2. I get 56 GL entries.
and etc..

Now.. Item A might have 28 GL entries and Item B might have 28 GL entries.
How can i know which GL entry belongs to which item or which sales invoice line.
](*,)

mohana_cse06

Hi suvidha,

if Gen. Prod. Posting Group or Inventory Posting Group or both different for 2 items den u can know with Gen. Prod. Posting Group,Inventory Posting Group in gl entris.

else u vl get single entry for 2 items.

srinivas.chittem

Hi,

Check the following... : ( May be this is useful )

1. Posting Groups
2. Automatic Cost Posting ( True / False ) ( Inventory setup )
3. Is there any Bifargations are there?
4. Check the structures. ( VAT / CST / Excise / Frieght / Insurance /Service Tax )

Based on above the GLAccounts may be differ.

ssingla

suvidha wrote:

Hi,
I am working on 3.7 DB.

For eg.
If i have a document no. XYZ (sales invoice doc)
when i navigate this document no. i get
1. Posted sales invoice with 2 items in the line A and B.
2. I get 56 GL entries.
and etc..

Now.. Item A might have 28 GL entries and Item B might have 28 GL entries.
How can i know which GL entry belongs to which item or which sales invoice line.
](*,)

2 items creating this much of ledger entries is very abnormal. Are you using serial numbers in item? Further you need to analyze the entries and should be sure what kind of accounts they are posting.

Check and make sure you haven't used the same number series in some other process especially in Journal Voucher and Production entries.