Error 47 - Substring reference out of string

[susanh]

Good Morning,

We are trying to post some receipts and are receiving the following error:

Error 47 - Substring reference out of string
Program POWUBD
Line 3630

I just wanted to get some pointers on how I maybe able to fix this issue before calling the Tech Support.

Any help would be great
Thanks
Sue

 

[BigLouie]

What is below was found on the Knowledge Base on the Sage support web site. If you are current on your maintenance you can get in there and find answers to most error messages.

Note: Extreme caution should be taken when selecting Debug. Only type the commands shown in the below instructions.

1. Recreate the error then go to Debug, type ? PO5$ and press enter. This will give the receipt number.
2. Type ? PO6$ and press enter. This will give line item that is missing the product line.
Note: Caution should be taken when using the options under the Repair Menu. If necessary, seek the assistance of a qualified Sage Software business partner or Customer Support analyst.
3. Open Library Master / Repair Menu and select Data File Display and Maintenance (DFDM). Click ok at the warning message.
4. At the File name type PO5XXX (XXX representing the 3 digit company code) and press enter.
5. In the Key Field type in the Receipt Number from Step 1 above and press enter.
6. Verify the Receipt Number and the Key are the same Receipt Number.
7. Look at field "02" and write down the number.
8. Go back to the File Name and type in PO6XXX and press enter.
9. In the Index Field enter the number from Step 7 and press enter. This record is the first line item in the Receipt.
10. Look at field "04", the first 15 characters will be the item number. If this is a regular Inventory Item, click the Edit button.
11. For the Field Number enter 4, press enter. Starting Position enter 82, press enter, Length enter 4 and press enter. Look at the Old Data Field, if it is blank then under Change Data enter the correct Product Line Code and click OK. Use CAPITAL letters for alpha characters. If the there is a product line then use step 12 below to go to the next line on the receipt.
12. Field 3 is the link to the next line item. In the index field enter the number from field 3. Repeat steps 10 and 11 until all items have a valid product line.

 

[susanh]

Thank you very much....

Do you have the link to that support site.....I can't seem to get to it.

I had a feeling it was a table out of sink, but didn't know how to go about fixing it.

Thanks
Sue

 

[BigLouie]

http://www.sagesoftwareonline.com/eservices/Main/frmLogin.aspx?timeout=true

You can also go to

http://www.sagesoftware.com

and log in and it will take you to support.

 

[susanh]

Hi again,

Well here we are about a month later and while researching another issue...stumble across an issue that I think has to do with the steps that MAS suggested in the above Error 47 we received.

I believe that this solution caused us to have a "Not On File" appear on our Daily Transaction Register under the Account Number.

When looking into the Receipt History...the same receipt is listed 3 times. 2 debits and 1 credit.

Could the above solution have written it again as a debit and not assigned it to an Account number?

I am looking on MAS's web site for answers also.

 

[BigLouie]

No. If you see Not On File for the account number it generally means that somehow you were able to delete the account from the GL before this was posted. Look at the account number, is it on file in the GL? Yes or No?

 

[susanh]

On the Daily Transaction Register, under the source Journal there are several entries. The last entry under our Source Journal of PO-001090 under the account number it says Not on File. The description is Not on File but the comment lists.

I believe you are absolutely correct, but I don't know the account number that was deleted. Where or how do I go from here so I can finish up my month end?

 

[BigLouie]

Add the account number back.

 

[susanh]

As you can tell...and I do apologize. I am no guru...can you give me some steps on how to do that?

 

[BigLouie]

Go to GL Account Maintenance.