Landed Cost Rollover

SUNNY

Member
We are facing an issue with the landed cost rule in JDE Procurement.
However, at the time of receipt, there are a few calculations that have to be done after the consignment is received.


Material cost 50
1. Freight 50
2. Excise 16% 16
3. Sales Tax 4% 4.64

If at the time of receipt if the freight amount is changed form 50 to 100 Rs. Then amount of excise duty amount ( which if based on the level cost + freight) is still 16 RS and not ( 50+100) * 0.16 )

System is not calculating as per the changes made in landed cost at the time of receipt.
 
Sunny,

We faced similar issues at one of my client and they were all resolved by some specific ESU (I will tried to find the numbers).

Tell us what is your configuration, that will help !

Christian Audet

Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)
 
Hi Christian,


Thanks A lot for your Reply.

Configuration of the system is as follows

Product : One World XE
Platform : Windows 2000
Database : Oracle 8i
Service Pack : 16.1
Clients On : Windows NT service Pack 6 A

Awaiting for your reply

SUNNY
 
Sorry sunny for the delay,

Can you tell me what is the latest update in your xt4314zn.c file ?

Go to the source folder and open the files, at the top of the file you will see a list of update, what is the latest ?

I'm asking this because we got similar error that were fix only in june and july 2001 so if your source are from february 2001 that can explain !

Christian

Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)
 
Sunny,

can you reply to me in the forum next time, so that everybody will share the question and answer.

here is you last private post :

--- POST BEGIN ------------------------
Hi Christian,

Thanks For the reply.
I have gone through the file. But could not find the information required.
I am sending you the header of the file for youe kind reference.
We have applied 16.1 and planning to apply update 2.
If you got the latest update, kindly let me know me the source (ESU / Service Pack Etc)
Awaiting for your reply
Regards
Sunny

