Sage 100

 View Only
  • 1.  I am trying to do a Job Billing Import and ran int

    Posted 10-29-2013 10:42
    I am trying to do a Job Billing Import and ran into an issue. I just realized that there is no perform logic to calculate the totals (taxable amount, non-taxable amount, sales tax amount, etc.). Has anyone found a work around for this?


  • 2.  RE: I am trying to do a Job Billing Import and ran int

    Posted 10-31-2013 06:28
    Just to confirm - the lack of an answer means there is no workaround, correct?


  • 3.  RE: I am trying to do a Job Billing Import and ran int

    Posted 11-01-2013 07:17
    It's been a while but it I recall being able to get VI to calculate a total by adding to the header total on each record. An example would be for each line you would take the taxable amount and add it to the header taxable total and the total field would accumulate. You also have to find a trigger to get the header total to reset when the job number changes. I hope that info helps.


  • 4.  RE: I am trying to do a Job Billing Import and ran int

    Posted 11-01-2013 08:04
    I ended up writing perform logic so that the tax records get populated properly. Thanks for the response.