Knowledgebase: Bpro
computer crashed while receiving an invoice
Posted by Lloyd Jansen on 25-02-2014 05:27 PM

Issue: while receiving a stock order the system crashes

Results: the order disappears from �receive order�, product quantity is changed without any records (I.E no transfer history, nothing in goods received or purchase order)

 

Action to take:

1- Make sure that the only part of the invoice that has taken affect is the change in stock quantity.

2- Change the stock on hand back to the original quantity before the invoice had taken affect via sql query.

3- Run the following query where QUANTITY represents the quantity received

@update orders

Set QTY_TO_REC=QTY_ORDERD

Where order_no=�ORDER NUMBER�

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: