Hi there, jet-reports community (and take cover…here is a newbie question coming in),
I am trying to find a way to get the tables FIXED ASSET, FA LEDGER ENTRY and FA DEPRECATION BOOK in a single excel report, in order to see the deprecation values of an asset together with all its informations.
As far as I (jet-newbie) understood the concept all three should be linked together via No.(Fixes Asset)+FA No.(FA Deprecation Book)+Fa No.(FA Ledger Entry). I only can connect either A+B or B+C. Am I completely wrong in trying to get my excel-report done with all three tables? Or does it simply take more than a connection via Fa No. and No.? I am using the Table Builder of Jet Essentials 2011 - maybe I am not only trying something impossible, but also using the wrong tool to achieve it.
Any information is highly appreciated - even harsh corrections.
Thank you very much in advance.
Yours,
Costello
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi costello,
how do you connect table a+b, and b+c?
Do you have an example for the report, you want to create?
maybe you have to work with two rows for the fixes assets, but it depends on your report…
greetings -
Jet Reports Historic Posts Hi
I have a FA Book Value Report already in NAV. See below. I want to add FA Posting group and location to the report using JetReports. How do I do this? Attached is what I've got so far. I'm still missing items in bold. Thank you
No. Description Acquisition Cost 12/31/14 Addition in Period Disposal in Period Acquisition Cost 10/31/15 Depreciation 12/31/14 Depreciation in Period Disposal Depreciation in Period Depreciation 10/31/15 Book Value 12/31/14 Book Value 10/31/15
Please sign in to leave a comment.