Multiple COS accounts, no product groups or part classes

Yahoo Archive
1
Wow, I feel foolish. I knew I was wording the question bad, but it
was basically "why is my COS option in A/R account maintenance grayed
out?". I feel foolish because I didn't even realize you could change
the Product Group on the SO, I was thinking parts were locked into
whatever they were set at in Part Master. I guess this takes care of
the whole problem (as long as the right A/R & COS accounts hit in the
next test, which I'm guessing they will). I won't even need to worry
about the A/R account maintenance COS setup if the Product Groups will
take care of them.

To answer your question we would just be moving parts between
warehouses, not companies, basically so the stock status report could
be run as a way to see "what leases have been sent out" - leases would
only be moved to the 'leased warehouse' when they were sent out, at $0
charge, and then billed periodically & separately from a customer
shipment/invoice.

As always thanks a ton, I'm finding myself heading here everytime
there's a problem instead of Epicor's support site...

-Z

--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> Hi Zack,
>
> I'm having a hard time understanding what you're trying to
accomplish but I
> wouldn't throw out Product Groups. You can change these on the Sales
Order
> line. The default is the one set on the Part. If we ship a part as a
sample,
> we just change the Product Group on the line and the COGS account
becomes the
> "Sales Sample Expense" account.
>
> Are you really moving things between multiple companies or just
warehouses?
>
> Mark W.
>
2
Hello,

We are still in the process of setting up a second company from
scratch, and slowly getting there. We are working on the A/R side now
and it seems very close to working correctly. Our setup is that we
want 4 categories of sales: General (normal) sales, sample
sales/shipments, leased items, and convention items. We can ignore
the convention (basically samples a salesperson would take to a
trade-show) & leased items for now, and focus on general sales &
samples to keep it simple. To organize this I setup 4 warehouses with
1 bin each (for inventory reporting purposes) and 4 A/R accounts with
their own G/L accounts setup (which works correctly on test invoice
edit lists). The same part can be in the general inventory and also
the sample inventory, which is why we used multiple warehouses to
separate them instead of product groups or part classes (which would
require a slight change in part #). We would use multiple customer
files for the same customer to use the different A/R accounts, for
example Customer1 (sales) & Customer1 (samples) would be two different
customer ids with everything the same except for the A/R account to
use. I realize all of the inventories could be consolidated into just
1 spot and things could be kept track of through sales reports, but
this is how the owner wants it.
The problem I see right now is while i can get multiple A/R & sales
accounts to hit correctly (on an invoice edit list for example), all
sales are going to the same cost of sales account (the COS - GENERAL
account setup in the main control accounts screen). "Inter-Company" &
the COS button are grayed out on the A/R account setup screens, which
I'm guessing is the problem. Do I need to 'turn on' Inter-Company
options, and if I do will this open a whole new can of worms? The
only place any COS accounts are setup at all in the system are the
control accounts in company maintenance, so am I possibly missing
something obvious?
Anyone ever setup a similar system and have any useful tips?

Thanks very much in advance,
Zack
3
Hi Zack,

I'm having a hard time understanding what you're trying to accomplish but I
wouldn't throw out Product Groups. You can change these on the Sales Order
line. The default is the one set on the Part. If we ship a part as a sample,
we just change the Product Group on the line and the COGS account becomes the
"Sales Sample Expense" account.

Are you really moving things between multiple companies or just warehouses?

Mark W.