Find purchase order for a drop shipment from Posted Sales invoice

(0) Share

Report

Posted on by Community Member

Dear All,

For a drop shipment, which the purchase order and sales order both had been posted.

When i go to the posted sales invoice screen and select any posted sales invoice, how do i find out the purchase order number? or posted purchase invoice number?

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

JAngle 133 on at

Like (0)

Report

Fields 71 and 72 from the sales line table are not part of the sales invoice line table. So the transferfields function does not pick up this data. It is the same on the purchase line too.

To get the data for the future you may consider doing two table extensions for the invoice line tables for the mentioned field numbers. For the missing data you would have to base it on the lines which have a purchasing code. At the header level you will have the order numbers if you created the invoice from the order at least

Was this reply helpful? Yes No
Kenneth Ariel Chave... on at

Like (0)

Report

JAngle, this is additional info you can look. In this course you will find the basics of how to this process works.

Post sales and purchase invoices in Microsoft Dynamics 365 Business Central - Learn | Microsoft Docs

I hope this is useful.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the reply, it would be easier for me to use a picture to illustrate. the above is from a sales order that is not posted. hence i can use the steps above to find out the PO that is associated with this SO.

However, when this SO is posted, the above function no longer available in the screen of posted sales invoice and sales order archive.

beside going thru the database, is there anyway i can find out the PO number from the screen?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the reply, it would be easier for me to use a picture to illustrate. the above is from a sales order that is not posted. hence i can use the steps above to find out the PO that is associated with this SO.

However, when this SO is posted, the above function no longer available in the screen of posted sales invoice and sales order archive.

beside going thru the database, is there anyway i can find out the PO number from the screen?

based on your answer, the only way is to go thru the backend database table?

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

My answer is you need to DEV. Back end wise the information isn’t there to stitch it together at present. It’s something that should be and it’s easy enough to repair. Logging it on the Dynamics ideas site would be a good plan

Was this reply helpful? Yes No
Verified answer

tshannon 55 on at

Like (0)

Report

Our partner added an extension (possibly multiple extensions?) that shows the PO number on each line of a drop ship sales document. That field is a clickable hyperlink that navigates straight to the PO. It also follows the sales document from order > sales invoice > posted sales invoice. And they made a corresponding field on the PO that is a clickable hyperlink with the related sales doc number. It's incredibly useful. One more thing they did was have the SO & PO doc numbers flow to 2 extensions on the GL entries, which greatly simplifies reconciliation of the interim COGS posting account. I absolutely hate the way BC handles drop ship COGS, and I can't believe it took so much customization to simply reveal the relationship between SO-PO.

Was this reply helpful? Yes No