Dynamics NAV/BC - Columbus Foods - Co-Product Planning and execution process

• Supply Driven Planning
• Enter Location
• Enter demand days view to get all demand for the next x days
• Enter Quantity to process
• In Web client, the processing screen will get pushed off screen if you have more than 5 boms displayed
• Either filter the list, or use the full client
• Should always process a little more to ensure you cover all package orders completely
• Enter Quantity to package on each Packaging Option line>Enter
• Batch floor processing to execute each one
• Must output from int orders
• Output on final packaging orders
• Batch Reporting to apportion materials and costs across all production orders
• Post all production orders

Dynamics NAV / BC - "the posting date is after the current fiscal year" posting period message

https://community.dynamics.com/business/f/dynamics-365-business-central-forum/287615/error-when-attempting-to-post-sales-journal-in-dynamics-365-business-central/824396

The Confirm posting after the current fiscal year option is enabled for the 1st user who could not post the sales journal and not for the other. (you can check this in the My notifications page).

NAV / BC - Calculate Intermediary and Finished Good Item costs using BOM information

• Use the standard Cost calculation tools to populate the cost in the standard cost field
• Use this for your initial cost estimates before production
• Run Standard Cost Worksheet
• Suggest Item Standard Costs
• Roll up standard costs 
• Set costing method filter to blank or remove it
• Ensure all boms are either new or certified or you will get an error
• This will update the standard costs on the item card
• You do not have to run the "implement standard cost changes" if you're not actually using standard costing

NAV / BC - Showmandatory options does not seem to work

• on numeric and option fields, the default is zero, and is never actually blank which causes the field to never show the red *
• Set the BlankNumbers to BlankZero, and BlankZero = Yes to actually let it treat zeroes as blanks .

Columbus Foods - There is no batch planning - batch within the filter

• The Equipment on one of the intermediaries is missing a capacity
• find the equipment, set a capacity
• On each bom that uses that equipment, go it it, remove it and re-add the equipment to get a capacity.
• Sometimes the Bom is not certified properly
• Change the status to Under Development, Save
• Ensure the correct equipment is on the bom, with a capacity configured
• Change it back to Certified, Save
• The planned production order from quick planning does not have a default machine populated
• After running quick planner, Review all planned productions and enter an equipment code if it does not have one before beginning batch planning

Columbus Foods ADC - Setup

• Setup
• ADC Setup>ADC>Transaction Setup
• Set Defaults on Transactions
• Web Client Setup
• http://fsbbonapps01/adc/login.html
• Click three lines in top left
• Enter all information
• Create a user that will be the system user
• Use the web access key on the user card

BC - "An Item with the same key has already been added" when trying to unpublish an extension

• Confirm no objects already exist with names trying to be used in extensions
• Run this to check if there are any duplicate object entries for specific companies. If any records return, check the names
• select * from Object where [Company Name] > ''
• Restart Instance

Columbus Foods - ADC Receiving - How to fix an accidental over-receive

• Over receiving in ADC will adjust the original PO

1. Go to Order Receiving>Open receiving screen
2. Find the errant line>Delete it from the warehouse receipt
1. You may need to go to Actions>Functions>Containers
2. Untick "Receive" to allow you to delete the line
3. Select all containers and delete them if you plan on redoing the PO, as these containers are connected to that specific PO number
3. Go to the Purchase Order>Set the quantity back to the correct quantity to receive
4. Close your ADC browser, and reopen it to reset any data on the transaction
5. Enter PO
6. Enter Container
7. Enter Item Number
8. Enter Quantity
9. After completing the receipt in ADC, the new line in the Order Receiving will not have a Bin
10. From the Order Receiving screen, open the warehouse receipt
11. Find the line, add the "RECEIVE" Bin
12. You can now post your corrected receipt

Columbus Foods - Manual Production Process

• Warehouse Physical Journal
• Adjust out raw materials
• Adjust in finished goods

Columbus Foods - Execution Process

• After planning and creating all planned Production Orders
• Do thaw pre-process
• Run Production Replenishment / Move List
• Select a specific date
• Run for each replenishment area
• Print Report
• User Manually decides how much to actually move int the thaw bin
• on ADC mobile
• do container move if moving entire container
• do Bin to Bin for partial container or loose amounts
• Scan item case label with lot
• enter quantity
• Place
• new container, in Replenishment Area
• Place all - yes
• Next day, run the Production Replenishment / Move List 
• If the report identifies a preprocess is required
• Complete Pre-Process activity
• Pre-Process Activities
• Open REL order (Planned order no. series)
• From Container no: Enter container in THAW
• Register Pre-Process Activity
• 
  
