ECM - Advanced Math Expression Documentation

ECM
44

I see. Can you place them in a folder at the ECM client and have the client copy it to the K: drive after being imported to ECM? You just need the XML file to give it the invoice number, customer number, etc.

BTW, it is possible to pull reports down from Kinetic using PowerShell. This is just an proof-of-concept if you know the SysRowId, but that could be looked up. You don’t have to push things through ECM, you can pull them too.

// Get Epicor Credentials. Boo. Use token auth instead.
$pscred = Get-Credential

$headers = @{ 'accept' = 'application/json'
              'Content-Type' = 'application/json'}

$rpt = ConvertTo-Json(@{ sysRowId = 'SysRowId here'})

$result = Invoke-RestMethod -uri "https://server/instance/api/v1/Ice.BO.ReportMonitorSvc/GetReportBytes" -Method Post -Credential $pscred -body $rpt -Authentication Basic  -Headers $headers

$filename = "path to K: drive with file name"

// Convert back to binary
$bytes = [Convert]::FromBase64String($result.returnObj)

// Write file to disc
[IO.File]::WriteAllBytes($filename, $bytes)

You could use a script like this to pull down the invoice, copy it to the input folder for ECM, then also copy it to the K: drive. Or let APS send it to ECM and then use this to copy to the K: drive afterwards. You have options.

Wait. These are AP invoices. Since they are already PDFs, you should be able to use the ECM client to load them, no?

2 Likes