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
1 = Active
0 = 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" />