SAP Business One ADDONS
PrintManager The Print Manager application opens up whole new opportunities to use the master data from your SAP Business One Database to more effectively communicate with your customers, suppliers or leads through its ‘mail merge’ capabilities. The application allows you to seamlessly export data from you master records into Microsoft Word templates which can then be used for any purpose. For example: · Creating newsletters to send out to business partners · Creating promotional leaflets · Creating letters for groups of, or individual business partners · Creating envelopes The exported date can also be filtered either by the embedded filters such as by Business Partner; Group, Type, Property, Postcode or position or alternatively by dynamic filters which are easily created using a simple SQL clause, giving you the opportunity to filter the master data by any means necessary. APIObserver A tool designed to serve functionality of the SAP DI-objects using only SQL-scripts. Great application to build "integration" data flows, data movements between two or more databases, recurrent and initial imports, etc. You can build automated processes based on SBO_TransactionNotification procedures (without any additional programming skills - only TSQL ). Examples/Scenarios: - Intercompany Trading
- Intercompany Consolidations
- Internal Integration (New BP will create "ShadowBP" for example )
- Automated messaging (SalesOrder placed from VIP will generate Internal/External message)
- Automation of documents
- Automated confirmation (Automated e-mail when Order is Approoved )
- many many more.
APIObaserver is a very sophisticated tool - windows NT service to be installed on the MS Windows/MS SQL server. APIObserver v4.0 - object overview
0. Possible / most popular scenarios: - PurchaseOrder in one Company (SALES) becomes SalesOrder in second company (PRODUCTION) - DeliveryNote in PRODUCTION Company becomes - GRPO in SALES Company - SalesOrder in branch become PurchaseOrder in branch and SalesOrder in HeadOffice - every changes on SalesOrder in HeadOffice - will be transferred to branch PurchaseOrder
- "whenever Production order is changed - related SalesOrder (DeliveryDate) will be changed" - "whenever DueDate on SalesOrder is changed - system will send e-mail to the Customer" - "Internal messaging between SAP databases" - "Everytime when new SalesOrder arrive from WEBShop - the message will be sent to SalesManager"
- "Consolidate every JournalEntry to the CONSOLIDATION database" - "Every time when ITEM is created in MASTER database this Item is created in every CHILD database" - "Every time when CUSTOMER is created in HeadOffice DB - it is replicated to Branch Databases"
- "Everytime when new ADDRESS is created against MASTER BPCODE - the new BusinessPartner is created as well with the proper Address entry" - "Take data from SQLWebShop and create SALES ORDER in SAP Business One System"
- "Take data from MySQLWebShop Database and create ITEM/SALES ORDER in SAP BusinessOne system"
- "Every time when new SALES ORDER is created - export it to SQLServer / SQLTable - System / WEBSHOP / CRMSystem"
and many many more....
1. Uses one SAPuser 2. Uses No "ProfessionalLicense" - only 1 AddonLicense 3. Can be installed along SAP2005, SAP2007A/B , SAP8.8 (Tests) 4. Works with SAP ONLY through SDK DI-API Interface 5. Works with up to 2- external data connections (MSSQL, MYSQL, ODBC) 6. Actions 'A' - Ad new object 'U' - Update existing objects 'I' - Update existing objects or Add if not exist 'C' - Close (if applicable) 'L' - Cancel (if applicable) 'R' - Release - (if applicable)
7. Objects list 2 - oBusinessPartners - SAP BusinessPartners MasterData 11 - oContactPersons - SAP BusinessPartners - ContactPersons -21 - oAddresses 4 - oItems - SAP BusinessOne Item MasterData 1 - oAccount - SAP BusinessOne ChartOfAccounts 30 - oJournalEntries 13 - oInvoices 14 - oCreditNotes 15 - oDeliveryNotes 16 - oReturns 17 - oOrders 18 - oPurchaseInvoices 19 - oPurchaseCreditNotes 20 - oPurchaseDeliveryNotes 21 - oPurchaseReturns 22 - oPurchaseOrders 23 - oQuotations 59 - oInventoryGenEntry 60 - oInventoryGenExit 122 - oDrafts 163 - oCorrectionPurchaseInvoice 164 - oCorrectionPurchaseInvoiceReversal 165 - oCorrectionInvoice 166 - oCorrectionInvoiceReversal
156 - oPickList 69 - oProductionOrder 81 - oMessage 153 - oUserTable 999 - oQuery - free SQLQuery table can be transferred onto second server/database.
MobileScanning A handheld wireless scanning application enabled for warehouse processes and production which has the potential to be tailored to unique customer needs and business processes. Warehouse Usability: The Mobile Scanning Add-On gives you the ability to transform warehouse processes by providing the ability to pick or receive goods on a portable handheld scanner directly from the original purchase or sales order stored in your SAP Business One database. This efficient system ensures that orders and deliveries are correct before shipping or taking delivery to reduce the time and cost of error whilst speeding up the process. The scanners can also be configured so that every item handled must be scanned, creating a means of quality control. Once the picking or receiving of goods has been completed, the Mobile Scanning Add-On automatically creates a respective Delivery Note or Goods Receipt which is entered automatically into your SAP Business One system as a target document. Additionally, the Mobile Scanning Add-On has been developed to work with serial numbers. The scanning device is configured not just for individual item and batch serial numbers, but also pallet and carton configurations. Production Usability: When using the Mobile Scanning Add-On in production, released work orders can be chosen via the handheld device from which goods can be issued from stock into production. Once the items have been produced, the work order can be marked as complete which automatically updates stock levels and generates a Receipt from Production into your SAP Business One system. Additional Functionality: Production Manager The Production Manager Add-On has become one of our most desired applications for SAP Business One because of its ability to offer full visibility into the production process and consequently more efficient processes as a result. A Centralised View: The central screen shown in the diagram allows your Production Manager to see at a glance all the production orders that are yet to be fulfilled, and those that have already been released for production. This not only gives a live view of production, but also gives you an efficient source of information between departments. Flexibility: In times when production orders may need to be altered or prioritised to meet changing needs, the Production Manager Application allows you to review and change delivery dates directly from the central screen, giving you the ability to adapt to customer requirements. Efficiency: The Production Manager Application also gives the user the ability to sort production orders by header and release multiple orders at the same time from the central screen, speeding up the production process. SapCloner Application wchich gives you functionality to clone production treee/BOM(BillOf Materials). Sometimes a new BOM - there is no function to copy entire BOM to the nerw-one. SAPCloner gives you possibility to Copy BOM and create new product. You can decide how many characters will be changed.Application automatically change first characters and entire name. In case of subcomponents - SAPCloner exchange sub-components code as-well. Additionaly SAPCloner can delete unused BOMS and ITEMS MySQL Observer Latest integration tool allows you to establish communication between ANY web-portal and SAP BusinessOne. The Web portal can be based on both ASP or PHP scripting language and MySQL database. It allows you to send ORDERS/ QUOTATIONS/ MESSAGES/ ALERTS from your externally hosted web-shop directly to SAP BusinessOne on your internal server. Comunication can be established both ways (In/Out). - both ways-communication (IN/OUT)
- works ON-LINE and OFF-LINE (interval)
- works with MySQL 5.xx
- data-flow can be triggered by web-portal side in easy way
- no need to host WEB-SERVER and WEB-SHOP on you company server
- easy implementation guide to put to existing shop scripts
- allows you to develop your WEB-SHOP and exchange other kind of data
- easy error control and management
|