| Info |
|---|
OverviewThis document details the specification of the myBuildings API import of Creditor invoices. Based on the data returned from the API Call new Creditor Invoices and GL Journals will be created in Synergetic Database and Postings will be shown under Creditor Invoice Entry in Synergetic. |
Fees and Subscription Model:
A one-off implementation fee will be charged. This will cover the one-off effort and will depend on the amount of Consultant consultant time requiredValid Creditor providedrequired.
Tasks covered:
Implementation of the Synergetic SQL Agent job, configuration & testing
Consulting time if client requires help inputting/matching GL codes in myBuildings and/or Synergetic
An ongoing Monthly fee A subscription will also be charged. This will cover the costs for introduced to cover any additional expected support (little to none, in reality) and will add an extra ongoing revenue stream. the and further development of this function. The monthly fee will more than reflect the time saved by Finance staff from having to manually input myBuildings Invoices into Synergetic.
Clients will be prompted to should reach out to their CSM if they would like this feature implemented.
...
Field for Creditor Invoice Details
Field Name | SQL Data Type | Mandatory | Description |
ContractorName | VARCHAR (100) | N | Creditor PayeeName |
ThirdPartySystem_ContractorID | INTEGER | Y | Synergetic Creditor ID |
InvoiceAmount | MONEY | Y | Invoice Amount (Excl. Tax) |
InvoiceTax | MONEY | Y | Invoice Tax Amount |
InvoiceDate | DATETIME | Y | Invoice Date |
InvoiceNumber | VARCHAR (15) | Y | Invoice Number |
InvoiceDescription | VARCHAR (100) | Y | Description for this Invoice |
Fields for GLAllocations
Field Name | SQL Data Type | Mandatory | Description |
AccountNumber | VARCHAR (15) | Y | GLCode. Must exist in Synergetic General Ledger |
Amount | MONEY | Y | GLAmount (Excl. Tax) |
TaxCode | VARCHAR (5) | N | Tax Code must exist in luTax |
GLDescription | VARCHAR (50) | N | Invoice Description from the Invoices Node. |
TaxAmount | MONEY | Y | The amount of tax for the allocation. |
...
Process will only import Creditor Invoices with Status “17: Approved for Processing“
workrequest API (POST)
Field Name | SQL Data Type | Mandatory | Description |
NewStatusID | Integer
| Yes | New StatusID. If not passed in (or -1), status will not be altered. Possible statuses available from this API are as follows: 1: New 2: In Progress 3: On Hold 4: Complete 6: Contractor Complete |
Comment | String | Yes | Comment to record against each request (added to Work Notes) |
WorkRequestID | Integer | No (Yes in our use case) | Which work request to update |
User stories:
Valid Creditor provided.
New creditor payment approved in myBuildings
Synergetic agent job will be running on an hourly basis, and picks up an unprocessed invoice (using myBuildings invoices API)
Synergetic creditor identified
New invoice created in Synergetic
...