Sage 100

 View Only
  • 1.  Wondering if anyone has seen, or better yet used,

    Posted 03-19-2018 12:43
    Wondering if anyone has seen, or better yet used, an elegant solution for tracking deposits by contract?


  • 2.  RE: Wondering if anyone has seen, or better yet used,

    Posted 03-19-2018 13:42
    Are you using JC or anything other module? How are you recording the deposit?


  • 3.  RE: Wondering if anyone has seen, or better yet used,

    Posted 03-19-2018 14:23
    Right now, Cash Receipts. Client isn't interested in Job Cost.


  • 4.  RE: Wondering if anyone has seen, or better yet used,

    Posted 03-19-2018 14:46
    IIG has the only solution I know for enhanced deposit tracking. It's part of the Credit Card Solution https://docs.wixstatic.com/ugd/da2e0f_7270ca745e3e4ff08c258ee145665ba7.pdf


  • 5.  RE: Wondering if anyone has seen, or better yet used,

    Posted 03-20-2018 04:10
    Not sure how involved you want to get, but a while back I needed a way to track profitability by customer. Not everything is invoiced through AR/SO invoicing (I use Timeslips for billing as well with a export to Sage GL). So I created a UDT to list all of my clients (used their company code as the key). Then in every module (AP, AR, SO, PO and GL), I created a company code UDF in line entry (e.g. cash receipts entry), validated against the UDT and flowed the UDF to the GL detail posting table. I use an Excel query to pull detail transactions whenever I want to see profitability (of course I summarize with a Pivot table). To a little time to set the UDF's, but it has worked well for five plus years. In addition to cash receipts, I would think a code in your billing module would be necessary as well.


  • 6.  RE: Wondering if anyone has seen, or better yet used,

    Posted 03-20-2018 09:02
    We did something similar to @JeffSchwenk for a customer who needed to match buy and sell contracts for bulk seed.