GLBatch

Tracks General Ledger (GL) batches with associated metadata, enabling batch processing and auditing.

Table Specific Information

Sage Intacct allows the user to update the GLBatch table and the associated GLEntry child table (read-only) by adding new GLEntry items to the associated GLBatch object. The driver does this by using the ItemAggregate field. The following is an example of an UPDATE statement:

UPDATE GLBatch SET [Batch_Title] = 'new title', 
    ItemAggregate='    <GLENTRY>
	<ACCOUNTNO>6530/ACCOUNTNO>
	<DESCRIPTION>modifyme/DESCRIPTION>
	<LOCATIONKEY>4/LOCATIONKEY>
	<LOCATION>100/LOCATION>
	<LOCATIONNAME>corporate/LOCATIONNAME>
	<TRX_AMOUNT>20/TRX_AMOUNT> <TR_TYPE>-1/TR_TYPE>
	<GLDIMTYPE>location/GLDIMTYPE> <GLDIMSERVICE>service/GLDIMSERVICE>
	/GLENTRY>
	<GLENTRY>
	<ACCOUNTNO>6530/ACCOUNTNO> <DESCRIPTION>modified/DESCRIPTION>
	<LOCATIONKEY>4/LOCATIONKEY> <LOCATION>100/LOCATION> <LOCATIONNAME>corporate/LOCATIONNAME>
	<MODIFIEDBY>NULL/MODIFIEDBY><PROJECTID>null/PROJECTID><TRX_AMOUNT>20/TRX_AMOUNT>
	<TR_TYPE>1/TR_TYPE> <GLDIMTYPE>location/GLDIMTYPE> <GLDIMSERVICE>service
	/GLDIMSERVICE>
	/GLENTRY>' 
	where Recrdno='xxx'

Insert

The following example is supported when UseLegacy=True and illustrates how to insert data into the GLBatch table.

INSERT INTO GLBatch (Journalid, Datecreated, Description, Itemaggregate) VALUES ('APJ', '08/24/2024', 'Test Description', '<glentry><trtype>debit</trtype><amount>1450.80</amount><glaccountno>6530</glaccountno><locationid>10</locationid></glentry> <glentry><trtype>credit</trtype><amount>1450.80</amount><glaccountno>0321</glaccountno><locationid>10</locationid></glentry>');

The following example is supported when UseLegacy=False and illustrates how to insert data into the GLBatch table.

INSERT INTO GLBatch (Journal, Batch_date, Batch_title, Itemaggregate) VALUES ('APJ', '08/27/2024', 'Accounts Payable Journal', '<glentry><ACCOUNTNO>6530</ACCOUNTNO><LOCATION>10</LOCATION><CURRENCY>USD</CURRENCY><TR_TYPE>-1</TR_TYPE><AMOUNT>1450.80</AMOUNT><EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID><DESCRIPTION>Accrued salaries</DESCRIPTION></glentry><glentry><ACCOUNTNO>0321</ACCOUNTNO><LOCATION>10</LOCATION><CURRENCY>USD</CURRENCY><TR_TYPE>1</TR_TYPE><AMOUNT>1450.80</AMOUNT><EXCH_RATE_TYPE_ID>Intacct Daily Rate</EXCH_RATE_TYPE_ID><DESCRIPTION>Salary expense</DESCRIPTION></glentry>');

Columns


Name	Type	ReadOnly	Description
Recordno [KEY]	String	False	Unique identifier for the GLBatch object.
Batchno	Int64	False	Batch number associated with the GLBatch object.
Batch_title	String	False	Title or description of the batch.
Balance	Double	False	Balance of the GL batch.
Journal	String	False	Journal type associated with the batch.
Batch_date	Datetime	False	Date of the batch.
Module	String	False	Module associated with the batch.
Userkey	Int64	False	Key identifying the user associated with the batch.
Referenceno	String	False	Reference number for the batch.
Reversed	Datetime	False	Date the batch was reversed.
Reversedkey	Int64	False	Key for the reversed batch.
Reversedfrom	String	False	Original batch from which this batch was reversed.
Templatekey	Int64	False	Template key associated with the batch.
Prbatchkey	Int64	False	Preceding batch key.
Modified	Datetime	False	Last modified date of the batch.
Modifiedbyid	String	False	ID of the user who last modified the batch.
Schopkey	Int64	False	Key for scheduled operations associated with the batch.
Baselocation	String	False	Base location related to the batch.
Baselocation_no	String	False	Base location number.
Userinfo_loginid	String	False	Login ID of the user who created the batch.
Whencreated	Datetime	False	Timestamp when the batch was created.
Whenmodified	Datetime	False	Timestamp when the batch was last modified.
Createdby	Int64	False	User key of the creator of the batch.
Modifiedby	Int64	False	User key of the last modifier of the batch.
State	String	False	Current state of the batch.
Megaentitykey	Int64	False	Key of the associated mega entity.
Megaentityid	String	False	ID of the associated mega entity.
Megaentityname	String	False	Name of the associated mega entity.
Record_url	String	False	URL for accessing the batch record.
ItemAggregate	String	False	Associated GL entry items for the batch.

ADO.NET Provider for Sage Intacct

GLBatch

Table Specific Information

Insert

Columns