Hi Using the table builder to build a report for margin per item. I am using the value entry table to get the data and use the posting date as a filter for the period required. Also filtering on the Item ledger entry type for Sale. Need to add the column for cost amount (Non-invtbl) but this needs to be filtered on the item ledger entry type purchase.
Is there a way of filtering a single column in table builder?
Can attach xml file if needed.
Cheers Gary
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello Gary -
That could be challenging with a report based on the NL("Table") function, but could be downright trivial if using other Jet functions such as NL("Rows") and NL("First").
Please sign in to leave a comment.