Materialised Query – Budgeting with Writeback

​Sharperlight Materialised Queries can not only take snapshots of operational data but can also be setup for writeback.   In the example the current Years Actuals for each Account are read from a Ledger Transactions table held in SAP Business One. An Budget field is creeated by using an Expression where the initial Budget value is the Actual + %4.  Once the Materialised Query has been created its properties are changed to allow for updating the Budget value based on the Company and Account

The Budget details are updated using both Excel and the Web Channel