How to Debug Flex Accounting issue in Sales Update

Purpose of Document

This troubleshooting document is provided to assist in debugging a specific issue. When possible, diagnostic tools are included in the document to assist in troubleshooting. This document is to explain how Flex Accounting takes effects (Technical) with detailed routines in it. Though this document is written based on Sales Update (R42800) it can be applied to any other Flex Accounting routine if needed.

Prerequisite

<Document 625475.1> - E1: 40: Automatic Accounting Instructions for Distribution (AAI / DMAAI)
<Document 756543.1> - E1: 42: P40296: Flexible Accounting for Distribution (R42800/P4112/P4113/P4114/P4312/P4314)
<Document 625421.1> - E1: 42: R42800: Sales Update

This note presume that you are familiar with what is Automatic Accounting Instruction (AAI) and business functions and it's debugging.

Related objects and Call Stack:

To deal with Flex Accounting, a number of objects are related with as below,

R42800 - Sales Update: So long as cGLInterface flag (F40205.GLI) from line type based on Sales Order Detail Line (F4211) or it's summary

(Initialize/store Flex Sales Accounting Cache - Sales Order Specific)
    1. B4201150 - ProcessFlexSalesAcctngCache (cAction = 2 - Add cache): If the sales flex accounting processing option is ON, write an empty record to the sales flex accounting cache. The cache will be keyed by sales update job number.
    1. B4201150 - ProcessFlexSalesAcctngCache (Ref #1) (cAction = 3 - Update cache): This function is to update empty cache created above to use during Building up Flex Account

(Get/build account store it into cache)
    1. B4200520 - GetSalesAAIsAndCallF0911EditLine: This function sets AAI Number and calling RetrieveDistributionAAICacheDB (if no error then) F0911FSEditLine. This function will load F0911 fields, retrieve the AAI for each journal entry required for a sales order, call Tax Calculator, and call the F0911 Edit Line to write the journal entries.
        2. B4204190 - RetrieveDistributionAAICacheDB: (Ref #2) This function is responsible to return Account Information (account number and MCU.OBJ.SUB set)
            3. B4000351 - RetrieveDistAAIwF4095Cache: This function gets Account Information based on setup made in F4095 either by DB or by Cache
                4. B4000352 - RetrieveF4095Cache: To deal with Flex Accounting this function handled AAI information returned by RetrieveDistAAIwF4095Cache
                4. N4002371 - BuildFlexibleAccountwithCache: Check whether to override Flex Account information as defined from F4096 and stored it into Cache
                    5. B4000341 - RetrieveF4096Cache: This function is to validate flex account and if any, it replaces Account  Information constructed by RetrieveDistAAIwF4095Cache
                    5. B4201150 - ProcessFlexSalesAcctngCache: (refer Ref #1) Validate/replace cache with components of Account Information
                    5. B4002420 - GetTableColValue: (Optional) This function validates setup made in F4096
            3. XX0901 - ValidateAccountNumber: This function validate Account Information which is returned by RetrieveDistAAIwF4095Cache
        2. B0900049 - F0911FSEditLine: This Master Business Function defaults/validates account information and makes use of Account Information returned by RetrieveDistributionAAICacheDB

(Terminate Cache)
    1. B4204190 - ProcessDistributionAAICache (Refer Ref #2) (After all the GL transactions have performed this function is to be called to terminate all the cached used during process with Cache Action 8 to Terminate all the caches)
        2. B4000352 - RetrieveF4095Cache (To terminate cache with Cache Action Code 8)
        2. B4000341 - RetrieveF4096Cache (To terminate cache with Cache Action Code 8)
          (Same routine will be repeating whenever one GL transaction takes place)

Cache Action in Flex Accounting Routine:

Note that below Cache Action Code is used during Flex Account transaction however this action code can be used for different purpose in different business functions. Most commonly cache action takes places as below sequence,

1. Cache Get (or Cache Fetch Next): No cache -> Error
2. (Read related tables F4095/F4096)
3. Cache Add: To store data which is retrieved by 2
4. Cache Get (Cache Fetch Next): To verify cache is added properly
5. Make use of cache during transaction
6. (At the end of transaction) Cache Terminate All: To release memory used during transaction

DMAAI set by GetSalesAAIsAndCallF0911EditLine

Below DMAAI is hard coded in B4200520 and each AAI can be called conditionally. For example, in most common transaction 4230, (4270, 4280), 4220 and 4240 will be called.
Sequence of validation/assignment:

1. 4245 -   Account Receivable Trade (SOR)
2. 4230 -   Revenue (SOS)
3. 4233 - Allocated Revenue
4. 4270  -  Price Adjustment
5. 4280 -   Rebate Payable
6. 4250 -   Tax Liability (SOT)
7. 4231 -   Deferred Revenue
8. 4232 -   Unbilled A/R
9. 4281 -   Temperature Gain/Loss Offset
10. 4282 -  Temperature Gain/Loss
11. 4220 -  Cost of Goods Sold (SOC)
12. 4240/4241 -   Inventory/Inventory in Transit (ST Batch)
13. 4242 - Accommodations
14. 4240 -   Inventory (SOI)
15. 4221 -  Defferred Cost of Goods Sold
16. 4223 - Deferred COGS - Accomodations
17. 4260 -   Inter Branch Revenue
18. 4240 -   Inventory (interbranch to offset)
19. 4242 - Accomodations (interbranch order to offset)
20. 4240 -   Inventory (interbranch order to offset)
21. 4141 -   Inventory or Expense/COGS
22. 4220 -   Cost of Goods Sold
23. 4240 -   Inventory
24. 4250 -   Tax Liability

Note: Description is coming from F4090 (Distribution/Manufacturing - AAI Record Type)


To have better understanding in GL transaction during Sales Update, possibly some of business function listed above can be written in detail as below: In EntepriseOne to minimize Global or Static variable, each business function contains complete sets of parameters which are required within a routine.

Information on Business Functions related

B4200520 - GetSalesAAIsAndCallF0911EditLine (Sales Update, Get AAIs and Edit F0911 Entries)

• Purpose: This function will load F0911 fields, retrieve the AAI (through B4204190 - RetrieveDistributionAAICacheDB) for each journal entry required for a sales order, call Tax Calculator (through B4001090 - TaxCalculator), and call the F0911 Edit Line (through B0900049 - F0911FSEditLine) to write the journal entries based on Account ID retrieved/constructed by B4204190.
• Parameters:
• Data Structure: D4200520 - GetSalesAAIsAndCallF0911EditLine, which contains possible variable in calling B0900049 - F0911FSEditLine (F0911 Edit Line) and B4204190 - RetrieveDistributionAAICacheDB (Retrieve Distribution AAI From Cache or DB)
• Detail Routine: As purpose of this function reads this function has to be called through R42800 (Sales Update) per lines to handle (or per summarized on when summarize GL option is ON through Processing Option). The primary purpose of this function is to hand over Sales Order information to inner business function to be called.

Reference: <Document 1307156.1> - E1: 40: How F0911.GLU (Units) Gets Written in Distribution

B4204190 - RetrieveDistributionAAICacheDB (Retrieve Distribution AAI From Cache or DB)

• Purpose: This function is to retrieve account ID or account information which is to be used in calling F0911FSEditLine (B0900049) which create G/L Cache which is to be consumed through F0911FSEndDoc. Regardless Flex account setup and parameter it gets MCU (Business Unit), OBJ (Object Account) and SUB (Subsidiary) based on setting made in DMAAI Table F4095 (Distribution/Manufacturing - AAI Values). In case Flex Accounting is activated MCU and/or SUB can be replaced by Flex Account setup which is recorded in F4096 (Sales Flex Accounting)
• Parameters:
• Data Structure: D4204190A - Retrieve distribution AAI Cache or DB

• Detail Routine:
• As the function name implies currently table F4095 (Distribution/Manufacturing - AAI Values) is defined in P98613 (Database Caching) so when database cache contains data DMAAI information is to be coming from Cache otherwise it will read a physical file to get information. Refer Database Caching for Detail
• If cSalesFlexAccountingFlag is not 1 (that is, not flex accounting) this routine calls ProcessDistributionAAICache with szCacheActionCode "1" to create a new cache using Cache Name for this function is D4204190B (not D4204190A).
• Either flex accouting is ON (cSalesFlexAccountingFlag = "1") or DMAAI is not found from cache then business function "RetrieveDistAAIwF4095Cache"
• If no Errors in the AAI retreival, Fetch the Account ID and Account Unit of Measure
• If Cost Center is not defined in AAI, system uses Revenue Branch Plant
• If the Account Id is blank in cache or a physical file, then no such account exists - Set Error because F0901 is a member of P98613
• But still it calls SimpleAccountConcatenation to return szAccountNumberInputMode which is MCU.OBJ.SUB
• If it is not flex account then call bsfn ProcessDistributionAAICache with szCacheActionCode = "2" and mnNumberOfKeys = "7"
• Error Codes:
• 043C - Account Number &1 is Invalid. &1 is szAccountNumberInputMode. This error comes when it fails to find Account ID from Account Mater Cache based on MCU, OBJ and SUB combination
• 078L - Initialization of cache &1 failed. 
• CAUSE . . . .  Cache &1 may not be able to be initialized because of an invalid user handle or not enough memory allocated to hold
                 JDECACHE structures.
  RESOLUTION. .  Verify that a valid user handle is being passed back from JDB_InitBhvr and that you have enough memory allocated.  Check the JDE.LOG and JDEDEBUG.LOG for additional information.
• Technical review: Error will come when jdeCacheInit () fails that is Cache Name (D4204190B + JobNumber) is not initialized.
• 032E - Error Processing Cache. 
• CAUSE . . . An error has occurred while processing cache in this application.
  RESOLUTION.  See your system administrator.

B4000351 - RetrieveDistAAIwF4095Cache (Retrieve Dis AAI w F4095 Cache)

• Purpose: Retrieve the correct account number based on AAI information from AAI Table (F4095). If no record found in AAI Table, Check for "****" in G/L Category and/or "00000" in Company or changed Table Number to "3280" and repeat the search.

• Parameters:
• Data Structure: D4000351 - Retrieve Distribution AAI w/ F4095 Cache

• Detail Routine:
• Through this function AAI Tables 3270, 3260, 3240, 3220, 4122, 4220, 4240, 4310, 4134, 4136, 4122, 4124, 4220, 4240, 4310, 3270, 3260, 3240, 3220, 4122, 4124, 4220, 4240, 4310, 4134, 4136 can be validated. AAI Table 4122, 4124, 4220, 4240, 4310, 4134 and 4136 are meant for Detailed Product Costing
• If Branch/Plant is blank and Cost Center is not blank, then fetch Cost Center Master (F0006).
• If Project Number is not blank, then load into Branch/Plant, otherwise load Cost Center to Branch/Plant. Use Branch/Plant as the key to fetch Cost Center Master (F0006) and retrieve Cost Center, Object and Subsidiary and retrieve Company Number through Validate Account Number Business Function. 
• If the AAI is set to do ProjectAccounting and if F4095 Subsidiary is blank and the passed in Subsidiary is blank, assign the passed in ProjectSubsidiary if not blank. Also, stor the value in F4095 Colums.mlsub so that the Subsidiary is not flexed.
• For Cost Management, open the Cost Management Constants File (F1609) and read the CO01 - Activate Cost Objects flag. If it is "On", then set the cCMSFlag "On"
• Flex accouting routine takes place (when any of below 3 conditions meet)
• F4095.MCU is Blank (then) Build Business Unit
• OR F4095.SUB is blank (then) Build Subsidiary
• OR input parameter szSubledger is blank or cSubledgerType is blank (then) Build Subledger
• For Cost Management, pass Item Number and Managerial information back only if flex accounting is ON and Activate cost object flag is ON
• If the Sub account for the record is blank and if the sub account returned from the "Build Flexible Account" function is not blank, use the sub account from the Build flexible account
• Use AAI's or Flexible Account's Subsidiary as default only when passed in Subsidiary is blank
• If the subledger and subledger type parameters returned from the "Build Flexible Account" function are not blank use them
• After 1st trial call same function again through calling routine RetrieveDistAAIwF4095Cache (B4000351) table F4095 is to be accessed (because there is no cache to get/read)
• The sequence of reading F4095 is the most specific to the most generic (which reads cache first if it is not found then read a physical file F4096),
• 1. A Specific Company and a specific GL Category Code
• SELECT  *  FROM PRODDTA.F4095  WHERE  MLANUM = 4220.000000 AND MLCO = '00001' AND MLDCTO = '  ' AND MLDCT = 'SO' AND MLGLPT = 'IN30' AND MLCOST = ' '
• No More Data found
• 2. (if no record then) A specific Company and any GL Category Code "****"
• SELECT  *  FROM PRODDTA.F4095  WHERE  MLANUM = 4220.000000 AND MLCO = '00001' AND MLDCTO = '  ' AND MLDCT = 'SO' AND MLGLPT = '****' AND MLCOST = ' ' 
• No More Data found
• 3. (if no record then) A Default Company (00000) and a specific GL Category Code
• SELECT  *  FROM PRODDTA.F4095  WHERE  MLANUM = 4220.000000 AND MLCO = '00000' AND MLDCTO = '  ' AND MLDCT = 'SO' AND MLGLPT = 'IN30' AND MLCOST = ' ' 
• No More Data found
• 4. (if no record then) A Default Company (00000) and any GL Category Code "****"
• SELECT  *  FROM PRODDTA.F4095  WHERE  MLANUM = 4220.000000 AND MLCO = '00000' AND MLDCTO = '  ' AND MLDCT = 'SO' AND MLGLPT = '****' AND MLCOST = ' ' 
• Fetched the record
• 5. If no record till 4th routine, set error '078D', '029P' or '029Q'
• Error codes:
• 078D - Open for table &1 failed. &1 is F0006. Review jde.log which shall contain ODBC level error.
• CAUSE . . . .  Table &1 could not be opened.  The table may not exist in your environment or you may not have authority to open it.
  RESOLUTION. .  Add the table to your environment and verify that you have proper authority.  You may also check the JDE.LOG and JDEDEBUG.LOG for additional information.
• Technical review: This error is coming from middle-ware layer so review jde.log for further detail.
• 029P -Distribution AAI Number &1 Invalid
• CAUSE : The Automatic Accounting Instruction (AAI) number &1 used by this application is not defined in the Distribution/Manufacturing AAI table.
• RESOLUTION : Review the AAI that is not set up correctly using the Distribution/Manufacturing AAI maintenance application and set up or modify the required data. Check the information for Company &3 , Order Type &4 and GL Class code &5 .
• Technical review: (&1 = mnAAITableNumber, &3 = szCompanyNumber, &4 = szDocumentType, &5 = szGLCategory)
• 029Q - Account &1 in AAI Table &2 invalid.
• CAUSE : The Account Number &1 referenced by Distribution AAI Number &2 is invalid.  Either this account does not exist or has a posting edit code that does not allow manual journal entries.
• RESOLUTION : Check the Account Number to verify that it exists and has a valid posting endit code for data entry.  Change the Distribution AAI to reference a valid account or add the missing account in the General Ledger system.
• Technical review: (&1 = szAccountNum, &2 = mnAAITableNumber)

B4000352 - RetrieveF4095Cache (Retrieve F4095 Cache)

• Purpose: This function is to retrieve cache. When it gets called first time it has to fail because there is no specific transaction cache (B4000352+JobNumber) when it tries to fetch cache. So only when the first call fails it reads F4095 to retrieve and store it into cache
• Parameters:
• Data Structure: D4000352 - Retrieve F4095 Cache

• Detail Routine:
• Initialize Cache using B4000352 + (Input mnJobNumber)
• Cache is made up of mnAaiTableNumber, szOrderType, szDocumentType, szCompany, szGlCategory and szCostType
• After 1st trial call same function again through calling routine RetrieveDistAAIwF4095Cache (B4000351) table F4095 is to be accessed (because there is no cache to get/read)
• The squence of reading F4095 is the most specific to the most generic (which reads cache first if it is not found then read a physical file F4096. Refer above section to get example of actual query issued),
• 1. A Specific Company and a specific GL Category Code
• 2. (if no record then) A specific Company and any GL Category Code "****"
• 3. (if no record then) A Default Company (00000) and a specific GL Category Code
• 4. (if no record then) A Default Company (00000) and any GL Category Code "****"
• 5. If no record till 4th routine, set error '078D', '029P' or '029Q'
• At once F4095 contains data, RetrieveDistributionAAICacheDB is calling this routine (RetrieveF4095Cache) again with szCacheActionCode = "2" to Add this information into Cache (B4000352+JobNumber) based on above key columns
• Error codes:
• 078L - Initialization of cache &1 failed (jdeCacheInit() is failed)
• CAUSE . . . .  Cache &1 may not be able to be initialized because of an invalid user handle or not enough memory allocated to hold JDECACHE structures.
• RESOLUTION. .  Verify that a valid user handle is being passed back from JDB_InitBhvr and that you have enough memory allocated.  Check the JDE.LOG and JDEDEBUG.LOG for additional information.
• Technical review: (&1 = B4000352 + JobNumber)
• 032E - Error Processing Cache. szCacheActionCode is wrong. szCacheActionCode is not IN 1, 2, 9 or 8.
• 078N - jdeCacheOpenCursor () is SUCCESS but jdeCacheFetchPosition () did not return any cache
• Fetch from cache &1 failed
• CAUSE . . . .  A record does not exist in cache &1 matching the key passed in for the fetch.
• RESOLUTION. .  Verify the key being passed into the fetch is correct and that a record exists in the cache matching that key.  Check the JDE.LOG and JDEDEBUG.LOG for additional information.
• 078M - jdeCacheOpenCursor () is FAILED
• Open Cursor for cache &1 failed
• CAUSE . . . .  A cursor was not able to be opened because the Cache Init was not successful or cache &1 was empty.
• RESOLUTION. .  Verify that the Cache Init was successful and that records exist in your cache prior to the Open Cursor.  Check the JDE.LOG and JDEDEBUG.LOG for additional information.

• Example of logs:

Entering jdeCacheInit                     Name:[B40003521197940]
   Found existing cache, total references:[5]
   hCache:[0A4A1CC0] Nm:[0B40003521197940] Recs:2 Curs:0 Hnds:5 Cchs:14 INIT exist
Entering jdeCacheOpenCursor (Called by: b4000352.c line 263)
   Open Cursor Success                     hCursor:[09310268] hCache:[0A4A1CC0]
    hCache:[0A4A1CC0] Nm:[0B40003521197940] Recs:2 Curs:1 Hnds:5 Cchs:14 CURS open
Entering jdeCacheFetchPosition                     hCursor:[09310268]
Entering jdeCacheCloseCursor                     hCursor:[09310268] hCache:[0A4A1CC0]
   hCache:[0A4A1CC0] Nm:[0B40003521197940] Recs:2 Curs:0 Hnds:5 Cchs:14 CURS close

N4002371 - BuildFlexibleAccountwithCache (Build Flexible Account with Cache)

• Purpose: This function is to build and return flex accouting based on setup made. Since this function is subset of RetrieveDistAAIwF4095Cache, which has to be understood in a context. Note that if F1690 (Enables Tables by Application) is empty it exit from routine so it is important to have valid setup.
• Parameters:
• Data Structure: D4002371A - Build Flexible Account with Cache

• Detail Routine:
• Get the CMS Cost Object Population Method for the Application Group of the calling program
• For this routine requested data from WHERE (F1690.CKEAP = 'R42800' AND F1690.CKFILE = ' ' AND F1690.CKCMTF = 'SM') to get F1690.CKCO02 which is to be used in calling BSFN B4000341 - RetrieveF4096Cache (Retrieve F4096 Cache)
• UDC (16/TF) - Cost Management Method

• Codes	Description 01	Hard Coded
  CF	Configurator	Y
  DC	Driver Calculation	Y
  FA	Flex Accouting	Y
  OT	Cost Object Type	Y
  RF	Related File	Y
  SM	Rule Setup Method	Y

• Table F1690 is a member of F986113 (Database Caching) so reset database cache will reflect the change made
• In case F1690 (Enables Tables by Application) does not have any data this function stop processing without issuing any error. So make it sure that all the setup is done properly before debug any Flex Account related issue (to get F1690.CO2 and application P1691 allows you to access data)
• CO02 has to be a member of UDC 16/SM - Cost Object Rules Setup Method

• Codes	Description 01	Hard Coded
  	Blank	Y
  A	AAI Number method	Y
  C	Combination of methods	Y
  N	No Flex Accouting is used	Y
  O	Object Account method	Y

• In calling B4000341 iCacheActionCode can be handled as below,
• 1 - Cache Get
• 2 - Cache Add
• 3 - Cache Get Next
• 9 - Close Cursor
• 8 - Cache Terminate All
• So N4002371 is calling B4000341 for the first time either iCacheActionCode 1 or 3 it has to fail (because cache is not created yet) which returns error code '078N'
• Then reads F4096 to get Flex Accounting Information.
• Do a SELECT on the F4096 file, ensuring that there is at least one match.
• The F4096 file rules can be entered with a combination of specific & generic key values. Therefore, there are a variety of possible combinations (aside from whether the Cost Object Population Method is "AAI", "Object Account" or Combined). The variations are:
• Cost Object Population Method
• Case (Specific Price Adjustment Type where F1690.CO02 (IN 'O - Object Account Method', 'C - Combination of methods')
• 1. Specific Document Type & Company
• 2. Blank Document Type & Company
• 3. Specific Document Type & Company '00000'
• 4. Blank Document Type & Company '00000'
• Case (Blank Price Adjustment Type (if one was present originally))
• 1. Specific Document Type & Company
• 2. Blank Document Type & Company
• 3. Specific Document Type & Company '00000'
• 4. Blank Document Type & Company '00000'
• The purpose of reading F4096 is to get below columns from F4096, which determines how to Build Flex Account
• @RT (Record Type - CC/SUB/SBL Flex Format)
• SBLT (Subledger Type)
• SFIT (Data Item) * Column Name
• SFDT (Data Type)
• ABT1 (Managerial Analysis Type 1)
• FILE (File Name) * Table Name
• At once there is any records meet condition above call BSFN B4000341 - RetrieveF4096Cache with iCacheActionCode = '2' to add cache based on record fetched from F4096
• If F4096 is successfully cached than call bsfn B4201150 - ProcessFlexSalesAcctngCache (Process Flex Sales Accounting Cache)
• If a match was found, then continue processing; otherwise, program ends execution here. Note that below routine is hard coded per szApplicationID as below,

• szApplicationID	Routine to validate/detault
  B0000062 - AccountsPayablePaymentPrePost (F0911 Write Cash Account) B0400115 - AccountsPayableVoucherPost (Account Payable Voucher Post)	B0400120 - ProcessAPCacheManagementCache (Process AP Cost Management Cache)
  B03B0025 - InvoicePost (F0911 Write Invoice Offset Automatic Entries) B03B0067 - ReceiptPost (ReceiptPost)	B03B0170 - ProcessARCMSCache (Process AR Cost Management Cache)
  XT4111Z1 - Inventory Transaction	B4101090 - CacheProcessFlexInventoryAcctng (Cache, Process Flex Inventory Accounting)
  R30835 - Item Cost Component - Frozen Update R31802A - Manufacturing Accounting Journal Entries R31804 - Variance Journal Entries	B3101370 - FlexMFGAccountingCache (Flex MFG Accounting Cache)
  P4312 - Purchase Order Receipt P4314 - Voucher Match	B4301410 - MaintainDistributionParmsCache (Maintain Distribution Parms Cache)
  B4200520 - GetSalesAAIsAndCallF0911EditLine (Sales Update, Get AAIs and Edit F0911 Entries) R42800 - Sales Update	B4201150 - ProcessFlexSalesAcctngCache (Process Flex Sales Accounting Cache)
  R12104 - Mass Asset Disposal R12108 - Asset Transfer R12845 - Asset Revaluation Journal R12855 - User Defined Depreciation	B1200170 - ProcessFlexFixedAssetCache (Process Flex Fixed Asset Cache)
  R4981 - Freight Update and Report	B4900190 - CacheProcessTransCMS (Cache Process Transportation CMS)
  Not met	Set Error '0001'

• Repeat error message which are returned from above internal routine listed
• Determine which file needs to be accessed to retrieve the field's value from.
• Refer to the BF specification for B4201140 to find the supported files (See parameter FileName). If the file name (from F4096) is blank, then the record is from the World RPG system and we need to get the file name from the 40/DI UDC table.
• Check that the File Name is valid for this Application (the calling program). Else set error 070X
• File and column Definition        

F4096.FILE	Columns	Note
F0101 (Address Book)	When szApplication ID is B4200520,R42800,R4981 Case (SFDT = 1) Sold To Case (SFDT = 2) Ship To Case (SFDT = 3) Parent Address	The Address Book number can be either '1' = Sold To  '2' = Ship To or '3' = Parent if SOP was the calling application. For all other applications, there is only one Address Book Number passed in the cache
	When szApplicationID is P4312, P4314 SFDT = 2 then get SHAN from F4301 SFDT = 3 get Parent Address Number of AN8 from F0150 Set error 3783	Add logic to enable flex datatypes of 2 and 3 when flex accounting is used in conjunction with P4312 and P4314. For datatype of 3, the parent address numbe is the value specified in the supplier master record. This parent address number is stored in F0150 with an organization type equal to blank. If the user has specified a datatype of 3, but there is no corresponding record in the F0150, VA evt_WorkAddressNumber is set to blank and an error is subsequently set. For datatype of 2 the ship-to is fetched from the F4301 record.
F4211 (Sales Order Detail)	When Application ID is B4200520, R42800 Based on return value of BSFN B4201150 (Process Flex Sales Accounting Cache) (Case SFIT = SRP1) F4211.SRP1 (Case SFIT = SRP2) F4211.SRP2 (Case SFIT = SRP3) F4211.SRP3 (Case SFIT = SRP4) F4211.SRP4 (Case SFIT = DOCO) F4211.DOCO (Case SFIT = DOC) F4211.DOC (Case SFIT = SLSM) F4211.SLSM (Case SFIT = SLM2) F4211.SLM2 (Case SFIT = AN8) F4211.AN8 (Case SFIT = ITM) F4211.ITM (Case SFIT = MCU) F4211.MCU (Case SFIT = EMCU)   If szApplicationID IN ('R4200520', 'R42800')        F4211.MCU   Else        F4201.MCU (=F4211.EMCU) (Case SFIT = KCOO) F4211.KCOO If DTAI IN ('CO', 'KCO', 'OKCO', RKCO') then ltrim zero	If the field is one of the fields passed in the SOP cache, use that value. Otherwise, we need to retrieve the value from the S/O Detail record.
F4071 (Adjustment Master)	If returned AST is Blank, then AST = (Input) szPriceAdjustmentType (Case SFIT = AST), returned AST (Case Others: call Get Table Column Value) to get szWorkString (Case SFIT = PA01 and szWorkString = "1"), returned Parent Address Number and exit from routine. (Case SFIT = PA01 and szWorkString = "2"), assign SIFT = AN82 (Case SFIT = PA01 and szWorkString = "3"), assign SIFT = AN83 (Case SFIT = PA01 and szWorkString = "4"), assign SIFT = AN84 (Case SFIT = PA01 and szWorkString = "5"), assign SIFT = AN85 (Case SFIT = PA01 and szWorkString = "6"), assign SIFT = AN86 (Case SFIT = PA01 and szWorkString = "7"), assign SIFT = AN87 (Case SFIT = PA01 and szWorkString = "2"), assign SIFT = AN82 (Case SFIT = PA01 and szWorkString = "2"), assign SIFT = AN82	If  SFIT is not "AST" then call bsfn B4002420 - GetTableColValue (Get Table Column Value) to get szWorkString from it. Depends on this value it identified which column values to assign into SFIT.
F4111 (Item Ledger)	SFIT = ITM, then F4111.ITM SFIT = LITM, then F4111.LITM SFIT = AITM, then F4111.AITM SFIT = KIT, then F4111.KIT SFIT = MMCU, then F4211.MMCU SFIT = MCU, then F4211.MCU SFIT = DMCT, then F4211.DMCT SFIT = DOCO, then F4211.DOCO SFIT = TREF, then F4111.TREF SFIT = RCD, then F4211.RCD	All permissable F4111 fields are in the inventory cache
F1201 (Asset Master)	SFIT = NUMB, then F1201.NUMB SFIT = CO, then F4211.CO SFIT = APID, then F1201.APID SFIT = ASID, then F1201.ASID SFIT = ACL1, then F1201.ACL1 SFIT = ACL2, then F1201.ACL2 SFIT = ACL3, then F1201.ACL3 SFIT = ACL4, then F1201.ACL4 SFIT = ACL5, then F1201.ACL5 SFIT = MCU, then F4211.MCU SFIT = TXJS, then F1201.TXJS SFIT = INSP, then F1201.INSP SFIT = INSC, then F1201.INSC SFIT = LOC, then F1201.LOC SFIT = AN8, then F4211.AN8 SFIT = LANO, then F1201.LANO SFIT = ACL6, then F1201.ACL6 SFIT = ACL7, then F1201.ACL7 SFIT = ACL8, then F1201.ACL8 SFIT = ACL9, then F1201.ACL9 SFIT = ACL0, then F1201.ACL0 SFIT = KIT, then F4211.KIT SFIT = JBCD, then F1201.JBCD SFIT = JBST, then F1201.JBST SFIT = FA0, then F1201.FA0 SFIT = FA1, then F1201.FA1 SFIT = FA2, then F1201.FA2 SFIT = FA3, then F1201.FA3 SFIT = FA4, then F1201.FA4 SFIT = FA5, then F1201.FA5 SFIT = FA6, then F1201.FA6 SFIT = FA7, then F1201.FA7 SFIT = FA8, then F1201.FA8 SFIT = FA9, then F1201.FA9 SFIT = FA21, then F1201.FA21 SFIT = FA22, then F1201.FA22 SFIT = FA23, then F1201.FA23 SFIT = TXA1, then F4211.TXA1 SFIT = MMCU, then F4211.MMCU SFIT = WRFL, then F1201.WRFL SFIT = NORU, then F1201.NORU
F1202 (Asset Balance)	SFIT = ADM, then F1202.ADM SFIT = ADSN, then F1202.ADSN SFIT = DIR1, then F1202.DIR1 SFIT = CHCD, then F1202.CHCD SFIT = ITAC, then F1202.ITAC
the other supported files (F0006, F03B11, F0411, F30006, F3009, F3111, F3112, F41001, F4101, F4102, F4311, F4801, F4215, F4941, F4942, F03B13, F03B14, F0413, F0414)	If (szApplicationID is B4200520 or R42800) and FILE = 'F42160' then KCOO = F4211.KCOO If (szApplicationID is B4200520 or R42800) and (FILE = 'F42160' or 'F4102') and Processing Option (#5. G/L Account Business Unit = 1) then MCU = F4211.MCU If (szApplicationID is B4200520 or R42800) and (FILE = 'F42160' or 'F4102') and Processing Option (#5. G/L Account Business Unit = 2) then MCU = MCU of F4211.AN8 If (szApplicationID is B4200520 or R42800) and (FILE = 'F42160' or 'F4102') and Processing Option (#5. G/L Account Business Unit = 3) then MCU = F4201.MCU If (szApplicationID is B4200520 or R42800) and (FILE = 'F42160' or 'F4102') and Processing Option (#5. G/L Account Business Unit = I) then MCU = MCU of F4211.EMCU If FILE = F4311 AND SFIT = CO, then ltrim company If FILE = F4801 AND SFIT = CO, then ltrim company

• The next section will build/derive either the Business Unit, Subsidiary or Subledger by concatenating WorkString onto the end (omitting blanks)

• @RT Value	Condition in P40296	Usage
  1	GC Business Unit is 'X'	Assign MCU based on above value
  2	GC Subsidiary is 'X'	Assign SUB based on above value
  3	GC Subledger is X	Assign SBL based on above value
  4	GC Item is X	Assign ITM
  5	GC Cost Object is 1	Return cManagerialAnalysisType1 = VA evt_cManagerialAnlysisTyp_ABT1
  6	GC Cost Object is 2	Return cManagerialAnalysisType2 = VA evt_cManagerialAnlysisTyp_ABT1
  7	GC Cost Object is 3	Return cManagerialAnalysisType3 = VA evt_cManagerialAnlysisTyp_ABT1
  8	GC Cost Object is 4	Return cManagerialAnalysisType4 = VA evt_cManagerialAnlysisTyp_ABT1

• Get the next matching Flexible Sales Accounting (F4096) record and continue processing by calling BSFN Retrieve F4096 Cache with szCacheActionCode 3
• If the Business Unit built is not blank, right justify it and pad it with blanks
• When done reading all matching records in the Sales Flex Accounting table, if there were no errors encountered when processing the rules, return the Business Unit, Subsidiary, Subledger and Subledger Type to the calling program
• Error codes:
• 0001 - Action Invalid. When (Input) szApplicationID is does not meet above list of applications
• 070X - Invalid Application/File Combination.
• CAUSE . . . .  The combination of the application group and file is invalid.
  RESOLUTION. .  The F1690 file has the permissible combinations of Application Groups and Files. No rules should be set up where an Application will be calling a rule in the F4096 file using a file that is not available to that application.
• Technical review: Fails to get data from F1690
• 3783 - Invalid Parent Number.
• Cause . . . . . . The parent number entered is not an allowable value.
  Resolution. . . . If the parent number is the same as the address book number, then you must change the parent number address.  Be sure that parent number address is also set up in the Address Book Master file (F0101).
• Technical review: No Parent Address

B4000341 - RetrieveF4096Cache (Retrieve F4096 Cache)

• Purpose: This function is to retrieve add cache based on Flex Accounting table (F4096) and this routine has to be called by BuildFlexibleAccountwithCache in building Flex Accouting
• Parameters:
• Data Structure: D4000341 - Retrieve F4096 Cache

• Detail Routine:
• This BSFN RetrieveF4096Cache is called by BuildFlexibleAccountwithCache as following szCacheActionCode
• 1st, Cache Action Code 3 - CacheGetNext to check whether there is existing cache using cache name B4000341 + JobNumber. This returns error code '078N' because this is the first time
• 2nd, Since it fails to return cache calling routine BuildFlexibleAccountwithCache reads F4096
• 3rd, BuildFlexibleAccountwithCache is calling RetrieveF4096Cache again with szActionCode '2' to add cache this time szDataItem and szFileName can be specified as 2nd routine returned by reading F4096 (either physicla file or cache)
• 4th, BuildFlexibleAccountwithCache is calling RetrieveF4096Cache again with szActionCode '3' to check whether there is additional cache to handle and this returns idCacheCursor so this value can be used by another routine if requested
• General Routine when mnJobNumber is 119794 when szCacheActionCode is 3

Entering jdeCacheInit                     Name:[B4000341119794]
   Found existing cache, total references:[8]
   hCache:[0A4A2038] Nm:[0B4000341119794] Recs:2 Curs:0 Hnds:8 Cchs:14 INIT exist
Entering jdeCacheOpenCursor (Called by: b4000341.c line 495)
   Open Cursor Success                     hCursor:[09310268] hCache:[0A4A2038]
   hCache:[0A4A2038] Nm:[0B4000341119794] Recs:2 Curs:1 Hnds:8 Cchs:14 CURS open
Entering jdeCacheFetchPosition                     hCursor:[09310268]
Entering jdeCacheCloseCursor                     hCursor:[09310268] hCache:[0A4A2038]
   hCache:[0A4A2038] Nm:[0B4000341119794] Recs:2 Curs:0 Hnds:8 Cchs:14 CURS close

• Error codes:
• 078L - Initialization of cache &1 failed. 
• CAUSE . . . .  Cache &1 may not be able to be initialized because of an invalid user handle or not enough memory allocated to hold JDECACHE structures.
  RESOLUTION. .  Verify that a valid user handle is being passed back from JDB_InitBhvr and that you have enough memory allocated.  Check the JDE.LOG and JDEDEBUG.LOG for additional information.
• Technical review: (&1 = B4000341 + JobNumber) when jdeCacheInit () is failed
• 032E - Error Processing Cache.
• CAUSE . . . An error has occurred while processing cache in this application.
  RESOLUTION.  See your system administrator.
• Technical review: szCacheActionCode is not in '1, 2, 3, 9, 8'
• 078N - Fetch from cache &1 failed.
• CAUSE . . . .  A record does not exist in cache &1 matching the key passed in for the fetch.
  RESOLUTION. .  Verify the key being passed into the fetch is correct and that a record exists in the cache matching that key.  Check the JDE.LOG and JDEDEBUG.LOG for additional information.
• Technical review: jdeCacheOpenCursor () is SUCCESS but jdeCacheFetchPosition () is FAILED when szCacheActionCode is 1 or 3 or jdeCacheOpenCursor () is Failed when szCacheActionCode is 3. All the cache error for szCacheActionCode is 3 (CacheGetNext) returns error code 078N regardless action taken
• 078M - Open Cursor for cache &1 failed. 
• CAUSE . . . .  A cursor was not able to be opened because the Cache Init was not successful or cache &1 was empty.
  RESOLUTION. .  Verify that the Cache Init was successful and that records exist in your cache prior to the Open Cursor.  Check the JDE.LOG and JDEDEBUG.LOG for additional information.
• Technical review: jdeCacheOpenCursor () is FAILED when szCacheActionCode is 1
• 078O - Add to cache &1 failed.
• CAUSE . . . .  The record being added already exists in cache &1 or there may not be enough memory or disk space avaliable to add the record.
  RESOLUTION. .  Verify that the record being added to the cache is unique. Check the JDE.LOG and JDEDEBUG.LOG for additional information.
• Technical review: jdeCacheAdd () is FAILED when szCacheActionCode is 2

B4201150 - ProcessFlexSalesAcctngCache (Process Flex Sales Accounting Cache)

• Purpose: This function is used to create and maintain Flex Sales Accounting in CACHE. As we can see from the first part of this note (Call Stack) the cache for Sales Flex Account has been built before AAI routine comes and inside Flex routine it makes use of cache create. This level of function can be different application by application as defined in BuildFlexibleAccountwithCache (that is, depends on the application you are running transactional cache for Flex Account has to be created in advance). For this example, the application ID is R42800 so BuildFlexibleAccountwithCache is calling this function B4201150. So this function is to get (and update cache) defined value for Flex Account based on definition in F4096.
• Parameters:
• Data Structure: D4201150 - Process Flex Sales Acctng Cache

• Detail Routine:
• This function has to be called before B4200520 - GetSalesAAIsAndCallF0911EditLine from R42800 to add Sales Flex Cache as all the values returned above is coming from Sales Order Information
• Example of cache action when cAction is 3 when JobNumber is 119794

Entering jdeCacheInit                     Name:[B4201150119794]
   Found existing cache, total references:[2]
   hCache:[0A4A14A8] Nm:[0B4201150119794] Recs:1 Curs:0 Hnds:2 Cchs:8 INIT exist
Entering jdeCacheOpenCursor (Called by: b4201150.c line 112)
   Open Cursor Success                     hCursor:[09310010] hCache:[0A4A14A8]
   hCache:[0A4A14A8] Nm:[0B4201150119794] Recs:1 Curs:1 Hnds:2 Cchs:8 CURS open
Entering jdeCacheFetchPosition                     hCursor:[09310010]
   hCache:[0A4A14A8] Nm:[0B4201150119794] Recs:1 Curs:1 Hnds:2 Cchs:8 FTCH pos
Entering jdeCacheUpdate                     hCursor:[09310010]
   hCache:[0A4A14A8] Nm:[0B4201150119794] Recs:1 Curs:1 Hnds:2 Cchs:8 UPD
Entering jdeCacheCloseCursor                     hCursor:[09310010] hCache:[0A4A14A8]
   hCache:[0A4A14A8] Nm:[0B4201150119794] Recs:1 Curs:0 Hnds:2 Cchs:8 CURS close
Entering jdeCacheTerminate
   hCache:[0A4A14A8] Nm:[0B4201150119794] Recs:1 Curs:0 Hnds:2 Cchs:8 TERM one

• Error codes:
• 0001 - cAction is 1 (Get element in CACHE) OR cAction is 2 (Add record to CACHE) OR cAction is 3 (Update on existing record in CACHE) or cAction is 5 (Delete record(s) in CACHE) and jdeCacheFetchPosition () is failed
• 4377 - Invalid Input Parameter. 
• CAUSE . . . . Input parameter passed to a function contains an invalid value.
  RESOLUTION. . Check input parameters for valid values.
• Technical review: Invalid Action. When input cAction is not IN (1, 2, 3, 4, 8)

B4002420 - GetTableColValue (Get Table Column Value)

• Purpose: This function is to validate values defined in F4096 (szDataItem (SFIT) and szFileName (FILE)) based on predefined settings. Depends on szFileName the way it validates can be vary
• Parameters:
• Data Structure: D4002420 - GetTableColValue

• Detail Routine:
• 1. Define szFiles Array (same with enumerator) F0006 (iFileNumber = 1), F0101 (2), F03B11 (3), F0411 (4), F30006 (5), F3009 (6), F3111 (7), F3112 (8),  F4071 (9), F41001 (iFileNumber = 10), F4101 (11), F4102 (12), F4211 (13), F4311 (14), F4801 (15), F4216 (16), F4215 (17), F4941 (18), F4942 (19), F0413 (iFileNumber = 20), F0414 (21), F03B13 (22), F03b14 (23), F42119 (24), F4111 (25), F0401 (26), F03012 (27), F0618 (28), F4981 (29), F4801T (iFileNumber = 30), F31122 (31), F40P01 (32), F40P011 (33), F0911 (34), F43199 (35), F4620 (36), F3102 (37), F42160 (38), FF31011 (39), FF31111 (iFileNumber = 40), FF31112 (41), F49211 (iFileNumber = 42)
• 2. Based on iFileNumber (which is same with a specific Table ID) validate definition
• 3. Validate it

• iFileNumber	szFileName	Routine
  1	F0006	JDB_FetchKeyed () against F0006 based on input value F0006.mcmcu = szBusinessUnit Index: ID_F0006_COST_CENTER
  2	F0101	Get Address Book Master (F0101) Data  based on input F0101.aban8 = mnAddressBookNumber Index: ID_F0101_ADDRESS
  3	F03B11	Fetch F03B11 using order number, order type, order company, order suffix. F03B11.rpdoc = mnDocVoucherInvoiceE F03B11.rpdct = szDocumentType F03B11.rpkco = szCompanyKey F03B11.rpsfx = szDocumentPayItem Index: ID_F03B11_DOC_NUMBER__DOC_TYPE___A
  4	F0411	Fetch F0411 based on F0411.rpdoc = mnDocVoucherInvoiceE F0411.rpdct = szDocumentType F0411.rpkco = szCompanyKey F0411.rpsfx = szDocumentPayItem F0411.rpsfxe = mnPayItemExtensionNumber Index: ID_F0411_DOCUMENT__TYPE____A
  5	F30006	Fetch F30006 using cost center F30006.iwmcu = szBusinessUnit Index: ID_F30006_BRANCH__BUSINESSUNIT
  6	F3009	Fetch F3009 using branch F3009K.mmcu = szCostCenterAlt ID_F3009_BRANCH
  7	F3111	Fetch F3111 using unique id F3111.wmukid = mnUniqueKeyIDInternal ID_F3111_UNIQUEKEYID
  8	F3112	Fetch F3112 using order number, Sequence No Operations, Type operation code and business unit. F3112.wldoco = mnDocumentNumber F3112.wlopsq = mnSequenceNoOperations F3112.wlopsc = szTypeOperationCode F3112.wlmcu = szCostCenterAlt ID_F3112_ORDERNO_OPERATIONSEQNO__A
  9	F4071	Fetch F4071 using price adjustment name F4071.atast = szAdjustmentName ID_F4071_ADJUSTMENT_NAME
  10	F41001	Fetch F41001 using system code and business unit F41001.cisy = "    " F41001.cimcu = szBusinessUnit ID_F41001_SYSTEM_CODE__BUSINESS_UNIT
  11	F4101	Fetch F4101 using short item number F4101.imitm = mnShortItemNumber ID_F4101_ITEM_MASTER
  12	F4102	Fetch F4102 using short item number and business unit F4102.ibmcu = szBusinessUnit F4102.ibitm = mnShortItemNumber ID_F4102_BRANCH__ITEM
  13		Fetch F4211 using order number, order type, order company, line number F4211.sddoco = mnDocumentNumber F4211.sddcto = szOrderType F4211.sdkcoo = szCompany F4211.sdlnid = mnLineNumber ID_F4211_ORDER_NUMBER__ORDER_TYPE___A
  14		Fetch F4311 using order number, order type, order company, order suffix and line number F4311.pddoco = mnDocumentNumber F4311.pddcto = szOrderType F4311.pdkcoo = szCompany F4311.pdsfxo = szOrderSuffix F4311.pdlnid = mnLineNumber ID_F4311_DOC_NO__ORDER_TYPE____1
  15		Fetch F4801 using document number F4801.wadoco = mnDocumentNumber ID_F4801_DOCUMENT_NUMBER
  16		Fetch F4216 using order number, order type, order company, line number, SSCC Number - Tare Level, SSCC Number - PAK Level, SCC Number, UPC Number F4216.xddoco = mnDocumentNumber F4216.xddcto = szOrderType F4216.xdkcoo = szCompany F4216.xdlnid = mnLineNumber F4216.xdplt = szSSCCNumberTareLevel F4216.xdpak = szSSCCNumberPackLevel F4216.xdsccn = szSCCNumber F4216.xdupcn = szUPCNumber ID_F4216_DOC___ORDER_TYPE
  17		Fetch F4215 using Shipment Number F4215.xhshpn = mnShipmentNumber ID_F4215_SHIPMENTNUMBER
  18		Fetch F4941 using Shipment Number and Routing Step Number F4941.rsshpn = mnShipmentNumber F4941.rsrssn = mnRoutingStepNumber ID_F4941_SHIPMENT_NUMBER_ROUTING_STEP
  19		Fetch F4942 using Shipment Number,Routing Step Number, Document,Document Type,Company, and Line ID F4942.isshpn = mnShipmentNumber F4942.isrssn = mnRoutingStepNumber F4942.isdoco = mnDocumentNumber F4942.isdcto = szOrderType, F4942.iskcoo = szCompany                                     F4942.islnid = mnLineNumber ID_F4942_SHIPMENTNUMBER
  20	F0413	@No Implementation
  21		Fetch F0414 using Payment ID F0414.rnpyid = mnPaymentID F0414.rnrc5 = mnFileLineIdentifier50 ID_F0414_PAYMENT_ID__LINE
  22		Fetch F03B13 using Payment ID F03B13.rypyid = mnPaymentID ID_F03B13_PAYMENT_ID
  23		Fetch F03B14 using Payment ID F03B14.rzpyid = mnPaymentID F03B14.rzrc5 = mnFileLineIdentifier50 ID_F03B14_PAYMENT_ID__FILE_LINE_ID
  24		Fetch F42119 using order number, order type, order company, line number    F42119.sddoco = mnDocumentNumber    F42119.sddcto = szOrderType    F42119.sdkcoo = szCompany    F42119.sdlnid = mnLineNumber ID_F42119_ORDER_NUM__ORDER_TYPE
  25		Fetch F4111 using unique key ID F4111.ilukid = mnUniqueKeyIDInternal ID_F4111_UNIQUE_KEY_ID
  26		Fetch F0401 using Supplier Number F0401.a6an8 = mnAddressBookNumber ID_F0401_ADDRESS
  27		Fetch F03012 using Address Number and Company    F03012.aian8 = mnAddressBookNumber    F03012.aico = szCompany ID_F03012_ADDRESS_COMPANY
  28		Fetch F0618 using Address Number and Payroll Transaction Number F0618.ytan8 = mnAddressBookNumber ID_F0618_ADDRESS_NUMBER__DATE_WORKED
  29		Fetch F4981 using Address Number and Payroll Transaction Number F4981.fhuk01 = mnUniqueKeyID01 ID_F4981_UNIQUE_KEY
  30		Fetch F4801T using Address Number and Payroll Transaction Number F4801T.wadoco = mnDocumentNumber ID_F4801T_ORDER_NUMBER
  31		Fetch F31122 using unique key ID F31122.wtukid = mnUniqueKeyIDInternal ID_F31122_UNIQUE_KEY_ID
  32		Fetch F40P01 using Promotion ID F40P01.phpmtn = szPromotionID ID_F40P01_PROMOTIONID
  33		Fetch F40P011 using Promotion ID and Promotion Deal ID   F40P011.pdpmtn = szPromotionID   F40P011.pddidp = szPromotionDealID ID_F40P011__PROMOTID__DEALID
  34		Fetch F0911 using DCT, DOC,KCO, DGJ, JELN, LT, EXTL     F0911.gldct = szDocumentType     F0911.gldoc = mnDocVoucherInvoiceE     F0911.glkco = szCompanyKey     F0911.gldgj = jdDateForGLandVoucherJULIA        F0911.gljeln = mnJournalEntryLineNo     F0911.gllt = szLedgerType     F0911.glextl = szLineExtensionCode ID_F0911_DOC_TYPE__NUMBER
  35		Fetch F43199 using doco, dcto, kcoo, sfxo, lnid     F43199.oldoco = mnDocumentNumber     F43199.oldcto = szOrderType     F43199.olkcoo = szCompany     F43199.olsfxo = szOrderSuffix        F43199.ollnid = mnLineNumber ID_F43199_ORDERNUM__ORDERTYPE__A
  36		Fetch F4620 using unique id F4620.cdukid = mnUniqueKeyIDInternal ID_F4620_UNIQUEKEY
  37		Fetch F3102 using doco, itm, cost, part ,mcu     F3102.igdoco = mnDocumentNumber     F3102.igitm  = mnShortItemNumber     F3102.igpart = cParentChildRelationshi     F3102.igcost = szCostType     F3102.igmcu = szCostCenterAlt ID_F3102_ORDERNUMBER__WORKCENTER
  38		Fetch F42160 using order number, order type, order company, line number              F42160.sddoco = mnDocumentNumber              F42160.sddcto = szOrderType              F42160.sdkcoo = szCompany              F42160.sdlnid = mnLineNumber ID_F42160_ORDER_NUMBER__ORDER_TYPE__A
  39		Fetch FF31011 using unique id FF31011.ehukid = mnUniqueKeyIDInternal ID_FF31011_UNIQUEKEYID
  40		Fetch FF31111 using unique id FF31111.plukid = mnUniqueKeyIDInternal ID_FF31111_UKID
  41		Fetch FF31112 using unique id FF31112.ehukid = mnUniqueKeyIDInternal ID_FF31112_PRIMARY
  42		Fetch F49211 using order number, order type, order company, line number F49211.uddoco = mnDocumentNumber F49211.uddcto = szOrderType F49211.udkcoo = szCompany F49211.udlnid = mnLineNumber ID_F49211_ORDER_NO__ORDER_TYPE___A
  default	other table	Set Error 070X

• Supported Data Type

• iDataType	Description	API to copy
  1	Character Value	jdeStrncpy((JCHAR *)szValue, (const JCHAR *)szTempCharValue,  iValueSize - 1);
  2, 20	String Value	jdeStrncpy((JCHAR *)szValue, (const JCHAR *)szTemporaryValue, iValueSize - 1);
  9	Math Numeric Value	FormatMathNumeric((PJSTR)szValue, (LPMATH_NUMERIC)&mnValue) to convert math numeric value to string
  11	JDEDATE	FormatDate(szValue, &jdValue, szFormatMask); to convert JDEDATE to string
  15	Integer Value	1. Convert integer to math numeric IntToMathNumeric(iValue, &mnTempValue); 2. and math numeric to string FormatMathNumeric(szValue, &mnTempValue);
  7	ID	1. Convert ID (a long integer) to math numeric LongToMathNumeric(idValue, &mnTempValue); 2. and math numeric to string FormatMathNumeric(szValue, &mnTempValue);

• Error codes:
• 3143 - File can not be accessed.
• CAUSE . . . . ERROR: File can not be accessed.
  Solution. . . Change IBM security or authority using the IBM EDTOBJAUT command. This file can not be accessed with the current IBM authority for the User executing this request.
• Technical review: this message can come from any routine when JDB_OpenTable () failed
• 017F - Fetch Unsuccessful.
• CAUSE:  An error occured while fetching a record.
  RESOLUTION:  Verify that the record being fetched is valid.
• Technical review: FetchKeyed () failed to get data from the specified table based on primary key
• 070X - Invalid Application/File Combination. 
• CAUSE . . . .  The combination of the application group and file is invalid.
  RESOLUTION. .  The F1690 file has the permissible combinations of Application Groups and Files. No rules should be set up where an Application will be calling a rule in the F4096 file using a file that is not available to that application.
• Technical review: An unsupported file name was passed

B4204190 - ProcessDistributionAAICache (Process Distribution AAI Cache)

• Purpose: This function is to delete cache created during Sales Update process based on Job Number as inpout value. This function is to call RetrieveF4095Cache and RetrieveF4096Cache with same szCacheActionCode 8 to terminate cache for DMAAI and Flex Account
• Parameters:
• Data Structure: D4204190B - Process Distribution AAI Cache

• Detail Routine:
• "B4204190B + JobNumber" is cache in getting Account Information whereas F4095 cache is defined as DSD4000352 and F4096 Cache is defined as DSD4000341
• Cache key is made up of mnJobNumber, mnAAITableNumber, szCompanyNumber, szDocumentType, szGLCategory, szCostType and szBranchPlant
• Note: Refer the second data structure from this note B4204190 - RetrieveDistributionAAICacheDB (Retrieve Distribution AAI From Cache or DB) with D4204190A
• Error Codes:
• 078L - This error will come when jdeCacheInit() API fails which intialize cache using "B4204190B + JobNumber"