Quote Import Mapping - Revision history

Vtran: Redirected page to Quote Import Mapping Rule

2022-07-21T19:04:37Z

Redirected page to Quote Import Mapping Rule

Vtran: Created page with "NOTOC ===General Information=== '''Default Menu Location''' Maintain >> System >> Rule Maintenance '''Function''' This rule maps column headers of the CSV format spre..."

2022-07-18T16:14:18Z

Created page with "__NOTOC__ ===General Information=== '''Default Menu Location''' Maintain >> System >> Rule Maintenance '''Function''' This rule maps column headers of the CSV format spre..."

New page

__NOTOC__

===General Information===
'''Default Menu Location''' Maintain >> System >> Rule Maintenance

'''Function''' This rule maps column headers of the CSV format spreadsheet for importing quote lines to specific configuration questions. The 'Import Column' entry in the rule must EXACTLY match the column heading in the spreadsheet in order to import.

[[File: Quote_Import_Mapping_Screen.png]]

===Rule Setup – Text Fields===
'''Import Column (text1, char, 50):''' Enter the column heading as it displays on the spreadsheet you're using for the import.

'''SOC Report Code (text2, char, 10):''' Enter the report code of the matched item's configuration question that the column's value should update. The following report codes are hardcoded since they relate to fields on the Customer Quote screen (instead of configuration questions):

''PRICE'' - This maps to the Sell Price field on the Line Items tab;

''SHIPWHSE'' - Transfers to the Ship Warehouse field on the Line Items tab;

''PLANT'' - Transfers to the Plant field on the Line Items tab;

''PRODNOTES'' - Transfers to the Production section of the line item notes;

''DESCRIP'' - Overrides the item description on the Line Items tab.

[[Category: Quoting]]
[[Category: Rule Maintenance]]

← Older revision		Revision as of 19:04, 21 July 2022
Line 1:		Line 1:
−	~~__NOTOC__~~	+	#REDIRECT [[Quote Import Mapping Rule]]
−
−	~~===General Information===~~
−	~~'''Default Menu Location''' Maintain >> System >> Rule Maintenance~~
−
−
−	'''Function''' This rule maps column headers of the CSV format spreadsheet for importing quote lines to specific configuration questions. The 'Import Column' entry in the rule must EXACTLY match the column heading in the spreadsheet in order to import.
−
−	[[~~File: Quote_Import_Mapping_Screen.png]]~~
−
−	~~===Rule Setup – Text Fields===~~
−	~~'''~~Import ~~Column (text1, char, 50):''' Enter the column heading as it displays on the spreadsheet you're using for the import.~~
−
−
−	'''SOC Report Code (text2, char, 10):''' Enter the report code of the matched item's configuration question that the column's value should update. The following report codes are hardcoded since they relate to fields on the Customer Quote screen (instead of configuration questions):
−
−	~~''PRICE'' - This maps to the Sell Price field on the Line Items tab;~~
−
−	~~''SHIPWHSE'' - Transfers to the Ship Warehouse field on the Line Items tab;~~
−
−	~~''PLANT'' - Transfers to the Plant field on the Line Items tab;~~
−
−	~~''PRODNOTES'' - Transfers to the Production section of the line item notes;~~
−
−	~~''DESCRIP'' - Overrides the item description on the Line Items tab.~~
−
−
−	~~[[Category: Quoting]]~~
−	~~[[Category:~~ Rule ~~Maintenance~~]]

Quote Import Mapping - Revision history

Vtran: Redirected page to Quote Import Mapping Rule

Vtran: Created page with "__NOTOC__ ===General Information=== '''Default Menu Location''' Maintain >> System >> Rule Maintenance '''Function''' This rule maps column headers of the CSV format spre..."

Vtran: Created page with "NOTOC ===General Information=== '''Default Menu Location''' Maintain >> System >> Rule Maintenance '''Function''' This rule maps column headers of the CSV format spre..."