Hello, I am trying to create a report from sales Header table in BC.
When I search for County, it does not show Ship-to, Bill-to, and Sell-to County fields.
Instead, I see three County fields that all will show Bill-to County data.
these fields are differentiated in BC and have different values. How come it is not the case in Jet?
Date
Votes
2 comments
-
BryanAtTigunia It probably has to do with displaying the field name vs the caption. If you are after one of those specifically, you can also just put in the field number so Jet knows which of those you are trying to pull.
86 = Bill-to
89 = Sell-to
92 = Ship-to -
Leila Yes, it works. I added the number to the caption and it is more clear now. Thanks!
Please sign in to leave a comment.