stockin.data.process

1. Basic Information

Item	Description
API Chinese Name	Work Order Stock-In Reversal (Cancel Stock-In)
API English Name	Work Order Stock-In Data Process (Cancel)
CROSS API Code	`stockin.data.process`
ESB Service	`/cancelStockIn` (General) or `/outsourcingProcess` (TRANSORDERTYPE=59)
Call Direction	MES → ERP
Trigger Timing	1. When MES executes cancel check-out 2. When quality issue requires rework
Trigger Condition	TL011/TL012 is not empty
Main Business Scenario	Cancel completed stock-in operation, ERP needs to restore inventory and void original stock-in document
Request Format	JSON (Content-Type: application/json)
Sync/Async	Synchronous call
Transaction Control	Required
Notes	Must check if TL011/TL012 has value before cancel, only call ERP if has value

Cancel Type Determination

TRANSORDERTYPE	ESB Service	Description
59	outsourcingProcess	Cancel outsourcing purchase receipt
Other	cancelStockIn	Cancel general stock-in

source_type Parameter (Outsourcing Only)

source_type	Description	Usage Scenario
0	Shipment reversal	Cancel check-out (outsourcing shipment)
1	Receipt reversal	Cancel check-in (outsourcing receipt)
2	Return reversal	Cancel return

2. Business Flow

Code Reference

Cancel logic: GeneralUpdater.java:1571-1605
TL011/TL012 check: GeneralUpdater.java:1571
TRANSORDERTYPE determination: GeneralUpdater.java:1577

Related API
Cancel stock-in and create stock-in (stockin.data.create) are paired.
Cancel requires TB001/TB002 returned by ERP after successful creation (stored in TL011/TL012).

3. Request Specification

Format: JSON
Content-Type: application/json

3.1 Cancel General Stock-In (cancelStockIn)

Field	Type	Required	Description	MES Source
companyID	string	Y	Company code	COMPANYID
userId	string	Y	Operator	Current user
stock_in_no	string	Y	Stock-in number (type-number)	TL011 + "-" + TL012

3.2 Cancel Outsourcing Stock-In (outsourcingProcess)

Field	Type	Required	Description	MES Source
companyID	string	Y	Company code	COMPANYID
userId	string	Y	Operator	Current user
outsource_no	string	Y	Outsourcing number (type-number)	TL011 + "-" + TL012
source_type	string	Y	Reversal type (0/1/2)	"0" (shipment reversal)

Field Source Description

stock_in_no / outsource_no = SFT_TRANSORDER_LINE.TL011 + "-" + SFT_TRANSORDER_LINE.TL012

TL011/TL012 is written after stockin.data.create succeeds, from ERP returned TB001/TB002.

4. Response Specification

Field	Type	Description
code	int	200=Success, other=Failure
msg	string	Processing result message

Success Behavior

ERP stock-in voided/reversed
Inventory quantity restored (deduct finished goods inventory)
MES check-out record cancelled

5. Validation Rules

#	Validation Item	Rule	Code Location
1	TL011 not empty	Must have ERP document type	GeneralUpdater.java:1571
2	TL012 not empty	Must have ERP document number	GeneralUpdater.java:1571
3	ERP connection	SFTConfig.isHasERP() = true	GeneralUpdater.java:1575
4	TRANSORDERTYPE check	59=outsourcingProcess, other=cancelStockIn	GeneralUpdater.java:1582
5	Original document exists	Document must exist in ERP	ERP side validation
6	Document status allows cancel	Only unposted can be reversed	ERP side validation

Important: ERP will not be called if TL011/TL012 is empty
In the program logic, only when both TL011 and TL012 are not empty, the cancel API will be called.
If empty, the cancel check-out action only executes on MES side, ERP is not affected.

6. Error Codes

Code	Message	Description
E101	Stock-in document not found	stock_in_no corresponding document does not exist
E102	Stock-in document already posted	Stock-in has been posted, cannot reverse
E103	Stock-in document has references	Has subsequent sales or transfer orders
E104	Insufficient inventory	Inventory will be negative after cancel
E999	System error	Timeout, connection exception

7. JSON Examples

Request - Cancel General Stock-In

{
  "companyID": "COMP01",
  "userId": "EMP001",
  "stock_in_no": "5101-20260319001"
}

Request - Cancel Outsourcing Stock-In

{
  "companyID": "COMP01",
  "userId": "EMP001",
  "outsource_no": "5902-20260319001",
  "source_type": "0"   // 0=Shipment reversal
}

Response (Success)

{
  "code": 200,
  "msg": "Stock-in cancelled successfully"
}

Response (Failure)

{
  "code": 500,
  "msg": "Stock-in has been posted, cannot cancel"
}

8. Race Condition Risk Description

Known Issue: TL011/TL012 is empty when cancelling check-out

When user cancels check-out before ERP returns, TL011/TL012 has not been written back yet, cancel API will not be called.
This causes MES and ERP data inconsistency.

Timeline Example

Root Cause

// GeneralUpdater.java:1571
if(!SftTransorderLine.getTl011().equals("") && !SftTransorderLine.getTl012().equals("")){
    // Only call cancel API when TL011/TL012 is not empty
    // If cancel before ERP returns, this if is false, skip ERP call
}

Solution	Description	Impact
Immediate	Manually void the stock-in in ERP	Requires manual intervention
Wait mechanism	Wait for ERP return before allowing cancel	Requires code modification
Lock mechanism	Disable cancel during check-out processing	Requires code modification
Periodic comparison	Scheduled job to compare MES and ERP document status	Requires new feature

Work Order Stock-In Reversal (Cancel)