Dynamics NAV - Setup Columbus Foods and Catchweights

• How to documents exist on Columbus Foods Customer Portal
• ToIncrease Help
• https://business-central.to-increase.com/md/en-US/index
• Generally Turn on automated cost postings, but can turn off
• Must run adjust cost nightly when using average costing
• Define UofMs as Weight uofm's for use in catchweight
• Catchweight Items
• Base is CASE
• Add UofM LB = 20 if 20 lbs in a case
• Alternate UofM
• Add UofM LB = 20 if 20 lbs in a case
• Costing = Alternate
• Pricing Unit = Alternate
• Catch Alternate Qtys = True
• Alternate Qty Tolerance % = 10%
• Inventory Setup
• Average cost by item by day
• 
  
• Item Card
• Type = Inventory
• Item Types - Will affect what options are available to process each item type
• Raw Material - food going in
• Packaging - Labels, boxes Etc.
• Intermediate - virtual in between
• Finished Good - FG
• Container - Serialized Pallet, anything holding product
• Spare - equipment maintenance
• Stock out warning
• Yes
• Prevent Negative
• Yes
• Sales UofM
• Sales Unit of Measure stays as Case for catchweight items
• Auto-Plan if component
• Will do low-level planning and Autocreate Required Mfg. Orders
• Production
• Production BOM No - BOM for this item
• Production Grouping Item - Intermediary required to make this item, will be used in planning
• Replenish
• Prod. Order
• Vendor Catalog  - Required for Req. worksheet
• Cross-References - Required for scanning
• Standard replenishment using req. worksheet for purchased items
• Vendor No.
• Replenishment System = Purchase
• Lead time = 3W
• Purch UofM = LB
• Reordering Policy - Lot for Lot
• Include Inventory = True
• Lot accumulation period = 1W
• Min, Max, Multiples
• Lot Tracking
• RCVLOTALL
• Lot sales tracking - False (We will provide lot on sale)
• Require Expiration Dates
• Lot Warehouse Picking - FEFO
• PRDLOTALL
• Lot sales tracking - False (We will provide lot on sale)
• Require Expiration Dates = False (will not require lots at production completion)
• Lot Warehouse Picking - FEFO
• Lot card can be manually edited to change dates if required
• Lot no Assignment - Recommend Doc. No
• Custom - Doc no, Date, Suffix
• Expiration Calculation
• 365D
• Freshness Calculation
• Freshness Calc Method
• Days to fresh - days old
• Best if used by, Sell By - same thing
• 250D
• Customers can be linked to Freshness calculation to force picking of fresh only
• Customer Card - Lot Preferences - Lot Freshness
• Country/Regions of Origin Reqd. - True
• Allows entry in gun or receipt
• Batch Planning Worksheet used to plan Prod. Order
• Production BOM No
• Production Grouping Item - Item number of Intermediate
• Used to link multiple production orders using same intermediate
• Flushing method - Manual
• Unapproved Items
• Used for BOM Development if item is not a real item as yet
• Production BOM Setups
• Inventory Setup
• Measuring System = Metric
• Process Setups - Number series, batches
• Warehouse setup
• General Ledger Setup
• Pre-Process
• Blending
• Blank - Just Notify, do nothing else
• Per Order - Create a Production order
• Per Item - Create 1 production order for all other production requirements for the day
• Autocomplete
• 
  
• Production BOM No.
• New>New Version
• Managed by date
• Active version is in red
• Equipment
• Resources - must have at least 1, can be 0 costed
• Only used for capacity planning
• Machine Type - Batch
• Replenishment area can be assigned per equipment
• Costing
• Can set overhead costs here
• Package BOMs
• Intermediate
• All packaging materials
• Co-Product By-Product Processes BOM
• One in, multiple out
• Lines = Input
• Qty Alt = Alt uofM Lbs
• Output 
• Co-Product - What we want to get
• Primary Co-product is used for planning
• Costing = (Input Cost - Std. By Product costs) / Co-products produced
• By-Product - What you get whether you want it or not
• Must be standard cost item
• Must use standard cost worksheet to revalue stock if changing standard cost
• Formulas
• Define all raw materials used to produce FG
• Set Batch Size
• Set Yield %
• Preprocess Type Code
• Define days for lead time
• Trigger trx on activity list for WH
• Displays on Pre-Process Activities page
• Up to worker to create WH Bin Movement as required
• User must mark as complete to remove from list
• If Blending, will generate Mfg Ord to pre-process
• Generate Pre-Process Activity
• Will generate all Pre-Process productions and activities
• Co-Products
• Outputs must be intermediate or finished goods
• Must have prod order as replenishment system
• One item can be marked as primary
• For By Products
• Must be standard cost
• Generally finished good
• 
  
• Alternate UofM
• set this to KG for items tracked in EACH but are issued in KG
• Cross Referencees
• Must be zero left padded 14 digits for Columbus Scanners
• Labels
• Integration to Loftware
• Will review Later
• Replenishment Areas
• Connect to Item
• Consumption Bin
• Output Bin
• Preprocess replenishment area
• Will show up in task list

• REPORT-Quantity Explosion of BOM

PROCESS

• Container Labels - Will read from container number series
• If non-14digit GTINs are coming from vendors, must relabel with internal numbers that can be read by scanners