Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Other: Missing records after sync

Completed
k r User

I've noticed a discrepancy while working with the gl_entry table. When querying the data directly via the API, I can see all the records as expected. However, the number of records retrieved through Fivetran is significantly lower.

Could you please investigate why some records are not being pulled into Fivetran for this table?

For example, when I apply the following filter:

  1. entry_date = '2023-10-16'
  2. accountno = 40020
  3. locationname = 'Isosceles Finance Limited'

the API returns two records, one with an amount of -81 and another with -77.4. However, in Fivetran, I can only find the -77.4 record — the -81 entry appears to be missing.

Below is a snippet from the Postman API response showing both records being returned by Sage Intacct, including the one with amount = -81.

<?xml version="1.0" encoding="UTF-8"?>
<response>
    <control>
        <status>success</status>
        <senderid>dains</senderid>
        <controlid>1752140346</controlid>
        <uniqueid>false</uniqueid>
        <dtdversion>3.0</dtdversion>
    </control>
    <operation>
        <authentication>
            <status>success</status>
            <userid>WS.JMAN</userid>
            <companyid>dains</companyid>
            <locationid></locationid>
            <sessiontimestamp>2025-07-10T09:39:07+00:00</sessiontimestamp>
            <sessiontimeout>2025-07-10T17:39:07+00:00</sessiontimeout>
        </authentication>
        <result>
            <status>success</status>
            <function>readByQuery</function>
            <controlid>100dd9bb-bb28-43aa-ba21-0ee18521df88</controlid>
            <data listtype="gldetail" count="2" totalcount="2" numremaining="0" resultId="">
                <gldetail>
                    <RECORDNO>2140-70587---accrual</RECORDNO>
                    <BATCHKEY>2140</BATCHKEY>
                    <BATCH_DATE>10/16/2023</BATCH_DATE>
                    <BATCH_TITLE>OPBAL - 16/10/2023</BATCH_TITLE>
                    <SYMBOL>OBJ</SYMBOL>
                    <BATCH_NO>2140</BATCH_NO>
                    <BOOKID>ACCRUAL</BOOKID>
                    <CHILDENTITY></CHILDENTITY>
                    <MODIFIED>03/27/2025 16:58:08</MODIFIED>
                    <REFERENCENO></REFERENCENO>
                    <ADJ>F</ADJ>
                    <MODULEKEY>2.GL</MODULEKEY>
                    <OWNERSHIPKEY>11</OWNERSHIPKEY>
                    <LINE_NO>107</LINE_NO>
                    <ENTRY_DATE>10/16/2023</ENTRY_DATE>
                    <TR_TYPE>-1</TR_TYPE>
                    <DOCUMENT>15158</DOCUMENT>
                    <ACCOUNTNO>40020</ACCOUNTNO>
                    <ACCOUNTTITLE>Fees Raised</ACCOUNTTITLE>
                    <STATISTICAL>F</STATISTICAL>
                    <DEPARTMENTID>300</DEPARTMENTID>
                    <DEPARTMENTTITLE>Accounts Advisory</DEPARTMENTTITLE>
                    <LOCATIONID>E-0009</LOCATIONID>
                    <LOCATIONNAME>Isosceles Finance Limited</LOCATIONNAME>
                    <CURRENCY>GBP</CURRENCY>
                    <BASECURR>GBP</BASECURR>
                    <DESCRIPTION>(Xero Acc. Code - 4003)  - My Staff Shop Limited - Introducer Commission - Aeralis</DESCRIPTION>
                    <DEBITAMOUNT>0</DEBITAMOUNT>
                    <CREDITAMOUNT>81</CREDITAMOUNT>
                    <AMOUNT>-81</AMOUNT>
                    <TRX_DEBITAMOUNT>0</TRX_DEBITAMOUNT>
                    <TRX_CREDITAMOUNT>81</TRX_CREDITAMOUNT>
                    <TRX_AMOUNT>-81</TRX_AMOUNT>
                    <CLEARED>F</CLEARED>
                    <CLRDATE></CLRDATE>
                    <CUSTENTITY></CUSTENTITY>
                    <VENDENTITY></VENDENTITY>
                    <EMPENTITY></EMPENTITY>
                    <LOCENTITY></LOCENTITY>
                    <RECORDTYPE></RECORDTYPE>
                    <RECORDID></RECORDID>
                    <DOCNUMBER></DOCNUMBER>
                    <STATE></STATE>
                    <WHENCREATED></WHENCREATED>
                    <WHENDUE></WHENDUE>
                    <WHENPAID></WHENPAID>
                    <WHENMODIFIED>03/27/2025 16:58:08</WHENMODIFIED>
                    <PRDESCRIPTION></PRDESCRIPTION>
                    <PRCLEARED></PRCLEARED>
                    <PRCLRDATE></PRCLRDATE>
                    <FINANCIALENTITY></FINANCIALENTITY>
                    <TOTALENTERED></TOTALENTERED>
                    <TOTALPAID></TOTALPAID>
                    <TOTALDUE></TOTALDUE>
                    <ENTRYDESCRIPTION></ENTRYDESCRIPTION>
                    <GLENTRYKEY>70587</GLENTRYKEY>
                    <CREATEDBY>SvcUser|PWCUKSYS|PS_Config_Natasha</CREATEDBY>
                    <BATCH_STATE>P</BATCH_STATE>
                    <ENTRY_STATE>P</ENTRY_STATE>
                    <AUWHENCREATED>03/27/2025 16:58:08</AUWHENCREATED>
                    <AUCREATEDBY>23</AUCREATEDBY>
                    <MODIFIEDBY>23</MODIFIEDBY>
                    <PROJECTDIMKEY></PROJECTDIMKEY>
                    <PROJECTID></PROJECTID>
                    <PROJECTNAME></PROJECTNAME>
                    <CUSTOMERDIMKEY>16964</CUSTOMERDIMKEY>
                    <CUSTOMERID>C-007753</CUSTOMERID>
                    <CUSTOMERNAME>My Staff Shop Limited</CUSTOMERNAME>
                    <VENDORDIMKEY>2378</VENDORDIMKEY>
                    <VENDORID>S-000945</VENDORID>
                    <VENDORNAME>My Staff Shop Limited</VENDORNAME>
                    <EMPLOYEEDIMKEY></EMPLOYEEDIMKEY>
                    <EMPLOYEEID></EMPLOYEEID>
                    <EMPLOYEENAME></EMPLOYEENAME>
                    <ITEMDIMKEY></ITEMDIMKEY>
                    <ITEMID></ITEMID>
                    <ITEMNAME></ITEMNAME>
                    <CLASSDIMKEY>11</CLASSDIMKEY>
                    <CLASSID>O-000011</CLASSID>
                    <CLASSNAME>Egham</CLASSNAME>
                    <AFFILIATEENTITYDIMKEY></AFFILIATEENTITYDIMKEY>
                    <AFFILIATEENTITYID></AFFILIATEENTITYID>
                    <AFFILIATEENTITYNAME></AFFILIATEENTITYNAME>
                    <RDEPRECIATION_SUMMARY></RDEPRECIATION_SUMMARY>
                    <RGLENTRYDS></RGLENTRYDS>
                </gldetail>
                <gldetail>
                    <RECORDNO>2140-70588---accrual</RECORDNO>
                    <BATCHKEY>2140</BATCHKEY>
                    <BATCH_DATE>10/16/2023</BATCH_DATE>
                    <BATCH_TITLE>OPBAL - 16/10/2023</BATCH_TITLE>
                    <SYMBOL>OBJ</SYMBOL>
                    <BATCH_NO>2140</BATCH_NO>
                    <BOOKID>ACCRUAL</BOOKID>
                    <CHILDENTITY></CHILDENTITY>
                    <MODIFIED>03/27/2025 16:58:08</MODIFIED>
                    <REFERENCENO></REFERENCENO>
                    <ADJ>F</ADJ>
                    <MODULEKEY>2.GL</MODULEKEY>
                    <OWNERSHIPKEY>11</OWNERSHIPKEY>
                    <LINE_NO>108</LINE_NO>
                    <ENTRY_DATE>10/16/2023</ENTRY_DATE>
                    <TR_TYPE>-1</TR_TYPE>
                    <DOCUMENT>15158</DOCUMENT>
                    <ACCOUNTNO>40020</ACCOUNTNO>
                    <ACCOUNTTITLE>Fees Raised</ACCOUNTTITLE>
                    <STATISTICAL>F</STATISTICAL>
                    <DEPARTMENTID>300</DEPARTMENTID>
                    <DEPARTMENTTITLE>Accounts Advisory</DEPARTMENTTITLE>
                    <LOCATIONID>E-0009</LOCATIONID>
                    <LOCATIONNAME>Isosceles Finance Limited</LOCATIONNAME>
                    <CURRENCY>GBP</CURRENCY>
                    <BASECURR>GBP</BASECURR>
                    <DESCRIPTION>(Xero Acc. Code - 4003)  - My Staff Shop Limited - Introducer Commission - Lloyds Online Doctor (Expert Health Ltd)</DESCRIPTION>
                    <DEBITAMOUNT>0</DEBITAMOUNT>
                    <CREDITAMOUNT>77.4</CREDITAMOUNT>
                    <AMOUNT>-77.4</AMOUNT>
                    <TRX_DEBITAMOUNT>0</TRX_DEBITAMOUNT>
                    <TRX_CREDITAMOUNT>77.4</TRX_CREDITAMOUNT>
                    <TRX_AMOUNT>-77.4</TRX_AMOUNT>
                    <CLEARED>F</CLEARED>
                    <CLRDATE></CLRDATE>
                    <CUSTENTITY></CUSTENTITY>
                    <VENDENTITY></VENDENTITY>
                    <EMPENTITY></EMPENTITY>
                    <LOCENTITY></LOCENTITY>
                    <RECORDTYPE></RECORDTYPE>
                    <RECORDID></RECORDID>
                    <DOCNUMBER></DOCNUMBER>
                    <STATE></STATE>
                    <WHENCREATED></WHENCREATED>
                    <WHENDUE></WHENDUE>
                    <WHENPAID></WHENPAID>
                    <WHENMODIFIED>03/27/2025 16:58:08</WHENMODIFIED>
                    <PRDESCRIPTION></PRDESCRIPTION>
                    <PRCLEARED></PRCLEARED>
                    <PRCLRDATE></PRCLRDATE>
                    <FINANCIALENTITY></FINANCIALENTITY>
                    <TOTALENTERED></TOTALENTERED>
                    <TOTALPAID></TOTALPAID>
                    <TOTALDUE></TOTALDUE>
                    <ENTRYDESCRIPTION></ENTRYDESCRIPTION>
                    <GLENTRYKEY>70588</GLENTRYKEY>
                    <CREATEDBY>SvcUser|PWCUKSYS|PS_Config_Natasha</CREATEDBY>
                    <BATCH_STATE>P</BATCH_STATE>
                    <ENTRY_STATE>P</ENTRY_STATE>
                    <AUWHENCREATED>03/27/2025 16:58:08</AUWHENCREATED>
                    <AUCREATEDBY>23</AUCREATEDBY>
                    <MODIFIEDBY>23</MODIFIEDBY>
                    <PROJECTDIMKEY></PROJECTDIMKEY>
                    <PROJECTID></PROJECTID>
                    <PROJECTNAME></PROJECTNAME>
                    <CUSTOMERDIMKEY>16964</CUSTOMERDIMKEY>
                    <CUSTOMERID>C-007753</CUSTOMERID>
                    <CUSTOMERNAME>My Staff Shop Limited</CUSTOMERNAME>
                    <VENDORDIMKEY>2378</VENDORDIMKEY>
                    <VENDORID>S-000945</VENDORID>
                    <VENDORNAME>My Staff Shop Limited</VENDORNAME>
                    <EMPLOYEEDIMKEY></EMPLOYEEDIMKEY>
                    <EMPLOYEEID></EMPLOYEEID>
                    <EMPLOYEENAME></EMPLOYEENAME>
                    <ITEMDIMKEY></ITEMDIMKEY>
                    <ITEMID></ITEMID>
                    <ITEMNAME></ITEMNAME>
                    <CLASSDIMKEY>11</CLASSDIMKEY>
                    <CLASSID>O-000011</CLASSID>
                    <CLASSNAME>Egham</CLASSNAME>
                    <AFFILIATEENTITYDIMKEY></AFFILIATEENTITYDIMKEY>
                    <AFFILIATEENTITYID></AFFILIATEENTITYID>
                    <AFFILIATEENTITYNAME></AFFILIATEENTITYNAME>
                    <RDEPRECIATION_SUMMARY></RDEPRECIATION_SUMMARY>
                    <RGLENTRYDS></RGLENTRYDS>
                </gldetail>
            </data>
        </result>
    </operation>
</response>

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Sandeep Preetam Saila Fivetranner

    Thank you for bringing this issue to our attention. We understand the importance of having all records accurately synced. To resolve this discrepancy, please contact our Support team directly, as they are best equipped to assist with specific data sync issues. They will investigate the matter and provide you with a solution promptly. We appreciate your patience and cooperation.