Please recommend the correct method to configure GL Acct Item Map

[Former Member]

Regarding GL Account determination for item master.

I want to track in my COA by different GL Accts, revenue for the same item but based on where it was sold.

We sell the same ITEM in our ecommerce site, in our bookstore, and in remote locations.

Either I create the SAME item multiple times and map them to coresponding GL Revenue accounts or ....

is there a different way to do this please.

I was thinking of perhaps using account determination per warehouse but I don't think it would work.

Thanks,

[Former Member · Accepted solution]

Mike,

In your case, it is better setup by Warehouse. You only need one Item with different account determination by warehouses.

Thanks,

Gordon

[former_member583013]

Mike,

I am not sure if Warehouse is the right way to it. Are you going to manage the items in 3 seperate warehouses and sell from there. This involves remembering which warehouse to ship from for each of these Customer types.

I believe using Project would be ideal.

I am not sure on what basis Gordon recommended using Warehouses?

Suda

[Former Member]

Suda:

Let me rephrase the question.

The business objective is to track sales from different channels: Ecommerce, Bookstore A, Bookstore B, Direct Sale, etc (Effectively we can think of them like different store fronts or locations).

However the same customer could buy from all different channels.

Customers are classifed per group like MEMBER, NON MEMBER, DISTRIBUTOR

Yet the business objective is to understand:

1. Revenue per channel

2. Revenue by item group

3. Revenue per channel, per item group

4. Revenue per item group, per channel

4. Revenue per customer group

I have started to use PROJECTS but I find them after having a lot of projects, it gets cumbersome.

Thanks for your help.