VAT entry to GL Entry mapping

abhi1901
abhi1901 Member Posts: 102
edited 2013-05-22 in NAV/Navision Classic Client
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.

Comments

  • geordie
    geordie Member Posts: 655
    Is the posting codeunit standard or customized?
    * Daniele Rebussi * | * Rebu NAV Diary *
  • abhi1901
    abhi1901 Member Posts: 102
    Posting is standard
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    If all amounts are the same and the calculation is correct, than why do you care?
    Marije Brummel | Freelance Business Central Specialist
  • geordie
    geordie Member Posts: 655
    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?
    * Daniele Rebussi * | * Rebu NAV Diary *
  • jglathe
    jglathe Member Posts: 639
    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
    abhi1901 Member Posts: 102
    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
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    You are correct, it is not possible.
    Marije Brummel | Freelance Business Central Specialist

Categories