1,159
Hi All
I have created a new data set for warehouse pick report and try to pull fields from sales order by linking sales header table as below:
dataitem(SalesOrder; "Sales Header")
{
DataItemLink = "No." = FIELD("Source No.");
DataItemTableView = WHERE("Document Type" = CONST(Order));
DataItemLinkReference = WhseActLine;
However new report doesn't show info from sales order. Not sure if the above link is correct?
Thanks
With the info provided is hard to say. In the Sales Header dataset you could also create an array of values like e.g. CustAddr[x] where X is the number of elements that qualify for the address (e.g. name, street, country, county, and so on). Then in the dataset add the column CustAddr[1], then CustAddr[2], etc.
Actually I did another test and i can get the fields to display on warehouse pick line level but not on header. This makes sense but since the business process does not include multiple sales orders on one pick i want to find a way to display customer address on header and i'd assume this is a common requirement. Maybe there is a way to do this
#1
YUN ZHU
628
Super User 2025 Season 1
#2
Mansi Soni
495
#3
Sohail Ahmed
436
Share
Report
All responses (
Answers (
