View G/L Budget Entry Row No. for each Acc. Schedule Entry

darrinkatz

Hi everyone,

Our finance department maintains several budgets and projections over the course of our fiscal year for many of our accounts. They would like to see all of these budget/projection values on the General Ledger > Reports > Financial Statement > Account Schedule report. I have been told that each Row No. in the Acc. Schedule Line corresponds to an entry in G/L Budget Entry.

I have attempted to add G/L Budget Entry to the Account Schedule report by adding it under the Acc. Schedule Line in the Report Designer like so:
DataItemIndent = 2
DataItemTable = G/L Budget Entry
DataItemTableView = <Undefined>
DataItemLinkReference = <Acc. Schedule Line>
DataItemLink = Entry No.=FIELD(Row No.)

However, when I run the report, I receive the following error:
"The two fields below must have the same type:

Field: Entry No. <-- Row No.
Table: G/L Budget Entry <-- Acc. Schedule Line
Type: Integer <-- Code 10"

Any advice you can offer with regards to resolving this error would be greatly appreciated.

Thanks!
Darrin

darrinkatz

Hi again,

I was just wondering if anyone has had a chance to look at this. Is there more information I could provide that would make the question easier to understand? Or is the request fundamentally unattainable?

Thanks!
Darrin