News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How to input sales ord...

Microsoft Dynamics GP (Archived)

How to input sales order user defined fields into purchase order report using report writer

(0) Share

Report

Report

Posted on by jodie888

20

I want to be able to convert the user defined fields in the sales order form into the purchase order report using Custom Report Writer. I have checked the box that allows fields from the Sales Order to automatically print on the purchase order; however, I want the user defined fields to be converted as well. Does anyone know how to do this? I did find a table called SOP_POPLink but there does not appear to be primary key on which to build from. Has anyone done this? It seems to me that this should be built in yet I don't know where to make this happen.

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

callen 4,595 on at

Like (0)

Report

Re: How to input sales order user defined fields into purchase order report using report writer

You need to make sure that:

1. You use sales commitments to link the SO to the PO -- the line item must be back ordered and you can click Action >> Purchase to create a PO that is linked to the SO

2. You would then need to create a link from the PO line item to the POP-SOP table

3. You can then link the SOP user defined table to the POP-SOP table

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans