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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Use Tax in Purchasing Invoice Entry

(0) ShareShare
ReportReport
Posted on by

Hello:

OK.  GP 10.0 with service pack 5.  Most of the items entered in Purchase Order Processing are going to be noninventoried items.  The exception is going to be a Sales Inventory item called "USE TAX".

This item will be manually added on the Purchasing Invoice Entry window because, by that time, the client will know how much tax they will have to put on their invoice and report to the state.

They cannot simply enter an amount in tax, as they need a formal USE TAX line item to track by.

OK.  So, I created a PO with one noninventoried item and successfully received it in.

Then, I auto-invoiced the noninventoried item.  Next, I entered a line item for the inventoried item "USE TAX".

When I clicked "Distributions", two things happened that really upset the living daylights out of me.  First, a line was created for "PURCH" for the USE TAX.  That's good, and that's what I wanted.

But, the account that I placed for the item in Item Accounts Maintenance did not default in.  When I tried to type it in, I got that wonderful message saying that you cannot change the account at the summary level and to do so at the line item level, instead.

Well, I'd love to do that.  But, when I click on line item entry, there is no field for account.

Not only that, it really would have been nice to have had a corresponding credit to Use Tax Payable.  Instead the whole payable amount for the invoice got booked into Accounts Payable.  I don't want to force the client to have to break out the payables amounts in the distributions screen manually.  Is there no an account in Item Accounts Maintenance to place this payable?

I think that it's pretty obvious what my question is:  How in the world do I get this USE TAX business to work?

Thanks!!!

John

*This post is locked for comments

  • Richard Whaley Profile Picture
    25,195 on at

    What you have not explained is why they do not put the use tax in the tax field when the vendor's invoice (with the tax on it) is vouchered.  This is the normally accepted way to do this.

    And BTW, you do NOT want to create a service item like Use Tax as a Sales Inventory Type item.  Quantity adjustments will drive you crazy.

  • Richard Whaley Profile Picture
    25,195 on at

    BTW..If they have the flexibility to use the sales tax on the invoice form, we have a document in the Free Stuff section of our web site that explains how to do this.  It is titles Sales Tax but also covers Use Tax

  • Community Member Profile Picture
    on at

    Hi Richard:

    The reason is because, first of all, the Use Tax does not happen often enough for our client to warrant setting up tax details or conducting GP's comparison to the purchase order default tax schedule based on shipping method.  In fact, most of the time, the shipping method is going to be "Delivery".  So, having the determination in GP of which tax schedule to use is a moot point.

    Not only that, for auditing purposes, they can more easily have a SmartList containing line items showing only "USE TAX", instead of pulling in simply tax amounts as a column and trying to deduce how much of that tax is only Use Tax.

    By the way, I hope that you have some copies of that book on MS-SQL scripts for GP Consultants.  I've been thinking about buying it, but I'm not so sure that you have any in stock.  :)

    John

  • Richard Whaley Profile Picture
    25,195 on at

    I think we do have a few in stock.  We pulled the listing from our web site because it is not written against the most current versions of MS SQL.  Technically nothing but the images will change but we have had people complain in the past.  If you want one, call the office in the afternoon (Eastern Time), ask for Elizabeth, and tell her you want a copy anyway or you can purchase it on Amazon as it is still listed there.

    321-206-4610

  • L Vail Profile Picture
    65,271 on at

    The debit account that defaults in should be the account assign as the Purchase Price Variance account on the item card.

    When you put the USE TAX item on the invoice, doesn't that increase the amount of $ owed the vendor? How do you avoid paying the Vendor too much?

    I don't follow how this is going to work through for him.

    He doesn't want to mess with setting up Purchases tax, but right now how does he figure which taxing authority gets the money?

    How is he going to handle, as Richard mentioned, the quantities that are being put into inventory?

    This sounds like an intriguing method, I'm just not putting all of the pieces together.

    Kind regards,

    Leslie

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans