Adding Vendor Item Number Field to SOP Blank Packing Slip Form

  • Adding Vendor Item Number Field to SOP Blank Packing Slip Form

    Posted by Pam-Williams on April 20, 2017 at 11:01 am
    • PAM WILLIAMS

      Member

      April 20, 2017 at 11:01 AM

      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

      Member

      April 20, 2017 at 12:29 PM

      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

      Member

      April 21, 2017 at 8:57 AM

      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
      ——————————
      ——————————————-

    Pam-Williams replied 7 years, 2 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Adding Vendor Item Number Field to SOP Blank Packing Slip Form’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!