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

ok, Thanks Much !
 
> From: RMcCracken-yS6WhPn/[email protected]
> To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]
> Date: Tue, 26 Apr 2011 15:49:31 -0500
> Subject: Re: [MAPICS-L] 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-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] 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: [email protected]
> > To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]
> > 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-Zwy7GipZuJhWk0Htik3J/[email protected]
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> > or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
> > 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-Zwy7GipZuJhWk0Htik3J/[email protected]
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
> 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.
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
> 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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.