Prevent adding serialized items ro SO lines

[Riyaz]

Hi There

We need to prevent adding serialized items to sales orders if it doesnt satisfy a condition, that all works well, except that it still allows the items to be added. Have tried throwing the exception too, but doesn't work.

Have attached the plugin, can you pls kindly check and advise.

[Scott.Pearce]

Need custom stored proc "usp_GetSOHComments"

[Riyaz]

Hi Scott

Pls find it attached

[Scott.Pearce]

It's actually a bit tricky because the line is added, THEN serials are asked for. I can cancel my way out of the serial dialog by adding the line:

Code: Select all

serialDialog.DialogResult = System.Windows.Forms.DialogResult.Cancel;

Just before your exception throw line:

Code: Select all

throw new JiwaFinancials.Jiwa.JiwaApplication.Exceptions.ClientCancelledException();

Here is the modified plugin:

Plugin Inventory Serial plugin DialogResult Cancel Mod.xml

(37.47 KiB) Downloaded 427 times

HOWEVER this has the affect of keeping the line, but putting the quantity on back order. Because remember, we have already added the line, it is the setting of the Quantity Ordered which triggers the serial selection dialog to display.

I think a better approach might be to LOCK the "Unit Quantity" cell on the serial dialog for rows which are not allowed to be selected. If you need to explain to the user why the cell is locked, use an error provider on the cell. Let me know if you need help doing this.

[Mike.Sheen]

Hi Scott

Pls find it attached

That's going to cause you problems if you have the same serial number of an item multiple times - I think you should just accept the LinkID as a parameter and use that.

[Riyaz]

Thanks Mike and Scott