[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

22.0. "timing of the appix data and pricing table" by ZGOV02::YNTAN (YN TAN @ZGO) Tue Jan 05 1993 04:10

    
    
    Hello,
      Currently I am receiving the daily APPIX feed for the local AMP2
      satellilte file. I notice that sometimes I do not receive the feed.
      My question here is:
       1. When  does the file arrive (which exact days of the weeK) ?
       2. Since changes to std cost occur monthly in month end processing,
          when will these changes be feed to local site ? 
       3. Again changes to MLP  may occur quarterly or mid-quarterly
          according to TPAS Physical Design Document.  
          Does the "First Monday of the first quarter"  mentioned in the
          TPAS Physical Design Document refer to the Monday in USA time.
          If so, we may receive the file late as our new accounting month
          may have already begun since Singapore is 12 hours ahead of USA.
          If MLP occur mid-quarterly, when will the feed be ??
    
       
       4. The TPAS pricing file will be available on the last Wednesday
          of the last fiscal week of the fiscal month. Will all individual
          site be informed when the file is available or will each site
          try to pull the file on that Wednesday ?? 
    
    
    
         P.S. My main concern is the timing of the input files for tpas
              price calculation especially for our case where we create
              our local TPAS pricing table at each month end for use at the
              new accounting month.
    
     Rgds,
       Yan Noi
T.RTitleUserPersonal
Name		DateLines
22.1pick a cost - any cost !!KBOMFG::HENDERSONThu Jan 07 1993 10:1738
    Hi,
    
    Brief intro - I work in Kaufbeuren, Germany as the Finance IM&T
    support.  I have just started into the guts of TPAS this week and so
    far have installed the software and in general started pestering my
    users for answers.   I see by these notes files Josephine and Yn
    appear to be the furthest on, so hopefully I can learn from you.
    (Jo already has been passing some info).  So please bear with me
    if some of these questions are not so clear or in fact a bit 
    wayward.
    
        
    
    APPIX - AMP2
    	Today KBO runs a job daily (noon) which if found will update the AMP2
    	file with the APPIX data.  This input file is sequentially numbered
    	and it is only at the last Saturday of the fiscal month that we
    	really check that all files have been received and loaded.  After
    	closing MAXCIM, the AMP2 file is then fed to MAXCIM INCMS file.
    
    	Q:  Should I continue to update AMP2 daily as per my schedule or
    	    is there an assumption that somehow all sites will update at
    	    the same time?
    
    	Q:  By updating the AMP2 daily, then it is possible to ship the
    	    same part at different times of the same day even, with 
    	    different costs.   Is it correct that ONLY parts whose STD
    	    was 0 will be updated during the month?
            MAXCIM INCMS is not changed during the month except for such
    	    cases or where the STD is totally out of line.
        
        
         Q:  Is there a memo, document detailing the schedules of updates ?
    
    Thanks
    CAthy
22.2MLP/DSPS/APPIX/AMPs update SchedualAWARD::MAGNIIM&T - 223-9837Fri Jan 08 1993 15:0438
NOTE: All times are Eastern Standard Time


                        MLP Adds and Changes to APPIX


DSPS MLP Updates:

        MLP adds can be done anytime, though DSPS tries to batch weekly
        on Mondays. The adds are for those parts that have zero MLP. 

        MLP changes are done quarterly - unless approved for mid-quarter.
        They are done on the 1st Monday of the fiscal month. The changes 
        are for those parts that have a current MLP greater than zero.

        There is an MLP change policy.

        Since DSPS closes on Thursday, any adds/changes that have a Friday or 
        Monday effectivity date are included in Thursday nights's file.

APPIX MLP Updates:

        APPIX receives DSP Files:           Tuesday thru Saturday Morning
        APPIX Updates on:                   Tuesday thru Saturday Evening
        AMPS files arrive in sites:         Wednesday thru Sunday Mornings

       MLP monthly changes:
        As DSPS does the MLP changes on:     1st Fiscal Monday 
        APPIX receives these changes on:     1st Fiscal Tuesday morning 
        APPIX Updated on:                    1st Fiscal Tuesday evening
        AMPS files are received at sites:    1st Fiscal Wednesday morning



Definitions:
        ADDS:     From Zero (0) to greater than zero
        CHANGES:  From greater than zero to something else
        MLP:      Feed obtained from DSPS Organization
22.3STD COST/APPIX/AMPs update schedualAWARD::MAGNIIM&T - 223-9837Fri Jan 08 1993 15:2138
NOTE: All times are Eastern Standard Time


                        STD COST Adds and Changes to APPIX

Standard Cost: 

        Standard Cost adds occur daily to the APPIX database. The adds are for
        those parts that have zero standard cost. 

        Changes to standard cost occur monthly in month end processing. 
        The changes are for those parts that have a current standard cost 
        greater than zero. 

	Changes can only occur to parts that have had a new standard set 
	within 90 days, all other standards are frozen.

APPIX STD COST Updates:

       Std Cost adds:
        APPIX receives Std Cost File:       Monday thru Friday Evening
        APPIX Updates on:                   Monday thru Friday Evening
        AMPS files arrive in sites:         Tuesday thru Saturday Mornings

       STD Cost monthly changes:
        CCA does the STD Cost changes on:    Last Fiscal Friday Evening
        APPIX receives these changes on:     Last Fiscal Friday Evening
        APPIX Updated on:                    Last Fiscal Saturday Morning 
        AMPS files are received at sites:    Last Fiscal Saturday Morning



Definitions:
        ADDS:     From Zero (0) to greater than zero
        CHANGES:  From greater than zero to something else
        STD COST: Feed obtained from Corporate Cost Accounting Organization
22.4TPAS$DB and TPAS$STKRM_DB RBR file AvailabilityAWARD::MAGNIIM&T - 223-9837Fri Jan 08 1993 15:2736
  Currently we have the following schedule for availability of extract files
  for the TPAS Process. There is some flexibility in the availability of the
  stockroom data, please let me know if that schedule is acceptable.



 TPAS$DB - SQL Extract File

      o	LAST FISCAL WEEK (4 or 5) - DAY 3 (Tuesday) - 04:00 EST

	  The APPIX organization will pull the TPAS RBR
	  files from the TAX Organization.

	  The data will be validated. If accurate an extract 
	  is made available to the sites. If errors
	  found a report is sent back to TAX and APPIX organizations
	  will wait to hear from TAX for availability of corrected data. 

      o	LAST FISCAL WEEK (4 or 5) - DAY 4 (Wednesday) - 20:00 EST

	  The latest day/time promised that the TPAS Extract Data
	  will be made available to sites.


 TPAS$STKRM_DB - SQL Extract File

      o	LAST FISCAL WEEK (4 or 5) - DAY 7 (Saturday) - 21:00 EST

	  The APPIX organization will pull the Corporate Cost Accounting
	  Stockroom file. This file will update the APPIX MPF RDB Database.

      o	LAST FISCAL WEEK (4 or 5) - DAY 7 (Saturday) - 24:00 EST

	  The latest day/time promised that the TPAS Stockroom Extract Data
	  will be made available to sites.
22.5More on the TPAS$DB and TPAS$STKRM_DB extractsAWARD::MAGNIIM&T - 223-9837Fri Feb 19 1993 13:4062
 Date:    19-February-1993
 Subject: TPAS DATABASE EXTRACTS - PROCESS and SCHEDULE


  The following is the schedule and the process for availability of the TPAS
  extract files for updating the local TPAS databases, TPAS$DB and
  TPAS$STKRM_DB. There is some flexibility in the availability of the 
  stockroom data, please let me know if that schedule is acceptable.



 TPAS$DB - SQL Extract File

 	Corporate Tax supplies the APPIX organization the data. The APPIX
	Organization validates the data for accuracy then creates an 
	extract file for sites to pull. This data is the PRICING_TABLE,
	DISCOUNT_TABLE and TRNSFR_AREA_TABLE.

	Sites will pull the extract file by executing:
	 TPAS_COPY_MNTHLY.COM
	supplied in the VMS install kit. 

	Once the file is pulled over sites can populate their TPAS$DB using:
	 TPAS_SITE_IMPORT_DB.COM
	also supplied in the VMS install kit.

	Sites are free to modify these command stream to fit their own
	production standards. The timing of these command stream to run is
	also site specific with one exception the extract file for the 
	TPAS$DB will be available after:

      	LAST FISCAL WEEK (4 or 5) - DAY 4 (Wednesday) - 20:00 EST


 TPAS$STKRM_DB - SQL Extract File

 	Corporate Cost Accounting supplies the APPIX organization the
	stockroom data. The APPIX Organization then creates an extract
	file for sites to pull. This data is the STOCKROOM table.

	Sites will pull the extract file by executing:
	 TPAS_COPY_STKRM_MNTHLY.COM
	supplied in the VMS install kit. 

	Once the file is pulled over sites can populate their TPAS$DB using:
	 TPAS_SITE_IMPORT_STKRM_DB.COM
	also supplied in the VMS install kit.

	Sites are free to modify these command streams to fit their own
	production standards. The timing of these command stream to run is
	also site specific with one exception the extract file for the 
	TPAS$STKRM_DB will be available after:

     	LAST FISCAL WEEK (4 or 5) - DAY 7 (Saturday) - 24:00 EST



**** Note that all accounts doing the TPAS_COPY_STKRM_MNTHLY and 
     TPAS_COPY_MNTHLY procedures MUST have proxy access into the
     ACADMY cluster. Instructions for this are given in the installation
     documentation.
22.6What if TRANSFER AREA CODE is used ??ZGOV02::YNTANYN TAN @ZGOSat Feb 20 1993 21:2313
    Lois,
      Just to countercheck with you. ZGO uses transfer area code in the
       call to TPAS to get the transfer price. Is it neccessary to have the
       updated TPAS$STKRM_DB database every monthend ?? If so, 
      I hope that this stockrm database be available on the 
      Wednesday of last fiscal week of the fiscal month (same 
      timing as TPAS$DB).
    
    Tnanks,
     Rgds,
     Yan Noi
22.7No translation needed if using TRNSFR_AREA_CDAWARD::MAGNIIM&T - 223-9837Mon Feb 22 1993 12:5714
Yan Noi,
As Singapore will be using the Transfer_area_code for the Ship_from 
and Ship_to then no translation will have to occur. You will not need the 
TPAS$STKRM_DB updated.

If you do want to copy it - currently the schedule IS Different from the
TPAS$DB update. The sources of the data are different. The stockroom data
we obtain from Corp Cost Accounting and it is available to us on the last
Saturday of the fiscal month.
Whereas the TPAS$DB is from Corp Tax, who make it available earlier for
validation and for sites to be prepared for Transfer Price Differences.

regards,
Lois