News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) SL 7 database tables f...

Microsoft Dynamics SL (Archived)

SL 7 database tables for sales tax

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

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

All responses Img

All responses (1)

Answers Img

Answers (0)

Fujimi DB 275 on at

Like (0)

Report

RE: SL 7 database tables for sales tax

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans