Monday, April 27, 2020

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


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).

Saturday, April 25, 2020

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

Thursday, April 23, 2020

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

Wednesday, April 22, 2020

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

Tuesday, April 21, 2020

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