20
Hi,
What I'm trying to achieve is to validate a license plate ID generated by a user, if it is already existing and existing in other locations. If it is not, I will insert the license plate ID in the WorkTable.
How can I validate this or are there standard methods / code I can follow to validate?
Thank you.
*This post is locked for comments
Your query is correct, but the assumption is wrong.
it should be inventSum.AvailPhysical (instead of RecId) I am sure, you will spot the difference immediately
[quote user=""Crispin"][/quote]
I don't know of a standard method.
But a simple code to look at InventSum joined with InventDim should do the job..
Hi Crispin,
Thanks for the suggestion!
I tried doing this:
Share
Report
All responses (
Answers (
inventDim = InventDim::find(_workLine.InventDimId);
inventStatusId = _workLine.inventDim().InventStatusId;
select firstonly RecId from inventSum
join inventDimLoc
join inventDim
where inventDimLoc.inventDimId == inventDim.inventDimId
&& inventDim.inventDimId == inventSum.InventDimId
&& inventDim.InventLocationId == inventDimLoc.InventLocationId
&& inventDim.InventSiteId == inventDimLoc.InventSiteId
&& inventDim.LicensePlateId == targetLicensePlateId
&& inventDim.wmsLocationId == inventDimLoc.wMSLocationId
&& (inventDim.InventStatusId == inventStatusId);
if (inventSum.RecId == 0)
{
WHSWorkTable::addTargetLicensePlate(_workLine.WorkId, targetLicensePlateId);
}
I checked if the RecId of InventSum is blank or has a value. If it's blank, it means the license plate is not existing yet, but if there is a value, it means it exists.
I don't know of a standard method.
But a simple code to look at InventSum joined with InventDim should do the job..
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156