My Oracle Support Banner

E1: 44H: Substitute Item Takeoffs For Options Incorrectly Generate Error Message H00157 and Display on R44H700 - Lot Start Workfile Generation Report When They Should Not (Doc ID 2778571.1)

Last updated on JUNE 28, 2021

Applies to:

JD Edwards EnterpriseOne Homebuilder - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

The Substitute Item Takeoff is a feature within the P44H602 Takeoff Master that allows users to link different takeoffs to a single quantity. When multiple items or trades utilize the same quantity, this functionality allows them to maintain this quantity in a single takeoff. An issue has been discovered with this functionality where Lot Start Workfile Generation generates an error message for Substitute Item Takeoffs used for options. The Substitute Item Takeoffs (which should be excluded from the R44H700 report output) are being included with error code H00157 - "Posting Code of "L" or Blank Required". However, the account being used by Substitute Item Takeoff has the PEC set to "Blank" in the F0901.

Steps to duplicate:

1.  P44H600 - Item Master Maintenance - Create Substitute Item 551SUBSQFT (no default cost code).  
2.  P44H600 - Item Master Maintenance - Create Contracted Items 551CLN01, 551CLN02, 551CLN03 (Each has different value in default cost code, 4408/4409/4410).   
3.  P0901 - Work with Accounts - Create/Identify accounts for use in this test.  PE, Posting Edit Code is blank on all related accounts.  
    A.  For the Contracted Item Takeoffs – Direct Construction Cost Accounts, the accounts have Cat Code 001 = INT.
    B.  For the Substitute Item Takeoffs – Unit Statistic Account, Cat Code 001 = blank.
4.  P44H401 - Option Master - Create 3 new Options:
    A.  FLP01   $100.00
    B.  FLP02   $200.00
    C.  FLP03   $300.00
5.  P44H602 - Takeoff Master Maintenance - Create Substitute Item Takeoff:  These Takeoffs have the substitute items in the “Item Number” (LITM) field. These takeoffs will hold the takeoff quantity that will be used by the other, contracted takeoffs. These takeoffs are setup with a Unit Statistic F0901 account, rather than a Direct Construction Cost account. These takeoffs will not result in Lot Start Workfile records.  
6.  P44H602 - Takeoff Master Maintenance - Create Contracted Takeoffs:  These Takeoffs have the contracted items. The takeoffs reference the substitute items in the “Sub Item No” (SUBITEM) field in the Takeoff Master. These takeoffs will use the substitute item as the link to the Substitute Item Takeoff from which it will draw the necessary quantities. These records will result in Lot Start Workfile records.  
7.  P44H603 - Material Item Pricing - Add Material Item Pricing for contracted items:  
    A.  551CLN01    Cost Code = 4408
    B.  551CLN02    Cost Code = 4409
    C.  551CLN03    Cost Code = 4410
8.  P44H604 - Supplier Assignment - Add Supplier Assignment for INT, (no trade code on sub TO acct, so no additional Supplier Assignment).
9.  P44H201 - Lot Master -  Configure a Lot Master record with a Plan/Elevation that will use the Substitute Item Takeoff functionality.
10. P44H500 - Sales Workbench -  Ensure that options are selected/added on the Lot prior to running Lot Start Workfile Generation.
11. Run the R44H700 - Lot Start Workfile Generation in proof mode.
    A.  The R44H700 pdf shows the Takeoff for the contracted items as it should.  
    B.  It also shows the substitute item takeoff pulling into the pdf next to each of the contracted item TOs, but it is in error.  
    C.  The error shown each time is: Error number H00157 occurred in: 11010009.9999.99SQFTX Posting code of "L" or Blank required.
12. Run R44H700 - Lot Start Workfile Generation in Final mode.
    A.  The R44H700 pdf shows the Takeoff for the contracted items as it should.  
    B.  It also shows the substitute item takeoff pulling into the pdf next to each of the contracted item TOs, but it is in error.
    C.  The error shown each time is: Error number H00157 occurred in: 11010009.9999.99SQFTX Posting code of "L" or Blank required.
    D.  Review the P44H711 - Lot Start Workfile Review - the contracted item Takeoff data is seen in the workfile as expected.
    E.  The Substitute Item Takeoff is NOT seen in the workfile, this is also correct as it should not show in the workfile.


The contracted item takeoff pulls into the workfile and the substitute item takeoff does not which is correct.  But the substitute item takeoffs should not be shown on the R44H700 report output. If the records are shown on the output, inexperienced users may expect to see the records in the workfile - which is not the intended functionality of substitute item takeoffs.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.