Soptype in SOP10106

  • Soptype in SOP10106

    Posted by Jeff Roe on May 1, 2017 at 7:08 pm
    • Jeff Roe

      Member

      May 1, 2017 at 7:08 PM

      We are seeing invoices in the SOP10106 table with a soptype of 3 and 4.

      In some cases we are see the same invoice number with a soptype of 3 and soptype of 4.

      What drives the soptype in the SOP10106 table?

      ——————————
      Jeff Roe
      Kele Inc
      Bartlett TN
      ——————————

    • Thaddeus Suter

      Member

      May 1, 2017 at 8:30 PM

      They are not both Invoices.
      The primary key in SOP10106 is both SOPTYPE and SOPNUMBE.
      To avoid confusion on SOPNUMBE since they are not unique, use a different numbering schema for each SOPTYPE (DOCID) in your SOP Setup.
      SOPTYPE 3 = INVOICE
      SOPTYPE 4 = RETURN
      We have an “I” usually in the Invoices and an “R” in the Returns

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

    • David Musgrave

      Member

      May 2, 2017 at 1:36 AM

      For a full list

      1 – Quote
      2 – Order
      3 – Invoice
      4 – Return
      5 – Back Order
      6 – Fulfilment Order

      Note that Fulfilment Order is normally listed after Orders in the drop down list, so that the positions in the drop down list do not match the data in the database.

      There are Dexterity functions that convert the values for you and most windows have an extra field which can be used from VBA.

      For example the SOP_Entry window has fields SOP Type and SOP Type Database.

      David

      ——————————
      David Musgrave MVP, GPUG All-Star

      Managing Director
      Winthrop Development Consultants

      Perth, Western Australia

      http://www.winthropdc.com
      ——————————
      ——————————————-

    • Jeff Roe

      Member

      May 8, 2017 at 1:15 PM

      Thanks

      Clearly I was not looking at the details correctly

      ——————————
      Jeff Roe
      Kele Inc
      Bartlett TN
      ——————————
      ——————————————-

    Jeff Roe replied 7 years, 2 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Soptype in SOP10106’ 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!