web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    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.

  • Community Member Profile Picture
    on at

    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

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans