Information Systems:Updating MMBC

This is a non-profit organization that is fully financed by industry to manage residential packaging and printed paper recycling programs in BC, either directly or by working with local governments, First Nations, private companies, and other non-profit organizations. (www.multimaterialbc.ca)

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.

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’.

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.

The update function in IN_MMBC02 calls CL program MMBC02, which calls RPG program MMBC03.

MMBC in InfoNet Partner Maintenance

A 'user defined field can be added to indicate whether or not the vendor is registered with MMBC. The options are -

in progress
no            uniPHARM is responsible for payment to MMBC
BC resident   
yes           vendor is responsible for payment to MMBC

MMBC in InfoNet Item Maintenance

If the main supplier is registered, the MMBC source is changed to 'Vendor Registered with MMBC', and not changes are allowed.

When changing the MMBC manually, the options are -

Averaged
BC Resident
Estimated
Manually Weighed
N/A
Vendor Registered with MMBC
Vendor Supplied
Yes