0

Table builder report errorr

I have made a report on the Vendor Ledger Entry table, using Table Builder. In the report 2 pivot tables are genereated and refresh on opening the report.
On my own PC the report works just fine, but on other PC's it errors, showing only #VALUE in the cell with the table statement. Am I forgetting something crucial in publishing the report? I just sent the .xlsx to them, but that doesn't work.
Below a copy of the range with the statements, filters etcetera. In columns E:P are the fields for the report; I only copied the first 2

row/Col C D E F
3 Tables and Fields Filters
4 Vendor Ledger Entry
5 Open 1
6 Document Type Payment|Refund|Credit memo

8 Links: ∞NL("LINK","Vendor",,"No.","=Vendor No.")
9 Headers: Vendor No. Vendor - Name
10 Fields: Vendor No. LinkField([Vendor],[Name]) Posting Date
11 =NL("Table";"Vendor Ledger Entry";$E$10:$P$10;"Headers=";$E$9:$P$9;"TableName=";"Vendor Ledger Entry";"Filters=";$C$5:$D$6;"InclusiveLink=Vendor Ledger Entry";$E$8)

for further reference, this is the Table Builder code Book2.xlsx

Does anyone have an idea why this won't workl on other PC's? The users have access to NAV and the tables used.

Kind regards,

Willem

    1 comment

    Please sign in to leave a comment.