• Consume Raw Materials-Production orders not connected to packaging orders
• Batch Floor Processing
• Select Production Order
• Click Process
• Enter posting date
• Click next
• Enter Qty to consume or Qty alt
• Next through each bom step
• Actions>New Lot
• Enter Qty to output
• click Actions>New Lot if you need a lot number
• Enter Qty Alt.
• Complete Production - Batch Reporting
• Select Production order
• System will auto-balance output from main order to use as consumption and input to packaging orders
• Quantity will auto-fill with expected quantity (auto backflush)
• Post> Finish
• If you choose "Leave order open" it will allow you to go back and make changes and post again
• RM is consumed, FG is produced, costs are finalized
• Consume Raw Materials-Batch Orders connected to packaging orders
• Batch Floor Processing-Main production order
• Select Main Production Order
• Click Process
• Enter posting date
• Click next
• Enter Qty to consume or Qty alt
• Next through each bom step
• Skip output (It will use output from the Packaging Orders)
• ADC Consumption
• Batch Floor Processing-Sub production orders (Packaging)
• Select Sub Production Order
• Click Process
• Enter posting date
• Click next
• Skip consumption (It will use consumption from Main order)
• Next through each bom step
• Actions>New container
• Enter container id 
• If loose or intermediate, no container id is required
• Actions>New Lot
• Enter Qty to output
• click Actions>New Lot if you need a lot number
• Enter Qty Alt.
• Complete Production - Batch Reporting
• Select main batch order
• System will auto-balance output from main order to use as consumption and input to packaging orders
• Quantity will auto-fill with expected quantity (auto backflush)
• Post> Finish
• If you choose "Leave order open" it will allow you to go back and make changes and post again
• RM is consumed, FG is produced, costs are finalized

NAV BC Extensions - The Multi-part Identifier "xxxxxx.field" could not be bound. in BC on-premises when we search on list page which has a custom field.

• This is a bug in the web client that comes up when the search returns no results, and there is a custom field on the page
• Workarounds
• Add any filter manually first, then the search works
• Hide the custom field, then reload the page

Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. The provider reported an unexpected catastrophic failure. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".

How to open Excel from SQL

• Install Access 2010 components
• Run these scripts

sp_configure 'show advanced options', 1; RECONFIGURE; GO

sp_configure 'Ad Hoc Distributed Queries', 1; RECONFIGURE; GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.15.0', N'AllowInProcess', 1 GO EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.15.0', N'DynamicParameters', 1 GO

• Restart entire machine
• Now this code should work

Select * FROM OPENROWSET ( 'Microsoft.ACE.OLEDB.12.0',

 'Excel 12.0; Database=C:\Budget\budget.xlsx;HDR=Yes', 'Select * from [sheet1$]' ) 

Dynamics NAV BC - Columbus Foods Navigation Custom Screens

• Warehouse ADC Receiving
• Order Receiving
• Inventory
• Bin Status
• Change Bin location of container
• ADC Container Move (no backoffice menu)
• ADC Bin to Bin (no backoffice menu)
• Containers - Change Bin Code manually
• BOM totals with all sublevels
• Quantity Explosion of Formula
• Quantity Explosion of BOM
• How to get ADC setup info
• User Screen - ADC User account
• User Screen - Web Service Access
• Servername - Server Machine Name
• Port - BC Instance Port
• Servicename - BC Instance Name
• Company - Refresh and Select company

BC 16 on premise 2020 release wave 1 notes

https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave1/dynamics365-business-central/

Dynamics NAV/BC Columbus Foods - Production Planning Process

Before doing any planning

• Ensure item replenishment areas are setup for all manufactured items
• Ensure items with pre-processes are setup to auto-plan if component

Regular Production

• Create Formula BOMs
• Create Packaging BOMs
• Quick Planner - Run for FG (or per level of package BOM)
• Run Quick Planner again if second level is also a package bom
• Batch Planner - Run at end to generate batch planned Production Orders with batch numbering and formula int
• If an item does not show up in the batch planning list,
• the production grouping item has not been set for that family of bom items
• Go to the item card and define the production grouping item for all items in the chain
• Filter by Quantity Required > 0
• If you get "attempted to divide by zero"
• It means the intermediate below this item's item type is not set to "Intermediate" on the item card
• Either your intermediate item should be set as an intermediate
• OR Run quick planner to generate orders for this level of production
• Select Item>Plan
• If you get another "attempted to divide by zero" when packing out
• The package bom should not have multiple equipment
• Generate Pre-Process Activities
• Run Prod. Repl. Move List for each replenishment area
• If bin is marked to break containers, ADC will not be able to transfer containers into the bin
• ADC Bin to Bin raw materials to Preprocess Bins, no destination containers
• After time passes,
• Update pre-process > Register pre-process to move stock into Replenishment Bin
• ADC Bin to Bin raw materials to Replenishment Bins, no destination containers
• Execute Production
• Post Batch Reporting
• Final packout (Bread only, or second level packout of FG)
• Release Planned Production Order
• Line>Component>Production Journal
• Enter consumption and output
• Post production journal
• ADC Bin to Bin finished goods to final destination

Co-Buy Production

• Setup Std cost by products
• Setup regular primary products
• Create co-Buy Bom
• Run Supply Driven Planning
•