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
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi
the report looks fine.
Even though it says "#value" have u tried pushing "report" so that the cached data updates ?
Please sign in to leave a comment.