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

(0) Share

Report

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

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
David Musgrave MVP ... 14,151 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

David

Was this reply helpful? Yes No
Doctor_Venkman on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No