I've managed to get my head around a couple of Customer based report extensions.
I am now struggling with a requirement on the Warehouse Receipt. I want to add the Vendor Item Reference, but I'm not sure of the table / way this should be linked?
Essentially the report needs to show the Item No | Vendor Reference | Item Description
I'm guessing the report lines are using Table 7317 Warehouse Receipt Line
I'm assuming I need to link to Table 5777 Item Reference on the Item No field?
Hi, this requires the Item No., Reference Type (Vendor) and Reference Type No. (Vendor No.) fields.
The Reference Type field value is fixed, Vendor. Item No. can also be found in the Warehouse Receipt Line. The only problem is that there is no Vendor No.
But the purchase order number can be found on the line, so the vendor no. can be found through the order number, and you can use these three fields to display the Vendor Reference No.
Personally, I think it is more convenient to add a variable than adding a Flowfield.
Hope this can give you some hints.
Thanks.
ZHU
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
50
Share
Report
All responses (
Answers (
