Sage 100

 View Only

  • 1.  Job Cost Retention

    Posted 02-25-2021 08:38
    There is a Retention Balance field in JC_Job that displays on the Status tab.  One would assume that is the field used when a Retention invoice is created, but I have a client on 2019.3 (which is AFTER the big JC fix bundle) who is doing RT invoices right now and the amount coming up on the invoice is NOT what is in that field.

    Does anyone know how it's calculated in JC billing?  Does it actually go through the TransactionDetail file and add up all of the Retention Amounts or something?

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


  • 2.  RE: Job Cost Retention

    Posted 02-25-2021 08:54
    It should be calculating based on the Retention % on the Main tab in JC Maintenance.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 3.  RE: Job Cost Retention

    Posted 02-25-2021 09:05
    I understand now they are trying to bill the retention balance and are using RT as the invoice number extension in JC billing.  I wonder if there was a previous RT invoice on the same job.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 4.  RE: Job Cost Retention

    Posted 02-25-2021 09:18
    Edited by Doug Higgs 02-25-2021 09:18
      |   view attached
    Check the Retention field in JC_CostRetentionDetail.m4t,  See the attached KB.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 5.  RE: Job Cost Retention

    Posted 02-25-2021 09:27
    I bet that's where the issue is.  HOWEVER - that lists 2018.  :-(

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

    Original Message


Related Content