Sage 100

 View Only

  • 1.  Commodity Code in Sage 100

    Posted 09-30-2024 12:06

    What useful purpose does commodity code in Sage 100 serve?  It seems like a feature that Sage added and never went back to again. So far as I can see the commodity code isn't even available in the SO Order or Invoice work tables so you have link in the Inventory ( or Product Line ) if you need to show commodity code on an order or an invoice.

    I'm probably overlooking super simple although I did spend a reasonable amount of time trying to search the KB and didn't find anywhere in the KB that commodity code was discussed. I did find discussion in the help files but that was it.

    Here's what I researched this last night ( email from customer below ):

    Hi Wayne,
    Do you think we can create an additional S/O Invoice form that includes the Commodity Codes. It would aid us on larger international shipments moving via freight forwarder where we need to provide customs information.
    Attached is an example invoice/shipment that we are shipping soon. It has 168 line items. Typically, we have to provide the freight forwarder a total value for each of the commodity codes. It helps to get the shipment through customs faster in the destination country.
    Ideally, I would like to be able to pull the invoice into excel to be able to organize it by Commodity Code to get the total of each of the Commodity Codes.
    And just to be clear we have a Commodity Code field and a code for each line item. We set up this UDF when we got Starship up and running. Works great for international shipments processed through Starship, but when we push larger shipments via freight forwarder it is much more difficult and a manual process.


    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------


  • 2.  RE: Commodity Code in Sage 100

    Posted 09-30-2024 12:40

    @Wayne Schulz - Commodity Code is on SO_SalesOrderDetail (and I assume the Invoice file), so you don't have to link the Item file - just create a UDF based on that SO file.



    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 3.  RE: Commodity Code in Sage 100

    Posted 09-30-2024 14:05

    I'll take a stab at the question "what useful purpose does it serve": Commodity Codes were added to allow for Level 3 Credit Card Processing. which is B2B CC processing at a reduced rate. I have never had a client ask about using that functionality. I remember it was added a long-long time ago, I don't know if it is still supported by Paya or any of the other 3rd party processors though 



    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------

    Original Message


  • 4.  RE: Commodity Code in Sage 100

    Posted 09-30-2024 14:44

    Thanks - both of these make perfect sense. It seemed odd that Sage didn't document much about the commodity codes but now I see they are usually more of a behind-the-scenes feature.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------



  • 5.  RE: Commodity Code in Sage 100

    Posted 10-01-2024 00:45

    I believe we use it to link in to starship for international shipments. 



    ------------------------------
    Russell Berman
    SAGE 100 Reseller
    Business Solutions Providers
    Hackensack
    ------------------------------



  • 6.  RE: Commodity Code in Sage 100

    Posted 10-01-2024 13:09

    Commodity code is used for PCI processing for credit cards as well as rate shopping for TL and LTL shipping.



    ------------------------------
    Gary Feldman
    Principal
    I-Business Network
    Marietta GA
    16786270646
    http://www-i-bn.net
    ------------------------------



Related Content