rbucek
(Rob Bucek)
April 23, 2020, 7:52pm
1
All,
So our bean counters want to route sales revenue to GL accounts by country. I thought we could do this by adding a GL Account type of AR-Account and creating a GL control to go along with that to route sales to an account but it doesn’t seem to override the product group that’s in place. We sell the same product group across multiple countries so we can’t really modify those.
Starting with customer
Then the control code
we have it going to a sub account, not sure if that matters?
However when i post the invoice it goes to the sales account defined under the gl control on the product group.
Any thoughts on what I’m missing here or is this not even capable of getting me where i want to go?
thanks!
jgiese.wci
(Joshua Giese)
April 23, 2020, 7:57pm
2
Dude, “Bean Counter” is not the preferred nomenclature, Numerically Gifted… please.
1 Like
bderuvo
(Bryan DeRuvo)
April 23, 2020, 8:02pm
3
@rbucek you can create sales categories, this will override the department code for sales if you add a gl control code. You can manually select or BPM from the country.
ckrusen
(Calvin Krusen)
April 23, 2020, 8:23pm
5
Seriously? You guys only use +
, -
, x
, and /
…
Engineers everywhere should be outraged …
ckrusen
(Calvin Krusen)
April 23, 2020, 8:56pm
9
So is it just the addition of the country based sub accounts that need to accounted for?
Like if PrdGrp XYZ
had acct 1234-56-789
. You now want sales of item of the PrdGrp, to be further specified by country, like
The PrdGrp is XYZ
:
And Customer is in Japan, then use GL Acct 1234-56-789-JPN
And Customer is in Germany, then use GL Acct 1234-56-789-DEU
Some GL controls “overlay” each other, like the division segment can be set by site.
Or GL for Inventory is 1151-00-01
(setup in the Company GL controls for Inventory). While there are Site based GL controls:
____-00-_
for site CHAL
____-16-_
for site GUTH
____-17-_
for site HOUST
The ___
parts above indicate that segemnet is left blank when setting up the GL Control.
When a GL tran happens for the GUTH Inventory, GL acct 1151-16-01
is used.
kenswaka
(Kennedy Swaka)
April 23, 2020, 11:04pm
10
How about changing the posting rules to allow the PE pick revenue account from Customer GL Control instead of product group?