Sage 100

 View Only
  • 1.  In SO_Invoice.wrk, what are SalesTaxAmt fields 1-4 used for? Pulled from?

    Posted 01-13-2025 10:48



    ------------------------------
    Bob Pfahnl
    Manager - Silicon Valley
    DSD Business Systems
    ------------------------------


  • 2.  RE: In SO_Invoice.wrk, what are SalesTaxAmt fields 1-4 used for? Pulled from?

    Posted 01-13-2025 11:45

    It looks like you can opt to print detail of the sales tax schedule - by checking " print tax detail " and if that's done up to 4 tax amounts can print on the form.

    Tax Schedule

    Enter a tax schedule to add or maintain, or click the Lookup button to list all tax schedules.

     

    Description (Tax Schedule)

    Type a description for the tax schedule.

     

    Print Tax Code Detail

    Select this check box to print tax detail information on sales orders or invoices. Clear this check box if you do not want to print this information on forms.

    When printing using standard forms or Crystal Designer, sales orders and invoices can be set up to print one sales tax line as an accumulation of all sales tax. In addition, detail can be printed for up to four tax codes by selecting this check box. Four separate tax amount, tax exemption number, and registration number fields can be configured to print from within the forms. During the print routine, the first three fields are used for the first three tax codes in the schedule. The fourth field is used for an accumulated tax amount for all remaining tax codes.

     

    Tax Code

    Enter a tax code for the tax schedule, or click the Lookup button to list all tax codes. The first tax code entered is used as the primary tax code, which is used during the calculation of taxable and nontaxable amounts on each invoice and printing/updating of sales tax history.

     

    Description (Tax Code)

    Type a description for the tax code.

    https://help-sage100.na.sage.com/2022/Subsystems/LM/LMSetupFields/Sales_Tax_Schedule_Maintenance_-_Fields.htm#SALES_TX_SCHDL_TX_SCHDL



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------



  • 3.  RE: In SO_Invoice.wrk, what are SalesTaxAmt fields 1-4 used for? Pulled from?

    Posted 01-15-2025 01:49

    Yes... we've had to use this often in Canada because there is a requirement to display GST (federal) vs PST (provincial) sales taxes separately.

    Be sure to test print... and if you have more than 4 tax codes in a tax schedule, it simply won't work.  (I've had to use sub-reports when that happened once).



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: In SO_Invoice.wrk, what are SalesTaxAmt fields 1-4 used for? Pulled from?

    Posted 01-15-2025 09:29
    That could be a problem with AvaTax which has 6 codes. 

    Bob Pfahnl
    Sent from mobile

     

    Bob Pfahnl

    Sr. Business Analyst (GM San Jose)

    e:

    bobp@dsdinc.com

    p:

    800-627-9032 x 220

    w:

    www.dsdinc.com

    CLOSURE NOTICE: DSD OFFICES WILL BE CLOSED MONDAY. JANUARY 20th

     
    
    Yes... we've had to use this often in Canada because there is a requirement to display GST (federal) vs PST (provincial) sales taxes separately. ...

    Sage 100

    Post New Message
    Re: In SO_Invoice.wrk, what are SalesTaxAmt fields 1-4 used for? Pulled from?
    Reply to Group Reply to Sender
    Jan 15, 2025 1:49 AM
    Kevin Moyes

    Yes... we've had to use this often in Canada because there is a requirement to display GST (federal) vs PST (provincial) sales taxes separately.

    Be sure to test print... and if you have more than 4 tax codes in a tax schedule, it simply won't work.  (I've had to use sub-reports when that happened once).



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------
      Reply to Group Online   View Thread   Recommend   Forward  




     
    You are receiving this message because you followed the 'In SO_Invoice.wrk, what are SalesTaxAmt fields 1-4 used for? Pulled from?' message thread. To unsubscribe from this message thread, go to Unsubscribe.

    Update your email preferences to choose the types of email you receive






  • 5.  RE: In SO_Invoice.wrk, what are SalesTaxAmt fields 1-4 used for? Pulled from?

    Posted 01-15-2025 11:31

    If you need to print tax details, and the work table fields don't work, you can use two sub-reports for that.  (One pointing at the open invoice tax tables, and one pointed at the invoice history tax tables).



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------