x Want to participate? Join the group to interact
  • Replies 7 replies
  • Subscribers 104 subscribers
  • Views 2718 views
  • Users 0 members are here
Browse Forums
Announcements
270
topics
260
replies
Databases and Operating Systems
760
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
852
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
876
topics
3k
replies
Sage CRM for Sage 300
183
topics
412
replies
Dana B. Stidsen

Sage 300 2019 with PU4 integrated with Sage CRM 2019 R2

Posted By

Client with the configuration above is reporting an issue in the Sage 300 Order Entry (Not Web based) 

The error is:

"Unknown RSCID used in CRMReportOrder. (1158 oeordg1.CPP)."

"Posting failed. You must enter the  shipment again"

This happened twice on the same workstation different orders.

Does anyone know what's causing this? 

Any and All Advice Greatly Appreciated

Parents

  • For anyone experiencing this issue, I created the following query to locate the 'orphaned' quotes in OE:

    SELECT SAMINC.dbo.OEORDH.ORDNUMBER, dbo.Opportunity.Oppo_OpportunityId, dbo.Opportunity.Oppo_Description, dbo.Opportunity.Oppo_UpdatedBy, dbo.Opportunity.Oppo_UpdatedDate,
    dbo.Opportunity.Oppo_Deleted, dbo.Users.User_Logon
    FROM dbo.Opportunity INNER JOIN
    dbo.Users ON dbo.Opportunity.Oppo_UpdatedBy = dbo.Users.User_UserId RIGHT OUTER JOIN
    SAMINC.dbo.OEORDH ON dbo.Opportunity.Oppo_OpportunityId = SAMINC.dbo.OEORDH.OPPOID
    WHERE (dbo.Opportunity.Oppo_Deleted = 1) AND (dbo.Opportunity.Oppo_OpportunityId <> 0)

Reply

  • For anyone experiencing this issue, I created the following query to locate the 'orphaned' quotes in OE:

    SELECT SAMINC.dbo.OEORDH.ORDNUMBER, dbo.Opportunity.Oppo_OpportunityId, dbo.Opportunity.Oppo_Description, dbo.Opportunity.Oppo_UpdatedBy, dbo.Opportunity.Oppo_UpdatedDate,
    dbo.Opportunity.Oppo_Deleted, dbo.Users.User_Logon
    FROM dbo.Opportunity INNER JOIN
    dbo.Users ON dbo.Opportunity.Oppo_UpdatedBy = dbo.Users.User_UserId RIGHT OUTER JOIN
    SAMINC.dbo.OEORDH ON dbo.Opportunity.Oppo_OpportunityId = SAMINC.dbo.OEORDH.OPPOID
    WHERE (dbo.Opportunity.Oppo_Deleted = 1) AND (dbo.Opportunity.Oppo_OpportunityId <> 0)

Children
No Data

*Community Hub is the new name for Sage City