Source File: xt4314zn.c
*
* Description: Voucher Match Source File
*
* History:
* Date Programmer SAR# - Description
* ---------- ---------- -------------------------------------------
*
* Author 12/18/1995 S.Bauer 968601 - Created
*
* -------------------------------------------------------------------
*
* 12/26/1996 S.Kumaran 1415700- Performance
*
* -------------------------------------------------------------------
* 01/24/1997 S.Kumaran 1415718- COGS variance AAI
* 02/03/1997 S.Kumaran 1422037- Voucher Logging
* 02/13/1997 S.Kumaran 1528093- Implementation of new Cache API.
* 04/08/1997 S.Kumaran - Localization Enhancements
* 05/01/1997 S.Kumaran - retrieved P0411 processing options
* 09/15/1997 S.Kumaran 1640618- Progress Payments
* 10/01/1997 S.Kumaran 1640616- Retainage
*
* -------------------------------------------------------------------
*
* 03/04/1998 S.Kumaran 1857962- B732.1 Fixes
* 03/04/1998 J.Haley 1857962- B732.1 Fixes
* 05/11/1998 J.Haley 1765873- Euro Changes
* 07/31/1998 K.White 2041869- Freight Matching
* 08/07/1998 J.Haley 2257811- B73.3 Summary Voucher Match
* 08/07/1998 J.Haley 1763252- B73.3 Voucher Recosting
* 08/07/1998 J.Haley 2293783- B73.3 Cost Managment
* 08/12/1998 J.Haley 2387712- Byte alignment fix
* 08/25/1998 S.Kumaran 2248923- Cannot add a line to a foreign order
* 08/25/1998 S.Kumaran 2249723- Cannot add tax only amount
* i.e. Tax Expl Code VT
* 08/25/1998 S.Kumaran 2347307- Default Retainage % not defaulting down
* to all change orders
* 08/25/1998 S.Kumaran 2194929- Errors matching non stock foreign order.
* 08/25/1998 S.Kumaran 2373960- Delete Voucher - Cost Update.
* 08/26/1998 S.Kumaran 2246549- Tax Y/N field & VAT
* 08/27/1998 S.Kumaran 2266822- Discount Due Date doesn't show
* **NOTE: Enhancement pending from AP
* 08/27/1998 S.Kumaran 2287130- Payment Terms not calculated
* 08/27/1998 S.Kumaran 2347171- Release Retainage Problems
* 10/14/1998 Konrad 2497583- Invoice number 3-way match
* 10/20/1998 Konrad 2173167- V taxes
* 10/24/1998 Konrad 2597736- 2-way match with EURO
* 11/03/1998 Konrad 2620570- Next number by Co/FY
* 12/21/1998 Konrad 2562875- Rebate Taxes
*
*-------------------------------------------------------------------------
*
* 01/07/1999 T.Idler 2733419- Memory leak
* 01/22/1999 S.Kumaran 2749365- Landed Cost lines
* 02/04/1999 Konrad 2790923- Partial Match/Tolerance
* 02/06/1999 Konrad 2841399- Logged voucher JEs
* 02/09/1999 Konrad 2492045- Reverse match with variance
* 02/10/1999 M. Kissel 1765144- Direct Ship Integrity B7.3.3.1 Enh.
* 02/10/1999 M. Kissel 2790721- Correct tolerance checking in 3-way
* 02/25/1999 M. Kissel 2654796- Discount doesn't change
* 03/01/1999 M. Kissel 2854915- Cost Revisions
* 03/01/1999 M. Kissel 2787476- Error in DMAAI 4330
* 03/10/1999 Konrad 2762041- Canadian Non-Recoverable GST
* 03/16/1999 M. Kissel 2802269- BeginDoc return 'D' if curr off
* 03/25/1999 Kristin 2768208- Expense Account symbol
* 04/01/1999 Konrad 2733419- Memory leak
* 04/22/1999 Tebben 3008622- Compile Errors
* 04/22/1999 Konrad 2792187- Diff Batch
* 05/04/1999 Tebben 3071576- Unnecessary Variances Created in F0911
* 05/18/1999 M. Kissel 3095228- Not populating RPRP2
* 06/10/1999 A. Ijaz 2944030- Not populating AC07
* 06/15/1999 A. Ijaz 2795046- Tolerance in Voucher Match
* 06/25/1999 Kristin 3043958- Populate PRDOC in F43121 for EDI
* 06/30/1999 M. Kissel 3183367- UOM Conv. and differing uoms
* 07/26/1999 P. Horton 3228772- Batch total document number incorrect
* 08/04/1999 Tebben 2920628- Don't Pass Subledger for AAI 4320/4355 (RNV)
* 08/04/1999 M. Kissel 3317601- Correct CARDEX Entries
* 09/02/1999 M. Kissel 3377962- Extra order line from Selct Orders form
* 09/09/1999 Kristin 3336491- Handle updating negative qty at match
* 09/09/1999 M. Kissel 3318604- V Tax expl. and Average Cost update
* 09/09/1999 M. Kissel 3396004- Correct fix for SAR 3183367
* 09/14/1999 M. Kissel 3276871- Discount not allowed SAR
* 09/27/1999 Kristin 2921760- Voucher Logging Pay Status
* 10/01/1999 M. Kissel 3414962- Discount applied to 411 not correct
* 10/11/1999 M. Kissel 3466295- Make correct G/L for partial 3-way
* 10/15/1999 M. Kissel 3479037- PO cache key changes
* 10/15/1999 Kristin 3276993- Updating AN06
* 11/05/1999 M. Kissel 3540871- Retainage Errors
* 11/08/1999 M. Kissel 3443190- Partial Close/Remaining
* 11/09/1999 Kristin 3316730- Correct Landed Cost Update on F0911
* 11/10/1999 Kristin 3518761- Correct rounding issue for non-recover GST
* 11/23/1999 M. Song 3502292- Write ITM to GL and summarize GL on items
* 11/24/1999 M. Kissel 3499812- Correct Average Cost Update due to variance
* 12/07/1999 Kristin 3598618- Update VRMK in F43121
* 12/08/1999 Tebben 3623369- Amount written to Vertex Reg. incorrect
* 12/22/1999 M. Song 3566413- Do not write Units into GL.
*
*-------------------------------------------------------------------------
*
* 01/03/2000 M. Song 3441004- Write added subledger and subledger type
* into F0911
* 01/10/2000 M. Song 3534681- Correct error when posting a voucher with
* currency off
* 01/12/2000 M. Kissel 3685893- Corrections to AVCO-replace 3317601
* 01/13/2000 M. Song 3519772- Correct the wrong calculation for exch.
* rate variance and PPV.
* 01/20/2000 R.Ranganathan 3622059- Non-Recoverable tax Error
* 01/20/2000 R.Ranganathan 3683548- Tolerance Error-UnitCost
* 01/21/2000 M. Kissel 3717681- Correct calc of unit cost-replace 3183367
* 01/26/2000 M. Kissel 3730498- Correct landed cost variance
* 02/08/2000 R.Ranganathan 3776437- Flex accounts and multi-line match
* 02/08/2000 R.Ranganathan 3713428- UnitCost Calcualtion Wrong
* 02/23/2000 R.Ranganathan 3782781- Partial 2W Match,Reverse and Tolerance
* 02/24/2000 M. Song 3650367- Not show "Address Number Invalid" error.
* 02/25/2000 M. Song 3814982- Not show "Amount does not balance to gross" error.
* 03/02/2000 R.Ranganathan 3964171- Exch. Rate Variance, Foreign Tax incorrect
* 03/03/2000 J. Torres 3809817- TRDJ shows wrong date in P4111
* 03/14/2000 Tebben 3765050- No Variance Voucher Match - J lnty
* 03/14/2000 Tebben 3727820- Wrong Acct for Exch Variance
* 03/14/2000 Tebben 4022848- Invalid Err for J lnty w/ variance
* 03/14/2000 M. Song 3699321- Validate, negative to positive
* 03/20/2000 R.Ranganathan 3973941- F4314Z Values used before fetch
* 03/31/2000 A. Wolf 4064597- Partial 2 Way Match
* 04/04/2000 A. Jimenez 4045361- Error 0088 with Negative Retainage Amount.
* 04/07/2000 Kristin 4006872- Tax Account Number in F0911
* 04/04/2000 M. Kissel 4089356- Variance in AA not CA
* 04/11/2000 M. Kissel 4036123- Foreign Retainage and 0088 error
* 04/17/2000 A. Jimenez 4093620- Redistribution does not allow PT 'P'
* 04/24/2000 M. Kissel 4119439- Display amount previously retained in a 3-way
* 04/25/2000 Tebben 4053978- Use subledger & sub type if flex acct. on
* 04/25/2000 Sonne 4155317- Display Amt to voucher
* 04/26/2000 M. Kissel 4135711- AOPN is not zero'd w/ opt 7
* 05/02/2000 Sonne 4114902- Invoice number for Argentina
* 05/16/2000 S Buss 4107059- Uniquely name G/L detail cache
* 05/20/2000 M. Kissel 4207957- AA Ledger Out Of Balance
* 05/25/2000 Bingham 4104481- CA Ledger Out Of Balance
* 05/30/2000 A. Kwok 4208837- Zero out discount amount
* 06/02/2000 Bingham 4207527- Purchasing Cost Updated P4314
* 06/06/2000 A. Jimenez 4240976- Gl/Date not shown in Encumbrance Inquiry
* 06/06/2000 A. Jimenez 4192741- Reverse Log Voucher Match - Void
* 06/08/2000 Bingham 4242031- Retainage Amount Taxed Twice
* 06/08/2000 R.Ranganathan 4234251- Partial match of a -ve PO
* 06/14/2000 R.Ranganathan 3737201- Error 0088 on Redistribution
* 06/19/2000 R.Ranganathan 3772559- Recost:08 CostMethod update
* 06/20/2000 R.Ranganathan 4273268- Tolerance on Landed Cost Lines
* 06/16/2000 Bingham 4044342- Error on GST Retention
* 06/26/2000 T. Chan 4206401- Hard error on exchange variance
* 06/27/2000 M. Kissel 4313055- Correct Summarization
* 06/27/2000 M. Kissel 4293082- 2-way foreign 'B' line type
* 06/28/2000 B. Kissler 4285120- Error 2837 and 2691 for two-way tolerance
* 07/07/2000 Hossain 4301126- Check Remark is deleted
* 07/11/2000 R.Ranganathan 4241240- 2-way match and variance
* 07/13/2000 M. Kissel 4364881- Add elements to Edit Line Data Struct
* 07/13/2000 M. Kissel 4366464- Matching Foreign order in Domestic
* 07/13/2000 McGinnis 4288970- P4314 incorrect tax in JE
* 07/13/2000 R.Ranganathan 4356881- 2 Way Partial Match Status
* 07/18/2000 M. Song 4332301- Can`t add line with triangulation currency
* 07/17/2000 Bingham 4187061- Tax Explanation Code - Exempt PO
* 07/24/2000 R.Ranganathan 4396508- 4330 hit with no variance
* 07/26/2000 McGinnis 4391310- P0411- Voucher Match Inconsistent
* 07/31/2000 M Song 4400183- Ave. Cost Uptd with Landed Cost
* 08/01/2000 M. Kissel 4419028- Multi currency logged vouchers
* 08/02/2000 M. Kissel 4371001- Adding multiple lines at VM
*
* Copyright (c) 1994 J.D. Edwards & Company
*
* This unpublished material is proprietary to J.D. Edwards & Company.
* All rights reserved. The methods and techniques de[censored]d herein are
* considered trade secrets and/or confidential. Reproduction or
* distribution, in whole or in part, is forbidden except by express
* written permission of J.D. Edwards & Company.
*
****************************************************************************/
/****************************************************************************
* Notes:
*
****************************************************************************/
--------POST END----------------------


When I look at your file, the last update is 08/02/2000, when I look at my file the last update is 08/10/2001.

Look at the List of update in one year.

---BEGIN MY FILE ---------------------
* 08/01/2000 M. Song 4418973- Currency Date in Processing Options
* 08/08/2000 M. Kissel 4430761- Fetch from cache fails due to logged voucher
* 08/09/2000 R.Ranganathan 4437162- No tolerance error when Exch Rate changes
* 08/11/2000 R.Ranganathan 4455117- A/P account and BU for J lines
* 08/15/2000 M. Kissel 4458318- Payment terms issues
* 08/23/2000 Bingham 4114161- Suspense Redist and CA Ledger
* 09/11/2000 M. Song 4476284- Average cost wrong w/ V+ tax
* 09/11/2000 M. Song 4521815- Amt.doesn't balance to gross
* 09/25/2000 M. Song 4560064- 0088 error when releasing a retainage
* 10/17/2000 R.Ranganathan 4560822- Use correct Subledger values for AAIs
* 10/23/2000 R.Ranganathan 4207551- Redistribute Dom. Voucher to a Foreign PO
* 10/24/2000 S. Vore 4469826- AA ledger OOB and CRYR
* 10/24/2000 R.Ranganathan 4508451- LastChanceVariance - Rounding issues
* 10/19/2000 Courntey 4542579- Performance, fetch array, not record
* 10/31/2000 S. Vore 4582263- Validate the effec. dates for tax by item
* 11/06/2000 Tebben 4546941- Errors with Zero cost and triangulation match
* 11/27/2000 M. Song 4525162- Wrong Purchasing Cost (08 cost) with UOM
* 11/28/2000 R.Ranganathan 4265436- Error matching 3 currencies
* 12/18/2000 McGinnis 4766185- variances on the RNV accunt
* 01/05/2001 R.Ranganathan 4818150- Tolerance Error on Foreign 2-way match
* 01/11/2001 Tebben 4831493- Cache Error w/ Dec. Format Char set to ','
* 01/12/2001 M. Song 4716313- 3-way match, B line, rounding variance account
* 01/22/2001 M. Song 4684964- Voucher/Add J line with VT tax
* 01/23/2001 R.Ranganathan 4658184- Amount to Voucher field blank
* 01/30/2001 Tony Gowan 4844278- To prevent unnecessary rounding on the tax amount
* when changing fields that do not apply to the
* calculation of tax.
*02/06/2001 M. Song 4480638- To update the cardex for the taxes added at Voucher
* Match.
*02/09/2001 Y.Ramirez 4894427- Pay status after reistribute
*02/09/2001 LR5644366 4901666- Left pad Purchase Order w/ zero in F0411
*03/06/2001 AM6935405 4935903- Record Invalid/Retainage
*03/12/2001 EB6834031 4915890- Negative OH VM Incorrect JEs
* 03/19/2001 R.Ranganathan 4465569- Reverse or VM with zero OH(hook up COGS - 3726350)
* 04/11/2001 B. Rak[censored] 5080193- Fix B7332 Build Errors
* 04/16/2001 R. Trinidad 4996239- To correct the CA tax entry for non recoverable VAT expense not to split on 2 lines.
* To get the correct multi-currency conversion amounts
* 04/24/2001 C.R Donepudi 5105629- Vat taxes wrong on Voucher Mat
* 04/25/2001 R. Trinidad 5118024- Fetch Unsuccessful from F0006 in P4314 when Flex Accounting is turn on
* 05/07/2001 C.R Donepudi 5144231 - PO still open after full match
* 06/06/01 B.Rak[censored] 5220820 - To prevent getting Cache error when user is taking
* option 9 to cancel the line.
* 06/08/2001 C.R Donepudi 5077091 - Rounding in voucher match
* 06/12/2001 C.R Donepudi 5149251 - Redistribution & tolerance
* 06/13/2001 MB249201 5121303 - Error 4375, foreign, tolerance
* 06/27/2001 A Mathias 5122947 - Dup of SAR 5116221 - PO Match
* 07/17/2001 J. Tongue 5226851 - Recost of a Foreign 3-way Voucher
* 07/26/2001 S. Yu 5292436 - B Tax Pay Item out of Balance
* 08/06/2001 C.R Donepudi 5337981 - Incorrect Tax Calculation
* 08/10/2001 J. Tongue 5390520 - PSTTax bypassed incorrectly.

---END MY FILE --------------------

Since this is a B733.2 file I cannot be sure of wich ESU for you to applied, but If you look on the knowledge Garden in the "Update Center Home" you will be able to get the latest ESU on XT4314ZN.c. Last time that I got error similar to yours(Landed Cost) was in mai and the fix from JDEdwards are from june and july, since your last update is in august 2000 then you are missing a lot of fix (1 year)!


Christian Audet

Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)
 
Back
Top