| 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 did a little test to see what happens in our application (being DMS)
if TPAS returns a high transfer price.
Here's what I did:
- selected a part (BA32-AB) with a zero MLP and a zero standard cost
in the AMPS file.
- in our local parts file changed the standard cost for BA32-AB to the
highest value possible, being 9999999.99.
- looked for a bill-to code for a customer in Italy. I decided to use
2411.
- first I entered this transaction using the supplied DEMOSITE program
(the output follows after the page-break) to see the output of the
TPAS module.
TPAS returned return status success and a very high transfer price.
Unfortunately the returned transfer price is wrong (the first digit is
missing); apparently an overflow situation occured inside TPAS which
did not result in a failure return status.
Returned transfer price in currency ITL: 4278591427.231
Calculated transfer price:
(STD COST) * (CMM) * (1-DISCOUNT PERCENT) / (XCHNG RATE) =
9999999.99 * 4.00 * (1-.45) / 0.00064180 = 34278591427.236
^
|
this "3" is missing in the
TPAS output
I checked the TPAS audit trail (included after the second page-break)
which showed the same result.
I also ran the DEMOSITE program with the logicals TPAS$DISPLAY_W_ERRORS
and TPAS$DISPLAY_I_ERRORS set to "Y" but the only message shown was
"%APPIX-W-SCMLPFROMLOCAL, STD COST OBTAINED FROM LOCAL FILES".
Does TPAS in its calculations do any overflow checking? If not, could
this somehow be added (preferably we would like to get back a failure
return status indicating that an overflow occured).
Thanks,
Andr�
DEMOSITE program output
=======================
TPAS LOGIC RESULTS DISPLAY
PART NO :BA32-AB PARSED PART NO =
SHIPMENT TYP CD :1
FROM STOCKROOM :610 BILL_FROM TYP CD: S LOCAL STD COST: 9999999.99
TO STOCKROOM :2411 BILL_TO TYP CD: B ORDER MLP : 0
FROM AREA CODE :FGO STD COST TYPE CD: L STD COST : 9999999.989999
TO AREA CODE :ITS PRODT TYPE CODE : OPT CORP. MLP : 0.00
FROM BUSNS TYPE CD:DIS PRICE TYPE CODE : A BASE PRICE : 39999999.960
TO BUSNS TYPE CD :SAL CURRENCY : ITL TRANSFER PRC : 4278591427.231
XCHNG RATE : 0.00064180
CMM :4.00 RBILL TRN PRC($) : 2498859.980
STD_COST UPLIFT : 0.00 RBILL DISC% TO MLP: .00
DISCOUNT PERCENT : .45
NOR DISCOUNT % : .20
RBILL DISCOUNT % : .09
MORE PARTS, PRESS 'Y' OR 'N'
TPAS TRANS STATUS : 000000000
%APPIX-S-NORMAL, NORMAL SUCCESSFUL COMPLETION
WARNING :
Dump of the TPAS audit trail
============================
TPAS_REQUEST_PART : BA32-AB
TPAS_TRANS_SHIP_TO_STKRM : 0002411
TPAS_TRANS_SHIP_TO_TYPE : B
TPAS_TRANS_SHIP_FROM_STKRM : 610
TPAS_TRANS_SHIP_FROM_TYPE : S
TPAS_ORDER_MLP :
0.00
TPAS_LOCAL_STD_COST :
9999999.990000
TPAS_SHIP_TYPE_CD :
1
TPAS_RCV_BASE_PRICE :
39999999.960
TPAS_RCV_TRANSFER_PRICE :
4278591427.231
TPAS_RCV_TRNSFR_PRC_CURNCY_CD : ITL
TPAS_RCV_STD_CST_TYPE_CD : L
TPAS_RCV_TRNSFR_PRC_REBILL :
2498859.980
TPAS_RCV_DSCNT_MLP_RBILL :
0.00
TPAS_RCV_ERROR_MESSAGE : %APPIX-S-NORMAL, normal successful completion
TPAS_RCV_SQLERR :
0
TPAS_RCV_VMS_ERROR :
0
TPAS_RCV_PRICE_TYPE_IND : A
TPAS_RCV_CMM :
4.00
TPAS_RCV_DISCOUNT_PERCENT :
.44
TPAS_RCV_NOR_DSCNT :
.20
TPAS_RCV_STD_COST_UPLIFT :
0.00
TPAS_RCV_RBILL_DSCNT :
.09
TPAS_RCV_FROM_TRNSFR_AREA : FGO
TPAS_RCV_TO_TRNSFR_AREA : ITS
TPAS_RCV_FROM_PLNT_MNEMNC : OR
TPAS_RCV_TO_PLNT_MNEMNC :
TPAS_RCV_SUBSID_BILL_CD_FROM :
TPAS_RCV_SUBSID_BILL_CD_TO : 0002411
TPAS_RCV_BUSNS_FROM_TYPE_CD : DIS
TPAS_RCV_BUSNS_TO_TYPE_CD : SAL
TPAS_RCV_TPAS_PRODT_TYPE_CD : OPT
TPAS_RCV_STD_COST :
9999999.989999
TPAS_RCV_MLP :
0.00
TPAS_RCV_AVG_PRODT_NOR_AMT :
0.00
TPAS_CREATE_DATE : 16-FEB-1995 17:09:54.00
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 71.1 | Expect TPAS V3.2 | AWARD::MAGNI | Lois, 237-5548 | Mon Feb 20 1995 11:14 | 16 |
Andre, I have spoken with Corp Tax on this and although the chances of a transfer price for a product to be greater than 9 billion is rare, they have opted for this to be fixed immediately. I will be releasing TPAS V3.2 with the Transfer Price and Transfer Price to Rebill to be able to 999,999,999,999.99 Beyond this an error message will be returned with NO Transfer Price or Transfer Price to Rebill. Now if we could make a bunch of these sales each month ! I will also be including some of the other SPRs in this release. A full listing will be posted. Regards, Lois | |||||
| 71.2 | ELIS::HOOG | On error then RTFM | Tue Feb 21 1995 04:22 | 25 | |
> I have spoken with Corp Tax on this and although the chances of a transfer
> price for a product to be greater than 9 billion is rare, they have opted
> for this to be fixed immediately.
True, a transfer price greater than 9 billion is rare, but with all
these different local currencies here in Europe you never know what is
going to happen (1558 Italian liras for 1 US$ is a bit excessive, but
who knows what the future will bring (it could get better or worse))!
> I will be releasing TPAS V3.2 with the Transfer Price and Transfer Price
> to Rebill to be able to 999,999,999,999.99 Beyond this an error message
> will be returned with NO Transfer Price or Transfer Price to Rebill.
Thanks, this is the solution we were looking for!
Can you give some indication of when TPAS V3.2 will be released? Our
usertest is due to be started in a couple of days; I guess this new
release will not be available soon enough for us to be able to use it
on the usertest system, but it would be nice if we can use V3.2 in at
least a part of the usertest.
Regards,
Andr�
| |||||