0

VAT entry

Jet Reports Historic Posts

April 22, 2013 10:17

None

Follow

I have built a report that looks at the spend per Vendor for a period and I'm pretty happy with the way it works.
I take the Invoice or Credit memo no from the Vendor Ledger Entry Table and the posting date and amount.

However the amount is the amount including VAT and I would like to split this out between Base amount and VAT amount. I know that the VAT entry table holds this data but when I browse my database this table is not visible or available to me. Anyone know why? or is there another way of splitting out the amount to see the VAT amount?

Running Jet Essentials 2012 R2 on Dynamics NAV 2009

• Facebook
• Twitter
• LinkedIn

5 comments

• 
  Jet Reports Historic Posts April 22, 2013 15:43 Official comment

  Hi,
  
  Are you experiencing a difference in table name vs. table caption? I'm guessing that VAT Entry is the table name, but it has a different caption. In Jet you can always use the table names, which is why typing in the table name worked. However, if you have a particular NAV language specified in your Jet Data Source Settings, Jet will display the captions for that language if they are available, which I'm guessing is what is happening in this case. Could this be what is happening?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts April 22, 2013 12:47

  I have been able to add the table and get the data I want. I did this by typing the Table name into the Table field on the Function Wizard screen and when I did this , the fields in the Table then became availabler to me.
  
  However the Table is not visible in the Browser, anyone know why?

• 0
  
  Jet Reports Historic Posts April 24, 2013 10:24

  Hi, While you can use the vendor ledger entry to work out the spend by Vendor be careful about VAT. I don't know your business model, but concider useing Item or G/L Entries based on the Source Type and Source Number. this will give a true picture all in LCY.
  Malcolm

• 0
  
  Jet Reports Historic Posts April 29, 2013 09:20

  Hi,
  
  Are you experiencing a difference in table name vs. table caption? I'm guessing that VAT Entry is the table name, but it has a different caption. In Jet you can always use the table names, which is why typing in the table name worked. However, if you have a particular NAV language specified in your Jet Data Source Settings, Jet will display the captions for that language if they are available, which I'm guessing is what is happening in this case. Could this be what is happening?
  
  Regards,
  Hughes

  Solved as above.
  This is the issue as you describe. In NAV the Language is set to English (United Kingdom) but in Jet it was set to English (US). Changing the Jet Data Source settings solved the problem. The down side is that every report that I have using Amount($) will no longer return a value and I must edit each formula to be Amount(LCY)
  
  Thanks for the help Hughes !
  
  John
• 0
  
  Jasmine Tjitradinata March 27, 2020 08:35

  Hi 

  I am experiencing the transaction mutliple line when pulling data from VAT entry table, is there anyone ever experience the same? 

  How to solve it? 

   

  Kindly advise.

  Thank you in advance for the help.