On PartTracker there are fields for Oty on Hand, Total Reserved, etc- There isnt a field for Qty Available( Qty on Hand minus all the commitments of inventory), how hard is it to get something like this?
Banderson
(Brandon Anderson)
April 24, 2019, 12:54am
#2
The reason it’s not a native field is because there are many definitions of “available” and it’s different for each company.
What tools are you familiar with? Do you know how to do BAQs? Do you know how to make simple customizations? How much code do you know?
There are probably many ways to accomplish this, but nothing super straight forward and easy. It’s probably going to take a few moving parts.
Thats what I figured, im am really only familiar with writing BAQs, haven’t done any type of customization and dont know code.
Hi Alex,
have you tried my solution on this post ? you may need to alter the code to give you what you exactly want i.e. as per your definition of Available QTY
Hi everyone,
Unfortunately, i could not find any similar or even far relevant examples on this area to suggest a start point on what LINQ C#.NET commands i can use or alter to suit my need.
so if any one interested on such issues, this is my solution, not perfect but will do the job and i think you will find it useful:
Create, and display an EbiNum box, with a different label name on that UI.
if you want, you can decompile the JobManager Contract assembly dll to find out how exactly the …
just to complete my solution i have notice that my BPM code is not catering for more than one record in PartWhse which is logicly wrong, so i have updated it to do that:
Erp.Tables.PartWhse PartWhse;
decimal dTTLOnHandQty = 0;
decimal dTTLDemandQty = 0;
foreach (var PartWhse_iterator in (from PartWhse_Row in Db.PartWhse
where PartWhse_Row.Company == Session.CompanyID
&& PartWhse_Row.PartNum == ipPartNum
select PartWhse_Row).ToList())
if (PartWhse_iterator != null)
{
dTTLOnHandQty = dTT…