Skip to main content
Solved

Custom field synchronizing error in purchase order line window.

  • September 7, 2022
  • 3 replies
  • 341 views
Anupa Arachchige
Sidekick (Employee)
Forum|alt.badge.img+6

When adding a view to a custom field, an error pops up when synchronizing.

The customer follows the below steps.

  1. Create read only custom field for Purchase Order Lines
  2. Select statement using arguments order_no,line_no,release_no

SELECT MAX(ifsapp.receipt_info.arrival_date) FROM ifsapp.receipt_info WHERE ifsapp.receipt_info.source_ref1 = :ORDER_NO AND ifsapp.receipt_info.source_ref2 = :LINE_NO AND ifsapp.receipt_info.source_ref3 = :RELEASE_NO

  1. Data type of custom field: Date and format: Date
  2. Click on detailed views and add receipt_info_alt
  3. Approve and publish/synchroinze 

 

  1. Synchronize and it errors.

 

Any solutions? 

 

Best answer by Tharindu Sooriyaarachchi

Hi Anupa,

 

Register arrival is considered as a general object and it has columns source_ref1, source_ref2, source_ref3 instead of order_no, line_no, release_no. Since the customer is trying to use order_no, line_no, release_no in Receipt_Info_Alt view, the issue pop ups.

 

Could you try to create custom field for Purchase Order Lines as below.

 

select statement using arguments:

v.objkey

 

Select statement:

SELECT MAX(r.arrival_date) FROM receipt_info r WHERE 1=1 AND r.source_ref1||r.source_ref2||r.source_ref3 = (SELECT p.order_no||p.line_no||p.release_no FROM purchase_order_line p WHERE p.objkey = :objkey)

 

Method Signature:

Purchase_Order_Line_Cfp.Get_Cf$_Last_Rec_Date(v.objkey)

 

Best Regards,

Tharindu

 

 

View original
Did this topic help you find an answer to your question?

3 replies

Tharindu Sooriyaarachchi
Hero (Employee)
Forum|alt.badge.img+6

Hi Anupa,

 

Register arrival is considered as a general object and it has columns source_ref1, source_ref2, source_ref3 instead of order_no, line_no, release_no. Since the customer is trying to use order_no, line_no, release_no in Receipt_Info_Alt view, the issue pop ups.

 

Could you try to create custom field for Purchase Order Lines as below.

 

select statement using arguments:

v.objkey

 

Select statement:

SELECT MAX(r.arrival_date) FROM receipt_info r WHERE 1=1 AND r.source_ref1||r.source_ref2||r.source_ref3 = (SELECT p.order_no||p.line_no||p.release_no FROM purchase_order_line p WHERE p.objkey = :objkey)

 

Method Signature:

Purchase_Order_Line_Cfp.Get_Cf$_Last_Rec_Date(v.objkey)

 

Best Regards,

Tharindu

 

 

https://www.linkedin.com/in/tharindu-sooriyaarachchi-2239b2142/
S
Ragul Ravindira
Anupa Arachchige
5 people like this
  • S
    Sahan Wellala
  • Ragul Ravindira
    Ragul Ravindira
  • Anupa Arachchige
    Anupa Arachchige
  • H
    Hashane Bolonne
  • D
    Dihan Perera
Anupa Arachchige
Sidekick (Employee)
Forum|alt.badge.img+6
  • Anupa Arachchige
  • Author
  • Sidekick (Employee)
  • 9 replies
  • September 8, 2022

Hi Tharindu,

Thanks for the reply. Customer was able to create custom field for Purchase Order Lines as you have suggested. 

 

Thanks and regards,

Anupa

 

 

Tharindu Sooriyaarachchi
D
2 people like this
  • Tharindu Sooriyaarachchi
    Tharindu Sooriyaarachchi
  • D
    Dihan Perera
L
Sidekick (Customer)
Forum|alt.badge.img+11
  • lisa.gilesAB
  • Sidekick (Customer)
  • 99 replies
  • August 9, 2023

I am experiencing this issue but I am trying to publish into Register Arrivals, Do I need to do a similar change to the SQL? 

I want to publish a Custom Field into Approved Detail Views Receipt_Info_Alt for a field already visible via Purchase_Order_Line_All.

Arguments: v.order_no,v.line_no,v.release_no

Select Statement: Select CF$_TVS_LINE from Purchase_Order_Line_Part_Cfv where Order_no = :order_no and line_no = :line_no and release_no = :release_no

 

Thanks, 

Lisa

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings