{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Choose","Buying Organisation","Supplier","NA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":54,"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":"Choose","index":0,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[29,1,34,10],[8,1,14,10],[23,1,23,5],[24,1,24,5],[25,1,25,5],[24,6,24,10],[25,6,25,10],[23,6,23,10],[16,1,20,10],[1,1,6,5],[26,1,26,5],[26,6,26,10],[27,1,27,5],[27,6,27,10]]}
[]
[null,"Basware Commerce Network - Buyer & Supplier Advanced Business Connection Form"]
[]
[]
[]
[]
[]
[]
[null,"Introduction:\n\nThis form is used to implement a back office integration between a buying organisation and a supplier through the Basware Commerce Network. Once completed, this document will allow Basware to configure the Basware Commerce Network with the buyer and supplier technical details and perform end to end testing of the integration.\n\nThis form needs to be completed by both the Buying organisation and the supplier before it can be actioned by Basware. Please read the below instructions and then select the tab relevant to you, or click on the relevant button at the bottom of this page"]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions:\n\nComplete the section of the form that is relevant to you (Buyer or Supplier section)\nIf the remaining section has not yet been completed, send this to the Buyer or Supplier (as applicable) to complete their section\n\nIf all sections are complete, save the form and send to the Buyer so they can raise a case via ServiceNow (https://basware.service-now.com/bw)"]
[]
[]
[]
[]
[]
[null,"Pre-requisites:"]
[null,"Buyer",null,null,null,null,"Supplier"]
[null,"Completed buyer section of this form",null,null,null,null,"Completed supplier section of this form"]
[null,"Be a live buyer transacting on Basware",null,null,null,null,"Be a fully registered supplier on Basware"]
[null,null,null,null,null,null,"Possess technical capability to process XML"]
[null,null,null,null,null,null,"Obtained agreement from buying organsation that they are happy to support testing"]
[]
[null,"Compulsory sections:\n\nIf a third party supplier is involved, who is not currently contracted with Basware, then they MUST complete an NDA form before configuration can commence.\n\nAll Mandatory fields must be completed"]
[]
[]
[]
[]
[]
[]
[null,"Please click the relevant option below to navigate directly to the desired tab:"]

{"sheet":"Buying Organisation","index":1,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,1,2,2],[10,1,10,2],[4,1,8,4],[23,3,26,3],[27,2,31,2],[27,3,31,3],[21,1,21,3],[23,2,26,2],[18,1,18,3],[19,1,19,3]]}
[]
[]
[null,"Buyer Section - to be completed by Buying Organisation"]
[]
[null,"Introduction:\nThis section is for completion by the buying organisation who is integrating with the supplier. All fields outlined below should be completed with the requested information before being returned to the Basware Service Desk for processing.\n\nOnce complete, save the form (with both sections completed by both Buyer and Supplier) and send to the Buyer so they can raise a case via ServiceNow (https://basware.service-now.com/bw)"]
[]
[]
[]
[]
[]
[null,"A) Form Completed By"]
[null,"Name*"]
[null,"Role"]
[null,"Email Address*"]
[null,"Phone Number*"]
[null,"Date"]
[null,"* Mandatory Field"]
[]
[null,"B) Do you have back office integration enabled for any other suppliers within the Basware Network?"]
[null,"Please select:"]
[]
[null,"C) Organisation Details - to be completed by Buyer"]
[null,"Organisation ","Details","Notes"]
[]
[null,"Organisation Name (Mandatory)"]
[]
[null,"Note – Max 50 characters"]
[]
[null,"Organisation DUNS Number (Mandatory)"]
[]
[null,"Unique nine digit identification number identifying you as a single business entity"]
[null,"Note - Once specified this cannot be changed."]
[]
[]
[null,"Please ensure all mandatory fields are completed before returning the form to the Service Desk"]

