Sage 100

 View Only

  • 1.  GL Detail by Customer

    Posted 01-05-2023 16:35
    Has anyone ever heard of a solution for posting SO invoices to the GL detail and capturing the Customer No as a reportable attribute / field to do GL analysis?

    Other ERP's (i.e., Acumatica, Quickbooks) can do this.

    ------------------------------
    Andrew Hagenbach
    Hagenbach Solutions, LLC
    ------------------------------


  • 2.  RE: GL Detail by Customer

    Posted 01-05-2023 16:48

    We have done this adding a UDF's in GL_DetailTransaction table and sourcing it from the AR and/or SO updates from invoice and Cash Receipts. For one client we even sourced it from Job cost module.

     

     

     

    Did you miss our 2022 Sage 100 Year-End Training Webinar? Watch the recorded webinar now!

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     

     






  • 3.  RE: GL Detail by Customer

    Posted 01-05-2023 16:56
    Why not use AR history data for that?  Any UDF flow to GL history can't be backdated, and with AR history, you should be able to link all the values they care about to the appropriate GL account...

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 4.  RE: GL Detail by Customer

    Posted 01-05-2023 20:17
    What sort of reporting are they wanting to do???

    I have modified to include a customer UDF in most modules where I want to track customer activity (SO, AP, AR receipts, JE's, etc).  The customer UDF flows from the module to the GL transaction history detail.  I run an Excel query to pull data from the transactions.  From there, I create a pivot table using the customer UDF to create a customer profitability report.  Once all of the UDF's were in place, it works well.

    And I can also see merit for @Kevin Moyes suggestion.

    Solution depends on client's end goal​

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

    Original Message


Related Content