Feature - Production Schedule Report CSV Export Customer Number and Name Columns
Version: 8.5 & Up
Background
Production Schedule Report is a BOMP feature located in Bill of Material Processor > Report > Production Schedule Report. It prints a list of items scheduled to be produced. For more information on this, check out the main article on the topic. This feature later was enhanced to allow exporting to CSV files. For more information, click here. This feature is a continuous improvement to support exporting customer numbers and names in the CSV.
Feature
The CSV export in Production Schedule Report now supports customer numbers and customer names as columns, called "Cust#" and "Ref-Desc" respectively. Below is a screenshot from a test CSV file produced in Production Schedule Report.
Only those work orders that were copied from the COP sales orders will have customer numbers and names as column information. Otherwise, they will be left blank. Click here for more information on the Copy COP Orders into BOMP feature.
This feature only applies to material work orders, not legacy or plus work orders. This means that field 9, "Work Order Type," must be M for this feature to work.
Once the fields have been filled out and field 9 has been set to "M," type "Y" in field 19, "Export to CSV?." Fill out the desired file path, and you will have a CSV file with the new columns.
This article is related to the following article on having the ability to export notes in a concatenated format in Production Schedule Report CSV exports.
Programs Modified: BM25P3
AWK