webERP Forum
PO receive error - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+--- Thread: PO receive error (/showthread.php?tid=8390)



PO receive error - alanmi3833 - 03-07-2020

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


RE: PO receive error - TimSchofield - 03-07-2020

Hi Alan, does this part have a cost set up for it?

Tim


RE: PO receive error - alanmi3833 - 03-07-2020

Hi Tim,
yes it does.


RE: PO receive error - TimSchofield - 03-07-2020

Hmmmm, interesting. The error message is saying that the standard cost field is blank, not zero but blank. This field is saved at the point the purchase order is raised.
Can you run the following database query:

SELECT stdcostunit FROM purchorderdetails WHERE podetailitem=596;

and let me know the result.
Tim


RE: PO receive error - alanmi3833 - 03-08-2020

localhost/weberp/purchorderdetails/ http://localhost/phpmyadmin/tbl_sql.php?db=weberp&table=purchorderdetails
Showing rows 0 - 0 (1 total, Query took 0.0011 seconds.)

SELECT stdcostunit FROM purchorderdetails WHERE podetailitem=596



1.99



RE: PO receive error - alanmi3833 - 03-08-2020

Ok I deleted line from PO, created new PO and receive the item. No Problem.
Up and running again.

Thank you Tim for the replies, still don't know what cause it, but that are now history.

Regards
Alan


RE: PO receive error - TimSchofield - 03-08-2020

Glad it's sorted for you Alan. Keep an eye on it and if it happen again let me know.

Tim