Hi friends,

Wish you all a very Happy New Year.

SERVER : ERP LN 6.1 FP7
OS : Windows 2008

I have come across a requirement where our client needs one of their material in another unit. We tried to use conversion unit feature but as there is no fixed definition between two inventory units, we couldn't.

Now, we decided to customize but trying to do it without touching standard functionality.

We need to implement it at warehouse level ie inbound, outbound, inventory transfer, adjustments.

For the convenience of the user, we want the field to be available along with with quantity field on all the forms, e.g.

Received qty (Inventory unit) - 10 kg - standard unit
Received qty (second unit) - 1 Roll - custom unit

Please suggest the ideas\approach through which I can address this issue.

My approach-
------------
As per my understanding I have made custom tables to store each transaction and summary of the warehouse wise item inventory.

transaction table : order number, order type, date, line, warehouse, item, qty1, qty2
summary table : warehouse, item, qty1, qty2

On the quantity field (inventory unit qty) on form, I changed it to zoom field to open a session to enter quantity (second inventory - qty2).

Here I want to validate:
It should only show the current receipt record not other records.


Thanks
Virendra

you can use hadling unit.

I had a similar requirement in a client, we took the opposite way: customized the standard functionality for the outbound, adjustments and receipts processes in my case. The conclusion is that we were wrong, the standard functionality for stock is so complex and it was and still is a pain in the head so your approach is very good don´t put your hands in the standard and keep your second unit in custom tables and show information when necessary. But if you can solved it with standard functionality as mentioned by ssugemura that will be the best solution, perhaps I don´t thing handling unit is what you are talking about.

I don´t understand what you are trying to validate “It should only show the current receipt record no other record” could you be more specific please.

Good luck