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

SOLVED

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!

  • 0
    verified 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

  • 0 in reply to TomTarget

    Tom this was exactly the issue, there were 15 invoices without a invoice date. Your solution was spot on, I appreciate your help!