[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference acadmy::tpas_notes

Title:	Transfer Price Administration System
Notice:	Conference has moved to ACADMY::TPAS_NOTES
Moderator:	ACADMY::MAGNI

Created:	Wed Jul 01 1992
Last Modified:	Fri Mar 21 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	102
Total number of notes:	459

60.0. "TPAS price history" by SNOFS1::CHEUNGW (Wilson Cheung) Tue Jan 24 1995 20:10

Hi, this is Wilson Cheung from down under (Sydney).

SPT is in the process of looking into the TPAS II implementation 
approach.  In order to provide revaluation, adjustments, etc., we may 
need to keep track of MTP price history.  We are examining all existing 
transaction systems to see if we can extract historical MTP from the 
local systems.

If the answer to the analysis is negative, we'll have to set up a 
database to store historical MTP.  This database needs to be updated 
every month.  With our data volume and retention period (18 months), 
we'll need to set up a database of around 300K blocks.  Also, it probably 
will take around 57 hours (during fiscal close) to update the latest MTP 
(using PPCS).

I understand TPAS doesn't store price history.  Also, according to 
Eamonn, Canada was once considering similar approach but dropped the 
requirement later.  Hi Canada!  If you are on-line, could you please 
provide me some detail about your decision?  Are there any other 
audiences considering storing MTP history?  If we have sufficient forum, 
it may be more cost efficient (corporate wide) to have it centralised.

Any comments are welcome.


Wilson

T.R	Title	User	Personal Name	Date	Lines
60.1	Canadian Decision on how we use TPAS	TROOA::BCAMERON	Bob Cameron, dtn 631-7431, Tea?	`Tue Jan 31 1995 09:12`	44
	Hello Wilson, Here is an attempt to reply to you're note, re: Canadian decisions. > I understand TPAS doesn't store price history. Also, according to > Eamonn, Canada was once considering similar approach but dropped the > requirement later. Hi Canada! If you are on-line, could you please > provide me some detail about your decision? Are there any other > audiences considering storing MTP history? If we have sufficient forum, > it may be more cost efficient (corporate wide) to have it centralised. We had originally looked at the option of a monthly mass update of transfer prices on our current price file, from TPAS. Currently, transfer price is a field calculated monthly on our price file, based on MLP. As a given process needs a transfer price, we would extract the value from our price file. A monthly update of our price files transfer pricing from TPAS, would fit in well with our existing systems. As you note however, this type of update would also be about 50 HRs processing each month-end. What we found though, was that over the course of a given month, the number of transactions requiring a transfer price, was much less than attempting to revalue our entire price file, and the transactions would be spread out through the month (with the exception of inventory). So, we opted to call TPAS as needed, instead of a mass price file update. I could forward you a feasibility study performed here if you would like additional details. Note, retaining historical transfer price has not been an issue in the study or with subsequent analysis. It is true, that we loose a current capability of previous 2 months transfer price values, which we now maintained on our price file. This is somewhat compensated for, by the fact that our inventory files are accumulated in YTD on our Data Warehouse. At this point, It does not appear to be a requirement to maintain history beyond the warehouse inventory file. Not sure whether this helps you, but that's the approach we are looking at using. Thanks, Bob Cameron Canadian/IM&T/Finance
60.2	Great help - Canada	SNOFS1::CHEUNGW	Wilson Cheung	`Sun Feb 05 1995 18:39`	15
	Hi Bob, Thank you for your helpful reply. Your situation of getting the appropriate pricing details from data warehouse seems to be a similar scenario for us too. We may have to modify it to extend a few more details though. Regards, Wilson SPT IM&T PS: I don't mind having your feasibility study report. There may be additional information that may help us finalising the detail. Thank.