x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 118 subscribers
  • Views 1048 views
  • Users 0 members are here
Browse Forums
Announcements
271
topics
260
replies
Databases and Operating Systems
771
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
854
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
878
topics
3k
replies
Sage CRM for Sage 300
184
topics
415
replies
PhilMcIntosh

Error adding an item to a sales order

Posted By

I have created a C# web service suing the Sage 300 objects, and all is working well except when I try to add another line to an existing order I get:

"Order Detail. Attempt to modify a different record than was retrieved." 

This occurs on the code 

oeOD.Update();

ORDUNIQ, ITEM, QTYORDERED, CUSTOMER, LINENUM have been set successfully.

If I send a POST instead of PUT, I get a different error in the same place:

"Internal error.  Order Detail. Operation not allowed."

Anyway around this other than disallowing adding items to orders in the calling app?

Parents
  • 0

    Have you changed the .Order of any of the OE views?  What do your view compositions look like?

  • 0 in reply to Django

    The code works for adding an order, but errors when adding to an existing order.

    Composition:

    // Compose the Header and Detail views together.
    oeOH.Compose(new AccpacCOMAPI.AccpacView[] { oeOD, null, oeOHC, oeOHP, oeOHfq, oeOHOpt });
    oeOD.Compose(new AccpacCOMAPI.AccpacView[] { oeOH, oeODOpt, oeODB, oeODK, oeODS, oeODL });
    oeOHP.Compose(new AccpacCOMAPI.AccpacView[] { oeOH });
    oeOHC.Compose(new AccpacCOMAPI.AccpacView[] { oeOH, oeOD });
    oeOHfq.Compose(new AccpacCOMAPI.AccpacView[] { oeOH });
    oeOHOpt.Compose(new AccpacCOMAPI.AccpacView[] { oeOH });
    oeODS.Compose(new AccpacCOMAPI.AccpacView[] { oeOD });
    oeODL.Compose(new AccpacCOMAPI.AccpacView[] { oeOD });
    oeODOpt.Compose(new AccpacCOMAPI.AccpacView[] { oeOD });
    oeODK.Compose(new AccpacCOMAPI.AccpacView[] { oeOD, oeODKS, oeODKL });
    oeODKS.Compose(new AccpacCOMAPI.AccpacView[] { oeODK });
    oeODKL.Compose(new AccpacCOMAPI.AccpacView[] { oeODK });
    oeODB.Compose(new AccpacCOMAPI.AccpacView[] { oeOD });

Reply
  • 0 in reply to Django

    The code works for adding an order, but errors when adding to an existing order.

    Composition:

    // Compose the Header and Detail views together.
    oeOH.Compose(new AccpacCOMAPI.AccpacView[] { oeOD, null, oeOHC, oeOHP, oeOHfq, oeOHOpt });
    oeOD.Compose(new AccpacCOMAPI.AccpacView[] { oeOH, oeODOpt, oeODB, oeODK, oeODS, oeODL });
    oeOHP.Compose(new AccpacCOMAPI.AccpacView[] { oeOH });
    oeOHC.Compose(new AccpacCOMAPI.AccpacView[] { oeOH, oeOD });
    oeOHfq.Compose(new AccpacCOMAPI.AccpacView[] { oeOH });
    oeOHOpt.Compose(new AccpacCOMAPI.AccpacView[] { oeOH });
    oeODS.Compose(new AccpacCOMAPI.AccpacView[] { oeOD });
    oeODL.Compose(new AccpacCOMAPI.AccpacView[] { oeOD });
    oeODOpt.Compose(new AccpacCOMAPI.AccpacView[] { oeOD });
    oeODK.Compose(new AccpacCOMAPI.AccpacView[] { oeOD, oeODKS, oeODKL });
    oeODKS.Compose(new AccpacCOMAPI.AccpacView[] { oeODK });
    oeODKL.Compose(new AccpacCOMAPI.AccpacView[] { oeODK });
    oeODB.Compose(new AccpacCOMAPI.AccpacView[] { oeOD });

Children

*Community Hub is the new name for Sage City