Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Tax Schedule Source (TXSCHSRC) field in the SOP10200 table

Posted on by 725

Anyone know what this field is used for?  The documentation is a little vague. It's stored as an integer and I found this function DYN_FUNC_Tax_Schedule_Source that tells me what the value means.  We are changing tax calculation software and are trying to cleanup some of our customizations and integrations.  Based on orders that we have created and out setup we will set ours to 2.

select dbo.DYN_FUNC_Tax_Schedule_Source(1) returns "Using Site Schedule ID"

select dbo.DYN_FUNC_Tax_Schedule_Source(2) returns "Using Ship To Schedule ID"

select dbo.DYN_FUNC_Tax_Schedule_Source(3) returns "Using Single Schedule"

select dbo.DYN_FUNC_Tax_Schedule_Source(4) returns "Schedule ID Empty"

select dbo.DYN_FUNC_Tax_Schedule_Source(5) returns "Schedule ID Not Found"

*This post is locked for comments

  • bwholl Profile Picture
    bwholl 725 on at
    RE: Tax Schedule Source (TXSCHSRC) field in the SOP10200 table

    Thanks, that was what I was looking for.

  • Verified answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Tax Schedule Source (TXSCHSRC) field in the SOP10200 table

    When tax liability is considered, based on the settings in the customer card, the system determines whether the schedules associated with your firm's site that is delivering the goods apply or the customer's ship to address schedule applies.  That provides response 1 or 2.

    If the schedule exists in the tax schedule table but has no tax codes associated, value 4 is applied.

    If the schedule does not exist in the tax schedule table, value 5 is applied.

    I am not sure what value 3 represents.  It may be a hold over from older systems

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans