UFFI step by step development for sales orders import into SAP Business One via XML

Step by step creation of a Boyum UFFI for importing sales orders from an XML file. This Mascidon demonstration shows in detail how to create a UFFI for importing sales orders. The initial 'simple' UFFI imports customer - item - quantity. Then we add the code to import the SAP B1 address IDs or ship to codes to get the order address information. Many on-line orders may use one time ship to addresses - so the code is enhanced to show how. Then we use an SAP quote as the 'base document' and import a sales order based on the quote. At this point our solution gets more specific. First we show how to include an SAP udf (user defined field) as part of the XML information imported. Then the issue of a customer using their part in the XML rather than the SAP item code is addressed - the BP Catalog is checked to retrieve the SAP item code. The next step provides storing the contact name, phone and email information in the sales order 'Opening remarks', and the entire XML file in the closing remarks - for easy retieval of the original order if necessary. The UFFI can result in errors if the expected XML data is not present. To address this Mascidon shows how to code around missing XML data. Our example is whether the 'email' tag is present or absent in the XML. Code is shown for how to check for this condition. This UFFI example is one of a group of UFFIs used to import most SAP B1 documents from XML files. Mascidon provides the Boyum XML export of these UFFIs for FREE - call 248-568-0418 or email [email protected].