Inventory transactions(Sales,Purch,Movement and etc) validation for Item

(0) Share

Report

Posted on by Mantas Vysniauskas

Hi All,

I'm facing issue to find place where I can add validation for InventTable one new field.

If it is not filled, I should not allow any Invent transaction. Is there any place/class where I can put validation on one place and it would check on every process. If it would be Sales Order, Purch Order, Inventory Movement and so on?

Or I should add validations separately for all processes?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Mea_ 60,286 on at

Like (1)

Report
Copy link

Link copied!

If you don't want to allow any inventory transaction just throw exception on insert of InventTrans table, but do you really want this ? It sound strange.

Was this reply helpful? Yes No
Mantas Vysniauskas on at

Like (0)

Report
Copy link

Link copied!

Client wants :) Not me :)

Was this reply helpful? Yes No
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I don't think if data is ever inserted directly in InventTrans. As you said yourself it comes though sources (PO, SO lines etc.)

So how about making fields mandatory in source location and as validation you can put validation on InventTans using TransactionType

Was this reply helpful? Yes No
Mantas Vysniauskas on at

Like (0)

Report
Copy link

Link copied!

The point is I don't want to touch sources. I want to add only one validation on the main connecting place. For example like ievgen Miroshnikov said, to add on InventTrans validateWrite. i'm testing it now. But also not sure how it will effect source if InventTrans will be not valid.

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

The bad news for you is that insert operations do not require a TTS transaction block, thus throwing an error is not going to help in many cases, because there is no transaction to roll back during record creation for InventTrans.

You could try to override the aosValidateInsert method and throw an error there on InventTrans which is being called no matter what (insert/doInsert), unless AOS validations are explicitly turned off in code (which is very rare). But that is not going to ensure that the creation of the parent record (origin, through InventTransOrigin) is not being inserted, and you are potentially going to end up with broken record references.

The only possible way to do this correctly is by identifying that in which scenarios do you want to prevent creating an inventory transaction, and change each and every places where you want to raise the error (such as SalesLineType, PurchLineType, various inventory movement classes, etc.).

Due to this I would tell the customer that this is technically not feasible or worth the effort, and would be too much effort to implement it and maintain the customization for future hotfixes and upgrades..

As an alternative solution, when the product is released, during validation you could check if your mandatory fields are filled in and if not, you could put the product on hold for specific transaction types. I believe that is set in the "Default order settings" and "Site specific order settings" on the product.

Was this reply helpful? Yes No
Mantas Vysniauskas on at

Like (0)

Report
Copy link

Link copied!

Thanks for your comments. Now I think I know what to do :)

Was this reply helpful? Yes No