News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Warehouse Receipt - ad...

Small and medium business | Business Central, N...

Suggested answer

Warehouse Receipt - add Vendor Reference

(1) Share

Report

Report

Posted on by LA-13061059-0

36

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:

Business Central

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 73,696 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

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans