Sales GL Accounts For Customer Groups

Yahoo Archive
1
Thought about it but in E9 still coming up to speed. Any thoughts would be appreciated

--- On Mon, 5/4/09, CharlieSmith <CSmith@...> wrote:

From: CharlieSmith <CSmith@...>
Subject: RE: [Vantage] Sales GL Accounts For Customer Groups
To: vantage@yahoogroups.com
Date: Monday, May 4, 2009, 3:08 PM








What about a posting rule?

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Mark Wagner
Sent: Monday, May 04, 2009 2:29 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Sales GL Accounts For Customer Groups

Epicor 9.

--- On Mon, 5/4/09, CharlieSmith <CSmith@vistaconsult ant.com
<mailto:CSmith% 40vistaconsultan t.com> > wrote:

From: CharlieSmith <CSmith@vistaconsult ant.com
<mailto:CSmith% 40vistaconsultan t.com> >
Subject: RE: [Vantage] Sales GL Accounts For Customer Groups
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Date: Monday, May 4, 2009, 2:18 PM

V8 or V9?

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On
Behalf
Of Mark Wagner
Sent: Monday, May 04, 2009 1:36 PM
To: Vantage User Group
Subject: [Vantage] Sales GL Accounts For Customer Groups

I am looking for a way to direct sales revenues to different GL accounts
based on type of customer. Using Customer Groups and Sales Categories
only allows you to change the department segment value of the account
and not the natural account. Without having to set up a control account
for every customer has anyone else had to deal with this and if so how
did you handle it?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



















[Non-text portions of this message have been removed]
2
I am looking for a way to direct sales revenues to different GL accounts based on type of customer. Using Customer Groups and Sales Categories only allows you to change the department segment value of the account and not the natural account. Without having to set up a control account for every customer has anyone else had to deal with this and if so how did you handle it?




[Non-text portions of this message have been removed]
3
Try using the AR account module which can then be assigned to each
customer.



We've found that the Customer Group is just a good report sorting
feature, but no real GL impact.



Thanks~



Kathleen

360/ 453-3445

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wagner
Sent: Monday, May 04, 2009 10:36 AM
To: Vantage User Group
Subject: [Vantage] Sales GL Accounts For Customer Groups








I am looking for a way to direct sales revenues to different GL accounts
based on type of customer. Using Customer Groups and Sales Categories
only allows you to change the department segment value of the account
and not the natural account. Without having to set up a control account
for every customer has anyone else had to deal with this and if so how
did you handle it?

[Non-text portions of this message have been removed]




NOTICE OF CONFIDENTIALITY: This e-mail message, including attachments, is for the sole use of the intended recipients and may contain confidential and privileged information. If you are not an intended recipient, please contact the sender by reply e-mail and destroy all copies of this message, including attachments. Any unauthorized review, use, disclosure or distribution is prohibited.


[Non-text portions of this message have been removed]
4
I have that situation and I dealt with it outside Vista/Vantage. I download a BAQ with the information including customer groups and sales categories. In Access, I take that data and create a reclassification JE. This JE reverses each item in the GL and puts it into the correct account. For auditability, I reference the original GL entry. The entry is created day by day, so the original entry and its offset both occur on the same day. I have a similar breakout for cost of sales, so those items get entries, too. As you might imagine, this can be a massive JE. So, I also create a download file for each day, and copy/paste them into the journal entry sheet in Vista/Vantage.

There is a lot of work involved Normally, I would be happy to share the work I have done. However, this database is pretty specific to how we do things, and probably would not translate well to others. I can answer any questions you have, though.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Monday, May 04, 2009 10:36 AM
To: Vantage User Group
Subject: [Vantage] Sales GL Accounts For Customer Groups





I am looking for a way to direct sales revenues to different GL accounts based on type of customer. Using Customer Groups and Sales Categories only allows you to change the department segment value of the account and not the natural account. Without having to set up a control account for every customer has anyone else had to deal with this and if so how did you handle it?

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
5
V8 or V9?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wagner
Sent: Monday, May 04, 2009 1:36 PM
To: Vantage User Group
Subject: [Vantage] Sales GL Accounts For Customer Groups








I am looking for a way to direct sales revenues to different GL accounts
based on type of customer. Using Customer Groups and Sales Categories
only allows you to change the department segment value of the account
and not the natural account. Without having to set up a control account
for every customer has anyone else had to deal with this and if so how
did you handle it?

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
6
Epicor 9.

--- On Mon, 5/4/09, CharlieSmith <CSmith@...> wrote:

From: CharlieSmith <CSmith@...>
Subject: RE: [Vantage] Sales GL Accounts For Customer Groups
To: vantage@yahoogroups.com
Date: Monday, May 4, 2009, 2:18 PM








V8 or V9?

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Mark Wagner
Sent: Monday, May 04, 2009 1:36 PM
To: Vantage User Group
Subject: [Vantage] Sales GL Accounts For Customer Groups

I am looking for a way to direct sales revenues to different GL accounts
based on type of customer. Using Customer Groups and Sales Categories
only allows you to change the department segment value of the account
and not the natural account. Without having to set up a control account
for every customer has anyone else had to deal with this and if so how
did you handle it?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



















[Non-text portions of this message have been removed]
7
Yes, I was hoping not to have to set up on each customer. The Sales Category tied to the Customer Group will work, but you must have a Product Group set up as well. When the Customer Group is on the Sales Order, it looks at the Sales Category department segment and then overrides that segment agains the product group GL account. Don't know why they couldnt set it up just to allow different GL accounts against Sales Categories!

--- On Mon, 5/4/09, Kathleen Tyrrell <ktyrrell@...> wrote:

From: Kathleen Tyrrell <ktyrrell@...>
Subject: RE: [Vantage] Sales GL Accounts For Customer Groups
To: vantage@yahoogroups.com
Date: Monday, May 4, 2009, 2:13 PM








Try using the AR account module which can then be assigned to each
customer.

We've found that the Customer Group is just a good report sorting
feature, but no real GL impact.

Thanks~

Kathleen

360/ 453-3445

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Mark Wagner
Sent: Monday, May 04, 2009 10:36 AM
To: Vantage User Group
Subject: [Vantage] Sales GL Accounts For Customer Groups

I am looking for a way to direct sales revenues to different GL accounts
based on type of customer. Using Customer Groups and Sales Categories
only allows you to change the department segment value of the account
and not the natural account. Without having to set up a control account
for every customer has anyone else had to deal with this and if so how
did you handle it?

[Non-text portions of this message have been removed]

NOTICE OF CONFIDENTIALITY: This e-mail message, including attachments, is for the sole use of the intended recipients and may contain confidential and privileged information. If you are not an intended recipient, please contact the sender by reply e-mail and destroy all copies of this message, including attachments. Any unauthorized review, use, disclosure or distribution is prohibited.

[Non-text portions of this message have been removed]



















[Non-text portions of this message have been removed]
8
Thanks for the input. If we need to go outside and come back in to update the data I'll let you know. Which there was an easier way!

--- On Mon, 5/4/09, Thomas Rose <t.rose@...> wrote:

From: Thomas Rose <t.rose@...>
Subject: RE: [Vantage] Sales GL Accounts For Customer Groups
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Date: Monday, May 4, 2009, 2:12 PM








I have that situation and I dealt with it outside Vista/Vantage. I download a BAQ with the information including customer groups and sales categories. In Access, I take that data and create a reclassification JE. This JE reverses each item in the GL and puts it into the correct account. For auditability, I reference the original GL entry. The entry is created day by day, so the original entry and its offset both occur on the same day. I have a similar breakout for cost of sales, so those items get entries, too. As you might imagine, this can be a massive JE. So, I also create a download file for each day, and copy/paste them into the journal entry sheet in Vista/Vantage.

There is a lot of work involved Normally, I would be happy to share the work I have done. However, this database is pretty specific to how we do things, and probably would not translate well to others. I can answer any questions you have, though.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror. com<http://www.electric mirror.com>

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Mark Wagner
Sent: Monday, May 04, 2009 10:36 AM
To: Vantage User Group
Subject: [Vantage] Sales GL Accounts For Customer Groups

I am looking for a way to direct sales revenues to different GL accounts based on type of customer. Using Customer Groups and Sales Categories only allows you to change the department segment value of the account and not the natural account. Without having to set up a control account for every customer has anyone else had to deal with this and if so how did you handle it?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



















[Non-text portions of this message have been removed]
9
What about a posting rule?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wagner
Sent: Monday, May 04, 2009 2:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Sales GL Accounts For Customer Groups








Epicor 9.

--- On Mon, 5/4/09, CharlieSmith <CSmith@...
<mailto:CSmith%40vistaconsultant.com> > wrote:

From: CharlieSmith <CSmith@...
<mailto:CSmith%40vistaconsultant.com> >
Subject: RE: [Vantage] Sales GL Accounts For Customer Groups
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Monday, May 4, 2009, 2:18 PM

V8 or V9?

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of Mark Wagner
Sent: Monday, May 04, 2009 1:36 PM
To: Vantage User Group
Subject: [Vantage] Sales GL Accounts For Customer Groups

I am looking for a way to direct sales revenues to different GL accounts
based on type of customer. Using Customer Groups and Sales Categories
only allows you to change the department segment value of the account
and not the natural account. Without having to set up a control account
for every customer has anyone else had to deal with this and if so how
did you handle it?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]