Sage 100

 View Only

  • 1.  Is there a way to customize the general ledger to include a fields for job number, vendor and/or customer, and invoice numbers?

    Posted 11-11-2020 11:02
    I had a customer who uses Job Cost ask me this question.

    Is there a way to customize the general ledger to include fields for job number, vendor and/or customer, and invoice numbers?


    I'm not sure the job number can flow from posting but I would love to be proven wrong

    I'm very wary of putting in a lot of time to prove ( or disprove ) that these fields can flow only to be told that my quote of $x is too much but thank you for replying...​

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------


  • 2.  RE: Is there a way to customize the general ledger to include a fields for job number, vendor and/or customer, and invoice numbers?

    Posted 11-11-2020 11:04
    I think customer and vendor info can likely be passed via comment ( using setup options for their respective module ). I'm not sure about the Job portion.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 3.  RE: Is there a way to customize the general ledger to include a fields for job number, vendor and/or customer, and invoice numbers?

    Posted 11-11-2020 15:13
    I've created UDFs to pass through to UDFS in GL before.  NOT into the comment field - into their own UDF field.  All of the registers dump into the GL_DailyPosting file.
    So, for the Job Number, for example, you would add the JobNo field to the JC_DailyPostingWrk (you have to make sure you have it coming in from ALL the registers), then flow to the GL_DailyPosting file from there, then to the GL_DailyTransactionRegister file, then finally to the GL_DetailPosting file.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------

    Original Message


  • 4.  RE: Is there a way to customize the general ledger to include a fields for job number, vendor and/or customer, and invoice numbers?

    Posted 11-11-2020 16:08
    Thanks.
    My other concern is that there’s no way to report on history. I’m also afraid I can get 85% of the way and the last 15% is going to be a surprise that I can’t overcome.

    ---------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ---------------------------------





  • 5.  RE: Is there a way to customize the general ledger to include a fields for job number, vendor and/or customer, and invoice numbers?

    Posted 11-11-2020 17:30
    I've been doing what @Beth Bowers discusses for years.  In my case, my udf is for clients (three character) validated against a UDT.  Add udf to the various modules impacting GL.  When processing AP invoice entry, enter the company code on the distribution line.  SO orders/invoices, each line on tab three have the field.  Cash receipts, PO's, etc.  all have the udf.  Update and the UDF is in GL detail posting.  Create a Crystal /Excel query and you can create a profitability by customer report.  Easy, fast and accurate.
    ​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 6.  RE: Is there a way to customize the general ledger to include a fields for job number, vendor and/or customer, and invoice numbers?

    Posted 11-12-2020 02:49
    I have also done what Beth has done for a couple of clients.  I'm in the process of doing this for a client now on version 2019. I take all the UDF's thru to history files so they can be used for reporting.  There may be a few UDF's that are not needed thru my process as I have never documented it.  The clients I have done this for have not been on the same versions and have some difference in how they enter and process transactions.  Attached is a screen shot and custom office export from version 2016.

    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Attachment(s)

    docx
    GL Daily Posting.docx   45 KB 1 version
    M4X
    Job_Number.M4X   7 KB 1 version
    Original Message


  • 7.  RE: Is there a way to customize the general ledger to include a fields for job number, vendor and/or customer, and invoice numbers?

    Posted 11-12-2020 10:35
    Thanks, Michele. I can't tell from the document if you are flowing through the job number from the source.

    For example, if they are entering an AP Invoice they are already keying in the job number. I presume you take that native Sage field and flow it to UDF_JobNumber?

    I am somewhat concerned that for the AP Invoice ( and any other detailed posting ) that Sage might summarize multiple postings made to the same ultimate GL account which would cause an issue for me in flowing all the detailed job numbers through to the GL.

    There is also the issue that this is only going to work going forward and if the customer loves the report and asks how they can get last year's data it's going to be a quiet few moments on the phone.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------

    Original Message


  • 8.  RE: Is there a way to customize the general ledger to include a fields for job number, vendor and/or customer, and invoice numbers?

    Posted 11-12-2020 10:54
    Yes, the Job Number is being entered in the Job Number Field thru out the modules.  I am going to pull the AP_InvoiceHistory table and use that to import into the GL UDF in GL Detail Posting.

    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Original Message


Related Content