x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 3 replies
  • Subscribers 119 subscribers
  • Views 579 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
91
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
962
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
KathyW

UDF PO ROI to AP_HistoryHeader & AP_TransactionPaymentHistory

SOLVED
Posted By

I created a Date UDF in PO Receipt of Invoice. it populates correctly. I'm trying to get this data into the AP_InvoiceHistoryHeader & AP_TransactionPaymentHistory.

I've tried several links and can't seem to get the correct combination.

Can someone tell me from PO_ReceiptHeader how I walk it through to these other 2 tables?

Parents
  • +1
    verified answer

    First create a UDF in this intermediary table:

    AP_InvoiceHeaderPosting
    Source = Business Object
    Business Object = PO_ReceiptRegister_upd
    Data Source = PO_ReceiptHeader
    Column = your UDF

    Then the UDF can go from the intermediary table to the destination tables:

    AP_TransactionPaymentHistory
    Source= Business Object
    Business Object = PO_ReceiptRegister_upd
    Data Source = AP_InvoiceHeaderPosting
    Column = your UDF

    AP_InvoiceHistoryHeader
    Source= Business Object
    Business Object = PO_ReceiptRegister_upd
    Data Source = AP_InvoiceHeaderPosting
    Column = your UDF

  • 0 in reply to Natasha Chang

    That did it. Thanks!

Reply Children

*Community Hub is the new name for Sage City