Hi all, im somewhat of a novice at all this,
anyway we have 20 entities in our group, all with different LCY. I want to be able to look at expenses tagged to individual employees.
So using a row replicator for the co name and a table to show the g/l entries by employee i can produce a table per entity.
Ideally what i want to be able to do is have the table reference the company name, and also the LCY code so that i can take all the tables into one large pivot and retranslate the non usd amounts in some way aswell,
Can anyone suggest how i could link the co name (company table) and the lcy code (general ledger setup) to the G/L entry table?
Thanks in advance
Date
Votes
4 comments
-
Jet Reports Historic Posts To be honest, I don't think it is possible to link that. This is directly from the MSDN https://msdn.microsoft.com/en-us/library/hh169173(v=nav.71).aspx :
General Ledger Accounts
You cannot link currency codes to general ledger accounts because amounts on general ledger accounts are in LCY. If you have a bank loan in USD and place deposits in a bank account in SEK, you can keep track of these accounts by setting up bank accounts in USD and SEK. With posting groups, you can link the accounts to the relevant general ledger accounts. In the general ledger, the value of the amounts is shown in LCY.
You can enter a currency code on a general journal line and post the line to a general ledger account. The relevant exchange rate is used to convert the amount to LCY before it is posted to the general ledger account.
Additional Reporting Currency
If you set up an additional reporting currency, all transactions that you post to the general ledger will be recorded in both LCY and the additional reporting currency. This allows you to make financial statements and print reports in LCY and a second currency. The additional reporting currency can be used to present the financial statement as if the company kept its books in that currency. -
Jet Reports Historic Posts thanks
what i was also thinking is, i wonder is it possible instead just to have the co name that the row replicator creates in the table, is there any way of having the table include a static text linked from another cell? -
Jet Reports Historic Posts Is it possible to include your report or screen shots of what you are trying accomplish?
Are you using the Table Builder or are you building this using Replicators? -
Jet Reports Historic Posts Can you see the attached?
i was using the table builder, so the table is set up, and added on extra filter where it selects the company database from a row replicator,
i would like to have that co name shown in the table for each different table.
Please sign in to leave a comment.