Hello,
I am trying to recreate a custom report that ran with V6.5 of the Ledger. The 3 tables required are:

Posted Transactions
Account Master
Department Maintenance

Whenever I try and create a link from the Posted Transactions table to the Account Master table, I receive the following error:

“ Invalid File link. Not an indexed field”

This happens with any field I try to link. This did work when using the 6.5 set of tables.

Can anyone please shed some light on this? I have gone through the help files that come wtih Ledger 9 and explain how custom reports need to be recreated, etc, but am having no luck with the linking of these tables.

Thanks

Azim

Clear the links from the Posted transaction to the Account Master in the visual linkin expert.

Next, drag the account, department and division fields, in that order, onto the Acct / Dept / Div key field of the Account Master file. Ignore the warnings about the mismatched type.

Verify that the linking is working correctly by creating a report that just has the account and department from the transaction file, and the account description 1 from the Account Master.

Worked for me, but I will admit it took a few attempts.

Thanks Andrew,

I tried that and initially, it seems to work. I will forge ahead and recreate the report and hopefully it will give me the right results.

Regards,

Azim