22/04/2021 10:43:05 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
22/04/2021 10:43:13 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
22/04/2021 10:43:17 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
22/04/2021 10:43:36 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
22/04/2021 10:43:55 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
22/04/2021 10:44:02 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
22/04/2021 10:44:09 Returns Account List error: Select  acctno,acctname,acctaddress FROM adidaspos.accounts WHERE asm = 'Ken Blowing' ORDER BY acctname ASC
22/04/2021 10:44:16 Returns Account Details error: Select  acctname,acctaddress FROM adidaspos.accounts WHERE acctno = ''
22/04/2021 10:44:31 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
22/04/2021 10:50:22 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
22/04/2021 10:55:24 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0134','COCHRANE CASTLE GOLF CLUB,SCOTT AVENUE    CRAIGSTON,JOHNSTONE,PA5 0HF','Ken Blowing','2021/4/22','Open','2070081776','ALAN LOGAN','Ken@codeworx.ltd.uk')
22/04/2021 10:55:24 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0134','ADI-019','2','Pending','N')
22/04/2021 10:55:24 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0134','ADI-025','2','Pending','N')
22/04/2021 10:55:25 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0134','ADI-024','1','Pending','N')
22/04/2021 10:55:25 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0134','ADI-022','1','Pending','N')
22/04/2021 10:56:41 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
22/04/2021 10:57:05 SQL used: INSERT INTO adidaspos.posorders (orderno, deladdress, asm, orderdate, status, acctno, acctname, asmemail) VALUES ('KB0135','SCHAWPARK GOLF COURSE,ALLOA GOLF CLUB, PROSHOP,SAUCHIE, CLACKMANNANSHIRE,FK10 3AX','Ken Blowing','2021/4/22','Open','2070081656','BRIAN LEISHMAN GOLF','Ken@codeworx.ltd.uk')
22/04/2021 10:57:05 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0135','ADI-020','3','Pending','N')
22/04/2021 10:57:05 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0135','ADI-023','1','Pending','N')
22/04/2021 10:57:05 SQL used: INSERT INTO adidaspos.orderitems (orderno, partno, qty, status, allocflag) VALUES ('KB0135','ADI-025','2','Pending','N')
22/04/2021 10:57:09 No Allocation has been defined: SELECT t2.availstk,t3.notes FROM  adidaspos.partstock as t2, adidaspos.parts as t3 WHERE t2.partno = t3.partnumber
22/04/2021 11:00:46 SQL used: UPDATE adidaspos.orderitems SET status = 'Returned' WHERE orderno = 'KB0135' AND partno = 'ADI-025'