﻿// clear status variables
Clear V[so_selindex] // selected index
Clear V[so_selorder] // selected order

// create table variable
CreateTable V[SalesOrders] _
  _statusicon _
  SalesOrder _  
  SalesOrderType _  
  SalesOrderDate _  
  SoldToParty _
  PurchaseOrderByCustomer _ 
  TotalNetAmount _  
  RequestedDeliveryDate _
  TransactionCurrency 

// reset scroll position etc.
Clear V[SalesOrders.stat*]

// build up filter
Include "so_read_orders_filter.txt"

// SAP message
CreateStructure V[msg] type message

// read sales orders
CallVB guinet.odata.read _
  service:="&V[so_service]" _
  filter:="&V[myfilter]" _
  top:=10000 _
  options:="-isDate.SalesOrderDate," && _
  "-isDate.RequestedDeliveryDate," && _
  "conversionExitOutput.TotalNetAmount=Round:2" _
  orderby:="SalesOrder" _
  result:="SalesOrders" _
  message:="msg" 

// any error ?
if V[msg.type=E]
  Message "&V[msg.message]" type="&V[msg.type]" -statusline
endif

Return