Financial Report Template-Missing Account

[Former Member]

Dear all,

We are currently having an issue with the financial report template module. Lets say that a template has been created for Balacne Sheet on the 4th of August with the current chart of account and named Test1. On the 5th of August a new account is added on the Chart of the Account. When we now generate a balance sheet using the Test1 template, the newly added account is not shown the financial report and we have and unbalanced Balance Sheet.

We have customised the test1 template with specific names for the title account and creating a new template so that the missing account is brought in will be very time consuming.

Is there a way to bring in missing account in an existing template. I have already tested the 'Show Missing account' option in the financial report template window but this seems not to be working.

Thanks

Rohan

[Former Member · Accepted solution]

Hi,

Thanks for the help.

Will you be able to help me in the steps to add the account manually.

Thanks again

[Former Member · Accepted solution]

Hi Rohan Kumar Gupta,

When create Customise Financial Reports Template you have to add Account at Four Level.

here dubble click on level four appear display list of G/L Account. here you have to add or delet G/L Account.

Thanks,

Srujal Patel

[DarioMoutinho]

Hi There,

I believe that you do have to add it in manually,
What you can do is run a query to see which accounts are currently in the template ("TemplateId" column)

SELECT "AcctCode",* FROM FRC1 WHERE "TemplateId" = 4

From here you can cross reference (vlookup) against the account codes in your Chart of Accounts (OACT) according to the Group or Drawer that you require.

Can possibly take this one step further, and set a query Alert that shows missing entries via a JOIN,
That will alert on a daily basis if there are any missing accounts in the template.

Hope this helps,
Dário

[DarioMoutinho]

Here is an alert I wrote as an example,

This will check any accounts in the first 3 drawers (Assets, Liabilities, Equity) and tell me if it is missing in my Balance Sheet report template (TemplateId = 4) - in my database.

SELECT  T0."AcctCode"
FROM OACT T0 
WHERE NOT EXISTS (SELECT T1."AcctCode" FROM FRC1 T1 WHERE  T0."AcctCode" =  T1."AcctCode" AND T1."TemplateId" = 4) AND "Postable" = 'Y' AND "GroupMask" IN (1,2,3)

Hope this helps,
Dário

[Former Member]

Hi Rohan Kumar Gupta,

When you have create Financial Reports Template with customisation & after it create new Account in Chart of Account then this Account not come automatically in your Template. its enter manually in Template.

Thanks,

Srujal Patel