VXL XL Vince Excel Makes M3 Easy The Challenge The Solution - PowerPoint PPT Presentation

VXL XL – Vince Excel Makes M3 Easy

«The Challenge»

The Solution Cloud enabled Excel as User Interface Security from M3 API Technology Version independent

VXL Technical Design M3

PPS101 – Purchase Agreement. Open Lines

Example PPS100 – Purchase Agreement

Connect M3 programs MMS0 MMS0 MMS0 PPS200 Respons OIS021 PPS101 PPS101 PPS101 01 02 01 Use standard Excel calculcations to support M3 data • Multiple APIs (run in sequence) • Save everything to track your changes • Excel history • Internal log files •

Import to M3

Configurator

Configurator

Examples of other functions M3 M3-functio ion API-support PPS100/PPS101 – Purchase agreement Create + Update standard MMS001/2/3 – Item information Create + Update standard BUS100 – Budget Create + Update standard PDS001/002 – Bill of material Create + Update standard OIS017/21 – Customer Price Lists Create + Update standard MMS010 – Warehouse location Create + Update standard MMS100 – DO/RO Create + Update standard MMS175 – Move between warehouses Create + Update standard OIS060/61 – Customer Agreements Create + Update standard PPS040 - Item/Supplier Create + Update standard PPS200/201 – Create Purchase order Create + Update standard OIS100/101 – Create Customer Order Create + Update standard