Issues with Bin Tracking in Business Central

[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ link=” linktarget=” link_hover=” padding=’0px’ border=” border_color=” radius=’0px’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-g8zfzo’]

[av_heading heading=’Issues with Bin Tracking in Business Central’ tag=’h1′ link_apply=” link=’manually,http://’ link_target=” style=’blockquote classic-quote’ size=” subheading_active=’subheading_below’ subheading_size=’15’ margin=” margin_sync=’true’ padding=’10’ color=” custom_font=” av-medium-font-size-title=” av-small-font-size-title=” av-mini-font-size-title=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-lau4vhoj’ id=” custom_class=” admin_preview_bg=”]
Written by Mike Scalamogna, Director of Dynamics 365
[/av_heading]

[/av_one_full][av_one_full first min_height=” vertical_alignment=’av-align-top’ space=” margin=’0px’ margin_sync=’true’ row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” title_attr=” alt_attr=” padding=’0px’ padding_sync=’true’ highlight_size=’1.1′ border=” border_color=” radius=’0px’ radius_sync=’true’ column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” attachment=” attachment_size=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-acrhes’ id=” custom_class=”]

[av_image src=’https://nmq52a.p3cdn1.secureserver.net/wp-content/uploads/2022/11/Issues-with-Bin-Tracking.jpg’ attachment=’18224′ attachment_size=’full’ align=’center’ styling=” hover=” link=’manually,https://opalbiz.com/business-central/’ target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ copyright=” animation=’no-animation’ av_uid=’av-l962e6bj’ id=” custom_class=” admin_preview_bg=”][/av_image]

[av_hr class=’default’ height=’50’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ av-desktop-hide=” av-medium-hide=” av-small-hide=” av-mini-hide=” av_uid=’av-s6gtpj’]

[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-l0mifgvu’ id=” custom_class=” admin_preview_bg=’rgb(255, 255, 255)’]
Last week I had an interesting issue come up where the “Bin Mandatory” flag had been set on a location card in Business Central. At the time it was enabled, there were some quantities of items not assigned to a bin. This created a problem when those quantities were being consumed.

The fix involves having everyone log out of Business Central and utilizing a Configuration Package. It worked flawlessly.  The steps are below:

***You must complete all these steps when there are NO OTHER users working in Business Central. We need to isolate the changes to only those that are made in these steps.***

  1. Using the configuration package, Export to Excel the data from table 14: Location.
  2. Open the resulting spreadsheet and for the MAIN location record, adjust the Bin Mandatory value from true to false.
  3. Save the changes to a NEW spreadsheet file—this is so that you will be able to easily get back to the old values which were originally exported.
  4. Go back to the Configuration Package Card page that you used to export. When the Location table record is highlighted, click Table – Fields.
  5. In the Edit – Config. Package Fields page, locate the Bin Mandatory field, and unmark the Validate Field checkbox.
  6. Close out of the Edit – Config. Package Fields page.
  7. When table 14: Location is highlighted, click Excel – Import from Excel. Point to the newly saved spreadsheet from step #4 above.
  8. After the data is imported, click Functions – Apply Data.
  9. When the data changes are successfully applied, in Business Central process Transfer Orders or Item Journals to move or remove the quantities for the items/lots in question out of the MAIN location.
  10. Verify that the quantities and lots are adjusted as desired.
  11. Go back to the Configuration Package Card page that you used to export/import.
  12. When table 14: Location is highlighted, click Excel – Import from Excel. Point to the originally exported spreadsheet from step #2 above.
  13. After the data is imported, click Functions – Apply Data.

If you have any questions about bin tracking or Dynamics 365 Business Central, reach out to our Dynamics team at Opal Business Solutions. We’re always happy to help!
[/av_textblock]

[av_hr class=’invisible’ height=’50’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’ av_uid=’av-l8t8n0fb’ id=” custom_class=” admin_preview_bg=”]

[av_button label=’More on Business Central’ link=’manually,https://opalbiz.com/business-central/’ link_target=’_blank’ size=’x-large’ position=’center’ label_display=” title_attr=” icon_select=’no’ icon=’ue800′ font=’entypo-fontello’ color=’theme-color’ custom_bg=’#444444′ custom_font=’#ffffff’ av_uid=’av-jiak8jn0′ id=” custom_class=” admin_preview_bg=”]

[av_hr class=’default’ height=’50’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’ av_uid=’av-l8t8n0fb’ id=” custom_class=” admin_preview_bg=”]

[/av_one_full][av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ link=” linktarget=” link_hover=” padding=’0px’ border=” border_color=” radius=’0px’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-g8zfzo’]
[av_heading heading=’TALK TO OUR TEAM‘ tag=’h2′ link_apply=” link=’manually,http://’ link_target=” style=’blockquote modern-quote modern-centered’ size=” subheading_active=” subheading_size=’15’ margin=” padding=’10’ color=” custom_font=” custom_class=” id=” admin_preview_bg=” av-desktop-hide=” av-medium-hide=” av-small-hide=” av-mini-hide=” av-medium-font-size-title=” av-small-font-size-title=” av-mini-font-size-title=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-vrnxzi’]
What is Microsoft Power Automate? How does it fit into the Power Platform? Find all the answers here.
[/av_heading]

[av_contact email=’jhess@opalbiz.com, chorta@opalbiz.com, sales@opalbiz.com’ from_email=” title=” heading_tag=” heading_class=” button=’Submit Request’ on_send=” sent=’Thank you! Our team will be in touch ASAP’ link=’page,18′ subject=’Issues with Bin Tracking in Blog’ autoresponder_email=’chorta@opalbiz.com’ autorespond=” captcha=’active’ captcha_theme=’light’ captcha_size=’normal’ captcha_score=’0.5′ hide_labels=’aviaTBhide_labels’ form_align=” color=” av_uid=’av-iz45j’ id=” custom_class=” aria_label=” admin_preview_bg=’rgb(255, 255, 255)’]
[av_contact_field label=’First & Last Name’ type=’text’ options=” check=” width=” av_uid=’av-vqltj’ multi_select=” av_contact_preselect=”][/av_contact_field]
[av_contact_field label=’E-Mail’ type=’text’ options=” check=’is_email’ width=” av_uid=’av-1bcbprc’ multi_select=” av_contact_preselect=”][/av_contact_field]
[av_contact_field label=’Company’ type=’text’ options=” check=’is_empty’ width=’element_half’ av_uid=’av-ilp4n’ multi_select=” av_contact_preselect=”][/av_contact_field]
[av_contact_field label=’Phone’ type=’text’ options=” check=’is_phone’ width=’element_half’ av_uid=’av-g4sif’ multi_select=” av_contact_preselect=”][/av_contact_field]
[av_contact_field label=’I’m interested in…’ type=’select’ options=’Business Central, Microsoft Products, Other’ check=” width=” av_uid=’av-kjn6qz’ multi_select=” av_contact_preselect=”][/av_contact_field]
[/av_contact]
[/av_one_full]

Related News