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

Jeff,
I think it is standard XA for the RW transaction to calculate the variance for you when a TW is done between warehouses with difference standard costs in their ITEMBL records. The INVTXN file just gets the IW and RW (no TW in INVTXN) with the amounts, including the variance amount, as mentioned by Mike. I suggest you test it out.

Rich

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Snyder
Sent: Tuesday, April 26, 2011 3:23 PM
To: mapics midrange
Subject: Re: [MAPICS-L] 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.

_______________________________________________
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.


CONFIDENTIALITY: This e-mail (including any attachments) is confidential, may contain proprietary information, and may also be legally privileged. If you are not the intended recipient, be advised that you have received this e-mail in error. Any use, disclosure, dissemination, printing or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately contact the sender by return e-mail and then irretrievably delete it from your system.