- How to documents exist on Columbus Foods Customer Portal
- ToIncrease Help
- 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
- 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
