eOne Smartconnect - How to integrate Custom Tax Amounts into SOP Line Items

• The issue is that you want to integrate a tax amount that does not equal the regular % calculation. For example, the tax is 15%, but you want to put $10 tax regardless of the sales amount.
• You must use line sequence numbers in your source data
• Add this code as a column to get your own row numbers
• Replace Custnmbr with a field from your view
•  row_number() over (order by dbo.RM00101.CUSTNMBR) * 1000 as RowNum,
• Create Sales Transaction Setup
• Create taxes  -False
• Freight Tax Amount - Local constant 0
• Misc Tax Amount - Local Constant 0
• Freight Taxable - nontaxable
• Misc taxable - nontaxable
• Tax Schedule - populate with a tax schedule
• Tax Amount - populate with total tax amount for the sop document
• Create Sales Line Item Setup
• use Line Sequence
• Tax Amount - populate with line tax amount
• All other tax related fields can be left blank
• Create Add Tax Line Detail Setup
• Use Line Sequence
• Sales Amount - Sales amount
• Freight Tax - Local constant 0
• Misc Tax - Local Constant 0
• Freight Amount - local constant 0
• Misc Amount - local constant 0
• Tax Detail ID - populate with a tax detail id
• Sales Tax - Put your custom amount of sales tax here ($10)
• The system will integrate the sop document, and all the lines, and hte tax detail, then replace the tax on the lines with your Line Sales Tax amount, and caculate the correct tax total on the Sales Invoice total
• The key is to use a sequence number, and set all of the values for the other taxes to 0 or a value if you have them.