INV-INVIDITM-Updating Item Attributes-Error:There are pending cycle count entries or physical inventory adjustments for this item.

INV-INVIDITM-Updating Item Attributes-Error:There are pending cycle count entries or physical invent

Error Message
There are pending cycle count entries or physical inventory adjustments for this item.
Please process these before changing the attribute.

SOLUTION(文档 ID 1566178.1)

1. If query 1a returns rows, try rejecting or accepting the physical adjustments pending for that item:
    a. Navigate: Counting > Physical Inventory > Approve Adjustments
    b. Accept of reject the adjustment(s) for the item.
    c. Retry the item update to see if error still occur.

2. If query 1b returns rows, try rejecting or accepting the cyclecount adjustments pending for that item:
    a. Navigate: Counting > Cycle Counting > Approve Counts
    b. Query the cycle count
    c. Click the Approvals button (see Note 306891.1 if the Approvals button is greyed out)
    d. Process the cycle count entry by approving or rejecting.
    e. Retry the item update to see if error still occurs.

SELECT MPI.PHYSICAL_INVENTORY_ID, MPI.PHYSICAL_INVENTORY_NAME

FROM MTL_PHYSICAL_ADJUSTMENTS MPA, MTL_PHYSICAL_INVENTORIES MPI

WHERE 1 = 1

AND MPA.PHYSICAL_INVENTORY_ID = MPI.PHYSICAL_INVENTORY_ID

AND MPA.ORGANIZATION_ID = 104

AND MPA.INVENTORY_ITEM_ID = 6418

--AND MPA.APPROVAL_STATUS = 1

AND MPA.ADJUSTMENT_QUANTITY <> 0;

Use SQL can get PHYSICAL_INVENTORY_NAME
Navigate to Approving Physical Inventory Adjustments

INV-INVIDITM-Updating Item Attributes-Error:There are pending cycle count entries or physical invent

Change Status Approve or Reject

INV-INVIDITM-Updating Item Attributes-Error:There are pending cycle count entries or physical invent

INV-INVIDITM-Updating Item Attributes-Error:There are pending cycle count entries or physical inventory adjustments for this item.

SOLUTION(文档 ID 1566178.1)

相关推荐