General Ledger API
GeneralLedgerGetAccountBalance
Get account balance from the general ledger.
Parameters
| fiscalYear | Select fiscal year (business year). Fiscal year which is set as default will be used if absent from the request. |
| accountNumber | General ledger account number |
| partnerCode | If partner code is specified the balance will be calculated for that partner with only. |
| voucherStatus | General ledger journal voucher status of entries used in balance calculation. Possible values are:
- all Include open and posted vouchers/entries when calculating the balance. This is the default parameter value.
- open Include only open vouchers.
- posted Include only posted vouchers.
|
| balanceDate | The date of the balance returned. |
| costPosition | Cost center code. |
Example request and response
Example 1.
POST /WebServicesSI/API HTTP/1.1
Host: eurofaktura.com
User-Agent: Mozilla/4.0
Content-Length: 410
Content-Type: application/octet-stream
<?xml version="1.0" encoding="utf-8"?>
<request>
<login username="micka" md5pass="ddb43e9f119c6805f4770ecc4f6466ba" token="E7DF3E6E94FB4579BBA8F54979010B5C" />
<method name="GeneralLedgerGetAccountBalance">
<parameter name="fiscalYear" value="2014" />
<parameter name="balanceDate" type="Date" value="2004-01-31" />
<parameter name="accountNumber" type="String" value="1200" />
<parameter name="partnerCode" type="String" value="003" />
<parameter name="voucherStatus" type="String" value="all" />
</method>
</request>
HTTP/1.1 200 OK
Server: e-racuni.com web server
Date: Tue, 1 Apr 2009 11:00:05 GMT
Content-Type: text/xml
Content-Length: 328
<?xml version="1.0" encoding="utf-8"?>
<response status="ok">
<AccountBalance accountNumber="1200" partnerCode="003" balanceCredit="11.00" balanceDebit="12.00" balance="-1.0" currency="EUR">
</response>
GeneralLedgerAccountStatementGetEntries
Get general ledger account statement entries.
Parameters
| businessYear | Select business year. Business year which is set as default will be used if not specified. |
| accountNumber | General ledger account number. |
| partnerCode | If partner code is specified, only entries assigned to the given partner will be returned. |
| document | If document ID is specified, the statement will include only entries assigned to the given document. Document string can containt the * (star) character to match entries where document Id matches the search string. |
| transactionDateFrom | Entries for transactions from the given date |
| transactionDateTo | Entries for transactions up to the given date |
| documentDateFrom | Entries for document from date |
| documentDateTo | Entries for documents up to given date |
| dueDateFrom | Entry due date from |
| dueDateTo | Entry due date to |
| postingDateFrom | Entry posting date from |
| postingDateTo | Entry posting date to |
| transactionAmount | Filter out entries matching approximate transaction amount. If currency parameter is also specified, then the amount will be matched with the entry amount in the foreign currency. |
| transactionCurrency | Use this criteria when you need to filter out transaction originating in a foreign currency |
| costCentre | Filter out entries on the given cost centre. Character * (star) can be used for matching multiple cost center codes |
| description | Filter out entries matching description (* character can be used) |
| creditOrDebit | Optional to filter out only debit or credit transactions. Possible values are:
- debit Only debit transactions
- credit Only credit transaction
|
| voucherStatus | Optional to limit list to entries depending on the GL journal voucher status. Possible values are:
- all Include open and posted vouchers/entries when calculating the balance. This is the default parameter value.
- open Include only open vouchers.
- posted Include only posted vouchers.
|
| entryStatus | Optional to specify entry status regarding document payment status. Possible values are:
- open list open items only
- cleared list cleared entries only
|
Example request and response
Example 1.
POST /WebServicesSI/API HTTP/1.1
Host: eurofaktura.com
User-Agent: Mozilla/4.0
Content-Length: 410
Content-Type: application/octet-stream
<?xml version="1.0" encoding="utf-8"?>
<request>
<login username="micka" md5pass="ddb43e9f119c6805f4770ecc4f6466ba" token="E7DF3E6E94FB4579BBA8F54979010B5C" />
<method name="GeneralLedgerAccountStatementGetEntries">
<parameter name="businessYear" value="2018" />
<parameter name="documentDateFrom" type="Date" value="2018-01-31" />
<parameter name="documentDateTo" type="Date" value="2018-02-28" />
<parameter name="accountNumber" type="String" value="1200" />
<parameter name="partnerCode" type="String" value="003" />
<parameter name="transactionAmount" type="Decimal" value="50.00" />
</method>
</request>
HTTP/1.1 200 OK
Server: e-racuni.com web server
Date: Tue, 1 Apr 2009 11:00:05 GMT
Content-Type: text/xml
Content-Length: 328
<?xml version="1.0" encoding="utf-8"?>
<response status="ok">
<AccountStatement>
<businessYear>
<account>
<Entry>
<amountDebit>200000.000</amountDebit>
<costPosition></costPosition>
<description>KBM-Infond, družba za upravljanje d.o.o.</description>
<document></document>
<documentDate>2011-12-31</documentDate>
<dueDate>2011-12-31</dueDate>
<generalLedgerAccountNumber>12000</generalLedgerAccountNumber>
<partner>KBM-Infond, družba za upravljanje d.o.o.</partner>
<partnerCode>1142</partnerCode>
<referencedDocument></referencedDocument>
<sequenceNumber>89</sequenceNumber>
<status>0</status>
<transactionDate>2011-12-31</transactionDate>
<vatDate>2011-12-31</vatDate>
</Entry>
<Entry>
<amountDebit>200000.000</amountDebit>
<costPosition></costPosition>
<description>KBM-Infond, družba za upravljanje d.o.o.</description>
<document></document>
<documentDate>2011-12-31</documentDate>
<dueDate>2011-12-31</dueDate>
<generalLedgerAccountNumber>12000</generalLedgerAccountNumber>
<partner>KBM-Infond, družba za upravljanje d.o.o.</partner>
<partnerCode>1142</partnerCode>
<referencedDocument></referencedDocument>
<sequenceNumber>268</sequenceNumber>
<status>0</status>
<transactionDate>2011-12-31</transactionDate>
<vatDate>2011-12-31</vatDate>
</Entry>
<Entry>
<amountDebit>200000.000</amountDebit>
<costPosition></costPosition>
<description>KBM-Infond, družba za upravljanje d.o.o.</description>
<document></document>
<documentDate>2011-12-31</documentDate>
<dueDate>2011-12-31</dueDate>
<generalLedgerAccountNumber>12000</generalLedgerAccountNumber>
<partner>KBM-Infond, družba za upravljanje d.o.o.</partner>
<partnerCode>1142</partnerCode>
<referencedDocument></referencedDocument>
<sequenceNumber>447</sequenceNumber>
<status>0</status>
<transactionDate>2011-12-31</transactionDate>
<vatDate>2011-12-31</vatDate>
</Entry>
.....
<AccountStatement>
</response>
