× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




ok, Thanks Much !

From: RMcCracken@xxxxxxxxxxxxxxxxxxxxxxxxxx
To: mapics-l@xxxxxxxxxxxx
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@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.
_______________________________________________
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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.