Hi There - anyone have an issue with the Get Trial Balance command for Sage Intacct?  

The issue is:  You can either enter the START DATE and the END DATE of the trial balance you want, OR specify a "reporting period" that you create in Intacct.  For example, you can have a reporting period defined as "Month Ended July 2020".  

In the instructions for the Get Trial Balance command, it states that if you enter a "Reporting Period", then the START DATE and END DATE fields are ignored.  

I want to use the REPORTING PERIOD option, but get the following error (see below).  I have tried wrapping the REPORTING PERIOD in quotes and in XML arguments [<REPORTINGPERIOD>Month Ended July 2020</REPORTINGPERIOD>].  But still get the error.  Directly below is the screen shot of the Get Trial Balance command configuration page.  Thanks for any information. 

🔌 Sage Intacct BizApp 2.0.2  

⚙️ Get Trial Balances Configuration:  

            Company ID: XXXXXXXXXXX 

              End Date: {"day":"","month":"","year":""} 

     Advanced Settings: {"adjbooks":["ASC 606","ASC 606-CONV\n"],"classid":"","classidSubs":true,"contractid":"","contractidSubs":true,"customerid":"","customeridSubs":true,"customertypeid":"","departmentid":"","deptSubs":true,"employeeid":"","employeeidSubs":true,"employeetypeid":"","includereportingbook":true,"itemid":"","locSubs":true,"locationid":"","productlineid":"","projectid":"","projectidSubs":true,"projecttypeid":"","reportingbook":"CONSOL","showdeptdetail":false,"showlocdetail":false,"showzerobalances":true,"statistical":"include","vendorid":"","vendoridSubs":true,"vendortypeid":"","warehouseid":"","warehouseidSubs":true} 

              Password: ENCRYPTED 🔐 

           Period Name: Month Ended July 2020 

        Preview Result: true 

             Sender ID: XXXXXX 

       Sender Password: ENCRYPTED 🔐 

            Start Date: {"day":"","month":"","year":""} 

               User ID: XXXXXX 

Command description:  Retrieves a list of trial balances 

Authenticating with Sage Intacct... 

Successfully authenticated. 

Getting trial balances... 

The following errors were found: 

0: 

NUM: XL03000003 

DESCRIPTION: XML Parse schema error: Error 1871: Element 'startdate': This element is not expected. Expected is one of ( showzerobalances, showdeptdetail, showlocdetail, reportingbook, adjbooks, includereportingbook, statistical, departmentid, dept_subs, locationid ).. Line: 1, column: 0. [Support ID: 1SxPU%7EX3iikWE0BXH6Laf7bmMC2gAAAAg] 

CORRECTION:  

Error getting trial balances XML Parse schema error: Error 1871: Element 'startdate': This element is not expected. Expected is one of ( showzerobalances, showdeptdetail, showlocdetail, reportingbook, adjbooks, includereportingbook, statistical, departmentid, dept_subs, locationid ).. Line: 1, column: 0. [Support ID: 1SxPU%7EX3iikWE0BXH6Laf7bmMC2gAAAAg] 

Result: Error: Could not execute command: XML Parse schema error: Error 1871: Element 'startdate': This element is not expected. Expected is one of ( showzerobalances, showdeptdetail, showlocdetail, reportingbook, adjbooks, includereportingbook, statistical, departmentid, dept_subs, locationid ).. Line: 1, column: 0. [Support ID: 1SxPU%7EX3iikWE0BXH6Laf7bmMC2gAAAAg]