Adding field in On-hand list form

(0) Share

Report

Posted on by Srihari.molaka

339

Hi All,

We have a separate module for transportation where we do processing of purchase order lines and all purchase order lines are linked to one transport id.

now user need one new field in on-hand list form called transport id to see the data of related items and filter also should work. So, they don't need display method.

Transport id should show up in this form based on itemid and batch number.

Please give me some suggestions to solve this.

Thanks in advance,

with regards,

srihari.

I have the same question (0)

All responses (6)

Answers (0)

Martin Dráb 237,803 Most Valuable Professional on at

Like (0)

Report

Could you please explain the business problem that you're trying to solve by this particular technical design? In other words, let's forget on-hand list form for a moment and let's focus on business processes.

On-hand quantity tells you have in warehouse, not what you have in a particular transport. Unless... you have transportation ID as a inventory dimension (either a custom dimension or reusing an existing one), but then you don't need any change at all, because on-hand quantity already takes inventory dimensions into account.

Was this reply helpful? Yes No
Srihari.molaka 339 on at

Like (0)

Report

Hi Martin,

Thank you for the response,

Business problem is, we did a customization and during product receipt, all items are batch registered. and in the the product receipt we have added a custom field to capture the track number(transport id) against each batch . now via a method the track number(transport id) is visible in on hand inventory form, how do I filter by the track number(transport id) , since method not allowing to filter

with regards,

srihari.

Was this reply helpful? Yes No
Martin Dráb 237,803 Most Valuable Professional on at

Like (0)

Report

You're still discribing your implementation, not the business requirement. When you look at what users actually needs to achieve, you might learn, for example, that creating a special form for transport handling may be better than trying to add transport-related logic to the on-hand quantity form.

Anyway, does you description mean that Transport ID is a property of batches (a field in InventBatch table)? If so, adding it to on-hand quantity form would require outer-joining InventBatch to InventDim in the form and because the form shows groupped data, you would need group by Transport ID as well. Obviously you would get Transport ID only if you set up the form to group by Batch ID. If it's not what you want, it's an indication that it's not the right form for the business requirement.

Was this reply helpful? Yes No
Srihari.molaka 339 on at

Like (0)

Report

Hi Martin,

Thanks for your reply,

The requirement is,

In the On-Hand list, select any of the item number and then select dimensions in the action pain, the users will select site, warehouse, batch number.

After that in the form it will show related information of the item, beside of the batch number, i need to add a column named as transport id.

The user also need to see from which transport id the item is present. The transport id is a custom field which is not present in inventBatch, inventSum, inventDim and inventTable.

The transport id has a reference with itemid, batch id and purchase order. purchase orders because they will buy the items.

By using display method i can get the information of transport id for that item but we cannot filter that field.

So to do the filter of that transport column which way i need to follow?

with regards,

srihari.

Was this reply helpful? Yes No
Martin Dráb 237,803 Most Valuable Professional on at

Like (0)

Report

I'm sorry, but there is not much I can do for you. I can explain why your technical design is wrong, but I can't make a design solving the business problem if don't tell us anything about it. You either know the business requirement and refuse to share it, actively preventing us from helping you, or you don't know yourself what you're doing.

First of all, the whole idea of showing a single Transport ID for a line in On-hand quantity form is wrong. According to yourself, there may be multiple Transport IDs for a single Item/Batch combination, because Transport ID depends on PurchId as well.

Also, what you see in the form has a very weak relation to purchase orders. You may have orders with Transport ID but nothing received to on-hand inventory, or it may be an old order and the items were sold months ago (therefore the current on-hand quantity has nothing to do with the Transport ID), the quantity could have been added by a transfer order and so on. Again, you need to understand what informations users need to get before you can start your implementation. You're apparently not yet in this position.

Was this reply helpful? Yes No
Ferit 10 on at

Like (0)

Report

Well adding fields to Inventsum and InventDim tables really terrible idea. Because all inventory related transactions end with that tables.There is really really complex mechanism to handle this change.

If you can give more detail why user need that field on Invent On hand area, we can help better. Here a quick question, are you planning to track inventory with transport Id? if this is the plan then you should use this transportId for each issue transaction. Or user just wants to see these fields together then develop a simple report

Was this reply helpful? Yes No

Join the conversation

Community site session details

Adding field in On-hand list form

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates

Community site session details

Adding field in On-hand list form

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates