Sales balance checker job failed

Issue No: AR-16544
Created 3/9/2023 2:05:16 PM
Type Bug-QC
Priority Critical
Status Closed
Resolution Fixed
Fixed Version 21.2
Description *This issue relates to i21 Help Desk ticket:* [ HDTN-290367 - schedule sql jobs for inventory rebuild and out of balance checks|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-290367]   + *Steps:* +   For more detailed steps kindly follow this test case link: [http://jira.irelyserver.com/secure/Tests.jspa#/testCase/JWP-T45]   + *Issues:* +   Message Executed as user: NT SERVICE\SQLSERVERAGENT. Invalid object name '##POSTEDINVOICES'. [SQLSTATE 42S02] (Error 208) Failed to initialize sqlcmd library with error number -2147467259. [SQLSTATE 42000] (Error 22050). The step failed.   + *Acceptance:* +   Should be able to generate Customer Aging and Customer Aging Detail Report without any error