You’re offline. This is a read only version of the page.
I have inherited a project and i am new to SL so please excuse the newbie question. Is there a database model that will help me identfy how sales tax is being handled when a sales order is entered?
It looks as though the sales order splits a line item into multiple data table rows, one for each taxId which is set by geocode. What i am trying to get out of the tables (that I can't find in a can report) is a report that shows each line item and the total tax paid for the line item. So if a Sales Order has two line items the data I want out my custom report is two rows.
*This post is locked for comments
I have the same question (0)
N2Teeth,
There's no database of which I'm aware. However, have you tried looking at the SL Shared Information user guide? It might provide some insight into how sales tax is calculated and applied.
Also, I think sales tax is applied to the total price of merchandise--not per line item. You could, perhaps, back-calculate the per line item contribution to the total tax, but this information isn't stored in SL.
Thanks,
DB
Share
Report
All responses (
Answers (
275
