web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Update Bin field of M...
Microsoft Dynamics GP (Archived)

Update Bin field of MOP1210 (or MOP1025) table

(0) ShareShare
ReportReport
Posted on by Community Member

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

Where([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

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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

  • Community Member Profile Picture
    Community Member on at

    Why didn't my code box break out as it did in OP?

  • Dean Marty Profile Picture
    Dean Marty Microsoft Employee on at

    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.

    -----------------------

  • Community Member Profile Picture
    Community Member on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans