Error #47 Substring reference out of string AR period end for May

Question

Hello, 
 We've been trying to close AR for May and are receiving this error every time in 'Program' AR_PERIODENDPROCESSING_UI, Line 631. Any help, I've seen similar issues trying to research a solution but all are for different modules such as inventory. One solution from BigLouie is to : Make sure there are no cash receipts in progress. (We do not checked this) Rebuild the keys for AR1 Rebuild the sort files. 
 However I am not sure if this solution would apply to me. I have attached some screenshots. Any help would be appreciated. Thank you!

TomTarget · Accepted Answer

This may or may not be a match, but it is worth checking out. Your invoice number with the problem appears to be 0243551IN. 
 Products 
 Sage 100 ERP 
 Description 
 Error: "47 AR_PeriodEndProcessing_ui.pvc 645" when running AR Period End Processing 
 Disclaimer 
 Backup Warning 
 Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage Business Partner, network administrator, or Sage Customer Support Analyst. 
 Cause 
 The Invoice Date field in AR_OpenInvoice.m4t may be blank. 
 Resolution 
 Determine the affected invoice transaction(s) 
 Select Info, Debug at the Error screen and enter the following command: 
 ? OpenInv.InvoiceNo$ 
 Select Library Master, Utilities, Data File Display and Maintenance 
 Select ..\Mas90\MAS_xxx\Arxxx\AR_OpenInvoice.M4T (xxx = company code) 
 Select the record from step 1 and click the Edit button 
 In the Field Number list, select 5 - InvoiceDate$ 
 In the Change field, add the invoice date with date format YYYYMMDD 
 Click the OK button. 
 Perform Period End Processing 
 Repeat steps if error occurs again. It is possible multiple records have issue

Sage 100

Error #47 Substring reference out of string AR period end for May

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING