You’re offline. This is a read only version of the page.
Since GP doesn't use the BIN field from the Item Quantity Master when building the picklist report, I need to print the Bin for the corresponding ITEMNMBR and LOCNCODE of the Item Quantity Master. Report Builder will not let me do this. I can't use word template. What would be the safest way to update the [BINNMBR] field of the MOP1210 table with the Bin value from [IV00102] table
Share
ReportWhere([MOP1210].[ITEMNMBR] = [IV00102].[ITEMNMBR] )
and ([MOP1210].[FROM_SITE_I] = [IV00102].[LOCNCODE])
Will updating this table impact other processes? Is this the only table that needs to be updated? I only need the correct Bin to print on the PickList(MPK) report.
I honestly don't know the difference between [MOP1210] and [MOP1025]. Some help there would be appreciated.
*This post is locked for comments
This is working so far.
I left out a big detail. We do NOT have multi-bin enabled. It is my understanding that if we did have multi-bin enabled that the correct BINNMBR would show on the picklist report.
Thanks Red.
The MOP1210 holds the Pickdoc information, while the MOP1025 holds BIN information prior to posting the Pickdoc.
Thanks!
----------------------
Dean
Partner Online Technical Community
-----------------------------------------------------------------------------------------
We hope you get value from our new forums platform!
Tell us what you think:
social.microsoft.com/.../threads
------------------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties,
and confers no rights.
-----------------------
Why didn't my code box break out as it did in OP?
Will something like this cause unexpected errors? I am running this in a test company with no issues, but I can't stress test with the same transaction load of production.
ALTER TRIGGER [dbo].[MPK_Update_MOP1210_BINNMBR_Trigger] ON [dbo].[MOP1210] FOR INSERT Begin Try UPDATE [dbo].[MOP1210] Set [MOP1210].[BINNMBR] = [IV00102].[BINNMBR] from [dbo].[MOP1210] join [dbo].[IV00102] on ([MOP1210].[ITEMNMBR] = [IV00102].[ITEMNMBR] ) and ([MOP1210].[FROM_SITE_I] = [IV00102].[LOCNCODE]) where ([IV00102].[BINNMBR] not like '') and (rtrim([MOP1210].[BINNMBR]) not like rtrim([IV00102].[BINNMBR])) GO
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (