Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[PAM WILLIAMS]

Is it possible to add our Vendor Item Number and Vendor Item Description to our SOP Blank Packing Slip Form? When I select the Vendor Item Number Field the button “add” is grayed out. 

Thanks,
Pam

——————————
PAM WILLIAMS
accountant
Smith Engineering
chaska MN
——————————

[Matthew Arp]

No, the vendor item number is tied to a specific vendor and item number. A Sales Order Line does not have a reference to a specific vendor, just the GP item.

——————————
Matthew Arp
Business Systems Developer
Hunton Group
Houston TX
——————————
——————————————-

[Thaddeus Suter]

If you are using the SOP/POP link to create your Purchase Orders then this is possible with a simple customization as the SOP Lines are directly linked to the PO Lines in the SOP60100 table.

What we do is use an I/U trigger on the SOP60100 to write the POP Line VendorID and the Vendor Item Number back into the SOP Lines table using the SOP/POP link to do it.

We utilize the Contract Number field for the Vendor ID and the Contract Item Number for the Vendor Item Number. These SOP/POP  Orders do not come from CA so the fields are available and fine to use.

Now all PO data is available on the Sales Order lines for printing/Smartlist etc on the SO.

We also use the same trigger to put the SOP Number into the PO Header so it is available when printing the PO.

Your SQL dba or VAR should be able to easily write this trigger to meet your needs.

If you also want this data to remain in history when the SO is transferred to an Invoice and posted a second trigger is required on SOP10100.

——————————
Thaddeus Suter
Retus, Inc
Helotes TX
——————————
——————————————-