Sage 100

 View Only
  • 1.  Sales Order detail and history detail tables - v2022

    Posted 04-04-2023 16:36

    Is it my aging eyes?  Or is it a WTF moment?  I am looking for the product line code in the above tables and I am drawing a blank (MIA) field.

    What gives?



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------


  • 2.  RE: Sales Order detail and history detail tables - v2022

    Posted 04-04-2023 16:44

    Not blind - apparently not added until invoicing...



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



  • 3.  RE: Sales Order detail and history detail tables - v2022

    Posted 04-04-2023 16:48

    So the upcoming cataract surgery will help here then,,,,,,  WTF.

    Hello ideation...

    Sage is so lazy at times.

    So I have to set up a UDF if I want it in the table or add the ci_item table to the query......

    Goodness



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 4.  RE: Sales Order detail and history detail tables - v2022

    Posted 04-05-2023 09:05

    @Jeff Schwenk I feel your pain.  I too had a WTF moment when I first discovered this - I still do every time I have to create that UDF!!!



    ------------------------------
    Susan Pawlowic
    Sage 100 Solutions Architect
    RKL eSolutions, LLC
    spawlowic@rklesolutions.com
    (717) 735-9109 Ext. 4352
    ------------------------------



  • 5.  RE: Sales Order detail and history detail tables - v2022

    Posted 04-05-2023 09:26

    Time to vote on the Ideation page.  I fear I will be a pensioner before it sees the light of day.  To paraphrase Smokey the Bear, only YOU can make a difference!



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------