web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Tax Schedule Source (TXSCHSRC) field in the SOP10200 table

(0) ShareShare
ReportReport
Posted on by 727

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

I have the same question (0)
  • Verified answer
    Richard Whaley Profile Picture
    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

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

    Thanks, that was what I was looking for.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans