Thursday, December 20, 2012

Dynamics GP - PSTL Item Combiner Tool Error


  • Error: 
    • Violation of Primary key constraint PKIV10202. Cannot insert duplicate key in object dbo.IV10202.
      • Controls linking of consumption records from IV10201 back to receipt in IV10200
    • After this error occurs, if you try to run combiner again, you get another error:
      • Cannot reconcile items, try again later.
      • You cannot complete this process while quantities are being reconciled.
  • Solution
    • Restart GP to remove the "quantities are being reconciled" error
    • Delete the line in the IV10202 that pertains to the number you are trying to Combine
    • delete from iv10202 where itemnmbr = 'youritem'
    • Consequence - GP will not be able to tie the sale of that item back to a receipt

  • Error: 
    • Cannot insert duplicate key row in object SEE30303
      • Controls linking of consumption records from IV10201 back to receipt in IV10200
    • After this error occurs, if you try to run combiner again, you get another error:
      • Cannot reconcile items, try again later.
      • You cannot complete this process while quantities are being reconciled.
  • Solution
    • Restart GP to remove the "quantities are being reconciled" error
    • Delete the line in the IV10202 that pertains to the number you are trying to Combine
    • delete from iv10202 where itemnmbr = 'youritem'
    • Consequence - GP will not be able to tie the sale of that item back to a receipt


No comments:

Post a Comment