Re: MAPICS-L Digest, Vol 9, Issue 50 - For Jeff Snyder from Mike Ellis / ISI

Hey Mike,

I highlighted the area of confusion to me in your reply, below.
The only thing I don't get is how you are Crediting the in-transit for 100. (set up a unique intransit WH, 100- STDUC?) I can see how that would work, and then the $85 to destination WH @ their std. (85). But how do you generate the variance?
It appears you are suggesting that if the TW 'from' WH is different from the 'to'' WH with 2 different cost associated, I would get a variance. But the rules are set for the IW and RW, not the TW? Do I need to populate the transaction amount in the IW, (plug in $100) to get the variance to generate?

Thanks for your help. Right now we are just in the investigation stage, but may model a few choice suggestions.

Jeff

Date: Tue, 26 Apr 2011 12:36:11 -0700
From: michael.ellis@xxxxxxxxxxxxxxx
To: mapics-l@xxxxxxxxxxxx
Subject: Re: [MAPICS-L] MAPICS-L Digest, Vol 9, Issue 50 - For Jeff Snyder from Mike Ellis / ISI

Jeff,

I have done this for a customer and can take you through it.
We have the same item in 2 warehouses (1 is Finished Goods, L is secondary
stock inventory).
The standard for warehouse 1 is $100 in UCDEF. STDUC in warehouse L is
$85. (We normally use UCDEF for standard, but in warehouse L we use 85% of
the full standard, to be able to charge a specific account when goods move
into the target warehouse.)
When we do a TW from 1 to L you get:
IW Credit inventory at $100, Debit in-transit clearing account $100
RW Debit inventory at $85 Credit in-transit clearing account $100 Debit
Variance account $25

I'm doing this from memory, but I believe that's how it works for us. If
you need me to flesh it out further, I can get on the system and get you teh
rules we defined in GLI.

Mike
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.