Excel BOM Import - Revision history

Freddy at 16:34, 25 July 2025

2025-07-25T16:34:04Z

Mwillard at 01:30, 31 July 2024

2024-07-31T01:30:58Z

Tcampbell at 22:30, 7 December 2022

2022-12-07T22:30:12Z

Tcampbell at 22:29, 7 December 2022

2022-12-07T22:29:47Z

Tcampbell at 20:17, 6 December 2022

2022-12-06T20:17:50Z

Tcampbell at 20:15, 6 December 2022

2022-12-06T20:15:42Z

DavidT at 14:50, 5 April 2022

2022-04-05T14:50:50Z

DavidT at 14:50, 5 April 2022

2022-04-05T14:50:25Z

DavidT at 14:46, 5 April 2022

2022-04-05T14:46:00Z

DavidT at 14:45, 5 April 2022

2022-04-05T14:45:38Z

← Older revision		Revision as of 16:34, 25 July 2025
Line 102:		Line 102:

	[[category:Item Control]]		[[category:Item Control]]
		+	[[Category:Production]]

← Older revision		Revision as of 01:30, 31 July 2024
Line 65:		Line 65:

	'''13.''' Once production has been completed, ship(invoice) both orders.		'''13.''' Once production has been completed, ship(invoice) both orders.
		+
		+	===Spreadsheet Format===
		+	The spreadsheet should be formatted as follows:
		+
		+	At least two worksheets, with the item list starting on Sheet2. Sheet1 can be left blank or act as a title page. Additional sheets after sheet2 can also contain items.
		+
		+	The item list must start on Row 13. Column headers are not required.
		+
		+	Column A = Qty (Make sure the column header for this is 'Quantity'. If the column header is something else - 'Qty', for example -- Adjutant will try to import the column headers onto the sales order.)
		+
		+	Column B = Piece Mark (SOC Report Code = A)
		+
		+	Column C = Description
		+
		+	Column D = Color Name
		+
		+	Column E = Drawing (not used in import)
		+
		+	Column F = Length in Ft-In (not used in import). If ROOFSLOPE is active then the roof slope can be entered into this column (will be mapped to any configuration question where the report code = 'S').
		+
		+	Column G = Cut Length in Ft-In (not used in import). If MBSWT is enabled, the value from column G is imported as the weight for that line. If MBSTOTWT is active, the value from column G is divided by the number of pieces to determine the weight of the individual pieces. In other words, the weight on the import is treated as an extended weight. (The weight can be saved as the answer to a configuration question if the report code = 'W'.) If MBSTOTWT is active then MBSWT needs to be active as well.
		+
		+	Column H = Punch Pattern (separate your leading and trailing punch with a dash; e.g. A-A)
		+
		+	Column I = Length in Decimal Inches (this is converted to ft-inch length and stuffed into SOC Report Code = B)
		+
		+	Column J = Class
		+
		+	Column K = Part
		+
		+	Column L = Thickness/Gauge
		+
		+	Column M = Color Code
		+
		+	Columns J, K, L, and M are not required, but will speed up the import process if filled out. See the "Matching Logic" section for more info.
		+
	[[category:Item Control]]		[[category:Item Control]]

← Older revision		Revision as of 22:30, 7 December 2022
Line 65:		Line 65:

	'''13.''' Once production has been completed, ship(invoice) both orders.		'''13.''' Once production has been completed, ship(invoice) both orders.
		+	[[category:Item Control]]

@@ Line 1: / Line 1: @@
 ===General Description===
 '''Default Menu Location''' Transaction >> Importers/Exporters >> MBS/QuestWare Integration >> Excel BOM Import/BOM to Excel
-'''URL''' mbsgrid_s.htm
+'''URL''': mbsgrid_s.htm
 ===Step By Step Guide For Metal Building Creation (MBS to Adjutant)===

@@ Line 3: / Line 3: @@
 '''Default Menu Location''' Transaction >> Importers/Exporters >> MBS/QuestWare Integration >> Excel BOM Import/BOM to Excel
-'''Screen Name''' MBSGRID
+'''URL''' mbsgrid_s.htm
 ===Step By Step Guide For Metal Building Creation (MBS to Adjutant)===
@@ Line 42: / Line 42: @@
-'''9.'''  Open the [^mbsgrid|Excel BOM Import] screen '''TRANSACTION --> IMPORTERS/EXPORTERS --> MBS QUESTWARE INTEGRATION --> BOM EXCEL FILE IMPORT'''
+'''9.'''  Open the [[Excel BOM Import]] screen '''TRANSACTION --> IMPORTERS/EXPORTERS --> MBS QUESTWARE INTEGRATION --> BOM EXCEL FILE IMPORT'''
 Fill in all corresponding information (Sales Order, Project, etc), then click the 'Process' button.
-[imageauto||{UP}/MBSBOMexport2.png]
+[[image:MBSBOMexport2.png]]
 '''10.'''  Use the 'BOM-Item Master Match Up' screen in order to map item codes from MBS to the item codes in Adjutant.  Items with existing cross references are displayed in Green, unmatched items are Red/Pink. Selecting the green disk saves the cross references made during the session.
-[imageauto||{UP}/MBSMatchup2.png]
+[[image:MBSMatchup2.png]]
 Both item code(Adjutant) and item description(Adjutant) are searchable.

@@ Line 52: / Line 52: @@
 [imageauto||{UP}/MBSMatchup2.png]
-{s:yellow
+Both item code(Adjutant) and item description(Adjutant) are searchable.
 '''11.'''  Once all items have been matched, click the BLUE save disk in the upper right hand corner. The GREEN save button allows you to save current matchups if user cannot finish the process in one session.
@@ Line 61: / Line 59: @@
 '''12.'''  Upon saving, Adjutant will then create a BOM Sales Order that matches the existing Sales Order (created in step 2).  The order will have the prefix 'BOM'.  This order is the order which the user will send to production.
-{s:yellow
-| text = *NOTE Adjutant will ask if user wishes to load pricing.  Select 'NO' (prices will default to '0' on BOM order to eliminate possibility of 'double invoicing')
+*NOTE Adjutant will ask if user wishes to load pricing.  Select 'NO' (prices will default to '0' on BOM order to eliminate possibility of 'double invoicing')
-−
 '''13.''' Once production has been completed, ship(invoice) both orders.

@@ Line 11: / Line 11: @@
 '''2.''' Create Sales Order from the Project screen for the building order by using the create SO button on the right side of the screen [[File:New_SO_button.png]] This sales order will have one line item. Line item will be "Metal Building" (additional line item with freight).  Once added on the Sales Order, system will ask configuration questions for the building (sizes, footage, etc.)
 [[File:MBS_NEW_SO.png]]
@@ Line 16: / Line 17: @@
   *NOTE Do not enter any costs on this Sales Order (cost will come from the BOM Sales Order, which is discussed below)
 </pre>
 '''3.''' Open up the [http://www.abiscorp.com/faq/index.php?title=MBS_to_Excel BOM TO EXCEL] screen in Adjutant: '''TRANSACTION --> IMPORTERS/EXPORTERS --> MBS QUESTWARE INTEGRATION --> BOM TO EXCEL'''

@@ Line 35: / Line 35: @@
 '''8.''' Once the file has been generated, user can go into the file and make any edits to the BOM necessary. Save file on desktop or within the appropriate Project Document Vault, and CLOSE THE FILE.
-<pre style="color: yellow">
+<pre style="color: red">
 *NOTE The Excel file must be saved as a XLXS type.
 </pre>