Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Sales Order Processing...
Microsoft Dynamics GP (Archived)

Sales Order Processing Posting Accounts From - is it possible to set up a matrix for this?

(0) ShareShare
ReportReport
Posted on by Doctor_Venkman

For Sales Order Processing:

Is it possible to use a matrix to determine how Posting Accounts are selected?

We want to use Inventory posting accounts as a default in most but not all cases.

If a sale is made to an Intercompany Customer, then the transaction should be posted to a single Intercompany sales account.


If a sale is made to any other customer then the transaction should be posted to a sales account that is determined by the set-up of the Inventory item.

Is it possible to do this except by means of a manual adjustment for each posting?

*This post is locked for comments

  • Doctor_Venkman Profile Picture
    Doctor_Venkman on at
    RE: Sales Order Processing Posting Accounts From - is it possible to set up a matrix for this?

    Thanks Bill.  That sounds like it will work for our needs.  Cheers.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,928 Most Valuable Professional on at
    RE: Sales Order Processing Posting Accounts From - is it possible to set up a matrix for this?

    George beat me to it. I would look at Flexicoder from eOne.

    David

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Order Processing Posting Accounts From - is it possible to set up a matrix for this?

    Hey Doc!

    You are limited on what you can do within the standard GP interface with regards to defaulting GL accounts.  However a great tool which can take care of your distribution needs is "Flexicoder" by eOne Solutions.  Check it out: (www.eonesolutions.com/.../overview) I think you will be impressed and eOne is a great ISV partner to work with.

    Good Luck.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Order Processing Posting Accounts From - is it possible to set up a matrix for this?

    This can be tricky. As far as I know, you must take the sales account from either the item or the customer. GP does not allow you to have your cake and eat it to.

    An easy workaround is to add a step to your period - end procedures to reclass intercompany sales to the appropriate GL account. You could use the SOP Document Analysis SSRS report, a SmartList, or a filtered version of the Sales Line Items Excel report to facilitate this process.

  • Verified answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Sales Order Processing Posting Accounts From - is it possible to set up a matrix for this?

    There are two places I know of to set the Posting Accounts for a customer in Microsoft Dynamics GP

    1. Administration >> Posting >> Posting Accounts - select Sales.

    2. Cards >> Customer >> Accounts

    If you do not enter anything at the Customer level, then the next default location is the Posting Account window.

    If you want specific customers to have specific posting locations, then enter them at the Customer Level.  Otherwise leaving that blank will make the system default to the 'general posting accounts' rule set on the Administration tab.

    Hope this helps.  Of course as with all configuration matters (1) backup (2) test and learn.

    Good luck.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans