GL Document

WARNING: GL Documents can have a LOT of Journal line items and can blow up Jade with 1018 errors (No memory for buffers). We will review how these are accessed and consider introducing a paging mechanism for the Journal lines

URL	Verbs	Function	Available
GLDocument	GET	Query a list of GL Documents	Post 2018.3
GLDocument	POST	Create a new GL Document	Post 2018.3
GLDocument/<reference>	GET	Query a specific GL Document by its reference	Post 2018.3
GLDocument/<reference>	POST	Update an existing GL Document	Post 2018.3

Supported modifiers

Query String	Definition	Sample	Available
batch	Return GL Documents for a specific Batch	batch=2000	Post 2018.3
includesGLAccount	Return GL Documents that contain at least Journal line item with the nominated GL Account	includesGLAccount=10.10.1050	2021.1
postingDate	Return GL Documents for a specific Posting Date	postingDate=2018-08-01	2021.1

Security Linked Menu

Menu Item	Located
Journal Entry	Data Entry / General Ledger

Sample XML Response

<?xml version="1.0" encoding="UTF-8"?>
<GLDocument>
    <Edition>2</Edition>
    <OidString>2796.338</OidString>
    <Detail>Some details</Detail>
    <PostingDate>2011-05-31</PostingDate>
    <Reference>5</Reference>
    <Currency>AUD</Currency>
    <IsAccrual>false</IsAccrual>
    <ReverseDate/>
    <DocumentDate>2016-05-31</DocumentDate>
    <CreditTotal>3000.00</CreditTotal>
    <DebitTotal>3000.00</DebitTotal>
    <IsCurrencyRateMultiply>true</IsCurrencyRateMultiply>
    <IsRevaluationDocument>false</IsRevaluationDocument>
    <CurrencyRate>1.00000000</CurrencyRate>
    <TotalLedger>0.00</TotalLedger>
    <BatchNumber>996</BatchNumber>
    <IsExchangeARAPOffsetVarianceJournal>false</IsExchangeARAPOffsetVarianceJournal>
    <IsConsolidationJournal>false</IsConsolidationJournal>
    <JournalTransactions collection='true' count='3'>
        <GLJournal>
            <Edition>2</Edition>
            <OidString>2655.50963</OidString>
            <EntryTimeStamp>2018-10-11T15:04:43</EntryTimeStamp>
            <EntryUser>SUPER</EntryUser>
            <ModifiedTimeStamp>2018-10-13T10:26:58</ModifiedTimeStamp>
            <ModifiedUser>SUPER</ModifiedUser>
            <Company>01</Company>
            <GLAccount>10.10.1000</GLAccount>
            <Quantity>0.00</Quantity>
            <IsReconciled>false</IsReconciled>
            <TranNetAmount>-1000.00</TranNetAmount>
            <AccountToTranRate>1.00000000</AccountToTranRate>
            <IsAccountToTranRateMultiply>true</IsAccountToTranRateMultiply>
            <LedgerToTranRate>1.00000000</LedgerToTranRate>
            <IsLedgerToTranRateMultiply>true</IsLedgerToTranRateMultiply>
        </GLJournal>
        <GLJournal>
            <Edition>2</Edition>
            <OidString>2655.50964</OidString>
            <EntryTimeStamp>2018-10-11T15:04:43</EntryTimeStamp>
            <EntryUser>SUPER</EntryUser>
            <ModifiedTimeStamp>2018-10-13T10:26:58</ModifiedTimeStamp>
            <ModifiedUser>SUPER</ModifiedUser>
            <Company>01</Company>
            <GLAccount>20.10.1000</GLAccount>
            <Quantity>0.00</Quantity>
            <IsReconciled>false</IsReconciled>
            <TranNetAmount>-2000.00</TranNetAmount>
            <AccountToTranRate>1.00000000</AccountToTranRate>
            <IsAccountToTranRateMultiply>true</IsAccountToTranRateMultiply>
            <LedgerToTranRate>1.00000000</LedgerToTranRate>
            <IsLedgerToTranRateMultiply>true</IsLedgerToTranRateMultiply>
        </GLJournal>
        <GLJournal>
            <Edition>2</Edition>
            <OidString>2655.50965</OidString>
            <EntryTimeStamp>2018-10-11T15:04:43</EntryTimeStamp>
            <EntryUser>SUPER</EntryUser>
            <ModifiedTimeStamp>2018-10-13T10:26:58</ModifiedTimeStamp>
            <ModifiedUser>SUPER</ModifiedUser>
            <Company>01</Company>
            <GLAccount>30.10.1000</GLAccount>
            <Quantity>0.00</Quantity>
            <IsReconciled>false</IsReconciled>
            <TranNetAmount>3000.00</TranNetAmount>
            <AccountToTranRate>1.00000000</AccountToTranRate>
            <IsAccountToTranRateMultiply>true</IsAccountToTranRateMultiply>
            <LedgerToTranRate>1.00000000</LedgerToTranRate>
            <IsLedgerToTranRateMultiply>true</IsLedgerToTranRateMultiply>
            <TransactionAnalysis collection='true' count='2'>
                <Tree>
                    <Name>Site</Name>
                    <Value>Gregorian Place</Value>
                    <Path>Gregorian Place</Path>
                    <ShortCode>GP</ShortCode>
                </Tree>
                <Tree>
                    <Name>Inventory Product Managers</Name>
                    <Value>Michael J</Value>
                    <Path>Michael J</Path>
                    <ShortCode>MJ</ShortCode>
                </Tree>
            </TransactionAnalysis>
        </GLJournal>
    </JournalTransactions>
</GLDocument>