Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

How to Self-Assess State Sales Tax for Purchases from an Out-of-State Vendor

(0) ShareShare
ReportReport
Posted on by

When we purchase goods from out-of-state vendors, we pay the vendor no state sales tax; however, we are required to self-assess the sales tax payable to our own state.  How should this be recorded in GP?

We create the GP SQL Server records outside GP from an external system.

I had thought that I could post the following distributions under one invoice:

Account Acct Type Debit Credit DistRef
Inventory - Parts PURCH 300 0  
Inventory - Parts PURCH 24    
Accounts Payable - Trade PAY 0 300  
Sales Tax Payable DUETO 0 24 Self-Assessed

 

However, it fails to post in GP with the following error: "The accounts payable distributions do not equal the actual amount."

The invoice record has Purchases and Doc Amt = $324.  If I change these values on the invoice record to $300, it still fails to post with the same error.

Must I create a separate invoice for the self-assessed taxes payable in this scenario?  Or is there another way to do this?

Thanks for any help you can give.

Wayne

*This post is locked for comments

  • RE: How to Self-Assess State Sales Tax for Purchases from an Out-of-State Vendor

    Thanks, JDoucette.  I think you're right.

    On the Invoice record, if I leave the PRCHAMNT = 674.15 (your example) and set the following to 639.00, it works:

    DOCAMNT

    CHRGAMNT

    CURTRXAM

    Do this seem right?

    Wayne

  • Verified answer
    RE: How to Self-Assess State Sales Tax for Purchases from an Out-of-State Vendor

    Hi Wayne-

    Our company also has to accrue "use tax" on out-of-state purchases.  I think your issue is arising from the  account type used in the distribution.

    Below is a sample distribution for purchases and document amount of $639.00

    Account Acct Type Debit Credit
    Expense PURCH 674.15
    AP Trade PAY 639.00
    Use Tax PURCH 35.15
    Functional Totals 674.15 674.15

    The total of the PURCH acct type items must equal the total of the amount entered on the purchases line of the invoice record.

    Hope this helps.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,401 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans