Physical Inventory Workflow

[Former Member]

Hello All,

I am in the process of development Physical Inventory Adjustment Approval Workflow. This workflow deals with multiple approvers. A work item is executed sequentially starting from level 1 approver to highest level approver depending on the dollar limit. When a work item is executed, the physical inventory document on a custom screen is shown to approver or reject. If approved, it goes to the next level of approver. Once all approvals are obtained, i create the physical count and post the PI document.

Question: What is the best approach of storing the physical inventory document info which is shown on the custom screen? I need this info till i get all the approvals and only then i do the count and post the PID.

Hope this is clear.

Thanks for your inputs,

Santosh

[surjith_kumar · Accepted solution]

Hi,

If you get those values by calculate and display it would be better. For Example Value A, B & C are stored in 3 different tables, but the value which you want to show is D, which you can get by performing some calculation using A,B & C.

Check this Possibilities, if it not working you can go for Custom table.

Regards,

Surjith

[Former Member · Accepted solution]

Thanks for the reply.

On the custom screen, i have only one calculated field and that is physical count. Rest are Plant, Storage loc, material, desc, qty, uom, serial numbers etc.

Thanks,

Santosh