News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Warehouse Receipt - ad...

Business Central forum

Suggested answer

Warehouse Receipt - add Vendor Reference

(0) Share

Report

Report

Posted on by LA-13061059-0

33

Hi all

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?

I'm just not sure what to add to the dataset!

Thanks in advance for the help.

Categories:

Reports and Business Intelligence

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 68,083 Super User 2024 Season 2 on at

Like (0)

Report

Warehouse Receipt - add Vendor Reference

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

Helpful resources

News and Announcements

New Dynamics 365 Community Call! (ERP Edition)

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,107 Super User 2024 Season 2

#2

Martin Dráb 227,969 Super User 2024 Season 2

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans