| 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 |
We have changed our application (called DMS) to use the new TPAS II V3
software without actually using the new functionalities in this new
TPAS version (DMS is being upgraded at this moment to also use the new
functionalities). I did a number of tests to see if DMS is still
returning the same transfer pricess and noticed a number of differences
between TPAS I V2 and TPAS II V3. Could someone explain these
differences?
Note: here are the relevant logicals which show how we use TPAS:
"TPAS$AMPS_AVAILABLE" = "N"
"TPAS$BILL_FROM_TYPE_CD" = "S"
"TPAS$BILL_TO_TYPE_CD" = "S"
"TPAS$CREATE_AUDIT_TRAIL" = "Y"
"TPAS$CREATE_STDCST_TRAIL" = "Y"
"TPAS$DISPLAY_I_ERRORS" = "Y"
"TPAS$DISPLAY_W_ERRORS" = "Y"
"TPAS$SEND_LOCAL_STD" = "N"
"TPAS$SEPARATE_OPEN" = "Y"
"TPAS$USE_AMPS" = "Y"
Note: for this test we wrote some SQL to build the TPAS I V2 databases
based on the (test) TPAS II V3 databases. By doing this we expect
both TPAS versions to return the same output when called with the
same input values. The tests have shown that both TPAS versions
always returned the same data except for one specific case (see
2) furtheron).
1) when local standard cost is used, TPAS I V2 sends out a mail
message; TPAS II V3 does NOT send a mail message.
2) the following transaction results in TPAS II V3 in an error but in
TPAS I V2 in success (although a zero transfer price is returned):
stockroom from : 610
stockroom to : 610
part number : 11/73-UH
-AMPS MLP : 0.00
-AMPS standard cost : 0.00
-local standard cost: 0.00
Results in TPAS I V2:
Return status : %APPIX-S-NORMAL, normal successful completion
Prodt type code : OPT
MLP cal. factor : 1.00
Price type code : F
STD cost : .000000
MLP : .00
Base price : .000
Discount percent: .00
STD uplift : .00
STD cost type cd: L(ocal)
Transfer price : .000
Results in TPAS II V3:
Return status : %APPIX-F-NOSCONLOCAL, NO STD COST Found from
TPAS_GET_LOCAL_COST FILE
Prodt type code : OPT
MLP cal. factor : 0.00
Price type code :
Local STD cost :
STD cost : 0.000000
Corp. MLP : 0.00
Base price : 0.000
Discount percent: .00
STD uplift : 0.00
STD cost type cd: L(ocal)
Transfer price : 0.000
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 59.1 | Can't re-produce - will look into it further | AWARD::MAGNI | Lois, 237-5548 | Mon Jan 23 1995 16:16 | 17 |
Andre, I am have not been able to re-produce your error (item 2). I have sent it to the other programmer to see if he can re-produce it. As for the mails. The TPAS_PART.DIS is empty, as Corporate Cost Accounting did not want to track the parts with zero std cost. Is this what you mean by no mails ? You can edit that distribution list, supplying whomever in you facility is interested in this. The mail goes through here no matter is the local standard is zero or not. It even goes through when it can't calculate the transfer price because the transfer_area_to <> transfer_area_from I will get back when letting you kbnow if I can or cannot reproduce the error. Lois | |||||
| 59.2 | TPAS demosite output | ELIS::HOOG | On error then RTFM | Tue Jan 24 1995 03:48 | 78 |
Lois,
Thank you for your quick response!
You are absolutely right about the mails! After we had put something in
the distribution list, TPAS II V3 did indeed send out mail, just like
TPAS I V2 was doing.
About the zero transfer price problem/difference: I ran these
transactions through your TPAS demo programs and captured the screens
(which follow after the page-break). Maybe this will help you
reproducing the problem/situation.
Regards,
Andr�
TPAS I V2 demosit program output:
=================================
TPAS LOGIC RESULTS DISPLAY
PART NO : -11/73-UH
PARSED PART NO =
FROM STOCKROOM :610 STD COST = .000000
TO STOCKROOM :610 MLP = .00
FROM AREA CODE :FGO PRODT TYPE CODE = OPT
TO AREA CODE :FGO CMM 1.00
FROM BUSNS TYPE CD:TBD
TO BUSNS TYPE CD :TBD
PRICE TYPE CODE :F
BASE PRICE : .000
DISCOUNT PERCENT :.00
STD_COST UPLIFT : .00 TPAS_STD_CST_TYPE_CD: L
TRANSFER PRICE : .000 MORE PARTS, PRESS 'Y' OR 'N'
TPAS TRANS STATUS :
%APPIX-S-NORMAL, normal successful completion
WARNING :
%APPIX-I-INTERPLANTSHIP, Successful INTERPLANT TRANSFER PRICING at STD COST
TPAS II V3 demosit program output:
==================================
TPAS LOGIC RESULTS DISPLAY
PART NO : -11/73-UH PARSED PART NO =
SHIPMENT TYP CD :1
FROM STOCKROOM :610 BILL_FROM TYP CD: LOCAL STD COST:
TO STOCKROOM :610 BILL_TO TYP CD: ORDER MLP :
FROM AREA CODE :FGO STD COST TYPE CD: L STD COST : 0.000000
TO AREA CODE :FGO PRODT TYPE CODE : OPT CORP. MLP : 0.00
FROM BUSNS TYPE CD:DIS PRICE TYPE CODE : BASE PRICE : 0.000
TO BUSNS TYPE CD :DIS CURRENCY : USD TRANSFER PRC : 0.000
XCHNG RATE : 0.00000000
CMM :0.00 RBILL TRN PRC($) : 0.000
STD_COST UPLIFT : 0.00 RBILL DISC% TO MLP: 0.00
DISCOUNT PERCENT : .00
NOR DISCOUNT % : .00
RBILL DISCOUNT % : .00
MORE PARTS, PRESS 'Y' OR 'N'
TPAS TRANS STATUS : 000000000
%APPIX-F-NOSCONLOCAL, NO STD COST Found from TPAS_GET_LOCAL_COST FILE
WARNING :
| |||||
| 59.3 | bug introduced with v3.0 | AWARD::MAGNI | Lois, 237-5548 | Fri Jan 27 1995 14:23 | 9 |
Andre, I have solved your problem. With the introduction of sending in the standard cost, a switch was not being checked. I have fixed and tested it. I am packaging the fix into V3.1 - which is going out today to everyone who has v3.0. Lois | |||||
| 59.4 | ELIS::HOOG | On error then RTFM | Mon Jan 30 1995 04:24 | 7 | |
Lois, Thank you for the fix. I will try to install the new kit ASAP and retest this problem. Andr� | |||||