Share
ReportHi,
Is there another way to select a "ship to address ID" to appear on a printed PO w/out selecting it for every item under item detail?
*This post is locked for comments
You’re offline. This is a read only version of the page.
55
Hi,
Is there another way to select a "ship to address ID" to appear on a printed PO w/out selecting it for every item under item detail?
*This post is locked for comments
Hi Hudson,
We can display each ship to address ID for a particular item in PO report.
1) Dexterity RW function
2) Modifier + VBA
Sample Code to achieve using RW function
function returns string ShipTOAddressID;
in string PONumber;
in integer POType;
in 'Item Number' itemnumber;
in Ord ordernumber;
release table POP_POLine;
range clear table POP_POLine;
clear table POP_POLine;
range table POP_POLine where physicalname('PO Type' of table POP_POLine) + " = '" + str(POType) + "' and "
+ physicalname('PO Number' of table POP_POLine) + " = '" + PONumber + "' and "
+ physicalname('Item Number' of table POP_POLine) + " = '" + itemnumber + "' and "
+ physicalname(Ord of table POP_POLine) + " = '" + str(ordernumber) + "'";
get first table POP_POLine;
if err(table POP_POLine) = OKAY then
ShipTOAddressID = 'Location Code' of table POP_POLine;
end if;
same process can be done in VBA
Note: please don't use custom table relation ship in the standard report . it works fine in test mode & while creating chunk Table Hierarchy error occur.
Usually the ship to address ID is picked from the logged in company address defaults which you have assigned while setting up the company and if you want it in the report the field is available in the POP10110 table
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,399
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
