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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)
Suggested Answer

Calculating purchase order receiving sales tax with the distribution to the expense codes for the purchased items

(0) ShareShare
ReportReport
Posted on by 425
Our purchasing folks currently add sales tax to purchase orders as a separate line item and receive it with the goods.  The reason they do it this way is that we charge sales tax to the same expense account as the underlying goods.  We use 0% tolerance for receiving and if we were to increase the unit price by the sales tax rate it would cause rounding issues as well as confusion when checking matching the vendor invoice.
We would like to use the GP Sales Tax functionality to calculate sales tax on purchase orders and receivings automatically and avoid all the additional data entry.   The credit distribution from the tax detail window can be set to the Accounts Payable gl code.  The problem is that the debit side of the transaction would default from the Sales Tax transaction type in Posting Accounts setup, vendor class setup or vendor accounts setup.  So we can only have one default expense code per document based on the vendor accounts setup and not based on the purchased item.  By the way, we do not use the inventory module.
Is there a set up trick or a third party product that will automatically set the sales tax distribution debit to match the expense distributions for the underlying purchase?  If there is more than one expense code charged on an order, the tax distribution must be split proportionally.  How does your company expense sales tax on non-inventory purchases in GP?  Thanks!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,633 Moderator on at

    Lou, you can setup multiple 'default' accounts at the vendor level - see screenshot below - this will either default the account marked as default in the transction or force the user to select from the valid accounts (from account lookup in the distributions window) setup in this window if no default is checked.  To make this work, delete the default account in the main Purhases account field.

    Another option is to use KampData's DynamicZip app, which does exactly what you're looking for - it has a default setting that will post the sales tax to the purchases account.  A side benefit is if you have use tax issues, DynamicZip handles Use tax quite nicely.  http://www.kampdata.com/Product/DynamicZip.aspx

  • Liane McIlraith Profile Picture
    350 on at

    HI Lou,

    I'm struggling with this same sales tax issue with a couple of clients right now.  I found a 3rd party product that handles this issue nicely but it would be nice to know how other users are handling this issue.  I don't see any response to your post.  Did you ever get any feedback?

    Thanks,

    Liane

  • Suggested answer
    Community Member Profile Picture
    on at

    In the tax detail window, you need to change the inventory Item with non-inventory items it picks up the expense you assign the PO line item.

    2705.Capture.PNG

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 Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans