Error receiving shipment

[PCS-Lists]

Nathan,

I made a purchase order normally, but when receiving shipments, clicking in "Save", this error appeared on screen:

    * Invalid SQL: INSERT INTO perp_goods_received (shipment_id,line_no,quantity_units,receive_date,stock_cost_id,received_by) VALUES (1,0,2,'2009-04-02 15:07:14',0,500): Unknown column 'received_by' in 'field list'
    * Invalid SQL: INSERT INTO perp_goods_received (shipment_id,line_no,quantity_units,receive_date,stock_cost_id,received_by) VALUES (1,1,5,'2009-04-02 15:07:14',0,500): Unknown column 'received_by' in 'field list'

Can you help me?

[Nathan Gray]

On 2-Apr-09, at 12:12 PM, PCS-Lists wrote:

> ...  Unknown column 'received_by'

Received by was added in perp_ap version 0.2.004.
Make sure you correctly update your tables in setup whenever you  
update your code.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

[PCS-Lists]

>Received by was added in perp_ap version 0.2.004.
>Make sure you correctly update your tables in setup whenever you  
>update your code.


Update by svn rev 3307 and the perp_ap is 0.2.011?
The problem still happens.

Can you help me?

[Nathan Gray]

On 13-Apr-09, at 8:45 AM, PCS-Lists wrote:

>
>> Received by was added in perp_ap version 0.2.004.
>> Make sure you correctly update your tables in setup whenever you
>> update your code.
>
>
> Update by svn rev 3307 and the perp_ap is 0.2.011?
> The problem still happens.

Is that column actually in the table?


Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

[PCS-Lists]

>Is that column actually in the table?

In GW setup the tables appear updated, but this column (received_by) not exists in the perp_goods_received table.
The columns of this table are:
        goods_received_id
        shipment_id
        receive_date
        line_no
        quantity_units
        purchase_order_id
        stock_cost_id

[Nathan Gray]

On 13-Apr-09, at 11:07 AM, PCS-Lists wrote:

>
>> Is that column actually in the table?
>
> In GW setup the tables appear updated, but this column (received_by)  
> not
> exists in the perp_goods_received table.

You can try adding it in manually.
received_by
'type' => 'int','precision' => '4','nullable' => False

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

[PCS-Lists]

>You can try adding it in manually.
>received_by
>'type' => 'int','precision' => '4','nullable' => False


Thanks Nathan,

it works!