Parameters   Output Objects  

Searches Sage 300 data.

Syntax

Select-Sage300 [parameters]

Remarks

The Select-Sage300 cmdlet allows you to use a syntax similar to SQL SELECT statements to search Sage 300 data.

$conn = Connect-Sage300 -User "SAMPLE" -Password "password" -URL "http://127.0.0.1/Sage300WebApi/v1/-/"
Select-Sage300 -Connection $conn -Table "OEInvoices" -Columns @("InvoiceUniquifier","ApprovedLimit") -Where "Allowpartialshipments='Yes'"