KDS - Ambiguous Column name 'KDSID'

Post Reply
lebo.kgware
Posts: 5
Joined: Fri Jun 02, 2017 7:45 am

KDS - Ambiguous Column name 'KDSID'

Post by lebo.kgware » Tue Jun 13, 2017 11:03 am

Error: [LoadOrders] Exception: Ambiguous Column name 'KDSID'

This error appears inside KDS application when orders are pending to be displayed on any particular KDS unit.

Cause: This is caused by a duplicate report group for one or more 'DISORD*' entry in the dbo.repn table.

Fix: check that there are no duplicate 'DISORD*' entries under column NAME that have been allocated to more than one Geport Group RGROUP. If present, delete the duplicate entries so that each DISORD* entry is only assigned to one report group named 'ORDERS-S*'

Post Reply