Simple Invoice

Question

I am a very experienced TS user but after 20+ years, I still cannot figure out how to create a Bill Layout that simply shows the amount of the current charges on the bill and any credit or funds transaction that I want to specifically come off that Invoice (not overall A/R balance) without having to bring in prior A/R balance and all other transactions (i.e. payments, etc.) since the last Invoice. 
 After years of formatting our Invoices multiple ways, our clients only want to see what the charges are for the current Invoice and any credits or funds transactions applied to that specific Invoice. 
 Creating a simple Invoice is easy enough to do if I don't have to show any sort of "transaction" applied to it--I do this all the time. But any time I want to just show ONE SPECIFIC transaction applicable to that Invoice, I cannot do it without having to bring in prior balance any other a/r transactions that occurred since the client was last billed. 
 Note: I have tried using the "a/r transactions obey date filters" (and I swear that used to work in older versions) but it doesn't seem to work anymore--frankly, if that feature doesn't allow me to filter out other transactions then what is the purpose if it--unless it isn't working properly. 
 I am using the most current version of TS, which is Premium Elite 30.0.4.84 
 
 Rhonda

Nancy Duhon · Answer

Okay, so to prove/disprove the theory. 
 I opened the sample database in Timeslips Premium Elite, and created a new client. Nickname: RCORN65. 
 Entered a new Payment to Funds on January 10 of $500. 
 Added one slip dated January 10th for $150 worth of time. 
 Changed the bill date to 1/31/2023, printed the bill to PDF and approved it. Did not draw any of the Funds to cover the bill, so the account still has $500 in Funds, but now has a Previous Balance of $150. 
 Now for the 2nd bill: Enter a second slip for $300 dated March 10th. A Payment dated February 12th of $150 paying the previous invoice, and a Payment from Account of $200 dated March 10th to partially pay the current charges on the new bill. 
 Total A/R Balance Calculation goes like this: 
 Previous Balance: $150 
 New Charges: $300 
 Payments received (2) for a total of $350 
 Balance Due $100 
 Here's what the initial run looks like (I have highlight the A/R Payment you do not want to see): 
 
 If I limit the A/R transactions to obey the slip filters and do nothing else: 
 
 Then the bill looks like this. 
 
 Note that the "A/R Transactions Obey the Slip Date Filter Range setting DOES work. It is excluding the February payment. 
 But the individual bill does not "add up" correctly to only the current new and unpaid charges. 
 But if we take out the Previous Balance and the New A/R Balance, then we get this: 
 
 Which is better, but there is no total due for this invoice. At this point, the EASIEST thing might be to just print to PDF, and use the Add Text option in your PDF editor to add the total manually to explicitly show it to the client. 
 But if I add a Customized Section to my layout to do that, I can get this: 
 
 A bit cludgy, but it works. 
 Caren's method could work two, but it is incorrect to categorically say that Timeslips cannot produce the invoice you desire. 
 It may take a bit more work, but it can. 
 Nancy Duhon, Esq. Duhon Technology Solutions, LLC Master Certified Consultant for Sage Timeslips LawPay Partnered Consultant Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions. 404-325-9779 duhon@duhon.biz

Sage Timeslips

Simple Invoice

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING