Solved

We do not wish to use Sales Part Cross reference functionality .

  • 7 February 2022
  • 6 replies
  • 165 views
K
Rank
Userlevel 4
Badge +7

Is there a basic data setup that makes the system use Sales Part Cross Reference.  We have recently upgraded to VS10 and did not have to use this in VS8.  How do we stop this error occurring - ORA-20110: ExternalCustOrderLine.CUSTOMERPARTNOERROR: Customer's part number ****** does not exist in sales part cross reference.  

icon

Best answer by Oshada Samarasinghe 7 February 2022, 14:50

View original
This topic has been closed for comments

6 replies

Vimukthi Mahakumbura
Rank
Userlevel 7
Badge +18

@klorimer, yes in the later updates Sales Part Cross Reference is imposed in several flows. I have come across few in Incoming CO flows. What is the context of your flow?
In one situation, we opted to use GTINs only in the incoming message, where it helped to function without using the Sales Part Cross Reference.  

https://www.linkedin.com/in/vimukthi-mahakumbura-9b2296aa/
K
Rank
Userlevel 4
Badge +7

@Vimukthi Mahakumbura thank you for your fast response.   This is a bit of a pain that for every sales part we will need to have a cross reference per customer ?  Why would this not have remained optional?  We do not require both Customer Part No. and a Sales Part No. in the incoming message as both are the same.  

K
Rank
Userlevel 4
Badge +7

@Vimukthi Mahakumbura sorry I  should have stated that it is in the Incoming Customer Order we are getting the error.

 

 

Vimukthi Mahakumbura
Rank
Userlevel 7
Badge +18

@klorimer, yes I agree with you, it can be cumbersome. But that is required basic data. What I hear from RnD is that, there have been several developments in this area, and that has caused this change. 
May I know what information is passed towards your ICO, with regards to the part no information? 

https://www.linkedin.com/in/vimukthi-mahakumbura-9b2296aa/
O
Rank
Userlevel 4
Badge +6

Hi @klorimer ,

This part of the code was introduced from bug id 150878.


If the Sales_Part_Cross_Reference is not entered, no internal PO is used and If the customer part number has a value, the code will raise the above error message.


According to the code , below are the ways of bypassing this error.
1. If the customer part number is null
2. If an internal PO is used ( when the sales part is available in both sites, customer_part_no can be used in place of catalog_no, even though Sales_Part_Cross_Reference is not entered) 

Best Regards,
Oshada

K
Rank
Userlevel 4
Badge +7

Thank you @Oshada Samarasinghe we will try and use your option 1 , leave the customer part number null. We just need to understand which field to update for the Sales Part No. and not the Customer Part No. 

 

The below is the current setup Customer Part No. , unsure of which line needs updated for the Sales Part No. 

 

Terms & ConditionsCookie settings