Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
PO receive error
03-07-2020, 04:35 PM,
#1
PO receive error
Good day
Having trouble receiving an item on a PO. Other items received OK.

Database Error 1366 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK ASSISTANCE: A GRN record could not be inserted. This receipt of goods has not been processed because
Incorrect double value: '' for column `weberp`.`grns`.`stdcostunit` at row 1

×Database SQL Failure : The following SQL to insert the GRN record was used
INSERT INTO grns (grnbatch, podetailitem, itemcode, itemdescription, deliverydate, qtyrecd, supplierid, stdcostunit, supplierref) VALUES ('172', '596', 'SOCSIL6W', '3 WAY SOCKET / FEMALE HEADER / 2.54 PITCH, HEIGHT=', '2020-03-07', '100', 'MAN001', '', '')

×Database Rollback Due to Error Above : Rolling Back Transaction OK
Back to Purchase Orders

Receive Purchase Order : 141 from Mantech Electronics
Reply


Messages In This Thread
PO receive error - by alanmi3833 - 03-07-2020, 04:35 PM
RE: PO receive error - by TimSchofield - 03-07-2020, 05:44 PM
RE: PO receive error - by alanmi3833 - 03-07-2020, 11:47 PM
RE: PO receive error - by TimSchofield - 03-07-2020, 11:57 PM
RE: PO receive error - by alanmi3833 - 03-08-2020, 12:13 AM
RE: PO receive error - by alanmi3833 - 03-08-2020, 03:38 AM
RE: PO receive error - by TimSchofield - 03-08-2020, 08:37 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)