017F (Fetch Unsuccessful) in Flexing F4102.STKT for Nonstock Item in R42800

Table of Contents

Q1> Why R42800 (Sales Update) writes work center error message as below,

Fetch Unsuccessful (Error Code 017F)

even when it contains error above, a user is able to post sales records without having any problem.

Business case 1:

To represent better cost of inventory, same item can have two different stocking type as below,

Branch/Plant Item Number Description Stocking Type Line Type G/L Class Sales Code 2
30 ItemA Description01 P S IN30
M30 ItemA Description01 M S IN30

Depending on the Branch/plant, the Subledger has to be P or M which is the stocking type of Item Branch File (F4102).

To meet this expectation,

DMAAI (F4095)

Co Do Ty Description G/L Cat Description G/L Branch Plant Obj Acct Sub
00200 SO Sales Order IN30 Manufactured Finished Goods 5015

Flex Settings (F4096)

Seq Business Unit Subsidiary Subledger Item Cost Object Cost Type File Name Len Description Data Item Data Type
1 X F4101 8 Item Number - Short ITM
2 X F4102 1 Stocking Type STKT

Since the stocking type in F4101 (Item Master) can be only a single value so the stocking type is only option to record it. Plus, F4211 (Sales Order Detail File) does not contain the stocking type (STKT) in it.

Answer1:

You can ignore the error message in work center (F01131M) because,
- The flex routine resolves DMAAI (F4095) first so the MCU, OBJ, SUB at this level is valid
- The flex settings (F4096) is a subset of F4095
- Hence, F0911.SUB will be remained blank for non-stock item (flex did not take effect).

R42800 - Sales Update (this batch is calling the wrapper function GetSalesAAIsAndCallF0911EditLine which gets/sets account then call G/L master function)

---| 1. GetSalesAAIsAndCallF0911EditLine
------| 2. RetrieveDistributionAAICacheDB
---------| 3. RetrieveDistAAIwF4095Cache
------------| 4. RetrieveF4095Cache
-----------------| 4. BuildFlexibleAccountwithCache
---------------| 5. RetrieveF4096Cache
---------------| 5. ProcessFlexSalesAcctngCache
---------------| 5. GetTableColValue *** this has to be called as many times as the number of row from F4096
---------------| 5. RetrieveF4096Cache
---------------| 5. GetTableColValue
------------------| ERROR INFO JDEERR - ID= 0, Error= 017F - b4002420.c, Line= 913

------| 2. F0911FSEditLine Mar


Meanwhile, the error 071F (Fetch Unsuccessful) is working as designed because Flex account routine is looking for data from F4102.STKT for non-stock item.

Q2> What is the usage of FC Adjustment Name in [Flex Rule Definition] P40296|W40296C? Can this setting allows the system to skip Flex routine not to hit the error 017F?

Answer2:

The Adjustment Name control is available only for DMAAI 4270 and 4280 which are meant for Price History (F4074). This control enables you not to flex a certain lines of sales order because it looks for exact matching records based on F4074. However this can't be used for DMAAI 4220, 4230, and 4240.

To be implemented by end of March 2018 including how adjustment lines working during flex routine.