Tag Archives: Excel

How to Install Microsoft Excel add-in in Sage X3

Sage X3 has an accompanying Excel add-in that you can use to export data from grids in Sage X3 into a Microsoft Excel spreadsheet. In this blog, we will run through the steps involved in installing the add-in and using it for a simple export. Integrating an Excel add-in with Sage X3 can be a… Read More »

How to solve the error@“Field BPAADD(Alphanumeric) : mid$ Function not defined for the value given” when extracting the Excel export from the Purchasing Receipt Line Inquiry screens

Sage X3 is enterprise resource planning (ERP) product which help organization to manage all the operation of organization and database into a single software solution. Sage X3 contains list of modules like sales, purchase, inventory, project, financial and many more. One of our clients is encountering an error “Field BPAADD(Alphanumeric) : mid$ Function not defined… Read More »

Exporting Real Time – SEI Data Models Using Excel Add-In

We all understand and know the importance of analyzing the daily/archived business data (from all different working styles & scenarios e.g., Sales, Purchase, Delivery, Warehouse, Payroll, etc.) which just not only helps to understand the current situation & performance of your business, but also helps to gain great, useful & valuable insights so that one… Read More »

How to link Menu Item to Excel | Sage Enterprise Management

We have come across the requirement where excel data needs to be refreshed on the basis of Sage X3 data. This can be achieved with the below steps. We will need Sage addin available in the Microsoft Excel, this addin will link the data with Sage X3 database. If you will have Sage Addin available, this… Read More »