Sage 100

 View Only

  • 1.  SO Invoice Data Entry - Ship Date Field

    Posted 09-10-2021 14:58
    The end user has a lot of back orders.  The inventory may arrive two, three, or more weeks after the sales order is entered.  When the back order is invoiced the ship date from sales order entry populates the ship date in invoice data entry.  The user always has to change the ship date to today's date (the date the product is shipping).  All of the other fields on the invoice are OK.   Is there an option to use today's date as the ship date when invoicing a sales order?  The invoice date is almost always the same as the ship date (That's how accrual accounting works!). :-)



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------


  • 2.  RE: SO Invoice Data Entry - Ship Date Field

    Posted 09-10-2021 15:29
      |   view attached
    Lookup under the SO invoice Default settings.  This has to be set by user when starting SO entry.


    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: SO Invoice Data Entry - Ship Date Field

    Posted 09-10-2021 15:45
    The default only works with a single step invoice.  When you choose a sales order the default date gets replaced with the sales order ship date.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 4.  RE: SO Invoice Data Entry - Ship Date Field

    Posted 09-10-2021 21:37
    Are you using Shipping data entry?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 5.  RE: SO Invoice Data Entry - Ship Date Field

    Posted 09-10-2021 21:39
    No shipping data entry. 




    Original Message


  • 6.  RE: SO Invoice Data Entry - Ship Date Field

    Posted 09-10-2021 21:41
    And you're right SO ship date is pulled over.  That truly sucks.  I think this is a big bug!!!  Who really ships EVERY invoice on the SO ship date specified?  Do you have Linda Code's direct number.  She needs to get this fixed.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 7.  RE: SO Invoice Data Entry - Ship Date Field

    Posted 09-10-2021 23:28
    I don't have her contact info. Seems like something that should, at a minimum, have an option to use either the invoice date or today's date as the shipping date.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 8.  RE: SO Invoice Data Entry - Ship Date Field

    Posted 09-11-2021 01:42
    If  you don't mind a scripted solution this can be easily solved with one or two lines depending on which date you want to use.  All of the following examples must be attached to the post validate event of the SalesOrderNo field in SO_InvoiceHeader.

    Use this one to use the system date.
      oBusObj.SetValue "ShipDate$", oSession.SystemDate​

      Use this one to use the module date.

      oBusObj.SetValue "ShipDate$", oSession.ModuleDate​

      Use this one to use the record's invoice date.

      sInvoiceDate = "" : oBusObj.GetValue "InvoiceDate$", sInvoiceDate
oBusObj.SetValue "ShipDate$", sInvoiceDate​​


      ------------------------------
      David Speck II
      Tennessee Software Solutions
      ------------------------------

      Original Message


    1. 9.  RE: SO Invoice Data Entry - Ship Date Field

      Posted 09-11-2021 11:20
      Thank you for sharing @David Speck II  !!  You're the best.  I don't mind a script at all.  Just trying to solve the issue the best way possible.
      ​

      ------------------------------
      Doug Higgs
      Midwest Commerce Solutions, Inc
      (312) 315-0960
      Chauffeur, Chef, and Personal Assistant to Sprinkles
      ------------------------------

      Original Message


    Related Content