trade creditors guidelines – rsa : supermarket suppliers
Contents
1. D E F G H 1 J K 25 SS TEMA 21 INVOICE 521237 214117 05 08 2005 43505 STORE 054584 05 08 2005 0 00 1275 39 25 SS TEMA 21 INVOICE 521245 219497 05 09 2005 43505 STORE 054897 05 09 2005 0 00 810 19 25 SS TEMA 31 RCLAIM 521237 214117 05 08 2005 43505 STORE 214117 05 08 2005 0 00 156 63 25 SS TEMA 34 PCLAIM 521237 054584 05 08 2005 43505 STORE 214117 05 08 2005 156 63 0 00 25 SS TEMA 99 CREDITNOTE 521237 05 08 2005 43505 STORE 214117 05 09 2005 156 52 0 00 25 SS TEMA 34 PCLAIM 521245 054897 05 09 2005 43505 STORE 219497 05 09 2005 99 50 0 00 25 SS TEMA 34 PCLAIM 521252 055103 05 09 2005 43505 STORE 223562 05 09 2005 73 58 0 00 25 SS TEMA 31 CLAIM 521259 227939 05 09 2005 43505 STORE 227939 05 09 2005 0 00 88 20 25 SS TEMA 34 PCLAIM 521259 055371 05 09 2005 43505 STORE 227939 05 09 2005 88 20 0 00 25 SS TEMA 99 CREDITNOTE 521259 05 09 2005 48505 STORE 227939 05 09 2005 88 13 0 00 25 31 CLAIM 531243 329180 05 08 2005 41626 UU NEWTOWN 329180 05 08 2005 0 00 339 43 73 EXP CLAIM JHB709 0000008 31 03 2008 DC 000008 01 04 2008 17842 29 A RECORD CLASS B DESCRIPTION RECORD CLASS C BATCH NUMBER D REF if Sclaim or Pclaim inv number to which it refers INVOICE 21 NUMBER E DATE2. Namibia Checkers Select Open EXCEL Print Please type in a store number Filter by Number E Please type in a store name Filter by Name 1 Select All E Click on Column Headers to sort Store Telephone Fax Trading Branch Number Store Name c Physical Address Physical Location IT Brand Code Division Region Number Number Status Manager Checkers 474 Closed Store closed 6001001004701 Closed Store Was Old Maeruy Namibia Mani Closed Division Office 5212 eee rete Khomas L Whitaker Region 264 61271820 264 61256796 Trading Charlotte Farmer Gustav Voigts Centre Windhoek Khomas Namibia Checkers 6265 Checkers Windhoek 6001001063609 GU Een L Whitaker Region 264 61237410 264 61226074 Trading Hans Shaanika Checkers 42185 6001001421505 Hidas Centre Nelson Mandela Ave Division L Whittaker Region 264 61245490 264 61225427 Trading Shirley Tsamaseb Checkers 55372 Checkers Academia 8001001553704 Plato Street Academia Faser Knee perked L Whittaker Region 264 61400572 264 61400574 Trading Julanda Finies Figure 2 How to filter by store number 40 To filter by a store number type the store s unique number see figure 4 e g 2701 and click the Filter by Number There is no need to make any selection
3. Select All Click on Column Headers to sort Brand 91 StoreName GLNCode Physical Address Physical Location Division Region Telephone Branch Checkers 2492 6001001024907 Gauteng eun 0114391100 0118675736 Trading Doep Du Plessis 2701 en typer tractet 6001001027007 ree Mei on Mica Hyper Region 02198080 021980453 Trading Kobus Matthee 9795 Felis seq 8001001097901 Ok Furniture Brackenfel South Africa poset Closed mm 44909 m le001001449007 raroridge mat Ok cape son Aba Diver Hyper Region Zo 0219608453 Trading Uthaler Medie 82218 Mr Brackenfell 6001001822107 Fairbridge Mall Old Paar Road Western Cape South i crie Division man 219822650 0219822653 Trading 2 Local intranet Figure 6 43 The select All Button The Select All Button will return the data for all the stores for all the countries that belongs to the Shoprite Group WebF orm Microsoft Internet Explorer Edit View Favorites Tools Help AN JD sro O 2 5 d LJ 3 Address http localhost GLNReport WebForm 1 aspx pdf J E search o T por
4. 37 Pastel Accounting System 23 July 2010 TO TRADE and EXPENSE DEBTORS Attention The Financial Director DEBTORS DEPT Dear Sir Madam YOUR DEBTORS SYSTEM PASTEL PARTNER EXPRESS We are aware that converting your financial information into the pre defined Excel Statement format as per our guidelines could be and most probably is a time consuming process We are pleased to advise that we were approached by a software company Selected Business Systems who have developed a program for vendors using Pastel Partner Express whether you are using an open item system or balance brought forward system to enable them to convert existing Pastel statements into the Excel format required by ourselves To assist you in the submission of your statements you could consider making use of this service The software is referred to as PasCheck and converts the data into Excel format within minutes 1 Selected Business Systems charges an annual licensing fee of R960 for the first year with an escalation based on inflation 2 The software used by Selected Business Systems is for vendors who use Excel version 2003 and 2007 3 Selected Business Systems will email the procedures to be followed by you 4 Telephonic assistance is also supplied at no charge 5 No other costs are involved other than call out charges should a client request on site support Should you wish to make use of this facility Selected Business S
5. DATE CLAIM DATE F DIVISION BRANCH NUMBER G BRANCH NAME H REFERENCE INVOICE CLAIM OR CREDIT NOTE NUMBER 1 DATE INVOICE OR CLAIM DATE J DUE BY YOU K DUETO YOU ANNEXURE F PROCEDURES TO OPEN IMPORT YOUR LIST OF UNMATCHED DOCUMENTS AND OR REMITTANCE ADVICE INTO EXCEL Make sure the Regional and Language Options on your computer is set as follows to ensure correct date imports NB Once points A L below is done you do not require doing it again Click on Start on the toolbar at the bottom of the screen Click on Settings if Control Panel is not directly visible Click on Control Panel Double click on Regional and Language Options Click the Regional Options header Pp re arog eh 14 Click on Customize Click the Date header Change the Short date format to dd MM yyyy Click on Apply Click on OK Click on OK Click on close the file 1 Save attachment on your PC s hard drive by either of the following two options depending what program you use for E Mail Outlook Outlook Express Lotus etc a Outlook and some Outlook Express versions 1 2 3 4 5 6 7 8 9 10 Open your E mail Click on inbox Double click on the mail that was send to you from Filedist Right click on Attachment Choose option Save As Next to Save in Click on and choose t
6. is the claim number When passing a credit note always use the number in the reference field Annexure B PAYMENT METHODS i ii iii Cheques must be collected from our Divisional Accounts Office by a person who you have authorized and notified us in writing of such authorization The value of money due will not be given over the telephone as all the relevant information will appear on the remittance advice Remittance Advices will under no circumstances be faxed to any supplier Kindly arrange with the Divisional Office at address Lower Level Office C11 Accra Mall Teteh Quarshie Roundabout Accra Ghana that you either collect your remittance advice or have it posted to you 7 2 The following is currently available to all suppliers registered B2B Claims Overcharge claims 34 Return claims Shortage claims 31S CMGJ Unresolved Invoices Claims Orders Automatic transfer Manager User CMPF Remittance Advice Reports Guidelines Statements B2B Ensure that all electronic documents are saved by yourselves for future reference SECTION B 1 DIVISIONAL ACCOUNTS OFFICE DAO i All queries relating to unpaid Tax Invoices credit notes and claims must be raised with the Divisional Accounts Office DAO in Ghana Contact person Johan Tomlinsonl Tel no 00 233 302823023 Fax no 00 233 302823027 E mail jtomlinson shoprite co z
7. 1022 100 32 290601 1022 71 59 200601 1284 649 80 50601 1284 191 52 280601 987 4719 60 300601 987 15657 32 80601 987 3624 82 10601 1014 2010 96 220601 1014 4264 17 250601 1014 19211 85 170601 1014 19864 50 280601 1014 3351 60 300601 DI 1438686 87 290601 PA 11349638 61 300601 CB 4782231 76 ANNEXURE G b ELECTRONIC SUPPLIER STATEMENT 20 amp Suppliername Statement Message 4 a cm D 4 i File Edit View Insert Format Tools Table Window WI Wie APP eee WEE ER NES Subject 2 Suppliername Statement Attach 3 ET statement xls 14 KB J Attachment Options NT i 3 PROCESS 1 The email address to send the statement is statements shoprite co za In the subject line enter Your company name followed by a space and the word Statement e g Clover Statement 3 Attach the statement 4 Send ANNEXURE ELECTRONIC SUPPLIER STATEMENT ZIP FILE 21 4 Suppliername Statement Message Microsoft Word File Edit Insert Format Tools Table Window Help Normal TimesNewRoman 12 B Z U eje elt 8 10 0 gisend 0 E 4 HTML xii See Bec Subject 4 Suppliername Statement Attach 1 cons
8. Date Info Branch Amount Error message 12 B 71940 07 No reference present nation 12 B 71940 07 Date missing 12 B 71940 07 INFO incorrect should be IN CR DI PA or CB Search 12 B 71940 07 Branch number missing 13 B 71940 07 No CB at end of statement nents ct us Unable to accept File Please correct the errors and try again ut 15 When submitting your statement you may choose to receive email notifications to keep you updated with the status of your statement Indicate whether you wish to receive emails by putting a tick in the checkbox remember to double check the e mail address in the text box above the submit button Shoprite Online Statements Checking the status of an uploaded statement 16 When logging in to the website the day after uploading your statement you will see a summary of your most recent statements on the main statements screen For full breakdown of previous statements sent click on View tatements View New Orders View Old Most recently uploaded Orders Statement date 28 07 2006 Date Loaded 26 02 2007 10 31 40 AM Opening Balance 10 00 Closing Balance 10 00 Information Status Uploaded Order Search View All Statements Contact us Upload Statement Log Out Statement File Browse Upload Statement 17 Once you have uploaded the file please check that your statement has been successfully submitted 1 Uploaded This means it has
9. Delimited 2 Click on Next for the following page 3 Click on Comma Keep the right mark in Tab 4 Click on Next for the following page 5 A Data Preview with several different columns should be visible These columns all have the same header named General 6 Click on the header General of column 5 date 7 Under column data format click on Date 8 Click on next to date and select 9 Repeat steps 7 and 8 for column 9 date as well 10 Click on Finish Your file is now imported into Excel 11 Click on the little blank block just above the no 1 line indicator to highlight the whole worksheet or alternatively highlight all the columns with info inside 12 Click on Format on the menu and choose columns Wait for the sub menu to appear and choose Auto fit selection by clicking on it All columns will now be formatted so that the info fits nicely into it 13 Click on File and choose the option Save As 14 On the Save As screen look for Save as Type Click and choose Microsoft Excel Workbook xls 15 Click on Save or press Enter Your file attachment has now been saved in an Excel format 16 Repeat steps 1 16 for each remittance attachment you have saved 3 For Opening CMGJ Unmatched Documents Open Excel and follow the following steps for each file attachment saved a b c G
10. B 21 74 jd V Reply with Changes End Review Cd Print Ctrl P 250107 Send To 2 pe View 11 1 OB 35853 68 2 811337 230107 2604 11053 17 3 811608 240107 2387 16888 82 4 811647 240107 43953 1067 59 8 812238 250107 41422 7076 81 6 CB 71940 07 p 26 2 Enter a name and select CSV MS DOS CSV as the Type j My 0 1 V9 Reply with Changes End Review 250107 a 000011596 5 Recent ee i 000025242 csv i T000032182 csv 7 2 000079966 5 9 000200224 5 Desktop 1 T000202111 csv aj T00204692 csv f N 2 My Documents Network Places Save as type File name nyFileName csv CSV 5 005 csv Text MS DOS txt C cin csy Cancel i v DIF Data Interchange Format diF SYLK Symbolic Link slk Microsoft Office Excel Add In xla 3 Click Save once you have selected the file type and entered a filename This will cause Excel to pop up a message box asking you to confirm your actions and telling you that some formatting will be lost this is fine Simply click Yes OB 35853 68 230107 2604 11053 17 240107 2387 16888 82 240107 43953 1067 59 p 2 Microsoft Excel myFileName cs may contain Features that are no
11. E SHOPRITE CJ Business 1 Checkers Online Shoprite GLN Report Date 2009 10 27 South Africa Select All Select i Please make use of the selection options on the left hand side to start Please type store number Filter by Number Please type in a store Filter by Name Select All amp Done amp J Local intranet Figure 7 Open in Excel and Print The Open in EXCEL and Print button only appears if six or more branches are returned from the system They will disappear when less than six stores are returned If you click the button Open in EXCEL the file will open a Download File dialog box Do you want to open or save this file see figure 9 If you click on Open the GLN Report will automatically paste into Excel The Excel GLN Location report can be formatted with data filter and columns can be adjusted to fit the page If you click on the Save it will download to your machine or file path specified by you If you click on the cancel it will return to the Location report Figure 10 returns the print screen of the report On the left hand side the PRINT button appears If you click on print your printer properties box will appear from where you can print the report Please ensure that your page setup is set to Landscape before printing the report 44 WebForm1 Microsoft Internet Explorer Edit View Favorites Tools Q O x She Favorites
12. 2 Ds Address http ocalhost GLNReport WebForm 1 aspx Se od y 4 Business Online Date 2009 10 27 Please type in store number Please type in a store name Telephone Notis Fax Number Atlantis Dassenberg 8001001000307 1 Innering Rd Town Centre Western Cape South 0215724451 0215723241 Africa Namib Cntre Valhalla Drive Lavis Matroosfontein 6001001000505 Drive Western 0219355260 0219355272 Cape South Africa Cape Town Diep River Western Cape South Africa 1600100100703 ShoPrte Diep River 207 217 Main Cnr Hugo And Voortrekker Rds Goodwood Western Cnr Hugo 8 Voortrekker Rds Cape South Africa 0215913133 6001001000901 nears Cape 10539273730 6001001001106 Stella Str Africa 6001001001304 258 Main Road Figure 8 File Download Do you want to open or save this file GLNReport csv Type Microsoft Office Excel Comma Separated Values Fil From localhost While files from the Intemet can be useful some files can potentially harm your computer If you do not trust the source do not open or save this file What s the risk Figure 9 45 Shoprite GLN Report Date 2009 10 27 Physical Address Physical Location 6001001000901 6001001
13. INV 15 05 2005 831316 15 05 2005 1371 08 cun SS TEMA STORE 035442 88 INV 15 05 2005 831316 15 05 2005 1371 08 41625 UU NEWTOWN 035442 88 INV 15 05 2005 000411 15 05 2005 731 24 A638 UU NEWTOWN 035442 88 INV 15 05 2005 000489 15 05 2005 731 24 mum UU NEWTOWN 035442 88 INV 15 05 2005 830845 15 05 2005 548 43 41625 UU NEWTOWN 035442 88 INV 15 05 2005 831173 15 05 2005 548 43 pe UU NEWTOWN 035442 88 INV 15 05 2005 831415 15 05 2005 365 62 41625 UU NEWTOWN 035442 88 INV 15 05 2005 831416 15 05 2005 365 62 ee UU NEWTOWN 035442 88 INV 15 05 2005 831896 15 05 2005 694 67 41626 UU NEWTOWN 035442 88 INV 15 05 2005 832441 15 05 2005 521 io UU NEWTOWN 521292 34 PCLM 115600 15 10 2004 924524 13 10 2004 15 32 DC JHB 709 73 000008 30 3 2008 000008 01 04 2008 A DIV BRANCH NUMBER B BRANCH NAME C BATCH NUMBER D RECORD CLASS E DESCRIPTION RECORD CLASS PCLM PRICE SHORT RETURN CLM MANUAL INV INVOICE F REF S CLM INV NO P CLM INV NO R CLM CLAIM NO G DATE H FIRST TIME APPEARANCE OLDER THAN 3 MONTHS REFERENCE CLAIM NUMBER OR INVOICE NUMBER J DATE K INVOICE AMOUNT L CLAIM AMOUNT 13
14. been sent on so that all the values transactions and balances can be checked and confirmed 2 Accepted green statement successfully processed 32 3 Rejected red Statement not processed due to errors To view the errors click on details ANNEXURE H Shoprite Checkers E Commerce B2B Business to Business claims Accessing claims Access the Shoprite Checkers E commerce B2B web site using the following Internet address https www shoprite co za b2b 1 Open your desktop browser application and enter the following Internet address https www shoprite co za b2b in the address space and press enter 2 Type in user name 3a Click on password 3b Type in password 4 Click on login 5 Select view claims Cursor must look like a hand The following steps can be used to view the claims 6a Click on next to see all current claims Claims that have not been viewed or sorted out b Type in claim number and click on next c Type in branch number and click on next 33 d Click on next to DAO and select the DAO that you want to view Click on next e Type in start date and end date of the claims and click on next f Select DAO and put in the start date and the end date Click on next You can View printable copy E mail or Download the claims View printable copy 1 Click in the select box next to the claim or claims that you want to view 8 Click on view printable copy 9 Click on
15. in red The image shows two drop down boxes and a select button The boxes work in conjunction with the select button The default value for the country is South Africa and for the brand is Select All This means that once you click on Select all the stores in South Africa will be displayed You can change the values in the drop down boxes for example Namibia and Checkers figure2 by clicking on the drop down arrows and select a country or brand If you want all the stores for a selected country leave the second drop down box as Select AII or change the value for a specific brand and click Select 39 Edt yew Favorites Jools Help O O X i2 5 2 erem Da3 Address http flocalhost GLNReport WebForm 1 aspx v E3e pd Search 20 45 POF LL eem zn SHOPRITE C3 Business E Checkers Online Shoprite GLN Report Date 2009 10 27 South Afnca Select All se Please make use of the selection options on the left hand side to start Please type in a store number Filter by Number Please type in a store name Filter by Name Select All Figure 1 WebForm1 Microsoft Internet x Edit View Favorites Tools a O 8 f Ps Yee GL Address htto Jocalhost GLNReport WebForm1 aspx 8 pdf 2 sal Search 0 25 PoF 5 Business skers Online Shoprite GLN Report Date 2009 10 27
16. relevant DAO TAX INVOICE Do not issue an invoice with a serialized number starting with an alpha 4 or O as our branches will punch it as a numeric 1 or 0 and the system will not match and pay above invoices REQUIREMENTS FOR THE TAX INVOICE The word Tax Invoice in a prominent place The name address and VAT registration number of supplier The name and address of the recipient An individual serialized number and date on which Tax Invoice is issued e Description of the goods supplied a b 2 aS 4 1 The quantity or volume of goods supplied ii Total of quantity or volume of goods supplied at end of Invoice iii The value of each supply as well as the Vat charged on each supply iv The total value and total Vat charged at end of Invoice Where the Vat charged is included in the total value a statement that Vat is included and the percentage N B We prefer nett price per line inclusive of Tax 5 CLAIMS i a Copies of Claims will only be supplied as the exception and not the rule and can be obtained from the DAO within 30 days from first appearing on our remittance advice When requesting claims ensure all the detail as per the CMGJ is submitted per line item on a spreadsheet see B2B Annexure J b Queries relating to SHORT and RETURN claims must always be i vi emailed on a SEPARATE spreadsheet please ensure that the CMGJ forma
17. the credit to be passed by the supplier must be recorded in column H amount supplier to pass credit Forward this schedule on an Excel spreadsheet to the Buyer via email ASAP NB Also DELIVER the spreadsheet together with the relevant propdoc invoice amp claim documents for investigation by the Buyer no investigation will take place until this is received by the buyer Do NOT complete the column Dept amp Sub BUYER In the event of a claim being valid delete it from the spreadsheet BEFORE submitting to the DAO In the amount supplier to pass credit column COL H you have to indicate what credit the supplier will pass If the cell COL H is left BLANK then the claim will be reversed in FULL You have to email the spreadsheet to the DAO The column highlighted in RED Dept amp Sub must be completed by yourself at the time of authorising the reversal leave blank if not to be reversed DAO in the event that a portion of the claim is valid the FULL claim value must be reversed Process a price claim for the value in the amount supplier to pass credit column COL H Process a reversal of the price claim when COL H transactions if left BLANK Amount supplier Invoice topass Number Credit Division Branch Name Claim no Grand total Buyer Name Date only necessary on copy Buyer Signature returned to supplier Divisional Head Buyer Signature
18. 001304 6001001001502 6001001001700 Innering Rd Town Centre 6001001000703 SoPrite Diep River 207 217 Main Cnr Hugo And Voortrekker Rds Cnr Hugo amp Voortrekker Rds 6001001001106 4 Str 178 Voortrekker Road 178 Voortrekker 6001001001908 365 Road 6001001002103 Shoprite Grahamstown Road lAtlantis Dassenberg Western Cape South Africa Cape Town Sea Point Western Cape South Africa Africa Cnr Berg River Boulevard and Van Der Western Cape South Western Cape Lingen Street i jvisi Division 10155161348 0215913133
19. 26 January 2015 SHOPRITE CHECKERS LIMITED TRADE CREDITORS GUIDELINES GHANA SUPERMARKET SUPPLIERS ONLY INTRODUCTION The purpose of this document is to communicate the correct procedures for suppliers when submitting documents and to assist in ensuring timeous payment SECTION A 1 DELIVERY DOCUMENTS i iii We will only accept Tax Invoices with deliveries In order for payments to be timeous we require an original Tax Invoice and a copy Tax Invoice to accompany all deliveries to our branches The copy Tax Invoice must be retained by the supplier as Proof of Delivery Should your driver present a Delivery Note it will be your responsibility to ensure that this is retained as proof of delivery until such time as a Tax Invoice has been submitted to the Divisional Accounts Office to use for payment purposes which will result in late payment of your Tax Invoice Some Tax Invoices reads Tax Invoice Delivery Note This causes confusion and is sometimes taken in as a Delivery Note which causes a delay in payment The Tax Invoice should read Tax Invoice only 2 GOODS RECEIVED STAMP All supplier deliveries including deliveries carried out by agents such as Road Transport and Freight companies requires Shoprite Goods Received Stamp GRN imprint and all the required details completed in full on your Tax Invoice in order to qualify as a Proof of Delivery POD The GRN number is critical and delivery documents without a GR
20. ION Suppliers are not entitled to cede or factory any rights arising from orders places by the Company without the Company s prior written consent Should the Company agree to the cession or factoring of rights then the Supplier shall in time notify the Company in writing of such cession or factoring taking effect 6 COURIER SERVICES i Suppliers who are making use of courier services to collect their documents must please ensure that completed waybills are supplied as our staff do not complete these waybills 7 REVIEW OF YOUR EMAIL ADDRESS Please note that it is your responsibility to maintain this communication service and advise us of any change of address Yours faithfully ALVIN KING GROUP CREDITORS MANAGER trade cred Ghana 11 MONTHLY PRINT OUT LIST OF UNMATCHED DOCUMENTS PURPOSE OF THIS DOCUMENT The purpose of this document is to enable you to ascertain which of your Tax Invoices have either not been paid yet or which have not yet been matched with the relevant GRN s It also assists you to establish for which claims you still have to pass credit notes or credit notes that have not matched with the relevant claims Current transactions are indicated with an asterisk next to the date We suggest you wait until you receive the following month s CMGJ report and if these transactions are still unmatched please contact the Divisional Accounts Office N B Please ensure that
21. ITE ONLINE STATEMENTS B2B 24 GENERAL REQUIREMENTS 9e Lm 10 11 12 13 14 16 Statement MUST be saved in CSV Comma Delimited or MS DOS format see Saving as CSV documentations 17 Statement MUST be in a balance brought forward format No open item statements with consolidated statements can be accepted 18 a Please ensure that the layout is exactly as in the example attached Complete the excel statement as follows Line 1 column B capture the word Statement Line 2 column B capture the words Supplier Name Line 2 column C capture your Company name e g ABC Line 3 column B capture the words Supplier Number Line 3 column C e g capture your supplier number 123456 six digits pad with Line 4 column B capture the word Month Line 4 column C capture the date e g 300606 six digits 30 June 2006 as 300606 Line 5 empty Line 6 column A capture the word Seq Line 6 column B capture the words Ref no Line 6 column C capture the word Date Line 6 column D capture the word Info Line 6 column E capture the words No Line 6 column capture the word Amount Start with opening balance on line 7 column F and indicate all types of transactions as follows in column D OB Opening Balance CR Credit notes IN Invoices Debits PA Payments DI Discounts CB Closing Balance N B b Process credit for payment and discount separately ensure the minus indica
22. L statement be required the date of the 27 ADDITIONAL statement must now read 02 07 06 Only send an additional statement once the previous statement has been processed Only send one statement per day 2 The OPENING balance on the statement must always be the closing balance of the previous statement or ADDITIONAL statement submitted Once all ADDITIONAL statements have been submitted and the normal monthly statement is then submitted the date of the normal monthly statement must read 31 07 06 xii Statement values must be reflected in Ghana Shillings NAME CHANGES Should a supplier undergo a name change these details must be conveyed to the Buyer Kwame Larbi Siaw email address klarbisiaw shoprite co za CHANGES IN OWNERSHIP Should a supplier undergo a change in ownership these details must be conveyed to the Buyer Kwame Larbi Siaw email address klarbi siaw shoprite co za BANK DETAIL CHANGES When changing your bank details we need the following i An original cancelled cheque or ii An original letter with a bank stamped from the bank stating the account name and number iii Confirmation of bank details your company letterhead signed by one of the directors owner iv If account holders name on cheques differs from the name in our record an indemnity form must be completed and signed by an authorized director member of the company before any changes will be effected in our books 10 5 CESS
23. N number will not be accepted and payment will be delayed 3 DELIVERIES WITH MORE THAN ONE CARTON i Deliveries by agents e g Road Transport must clearly reflect the Shoprite Purchase Order Number on the consignment note or waybill Tax Invoice numbers must also be filled in on the consignment note waybill and likewise the consignment note waybill number must also be cross referenced on the Tax Invoice ORDER NUMBER i ii The order number must appear on all delivery documents Kindly issue only one Tax Invoice per order to avoid delay in payment Stock not ordered or substituted stock will under no circumstances be accepted or paid for YOUR ACCOUNT i i iii We require that your account is kept in a current state We regard up to 90 days as current CMGJ The CMGJ is a monthly report of outstanding invoices and unresolved claims payments PA and or discounts DI b All INVOICES older than 90 days as per our report CMGJ must be cleared by passing a credit note or supplying the relevant Divisional Accounts Office with the require P O D when requested within the 90 day period see Section B point 2 c All CLAIMS older than 90 days as per our report CMGJ must be cleared by passing a credit note or supplying the relevant Divisional Accounts Office with the necessary information that the claim is either invalid incorrect or that a credit note has already been passed see Sect
24. a csv file See the user manual concerning the file format for help Upload Statement Statement File C Documents and Setti Browse lo 12 It might take some time for the system to upload the file to Shoprite s web server this will depend on the size of the file you are uploading and the speed of the internet connection you re using Once the file has been uploaded it will be checked for basic errors in the formatting Should the file not contain any formatting errors you will be allowed to submit it 13 Click on submit mo A 4 ww wT SS Checkers Online Statements RETAILER BAKING Document Summary tion Line Ref Date Info Branch Amount arch 7 2007 01 25 OB 35853 68 12 CB 71940 07 Expected 71940 07 us Your statement format is correct and can now be submitted Please Click Submit to continue Send me an E Mail natification when there is a change in status me webmail co za 14 Should your statement contain any formatting errors you will be notified of those errors and you will not be able to submit the statement for processing until they have been fixed Note the error description and the line number on which it occurred Find the file on your computer and correct these errors and save file Then upload the statement again 31 E gt eusinuss Gheekers Online Statements RETAILER BAKING Jld Line
25. a 2 UNPAID TAX INVOICES When querying unpaid Tax Invoices with the DAO the following schedule must be submitted in the format indicated hereunder G R N VALUE ascending order INVOICE INVOICE DATE NO Do not include current Tax Invoices on this schedule If they do not appear on the next payment advice as paid then prepare and submit the schedule as indicated above i It is imperative that outstanding payments are fully investigated by yourselves for accuracy before unpaid invoices are listed on a spread sheet and e mailed to the DAO e g check that the Branch number on the POD s are the SAME as the Branch number on the if not CREDIT the Branch number as it appears on the CMGJ and DEBIT the Branch number as per the using the SAME Reference number and value ii Care should also be taken when entering Branch numbers on the Statements Any wrong Branch number and or reference numbers and or amounts will lead to non timeous payment Do not fax any unrequested documentation to the DAO as all communications must be via e mail NB Requested POD s must be delivered to the DAO If you have the facility physical POD s can also be scanned and e mailed as PDF files Regrettably no fax copies of POD s would be accepted DOUBLE DEDUCTIONS SEE SECTION C PAR 1 iv In order to expedite the investigation of double deductions contact the
26. a delivery note packing slip does not form part of the documents when delivering goods The documents required at our Receiving Department to effect payment is a Tax Invoice amp Copy Tax Invoice The copy Tax Invoice must be the P O D which your driver agent returns to your company DOCUMENT DETAILS DAO Divisional Account Office BRANCH Number and name of branch BATCH NO 6 Digit reference This is an internal number and should be quoted when querying something OUR REF Claim or Tax Invoice no DATE Claim or Tax Invoice date RECORD CLASS 91CLM Manual claim at DAO 31RCLM Return claim 31SCLM Shortage claim 34PCLM Overcharge claim 88 Invoice ex statement 12 CMGJ A B D E F G H J K L 25T 43505 SS STORE 035442 88 INV 15 05 2005 000488 15 05 2005 457 03 43505 SS TEMA STORE 521126 31 RCLM 022075 06 05 2005 022075 06 05 2005 63 92 SS STORE 521349 31 RCLM 117629 15 12 2005 117629 15 12 2005 307 12 Ar SS TEMA STORE 521297 31 056471 23 02 2006 367609 23 02 2006 62 64 pua SS TEMA STORE 035442 88 INV 15 05 2005 830846 15 05 2005 914 05 43505 SS STORE 035442 88 INV 15 05 2005 830847 15 05 2005 914 05 43508 SS STORE 035442 88 INV 15 05 2005 831174 15 05 2005 914 05 qu SS TEMA STORE 035442 88
27. ape South Africa Division Region 10219808400 0219808453 Trading Kobus Matthee Done amp J Local intranet Figure 4 How to filter by a store Name To filter by a store name type in the stores name or part of it see figure 6 e g Bracken for Brackenfell and click on Filter by Name This will return all the stores with the sequence of letters Bracken in the name This search is not case sensitive therefore the name does not need to be in the correct case There s no need to make any selections from any other drop down boxes 42 PI Edt Vw Favorites Tools 42 De de dL RA Ad ress http Aocalost GLNReport VebForm 1 3 px SHOPRITE Business Checkers Online Shoprite GLN Report Date 2009 10 27 South Afnca Select All Select Please make use of the selection options on the left hand side to start Please type in a store number Filter by Number Please type in a store name Filter by Name Select Ail Figure 5 Edit View Favorites Tools Help a O O DAG e dem 2 2 9 0 S Address 4 http localhost GLNReport WebForm 1 aspx pdf 2 SHOPRITE Business Checkers Online Shoprite GLN Report Date 2009 10 27 i South Africa Select All Select Please type in a store number Filter by Number Bracken
28. ble when suppliers send us a zipped statement file Specific requirements 1 Supplier number Six digits with no separator e g 123447 Month MUST be your monthly cut off date i e 25 30 etc Also adhere to point 3 below 3 Date No day month or year separators such as or or are allowed Format the column as a text column and give the date purely as a number e g 12 June 2003 should read as 120603 Please do not give the year as 2003 but only as 03 requirements as per our Trade Creditors Guidelines are still applicable statements submitted via E Mail must be submitted to the following E Mail address statements shoprite co za Statements submitted to any other address will not be processed and regarded as if never received See Trade Creditors Guidelines Section C par 1 x Should you have any enquiries please phone the relevant clerk Please do not phone to establish whether we have received your statement See point 16 Yours faithfully ALVIN KING GROUP CREDITORS MANAGER E mailrequirements ANNEX Ga EXAMPLE OF SMENT ALL COUNTRIES Keep the yellow area unchanged Just fill in your details into the red area 1 10601 OB 17499217 01 2 182317 130601 CR 1006 242 82 3 151271 130601 CR 1014 38 07 4 631386 130601 CR 1014 70 47 ONO Oo 11 12 13 14 15 16 17 18 19 142825 483615 165008 165418 244216 245007 245008 242012 242950 243764 244404 244408 19 200601
29. cape 25 Click on OK 26 Click on print 27 Click on print 28 Close claim 29 Click on logout If you do not want to save the file do the following steps 1 Click in the select box next to the claims that you want to Download 2 Click on Download 3 Click on the word here 4 Click on open 5 Follow steps 16 29 under download Claims will not appear under current anymore but under old To see the claims again you must do the following 1 Click on old 2 Click on next The following steps can be used to view the old claims 3a Click on next to see all current claims Claims that have not been viewed or sorted out b Type in claim number and click on next c Type in branch number and click on next d Click on next to DAO and select the DAO that you want to view e Type in start date and end date of the claims and click on next 36 f Select and put in the start date and the end date Current claims must viewed daily otherwise the file will be too big if you want to e mail it You must then break up the claims according to the DAO s and dates before you e mail Should you have a problem contact Mubanga Muche 0925522 218 1272 business to business ANNEXURE 1 ALL AFRICA PROCEDURE PRICING CLAIMS Supplier s to complete the spreadsheet below by Branch no branch name claim no and claim value and indicate if VAT or NOT COL F For request for PART reversals
30. de any columns Use columns only as follows Column A sequence number Column B reference number Column C date Column D info Column E branch number and Column F amount No alpha numerics in the reference column B Only numerics Maximum last 6 digits of the invoice number if more than 6 If the Ref no is less than 6 digits e g 3456 enter only 4 digits No alpha numerics in the Branch no column E Only numerics Maximum 5 digits No page totals Statement MUST balance a No formula must be entered into the amount column including the closing balance The date of your statement your company name and your supplier number MUST be at the top of the sheet page as per the attached example No logos Before sending the statement off to us please ensure that your company name as well as the word statement is in the subject line just below the address see Annexure G a 16a Please ensure that you request a delivery receipt as well as a read receipt Microsoft Outlook go to Tools Options Preferences Email options Tracking options see Annexure G c for procedure 16b We will return a successfully processed or not successfully processed message to your official company e mail address Please keep this message as it will be your only proof of statements being received by us 18 17 Zipped files save your Excel spreadsheet as consolidated xls see Annexure G b N B Only applica
31. file 10 Click on page setup 11 Click on landscape 12 Click on OK 13 Click on print 14 Click on print 15 Close the claim 16 Click on logout E MAIL 1 Click in the select box next to the claims that you want to E mail 2 Click on E mail 3 Click on close 4 Click on logout Claims will go through to there E mail address 34 Download Supplier needs access to open file 10 11 12 13 14 15 16 17 18 19 20 21 22 Click in the select box next to the claims that you want to Download Click on Download Click on the word here Click on save Choose folder where you want to save it Rename it so you will recognize it later Click on save Click on close Open excel and follow the following steps for each file saved Click on file Click on open Click on next to look in and choose the folder where you have saved the file Click on next to files of Type at the bottom Click on All files Right click on file and go to open with and click on compressed zipped folders Right click on Inetpub and click on open Right click on wwwroot and click on open Right click on B2B New and click on open Right click on overcharges and click on open Right click on claim files and click on open Right click on Internet Icon and click on open Click on file 33 23 Click on page setup 24 Click on lands
32. fore submission Should the contra entry appear on the following month s statement please quote the original document number and cross out the current contra entry number The above should also be done when a credit is issued for a non delivery We will not accept faxed statements Branch 435 is not a valid branch and will appear on our report if no branch number or an incorrect branch number is supplied To correct issue a credit note using the same reference number as it appears as branch 5173 and re debit using the same reference and correct branch number viii Our system can only handle 6 numerical digits Should your Tax ix Invoice numbers consist of more than 6 digits then please adjust these by deleting the digits at the start of the number leaving the last 6 manual statements only Reference numbers referring to Debits and Credits are the only reference numbers to appear All other reference columns must be crossed out to ensure no delay in payment Separate entries are required for our payments and your discount where applicable i e 2 entries ADDITIONAL STATEMENT PROCEDURE The following must be adhered to when sending an ADDITIONAL statement 1 The DATE of the statement must always be the next day following the last statement processed EXAMPLE If the date of your last statement processed was 30 06 06 the date of your additional statement should read 01 07 06 Should a further ADDITIONA
33. he folder where you want to save it Next to File name Delete file name and rename the file so that you will recognize it later Never change the detail in Save as type Press Enter or click on Save Repeat steps 1 9 for all attachments b Allother programs where the above procedures do not work 1 2 3 4 5 6 7 8 9 10 Open your E mail Click on inbox Double click on the mail that was send to you from Filedist Double click on the attachment to open it in Notepad Some are too big for Notepad and you will be asked if you want to open it in Word Answer should be Yes Go to File and choose the option Save As Next to Save in Click on and choose the folder where you want to save it Next to File name Delete file name and rename the file so that you will recognize it later Never change the Save as type Press Enter or click on Save Repeat steps 1 9 for all attachments 2 For Opening Remittance Advice Open Excel and follow the following steps for each file attachment saved ap 15 Click on File and then click on Open Next to look in click on and choose the folder where you have saved the attachment file Next to Files of type click and click on files When you find your file select it and click on open A Text import Wizard will come up Follow the following steps 1 Click on
34. ion B paragraph 5 d All outstanding payments and discounts amp discount reversals as per our report must be cleared by passing a credit with a PA for payment on your next statement Non compliance to keep your account current could result in us not releasing the above reports and also the possibility of your cheque being withheld without any interest liability or penalty by way of a forfeiture of any discount to the Company see Annexure A for more information on the report iv v a The CMGJ will be available to all registered suppliers on internet B2B on a monthly basis b Those suppliers who are not registered on internet can collect the CMGJ monthly form the Divisional Accounts Office The CMGJ will exclude current invoices i e the CMGJ for 19 November will exclude invoices for November and October Only invoices for September and prior will be shown N B See Annexure F for procedures to open import CMGJ or CMPF into Excel iv CMGJ and CMPF To assist suppliers to identify to which invoice a short or price claim refers to the following The reference D on the CMPF Annexure E will reflect the supplier s Invoice number and the reference field H will be the claim number When passing a credit note always use the number in the reference field Annexure E The reference field on the will reflect the suppliers Invoice number and the reference field
35. ivisional Account Office can be contacted ii a JSuppliers can collect the remittance advice at the Divisional Account Office see B2B Annexure J b The CMPF will be available to all suppliers who are registered on B2B on a monthly basis SECTION C STATEMENT PROCEDURES Branch numbers consisting of 5 digits and NOT branch names must be recorded next to entries on the statements Non compliance with this requirement will result in payments being delayed ii Manual statements must be sent only to the Divisional Accounts Office Should you make use of a courier service please clearly mark the waybill for attention of CREDITORS DEPARTMENT b Statements can be submitted via e mail All statements submitted via e mail must only be submitted to the following e mail address statements shoprite co za Annexure G c It is recommended that statements be submitted via internet B2B Statements must reach the DAO office on or before the 8 of each month Late arrival will result in late payment a Credit note numbers must be crossed out replaced with our claim number Non compliance with this procedure will result in double deductions b Should the value of the credit note not agree with the value of the claim the credit note will also be deducted For manual statements all contra entries which appear on your current month s statement must be manually crossed out be
36. le and choose the option Save As 15 On the Save As screen look for Save As Type Click on it and choose Microsoft Excel Workbook xls 16 Click on Save or press Enter Your file attachment has now been saved in an Excel format and you can manipulate the date to your preference 17 Repeat steps 1 16 for each CMGJ attachment you have saved Any queries regarding the above procedure can be referred to CHARLES VICE 0925522 2181272 procedures for opening rem advice in excel ANNEXURE G STATEMENTS VIA E MAIL Our statement receiving system is a fully automated processing system To ensure smooth processing of your statement please attach your statement to an e mail which has the company name amp the word statement in the subject column see attached schedule A point 2 The system will automatically confirm receipt of your statement and will return all incorrect statements with reasons to your e mail address All electronic statements must comply with this format We enclose an example of a statement in the format we require As we will code it on the computer NO DEVIATIONS from the format attached can be allowed The following are the general requirements 1 Statement MUST be in Excel format 9 10 11 12 13 14 15 17 Statement MUST be in balance brought forward format No open item statements with consolidated statements can be accepted Use
37. o to File and then to Open Choose the folder where you have saved the attachment file Ensure that at the bottom of that window to open a file that the Files of type are set to All files by clicking on the arrow and choosing THE All files option When you find you file open it A Text import Wizard will come up Follow the following steps 1 Click on Fixed With 2 Click on Next for the following page 16 3 Delete all current Break lines by double clicking on the line 4 Insert new lines at the following intervals by using the ruler bar 3 10 13 28 34 45 57 58 62 68 74 91 110 124 5 Click on Next for the following page 6 A Data Preview with several different columns should be visible These columns all have the same header named General 7 Click on the header General of column 7 8 Format column by clicking on Date 9 Scroll down on date and select 10 Repeat steps 7 and 8 for column 12 as well 11 Click on Finish Your file is now imported into Excel 12 Click on the little blank block just above the no 1 line indicator to highlight the whole worksheet or alternatively highlight all the columns with info inside 13 Go to Format on the menu and choose columns Wait for the sub menu to appear and choose Auto fit selection by clicking on it columns will now be formatted so that the info fits nicely into it 14 Go to Fi
38. olidated zip 27 KB 4 WinZip Evaluation Version Consolidated zip File Actions Options Help w E New Open Favorites Add Extract View CheckOc Modified Size Ratio Packed Path 16 08 2006 08 4 180 736 85 27 883 At Selected 0 files 0 bytes Total 1 file 177KB Consolidated Microsoft Excel Worksheet Open New Print Open With 3 winzip 2 CD Add to zip file Add to Consolidated zip 05 Add to recently used zip file Send To Cut t9 Zip and E Mail Consolidated zip Copy t3 Zip and E Mail Plus 0 Configure Create Shortcut PROCESS 1 Save your excel statement as consolidated 2 Right click on excel file Click on WinZip Click on Add to 3 Consolidated zip 4 The e mail address to send the statement is statements shoprite co za In the subject line enter Your company name Statement e g Clover Statement Attach 22 Attach the zip file Send ANNEXURE G d PROCEDURE FOR A READ RECEIPT FOR STATEMENTS 1 Go to Microsoft outlook 23 2 Click on Tools 3 Click on Options 4 Click on E mail Options 5 Click on Tracking Options 6 Make a tick in Read receipt 7 Make a tick in Delivery receipt 8 Select Always send a response 9 Click on OK 10 Click on OK 11 Click on OK This process will acknowledgement that your e mail has been delivered and read procedure for a read receipt ANNEXURE G E AFRICA SHOPR
39. one worksheet only per file a Please ensure that the layout is exactly as in the example attached Complete the excel statement as follows Line 1 column B capture the word Statement Line 2 column B capture the words Supplier Line 2 column C capture your Company name e g ABC Line 3 column B capture the words Supplier Number Line 3 column C e g capture your supplier number 123456 six digits Line 4 column B capture the word Month Line 4 column C capture the date e g 300606 six digits Line 5 column A B C D E F empty Line 6 column A capture the word Seq Line 6 column B capture the words Ref no Line 6 column C capture the word Date Line 6 column D capture the word Info Line 6 column E capture the words No Line 6 column capture the word Amount Start with opening balance on line 7 column F and indicate all types of transactions as follows in column D OB Opening Balance CR Credit notes IN Invoices Debits PA Payments DI Discounts CB Closing Balance b Process credit for payment and discount separately ensure the minus indicator is entered for all credits credit notes payments and discount No open lines between transactions Only a point between Rands and cents will be accepted e g 20 00 Please do not use a comma separator for thousands as well as 2000 00 no spaces No open columns at the left of sequence number Never hi
40. s from any other drop down boxes Favorites Tools O O id yv 2 Ba Wa 3 Address 4 htp Aocalhost GUNReportANVebForm 1 aspx pdf Te A SHOPRITE Business E Checkers Online Shoprite GLN Report Date 2009 10 27 Namibia Checkers Select 7 Please make use of the selection options on the left hand side to start Please type in a store number Filter by Number Please type in a store name Figure 3 41 WebForm1 Microsoft Internet Explorer Edit Favorites Tools Help a MAG Pwo de 0 8 s http localhost GLNReport WebForm 1 aspx pdf 2 v senec 0 58 por gt SHOPRITE Business gt Checker Online Shoprite GLN Report Date 2009 10 27 Select All Select i ipo Filter by Number Please type in a store name Filter by Name Select ERE Click on Column Headers to sort Store amp z a E Telephone Fax Trading Branch Store Name Physical Address Physical Location Branch Brand Number GLH Code Division Region Number Number Status Manager Checkers Ch Hyper Fairbridge Mall Old Paar and Brackenfell Bracken Heights Western Western Cape Hyper Hyper 2701 Brackenfell 6001001027007 Oak Road C
41. summary screen allows you to upload a statement file by browsing your computer for the file you want to upload 6 Click on the Browse button Statements Contact us Upload Statement Log Out Statement File Browse Upload Statement 7 Using the explorer window that pops up after you clicked the Browse button find the statements file that you want to on your computer 8 Next to Look in Click on J and choose the folder where you have saved your statement 9 Next to Files of type Click on and click Files 10 When you find your file select it and click on open EEC oe Krme 60 2 4 Fe My Recent Documents S Shares on NetApp2 5 52 Users NetApp1 U Vi 52 shoptrackwiller on wlotz w BRANDS Desktop 5v ftpfiles on webdb3 2 52 Intranet Webtest webtest Y OQ gt Internet on Webtest webtest 2 107 10 31 40 AM My Documents In lO My Computer st T DECEM Filename zi Places Files of type All Files Statement File Upload Statement 30 The name and path of the file that you selected will now appear the textbox next to the Browse button You are now ready to upload the file 11 Click on Upload Statement to continue Remember the file must be a csv file or a zip file containing
42. t WITH headers is used see Annexure F for procedure Claim numbers whether for returns and or shortages are entered on our GRN stamp and copies are given to your driver agent lt is your responsibility to ensure that you obtain these copies from the driver agent and that they are passed on to your Debtors Department For every claim raised a separate credit note is required We will not accept one credit note for two claims or two credit notes for one claim Queries related to pricing claims must be discussed with the Buyer Annexture 1 Pricing claims raised due to incorrect punching by the store must be separated into a bundle and sent to the Divisional Financial Manager Mr S Pascoal When suppliers send substitutions for stock that has not been ordered a pricing claim for substitutions is created These claims must also not be sent to the Buyer and must therefore be credited by the supplier concerned A new order must be raised in all cases where stock is substituted 6 With regards to the above suppliers must provide the propdoc Tax Invoice order no and claim copy in order to eliminate any misunderstandings vii a Those suppliers who are not registered on B2B can collect the claim weekly from the Divisional Accounts Office b For suppliers B2B all balanced claims will be available on internet Annexure J REMITTANCE ADVICE CMPF i a If there are any queries on our remittance advice the D
43. t compatible with CS MS DOS Do you want to keep the workbook in this Format J keep this format which leaves out any incompatible Features click Yes To preserve the features click Then save a copy in the latest Excel Format see what might be lost click Help Yes No 5 the file has now been saved as a CSV file and is ready to upload via the website 27 Shoprite Online Statements User Guide How to upload a statement file This document contains a step by step guide to uploading your statement via Shoprite s B2B website https www shoprite co za b2b 1 Log on to the B2B website if you require any help with website access please do not hesitate to contact our helpdesk Stephen Smith Tel 021 980 4840 Email ssmith shoprite co za Gary Hinrichsen Tel 021 980 4135 Email ghinrichsen shoprite co za 2 Type in User Name lower caps 3 Type in Password lower caps 4 Click on Login SHOPRITE 3 Business Checkers Online F Login Register Maintain Accounts User Name eBusiness Password Helpline Barcode E Standards Login Change Password Forgot your password 5 Select Statements on the left hand side of the screen view New Orders h E View Old Orders lt Information Am a Order Search Contact us Log Out 29 The Statement
44. tor is entered for all credits credit notes payments and discount 19 No open lines between transactions 5A Only use a point for a decimal separator between Rand and Cents e g 20 00 5B Ensure that NO additional character is in front of your branch number invoice number or amount e g space of apostrophe No open columns at the left of sequence number No open lines at the end of the file Never hide any columns Use columns only as follows Column A sequence number Column B reference number Column C date Column D info Column E branch number and Column amount No alpha numerics in the reference column B Only numerics Maximum last 6 digits of the invoice number if more than 6 If the Ref no is less than 6 digits e g 3456 enter only 4 digits No alpha numerics in the Branch no column E Only numerics Maximum 5 digits No page totals Statement MUST balance a No formula must be entered into the amount column including the closing balance The date of your statement your company name and your supplier number MUST be at the top of the sheet page as per the attached example No logos ANNEXURE G Shoprite Online Statements Correct File Format CSV 25 The new format requires a CSV file To make things as simple as possible you can prepare the file in Excel and save as follows Saving the Excel file as a CSV file Insert Format Tools Data Window Help 8 02 5 21 10
45. ystems can be contacted at pascheck selected co za or telephone 27 32 586 1712 fax 086 6705006 cell 083 7008801 Ken Austin cell 083 7467871 Andrew Austin cell 083 2896765 Maria Austin Yours sincerely ALVIN KING GROUP CREDITORS MANAGER TEL 021 980 4839 FAX 021 980 4806 E MAIL aking shoprite co za 38 ANNEXURE L GLN Location Report Branch Details Introduction The new GLN Location Report offers a simplified way to retrieve store location data Accessing the new Report e Goto Shoprite Checkers Business on line Website address https www shoprite co za b2b e Enter user name and password and click on login e Click on Information on the left hand side e Select a depot depots e then click on Next e Click on the icon on the right hand side called MORE e The next page will open then click on icon Location e Click on View Report e System will wait until you select a country e report gives you options to filter for a specific group of branches i e checkers shoprite etc in a specific country e It also gives you the option to select all the branches in any of the countries e You can export the file to excel or print the report e Once the report is in excel format you can sort it by division e The has options to search for spescific store number or B specific store by name How to make a selection Look at figure1 at the section highlighted
Download Pdf Manuals
Related Search