Microsoft Dynamics GP (Archived)

Batch won't come out of Batch Recovery.

(0) Share

Report

Posted on by Community Member

Hi!

I keep getting the below error when trying to post a batch.

Illegal address for field 'Origin' in script 'CreateReferenceRec.' Script terminated.

Here's some background on what happened:

I printed a check from the Payables Transaction Entry window, but when I went to print, it kept giving me the above error message. (Illegal address for field 'Origin'...) So to avoid having to re-print the check, I posted the transaction from the Payables Batches window. This kicked the batch over to the Batch Recovery window. Now that I'm trying to recover the batch, I'm getting a message stating that the "batch failed to complete posting. Use the Batch Recovery window to complete the posting process." When I click More Info on that same error pop-up, it gives me the above error message again (Illegal address for field 'Origin' in script...)

Can anyone help me out on this one?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

KirkLivermont 5,985 on at

Like (0)

Report

RE: Batch won't come out of Batch Recovery.

Leslie's recommendation is probably correct but I would recommend running checklinks, and seeing if it resolves the issue before you start manually changing data in SQL.

Kirk

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
RE: Batch won't come out of Batch Recovery.

I had a similar error posting Sales Documents that had "Document Attachments". It was difficult to troubleshoot, because not every SOP Doc had a Document Attachment, so some would post successfully, and others would fail with this error.

The column "AllowAttachmentFlow" in table CO00102 was being set to 0 by an add-on product. The only valid numbers for this field are 1 or 2 for the GP 2016 R2.

To fix this we did the following:

1) In Tools>Setup>Company>Document Attachment Setup,

mark the boxes to Allow Attachments to flow from Master Records for Customers, Vendors and Items

select the Radio button next to Type "Flow".

2) Update that field in the CO00102 and set it to 1.

update CO00102 set AllowAttachmentFlow = 1 where AllowAttachmentFlow = 0

After that, we were able to post the documents successfully.

Unfortunately, the sales docs that received this error were being posted to Receivables but never moved to SOP History.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: Batch won't come out of Batch Recovery.

Hi,

At this stage of the game I normally fire up SQL and edit the SY00500 table to 'free up' the batch. It doesn't fix anything necessarily, but It gives you a fighting chance at troubleshooting. In the SY00500 table I look at the following fields: (well, I really look at all of them for discrepancies with the other batches.)

Marked to Post - MKDTOPST

Checks Printed - CHKSPRTD

Batch Error Message 1 - BCHEMSG1

Batch Error Message 2 - BCHEMSG2

Batch Status - BCHSTTUS

Error State - ERRSTATE

Typically, I only change the Marked to Post and Batch Status Fields. You should be able to print the edit lists after making the changes. The changes will allow you to open the batch.

To troubleshoot this a bit, I'd look at my payables module's A/P trial balance and make sure there isn't anything hanging. Also look at the checkbook register to see if anything got as far as the checkbook. Finally look at the state of the GL. If your Payables are OK and your checkbook hasn't been touched, I'd be tempted to just delete the transaction altogether and start over. I'd probably just delete the batch unless I had some other transactions in it. I'd move the good transactions to a new batch and leave the bad one in there alone. Then I would delete the batch.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Batch won't come out of Batch Recovery.

I created the check in the Purchasing Transaction entry screen.

It won't let me view transaction again. When I try opening up the batch from the Payables Batch Entry screen, it gives me the below pop-up message.

But then when I go to the Batch Recovery screen, check the batch and click Continue, it gives me this error message:

Is there any other way to get to the transaction to print the edit list?

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

RE: Batch won't come out of Batch Recovery.

Where did you create the Check? Did you create it in the Purchasing Transaction entry screen?

Can you go back to the Transaction you were trying to post and see if you can print an edit list for the batch?

From there you often get a bit more of an idea of the problem - like missing datum from the the fields.

Post back and continue to assist.

Was this reply helpful? Yes No