Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleDescription of Issue
  • The sublocation quantity on hand is incorrect 
  • Item shows duplicate sublocation warehouse 
    • Expanding item details in the Items program shows the duplicate sublocation 
    • Duplicate sublocations exist on the WarehouseSublocationItems table 
  • Duplicate sublocations are shown for an item in the Enter Inventory Counts program
  • Errors received when attempting to transfer an item:
    • Inventory Transactions: 
      • Error selecting item sublocation QOH (infuncts 6415: Error selecting item sublocation quantity (infuncts 10546). Status: 284
      • Transfer-receipt failed. See error log for further details.
    • System Log:  A subquery has returned not exactly one row.
Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleContext

Inventory Management 

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleCause

Defect occurs when sublocations are added from multiple open tabs of the Items program

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution

Install MUN-485030 once it's been released

Workaround:  

  • Contact Enterprise ERP Assets and Civic Support to
create a support case to track and review this issue 
  • have it corrected with a SQL script 
  • To prevent this issue from happening in the future, refresh the Items program before making any updates to the item record 
Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleAdditional Information


...