{"sheet":"Supplier","index":2,"n_rows":133,"n_cols":27,"rows_kept":133,"cut":false,"hidden":false,"merged":[[126,1,126,2],[92,1,92,3],[103,1,103,2],[65,1,65,3],[58,1,58,2],[59,1,59,2],[74,2,74,3],[89,2,89,3],[87,1,87,3],[121,1,121,3],[73,1,73,3],[91,1,91,3],[109,1,109,2],[114,1,114,2],[88,1,88,3],[96,1,96,2],[95,1,95,2],[90,2,90,3],[94,1,94,3],[2,1,2,2],[5,1,9,4],[33,1,33,3],[35,2,39,2],[35,3,39,3],[11,1,15,4],[25,1,25,2],[17,1,17,3],[18,1,20,3],[22,1,22,3],[23,1,23,3],[47,1,47,2],[64,1,64,4],[40,2,44,2],[40,3,44,3],[49,1,49,2],[50,1,50,2]]}
[]
[]
[null,"Supplier Section - to be completed by Supplier"]
[]
[]
[null,"Introduction:\nThis section is for completion by the supplier who is integrating with the buying organisation. \n\nPlease select the integration method you wish to use for trading with the buyer listed in this workbook. Basware provide 3 integration options and details of how each one functions, along with the supplier pre-requisites for use of the solution, can be found in the supporting fact sheet - http://suppliers.basware.co.uk/wp-content/uploads/2015/10/6__Supplier_Connectivity.pdf:\nHTTP\nSWS\nSP Connect\n\nOnce you select your desired option below, the form will filter to present only the boxes you need to complete. All fields outlined below should be completed with the requested information before sending to the Buyer so they can raise a case via ServiceNow (https://basware.service-now.com/bw)"]
[]
[]
[]
[]
[]
[null,"Important Information:\nIf you require any bespoke formats of XML, outside of the standard cXML format then this will be a chargeable service. All integrations listed below utilising the standard cXML are provided as a free of charge service.\n\nThe cXML sent as part of the back office integration will be sent with a core set of XML tags included, regardless of the buying organisation. Some buying organisations may send additional values within a larger number of XML tags, but others may not (depending upon their configuration). Therefore, in order to integrate you will be required to be able to cope with both scenarios, but as a minimum you will need to handle the core data.\n\nIf you use a third party supplier to administer your back office integrations then a Non Disclosure Agreement must be completed"]
[]
[]
[]
[]
[]
[null,"Please select one of the below options based upon the integration option you require:"]
[]
[]
[]
[]
[null,"A) Are you currently Back Office Integrated with any Buyer(s) on the Basware Commerce Network?"]
[null,"Please select:"]
[]
[null,"B) Form Completed By"]
[null,"Name*"]
[null,"Role"]
[null,"Email Address*"]
[null,"Phone Number*"]
[null,"Date"]
[null,"*Mandatory Fields"]
[]
[null,"C) Organisation Details"]
[null,"Organisation","Details","Notes"]
[]
[null,"Organisation Name (Mandatory)"]
[]
[null,"Note – Max 50 characters"]
[]
[]
[null,"Organisation DUNS Number (Mandatory)"]
[]
[null,"Unique nine digit identification number identifying you as a single business entity"]
[null,"Note - Once specified this cannot be changed."]
[]
[]
[null,"D) Do you use a third party supplier for integrations?\nIf a third party is involved in the integration (they may administer your back office system) then a Non Disclosure Agreement (NDA) will need to be completed. Please specify below, fill out requested details and the Service Desk will circulate a copy of the NDA to be completed by your third party supplier"]
[null,"Do you use a third party?","Please select:"]
[null,"There is no requirement for a Non Disclosure Agreement, please continue"]
[null,"A Non Disclosure agreement is required before any configuration work can commence. Please complete the below details and the Service Desk will circulate the NDA to your third party supplier"]
[null,"Third party supplier name"]
[null,"Third party supplier contact name"]
[null,"Third party supplier contact email address"]
[]
[]
[]
[]
[null,"E) Transmission and Document Chosen Options - (please note by default you will be provided with all document types)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[null,"(Should you wish to receive a file format other than the free of charge cXML, for example BASDA, OAG or EDI, to receive a quote please contact the Service Desk on 0845 603 2885 or at support@procserve.com)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HTTPS"]
[null,"Document Type ","Please select below:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SWS"]
[null,"PO","Please select:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP Connect"]
[null,"Invoice","Please select:"]
[null,"Credit Note","Please select:"]
[null,"Please note: The default Basware offering is based on the cXML standard. If you require any bespoke data values to be included within the cXML or can only support other file formats and standards, please email support@procserve.com and request a contact from Basware to discuss these options and the potential costs that may be incurred to provide these"]
[null,"Please note that for each of the document types, Basware cannot guarantee that the data contained within is the same for each customer. The reason being that:"]
[null,"-     some customers pass only the minimum data on the PO"]
[null,"-     different XML standards support different data and therefore when mapping from one to another the lowest common denominator applies"]
[]
[]
[null,"HTTPS"]
[null,"Please complete the details below:"]
[]
[null,"HTTPS Details"]
[null,"Please select your data delivery method","Please select:"]
[null,"Test System ","Supplier receiving documents i.e. PO ","Supplier sending Documents i.e. Invoice"]
[null,"Your URL "]
[null,"Your IP address "]
[null,"Basware URL","https://preprod-connect.procserveonline.com/GetList","https://preprod-connect.procserveonline.com/SendFile"]
[null,"Basware IP address ","216.219.77.126"]
[]
[null,"Live System ","Supplier receiving documents ","Supplier sending Documents "]
[null,"Your URL "]
[null,"Your IP address "]
[null,"Basware URL ","https://connect.procserveonline.com/GetList","https://connect.procserveonline.com/SendFile"]
[null,"Basware IP address ","212.124.239.230"]
[]
[null,"How you want to receive your documents i.e. PO "]
[null,"Authentication details (if required) "]
[null,"ID:"]
[null,"Password:"]
[null,"How you want to send your documents i.e. Invoice"]
[null,"Please note - Basware will circulate your username and password to enable you to send documents"]
[]
[null,"Authentication method for multiple buyers"]
[null,"Are you planning on integrating with multiple buyers on the Basware Commerce Network through the connection form, or only the buying organisation specified?",null,"Please select:"]
[null,"Does your system authenticate orders from different buyers using the same method? E.g. if you receive orders from 1 buyer and decide to integrate with a second buyer in the future, would you authenticate the orders using the same method?",null,"Please select:"]
[]
[null,"Please ensure all mandatory fields are completed before returning the form to the Service Desk at support@procserve.com"]
[]
[]
[null,"SWS Details"]
[]
[null,"Test System"]
[null,"Your Certificate  "]
[null,"Your Provider"]
[null,"Basware Test URL ","https://preprod-sws.supplierportal.co.uk"]
[null,"Basware IP address ","167.216.140.168"]
[]
[null,"Live System"]
[null,"Your Certificate  "]
[null,"Your Provider"]
[null,"Basware Live URL ","https://sws.supplierportal.co.uk"]
[null,"Basware IP address ","212.124.224.168"]
[null,"If you have selected SWS on this Advanced Business Connections Form, once we have received this form with the SWS request and certificates, we will configure your account and apply the certificates.  You will be notified by email once your configuration is complete.  "]
[null,"For Technical documentation on SWS or how to obtain a certificate, please click the URL below:"]
[null,"http://suppliers.basware.co.uk/options/integration/"]
[]
[null,"Please ensure all mandatory fields are completed before returning the form to the Service Desk at support@procserve.com"]
[]
[null,"Sp Connect"]
[null,"If you have selected Sp Connect on this Advanced Business Connections Form, once we have received this with the Sp Connect request we will configure your account.  You be notified by email once your configuration is complete.  You can then download the software via the Supplier Portal.  It only takes a few minutes to download. "]
[null,"Please note that you will need an active log in for Basware in order to access the Supplier Portal and download the client."]
[]
[]
[null,"For Technical documentation on Sp Connect please click the URL below:"]
[null,"G) Completed By"]
[null,"Name"]
[null,"Role"]
[null,"Date"]
[null,"Further details can be found at the following URL:"]
[null,"http://suppliers.basware.co.uk/options/integration/"]
[null,"Please ensure all mandatory fields are completed before returning the form to the Service Desk at support@procserve.com"]

{"sheet":"NA","index":3,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Please select:"]
["Yes"]
["No"]
["Don’t know"]
[]
["Please select:"]
["Form Data"]
["Body Data"]
[]
["Please select:"]
["I am integrating with multiple buyers"]
["I am integrating with only the buyer specified in this form"]