Hi,
i have faced a problem when i tried to filter sales invoice line by Dimension, i couldn't filter on all dimensions that exist? i get the error message : look-up not available, invalid field.
example :
Code1 : FAMILLE PRODUIT
Name1 : FAMILLE PRODUIT
Code caption1 : FAMILLE PRODUIT
Code2 : SOUS FAMILLE PRODUIT
Name2 : SOUS FAMILLE PRODUIT
Code caption2 : SOUS FAMILLE PRODUIT
i can filter by : FAMILLE PRODUIT
but i can't filter by : SOUS FAMILLE PRODUIT
any idea?
thanks,
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi,
Typically the dimension values associated with the Sales Invoice Line would exist in the Posted Document Dimension table. If you do this formula:=NL("Table","Posted Document Dimension",,"Table ID","113")
Run the report and you should see all the dimension values that are associated with the Sales Invoice Line records. The Dimension Code field should match whatever it is you're trying to filter on (in this case SOUS FAMILLE PRODUIT). In the most recent versions of Jet you can filter on the dimension caption as well, but the code should match the code you're entering for a field. What result do you get when you do this?
Regards,
Hughes -
Jet Reports Historic Posts Hi,
Posted Document Dimension has over than 600 000 records. So i went directly to the table and i found the Dimension Code field SOUS FAMILLE PRODUIT there, if this is what you want to know by running this report!
Regards; -
Jet Reports Historic Posts Hmmm, I'm not sure there's much else I can do for you on the community forum. You should first install the latest version of Jet to make sure you're not experiencing an issue that has already been fixed. If that doesn't help, you should create a support ticket with Jet support so someone can look at the issue with you in more depth.
Regards,
Hughes
Please sign in to leave a comment.