GetGeneralLedgerAccounts
List accounts for the current GLYear and only accounts which the vendor user account is authorised to view. The vendor user account is resolved from the passed in VendorTokenGUID.
This web service calls underlying SQL stored procedure – SynergyOneFinance.dbo.spxeGeneralLedgerAccounts.
InputObject (XML)
Element |
SQL Data Type |
Mandatory |
Description |
VendorTokenGUID |
GUID |
Yes |
Specific GUID that Synergetic will give the third party app to validate them upon every web service request. |
VersionNumber |
Decimal(4,2) |
Yes |
To cater for extending the web service and return the version specific format. Default 2.5. |
ConfigFileName |
Varchar(max) |
No |
Optional - if missing or blank then the authentication details into DB are found in WebServiceSynergetic.XML in the website folder. |
GLYear |
Smallint |
No |
Optional for a particular GLYear the current glyear will be selected if this is not populated. Multiple GLCode nodes can be passed through if required. |
GLCode |
Varchar(max) |
No |
Optional for a particular GLCode. |
Sample Input
<InputXML>
<VendorTokenGUID>3FC2ABA9-8F37-4CC9-934C-6ABCCA9F44B7</VendorTokenGUID>
<VersionNumber>2.5</VersionNumber>
<ConfigFileName></ConfigFileName>
<GLYear></GLYear>
<GLCode></GLCode>
</InputXML>
OutputObject (XML)
Element |
SQL Data Type |
Description |
GLCode |
Varchar(15) |
General Ledger code. |
GLYear |
Smallint |
General Ledger year. |
GLDescription |
Varchar(50) |
Descriptive text for the account. |
GLActiveFlag |
Bit |
Flag to indicate if General Ledger is active or inactive |
AnnualBudget |
Money |
Annual budget figure |
CurrentBalance |
Money |
Current balance of this General Ledger. |
TotalOutstandingCommitment |
Money |
The total outstanding where a purchase order has been allocated to this account but not yet paid. It is the Extended Cost of the order line minus the Tax Amount. |
Sample Output
<Account GLYear="2010" GLCode="0110" GLDescription="School Fees" GLActiveFlag="1" AnnualBudget="50000.00" CurrentBalance="0.00" />
<Account GLYear="2010" GLCode="2123" GLDescription="Gardens & Grounds" GLActiveFlag="1" AnnualBudget="0.00" CurrentBalance="0.00" TotalOutstandingCommitment="4545.45" />