Jump to content

Rob Reiser

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Rob Reiser

  • Rank
  1. Hey Fitch and Comment (and anyone else up for the task). You guys were able to help me with this problem a couple of months ago. Maybe you can help again. I've recently learned that my tax payment cycles are NOT from the 21st to the 20th, but instead from the 1st to the end of the month (to be paid on the 20th of the following month.) I thought it would be easy to modify the calculations as follows: Calculated Field 'cStartDate': Date ( Month ( gAnyDate ) - 1 ; 1 ; Year ( gAnyDate ) ) Calculated Field 'cEndDate': Date ( Month ( cStartDate ) ; 31 ; Year ( cStartDate )
  2. Beautiful!... you anticipated my next question! Thanks comment.
  3. Okay, I see now. Every month I change the Start Date and End Date, and it shows the records that fall within that cycle. I didn't understand that from your first response. Thanks, Rob
  4. Fitch, I did what you suggested and got inconsistent results. At first the Calculated Range came back with a number... it was 180, I believe. Cool, I figured that was like an ordinal calendar (the 180th day of the year being June 29th, the End Date). I kept changing the End Date, and the Calculated Range number would predictably change along with it. I changed the Start Date and the Calculated Range number stayed the same... still good, I think. But that number was reflected on ALL my records (was that the Global Storage setting doing that?) Not so good, most jobs won't get paid
  5. Thanks Fitch. I'll give this a try as soon as I can. I'll probably have more questions. But, again, thanks for start.
  6. Each month, on the 21st, I have to pay all the sales tax I've collected since the 21st of the previous month, 'sales tax' being a field on each job record. I have a running total of 'sales tax', but it includes ALL visible records. Without Finding or Omitting, is there any way I can set up a field(s), script, or calculation - or any combination - that helps me keep a running total on collected 'sales tax' that falls within one of 12 cycles (from 21st to 21st)? I'm rather a neophyte when it comes to this stuff, but if someone could steer me in the right direction, I think I can do it.
  7. For those who might still be following this topic, and might be able to help me with my problem, what I need my file to do is, for any given record, perform one of two Calculations; either add tax (.0775) or add no tax (0), depending on which value (one of two) in a Value List is chosen. Can anyone steer me in the right direction?
  8. Fitch, I see that in my first message I said that Total was a calculation yet to be determined. What I should have said is that Total is a calculation that I've temporarily said to be Subtotal + Tax, but that I wish to edit it so that it can be dynamically set to be Subtotal + 0 in those instances where I don't need to charge Tax.
  9. Thanks for the response Fitch. But isn't that essentially what I have? I mean, right now, every job gets calculated with sales tax. That is, the Total is a calculation that is Subtotal plus Sales Tax. What I need is for each record to have the flexibility to calculate Sales Tax or not, depending on the whether or not Tax is applicable on a given project..
  10. I'm trying to set up my FM invoice file to calculate sales tax - or NOT - depending on whether the job I do is taxable or not. I'm not sure that I've set this up the right way, but here are the fields I currently have: Subtotal (a calculation of Hours X Rate) Sales Tax (a calculation of Subtotal X .0775) Taxable (a Checkbox Set with values list:True, False) Total, a calculation which has yet to be determined It seems to me that the calculation I want performed for 'Total' is as follows: If 'Taxable' is checked True, then Total = Subtotal + Sales Tax If 'Taxable' is
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.