General. Grid ‘Export to Excel’ will now create a new sheet if the number of rows being exported exceeds the number of rows available for a single sheet. The column widths will also be auto sized for ‘best fit’. Multiple new ‘User Exits’ have been made available that enhance the flexibility of the system when […]

Sales Order Entry Shopify CSV import A new program has been developed to allow CSV or Excel format files exported from the online retail software Shopify to be bulk imported into WinMAGI as new sales orders. The CSV (or Excel) file is exported directly out of Shopify and can then be uploaded into WinMAGI.  Validation […]

A new utility has been developed that gives a visual representation of the available stocking locations within a warehouse using Excel. The user simply enters in the warehouse id and nominates the aisle component of the location field and all locations within the warehouse are automatically displayed to the screen in aisle sequence with a […]

Quickly calculate customer rebates using the Rebates Pivot Table utility. Setup the rebate percentages based on customer, customer and product class and whether the rebates apply to overall sales or sales over and above nominated customer targets. The Rebates Pivot Table utility allows the rebate values to be broken down into month and year and […]

WinMAGI has the ability to import data from 3rd party sources to automatically load and create new sales orders.  If your customer is able to supply a CSV, Excel or Text file with their order requirements, then WinMAGI can import this data and automatically create new planned sales orders. The incoming data can hold details […]

WinMAGI now has additional Excel Pivot table interfacing functions. On a screen by screen basis, and a table by table basis, you can develop a standard Excel Pivot table simply with the click of a button. You can now let the power of the Excel Pivot tables help you to drill down into the WinMAGI data.