Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

Error Number = 9284 When I transfer a back order to order then update this order by using eConnect

Posted on by 10

Hi Experts, 

I met an issue. When I transfer a back order to order. The TRXFREQU in SOP10100 about this new order was updated to 1.(The frequency in Sales Document Detail Entry) But the Allow Repeating Documents check box is not checked in SOP Setup for this order type. 

When I use Econnect to update this sales order, it will return the error :

Error Number = 9284  Stored Procedure= taSopHdrIvcInsert  Error Description = The Allow Repeating Documents check box is not checked in SOP Setup for the DOCID, a value other then 0 for Repeating, Frequency, Times to Repeat, or Quote Days to Increment can not be used.

It was caused because TRXFREQU has been changed to 1 in DB. But the Frequency in the user interface was disabled, it should be 0 in DB.

Why this field was changed?

Could anyone please help on this issue ?

Thanks.

  • Reggie Profile Picture
    Reggie 10 on at
    RE: Error Number = 9284 When I transfer a back order to order then update this order by using eConnect

    Hi Isaac,

    Now the issue makes sense .It's very helpful.

    Thanks a lot!

  • Verified answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: Error Number = 9284 When I transfer a back order to order then update this order by using eConnect

    Hi Reggie,

    I did a little more research on that field, and our code always sets this TRXFREQU column to be a 1 when a sales transfer occurs.  So if you transfer a back order to an order, or an order to an invoice for example, we always set this field to a 1 in those scenarios in our code.  I don't see any significance for why it would need to be a 1, but it is what our code does by default on transfers.  With that being said, I really don't see this being a major concern to be updated to 0, BUT you could simply add a post proc to just revert it back to 1 when you push the data back in and then its in the same condition that you originally had and you wouldn't have to worry about any unforeseeable side effects.

    I hope this helps!

    Isaac Olson

    Microsoft Support

  • Reggie Profile Picture
    Reggie 10 on at
    RE: Error Number = 9284 When I transfer a back order to order then update this order by using eConnect

    Hi Experts,

    Add pre-proc logic to the taSopHdrIvcInsertpre to update TRXFREQU back to 0 can fix this issue. But I am concerned if we update it to 0 in database directly .Would it cause any other issues down the line ? Is TRXFREQU has other function except representing Frequency in the user interface ? TRXFREQU was update to 1 when I transfer a back order to order in the user interface. It has already been 1 before I pass the XML with eConnect. 

    Thanks for your reply!

  • Verified answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: Error Number = 9284 When I transfer a back order to order then update this order by using eConnect

    Hello, 

    I cannot say that I have specifically seen this issue before, but you could just add pre-proc logic to the taSopHdrIvcInsertpre stored procedure to check for anything other than 0 on the TRXFREQU  and if it is, update it back to 0.  This would help you avoid this error message in an automated fashion before the check is ran. 

    If you want to dig further into why this would have occurred you could open a support case and we could review your process and what XML you are passing through eConnect to identify why it would change to a 1, but I am not sure if that is worth your time compared to just putting a Pre-Proc in place. 

    If anyone else in the community has your same setup and has ran into this issue, hopefully they will post on the thread as well. 

    [quote user="Reggie"]TRXFREQU [/quote]

    Thanks,

    Isaac Olson

    Microsoft Support

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans