VAT entry to GL Entry mapping

abhi1901

Hi,

For example suppose I have 10 lines in GL table and 5 lines in VAT entry table and the base amount is same for all VAT lines.
So how can I find that which VAT is against which GL line.

Note:- In my database "Item Application Entry" table is not getting updated and also "G/L Entry - VAT Entry link" table is not present.

geordie

Is the posting codeunit standard or customized?

abhi1901

Posting is standard

Marije_Brummel

If all amounts are the same and the calculation is correct, than why do you care?

geordie

You could identify the related GL Entries crossing Type, Document Type, Document No., Posting Date, VAT Bus. Posting Group and VAT Prod. Posting Group: does it work your case?

jglathe

Hi,

abhi1901 wrote:

Posting is standard

you can always find G/L entries belonging to VAT entries with a filter by transaction no. To rule out the oddities like a general journal with all lines marked as system-created entry (not standard, though), you can additionally filter by all the fields geordie mentioned, too. Without a VAT entry to G/L entry link table, you can still get ambiguous results within the filter.

with best regards

Jens

abhi1901

jglathe wrote:

Hi,

abhi1901 wrote:

Posting is standard

you can always find G/L entries belonging to VAT entries with a filter by transaction no. To rule out the oddities like a general journal with all lines marked as system-created entry (not standard, though), you can additionally filter by all the fields geordie mentioned, too. Without a VAT entry to G/L entry link table, you can still get ambiguous results within the filter.

with best regards

Jens

Thank you all for your answer but this will not solve my query.

suppose there are 10 GL lines 5 for Amount and 5 for VAT all 5 amount line will contain exact same amount, Posting setup(General and VAT).
Now there will be 5 lines in VAT Entry table with same VAT amount and base amount so In this case with the above code 1 to 1 mapping cannot possible.

Marije_Brummel

You are correct, it is not possible.