Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Error Number = 9284 W...
Finance | Project Operations, Human Resources, ...
Answered

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

(0) ShareShare
ReportReport
Posted on by Reggie 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.

Categories:
Microsoft Dynamics GP
  • 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans