BuyOrder Insert

Copy lines of manually po’d items in BuyOrder Insert doc, into SQL script. Run errors then update BuyOrder Insert doc with correct color formatting.

Required Applications:

SSMS 18 or newer

Instructions

Launching Script

Open SSMS.
1. Connect to 192.168.10.204
2. Connect using AppUser Credentials.
Open BuyOrderScript.Sql
1. Scroll to line # 86.
Open BuyOrder Insert SharePoint page.
1. Navigate to TB1 Entry Tab.
2. Scroll to white rows at bottom of page.
3. Identify error codes passed in upload statement in column V.
  1. Pass error codes to Asset Manager.
4. Once resolved, copy white lines from column V in BuyOrder Insert doc.
Return to BuyOrderScript.Sql.
1. Paste white lines from column V in BuyOrder doc at line # 86 in BuyOrderScript.
2. Execute script by pressing F5.
Scroll to bottom of output window in SSMS.
1. If any errors, find line items in BuyOrder Insert doc and highlight them yellow.
2. Communicate errors to Asset Manager to resolve
3. Copy and paste the confnum column into column x.
4. Copy and paste the ponumber column into column y.
5. In Column W, write a vlookup in the first line uploaded.
  1. =vlookup(click column Q, click columnx:columnY,2,false)
  2. Use the confirmation number in column q of that line as your lookup value.
  3. Lookup against column X:Y.
  4. Return column 2.
  5. Copy and paste the vlookup down all lines just uploaded.
  6. Copy and paste the values of the vlookups on themselves.
  7. Turn Lines green.
Repeat process for TB2 Entry and TB3 Entry tabs.

Highlight important information in a panel like this one. To edit this panel's color or style, select one of the options in the menu.