{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Info","1_open items-invoice","2_open items-SBI"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Info","index":0,"n_rows":113,"n_cols":4,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"EN please see below…"]
[]
[]
[null,null,null,"Tabellenblatt 1 Anfragen bezüglich offener Posten Rechnungsverfahren"]
[null,null,null,"Tabellenblatt 2 für Anfragen bezüglich offener Posten  Gutschriftsverfahren"]
[null,null,null,"Gutschriften werden automatisch nur für gebuchte Wareneingänge erstellt. "]
[null,null,null,"Wurde Ihre Lieferung von BMW vereinnahmt?"]
[]
[null,null,null,"Bitte folgen Sie den Anweisungen auf Tabellenblatt 1 und 2 um Ihre Rechnungen und Gutschriften anzuzeigen. "]
[null,null,null,"Falls Sie noch keinen Zugang zum Info Portal haben, schicken Sie eine Email an einvoicing-infoportal@bmwgroup.com. "]
[null,null,null,"Nach erfolgreichem Onboarding erhalten Sie eine Email mit Ihren Login Daten. "]
[]
[]
[]
[null,null,null,"Work sheet 1  for requests relating to open items invoice "]
[null,null,null,"Work sheet  2 for requests relating to open items SBI"]
[null,null,null,"Self-Bills will be automatically only for posted goods receipts compiled."]
[null,null,null,"Have the supplies been collected by BMW ? "]
[]
[null,null,null,"Please follow the steps mentioned on the work sheets 1 and 2 in order to search for your invoices and self billed invoices. "]
[null,null,null,"In case you do not have access to the Info Portal yet, please send an email to einvoicing-infoportal@bmwgroup.com. "]
[null,null,null,"After successful onboarding, you will receive an email with your login credentials. "]
[]
[]
[]
[null,"Example"]
[null,"1. You want to search for several invoices and look up their status. In order to do so, please open tab 1 and fill in all affected invoice numbers and respective information, such as follows. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. Now click on the button \"Convert\", and copy cell \"H4\". "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. Click on the link to access Info Portal, login and open report \"Invoices / Self Billed Invoices\". Check your search window, necessary search criteria needs to be populated. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4. Paste the content of cell \"H4\" into search field \"Partner invoice number\" and click on search. You should get all relevant invoice information displayed according to your search. "]

{"sheet":"1_open items-invoice","index":1,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,1,29,1]]}
[]
["Rechnungs-nummer / Invoice Number"]
[null,"Please fill in all information, if you have any inquiries on open SBI items. \nPlease use the Info Portal in order to self-check your SBIs before sending a request to BMW. \n\nSteps: \n1. Please fill in or copy your delivery note numbers into column A. Please note that you can search for a maximum of 1.000 line items. \n\n2. Click on button \"Convert\" in order to convert all line items into the correct format (which is supported by Info Portal).  \n\n3. Copy the converted format (cell B2) and paste it to the respective search field (Delivery note number) in report \"Invoices / Self Billed Invoices\" on the Info Portal.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"--> Click here to access Info Portal"]

{"sheet":"2_open items-SBI","index":2,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[[5,1,32,1]]}
[]
["Lieferant \nLieferscheinNr. / Delivery Note"]
[]
[]
[]
[null,"Please fill in all information, if you have any inquiries on open SBI items. \nPlease use the Info Portal in order to self-check your SBIs before sending a request to BMW. \n\nSteps: \n1. Please fill in or copy your delivery note numbers into column A. Please note that you can search for a maximum of 1.000 line items. \n\n2. Click on button \"Convert\" in order to convert all line items into the correct format (which is supported by Info Portal).  \n\n3. Copy the converted format (cell B3) and paste it to the respective search field (Delivery note number) in report \"Invoices / Self Billed Invoices\" on the Info Portal.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"--> Click here to access Info Portal"]