Information Systems:Updating MMBC - Revision history

Johnt at 20:49, 11 July 2019

2019-07-11T20:49:29Z

2019-07-11T20:48:09Z

2019-06-13T22:32:30Z

Upload File from Excel

2019-06-13T22:30:34Z

Download File to Excel

2019-06-13T22:29:40Z

Download File to Excel

2019-06-13T22:20:22Z

Download File to Excel

2019-06-13T22:19:13Z

Download File to Excel

2019-06-13T22:08:42Z

Download File to Excel

2019-06-13T21:30:42Z

Download File to Excel

2019-06-13T21:30:15Z

Download File to Excel

@@ Line 24: / Line 24: @@
 #On the website indicated above, obtain a current list of the stewards that are registered in BC.  Suggestion is to print this list off (in 2019 this was 27 pages).
 #Based on the vendor name column, check on the print out to determine if any new vendors have registered in the past year.  Keep track of vendors in our system that will need to have their business partner information updated.
-## Update any new vendors in Business Partner maintenance - user defined - MMBC registered - if registered select "Vendor registered with MMBC" OR if Resident Steward select "BC Resident"
+## Update any changed vendors in Business Partner maintenance - user defined - MMBC registered - if registered select "Vendor registered with MMBC" OR if Resident Steward select "BC Resident"
 #On spreadsheet indicate these changes in Vendor Status column.
 #Fictitious items (Nancy) can be removed from spreadsheet.

@@ Line 24: / Line 24: @@
 #On the website indicated above, obtain a current list of the stewards that are registered in BC.  Suggestion is to print this list off (in 2019 this was 27 pages).
 #Based on the vendor name column, check on the print out to determine if any new vendors have registered in the past year.  Keep track of vendors in our system that will need to have their business partner information updated.
 #Fictitious items (Nancy) can be removed from spreadsheet.
 #Internal supply items can be removed from spreadsheet.

@@ Line 32: / Line 32: @@
 ==Upload File from Excel==
-Save the updated file as CSV.  This must be in the same format as was previously downloaded – you cannot insert or remove columns (however, you can add columns to the end; they will be ignored in the upload). In InfoNet, go to Maintenance & Lists / MMBC / Upload CSV File.  After it has been uploaded, the first 50 records of the file will be displayed.  If they look correct – like, for example, everything is in the correct column – click on ‘Update’.
+#Save the updated file (the spreadsheet that you have been working on above) as CSV.  This must be in the same format as was previously downloaded – you cannot insert or remove columns (however, you can add columns to the end; they will be ignored in the upload).
 The upload runs WebSmart program IN_MMBC01, which calls CL program MMBC01 to copy the file from the IFS to the data base file MMBCINTF.

@@ Line 27: / Line 27: @@
 #Internal supply items can be removed from spreadsheet.
 #For the remaining item records - need to determine the various column weights (grams) as needed - this can be obtained by contacting the manufacturer for the information OR physically inspecting and weighing the packaging material OR by estimation based on a similar item from the same manufacturer.  NOTE: This step will take HOURS/DAYS/WEEKS to complete.
-#The spreadsheet will update the units sold times the various weights columns and provide totals at the bottom.  These totals at the bottom will be what is used when logging into the recyclebc website and completing our annual activity report.
+#The spreadsheet will update/calculate the units sold times the various weights columns and provide totals at the bottom and far right columns.  These totals at the bottom will be what is used when logging into the recyclebc website and completing our annual activity report.
 #Once all items have been reviewed & checked it is time to upload this spreadsheet back into the item master.  Steps below.

@@ Line 24: / Line 24: @@
 #On the website indicated above, obtain a current list of the stewards that are registered in BC.  Suggestion is to print this list off (in 2019 this was 27 pages).
 #Based on the vendor name column, check on the print out to determine if any new vendors have registered in the past year.  Keep track of vendors in our system that will need to have their business partner information updated.
 #The spreadsheet will update the units sold times the various weights columns and provide totals at the bottom.  These totals at the bottom will be what is used when logging into the recyclebc website and completing our annual activity report.
 #Once all items have been reviewed & checked it is time to upload this spreadsheet back into the item master.  Steps below.

@@ Line 20: / Line 20: @@
 #Copy formulas down to bottom of data records and paste on current spreadsheet.
 #Copy from column BO (go to the very bottom) and now copy the remaining rows that contain all the totals into the new spreadsheet.  Note: you will probably have to edit the formulas to account for new data records.
 ==Upload File from Excel==

@@ Line 15: / Line 15: @@
 This will create an Excel file of item information, sales, and MMBC rates that have been previously uploaded.  Items with main suppliers that are registered with MMBC are not included.
 #The file is saved on superserver/buying/common/Multi Material BC (example: sls2018.xlsx)
 #Open the previous years spreadsheet.  Copy columns BN1:DR2 (headers) and past into current years spreadsheet.
@@ Line 21: / Line 20: @@
 #Copy formulas down to bottom of data records and paste on current spreadsheet.
 #Copy from column BO (go to the very bottom) and now copy the remaining rows that contain all the totals into the new spreadsheet.  Note: you will probably have to edit the formulas to account for new data records.
 ==Upload File from Excel==

@@ Line 10: / Line 10: @@
 ==Download File to Excel==
 In InfoNet, go to UniView / Sales Statistics / Summarized Item Sales.  Set ‘From Year/Month’ and ‘To Year/Month’ so that the entire year is included, and click on ‘Search’.  Then click on ‘MMBC to Excel’.
 This will create an Excel file of item information, sales, and MMBC rates that have been previously uploaded.  Items with main suppliers that are registered with MMBC are not included.
-The user can key in new rates, calculate our payment, then upload the updated rates back into the i.
+The user can key in new rates, calculate our payment, then upload the updated rates back into the I.
 ==Upload File from Excel==