Changing Default Validations in Purchase Line

ssingla · 2007-04-20

Due to the preculiar circumstances of the bussiness the client is not in position to determine the exaxt conversion factor for different unit of measures for a item. To solve the problem we customize it for Dual Unit of measure whereby the client enters the conversion factor in the Purchase line in a customized field and system will create a new unit of measure for the item if it is not defined earlier. The customization was done after seraching the forum where a meat shop example was quoted.

Now the problem is that if Order of 100 pcs is issued and first lot of 20 pcs is recd, client defines the conversion factor and new UOM is updated in the Purchase Order. After Receipt when the second lot is received with different conversion factor , the system while updating UOM validates that the quantity recd/invoiced should be 0.

If the validation is removed than what will be the possible impact on the system :?: If the validation should not be removed then how does the transaction will take place :?:

Help on the matter will be appreciated.

kriki · 2007-04-20

I would say that the best is to do some tests.
Another way you can do (I think this is better) : when they want to change the factor, it is better to create a new line with the remaining quantity and putting the Quantity of the original line = Quantity received.

ssingla · 2007-04-20

Thanks for the reply. I was also thinking on the similar terms but this will modify the Purchase Order. The client does not want that. As client has not purchased the warehouse management the Purchase Receipts need to be booked thru P.O. ption only.
As per client the authorized P.O. has been sent to the vendor and just because the conversion factor has changed, the revised PO cannot/needn't be created.
I am confused how to handle this ](*,)

David_Singleton · 2007-04-20

ssingla wrote:

Due to the preculiar circumstances of the bussiness the client is not in position to determine the exaxt conversion factor for different unit of measures for a item. To solve the problem we customize it for Dual Unit of measure whereby the client enters the conversion factor in the Purchase line in a customized field and system will create a new unit of measure for the item if it is not defined earlier. The customization was done after seraching the forum where a meat shop example was quoted.

Which thread was this? I know I posted about this exact issue, and how I solved it for a meat customer, and this sounds the same.

ssingla wrote:

Now the problem is that if Order of 100 pcs is issued and first lot of 20 pcs is recd, client defines the conversion factor and new UOM is updated in the Purchase Order. After Receipt when the second lot is received with different conversion factor , the system while updating UOM validates that the quantity recd/invoiced should be 0.

If the validation is removed than what will be the possible impact on the system :?: If the validation should not be removed then how does the transaction will take place :?:

Help on the matter will be appreciated.

Yes this was an issue in our case as well. Basically the issue is that from the inventory point of view this really is a new purchase line that will have a new Item ledger entry created. But from the financial view point, we need it to remain as one purchase line. We basically did what you are suggesting, where we update the existing line with the new UOM and new UOM Qty. Our original suggestion was that we split the line into two separate lines, but that was not acceptable to the client.

it worked fine, but there is quite a bit more development work, than simply adding // in front of the validation check. but for sure it can work this way.

David_Singleton · 2007-04-20

ssingla wrote:

Thanks for the reply. I was also thinking on the similar terms but this will modify the Purchase Order. The client does not want that. As client has not purchased the warehouse management the Purchase Receipts need to be booked thru P.O. ption only.
As per client the authorized P.O. has been sent to the vendor and just because the conversion factor has changed, the revised PO cannot/needn't be created.
I am confused how to handle this ](*,)

By the way, Warehouse management would not help too much, since it still has to validate the purchase line.

ssingla · 2007-04-21

Thanks for the reply. I am doing testing and will see any adverse effect created due to commenting the standard code.

David Wrote

Which thread was this? I know I posted about this exact issue, and how I solved it for a meat customer, and this sounds the same.

I remembered your post though I do not remember which exact post it is.

Changing Default Validations in Purchase Line

Answers

Categories