0

How to massively link all invoices to their customer?

I have imported a customer table with 300 records and an invoice table with 500 records. Both tables have the customer no. How to massively link all invoices to their customer? I know how to do it one by one from the tutorial. Is there a way to complete the linkage all in one go? Please advise. 

2 replies

null
    • Support
    • 5 yrs ago
    • Reported - view
    • slee3010
    • 5 yrs ago
    • Reported - view

    Thank you, Birger, for the information.  I tired the mass-data-update as you suggested.

    It's very useful for the regular data fields. However, the linked filed seems to take the data as row-id and ended up linked to the wrong customer.  

    For example, in my invoice table, I have imported cust no, 22NDTI, I added a linked field to the customer table(cust no).  I used the mass data update, only the number 22 was updated to the linked field. The customer with row_id 22 was linked to the customer no "22NDTI" in the invoice.  As row_id and cust_no are different fields. I got a mismatch. 

    Any further solution is greatly appreciated!  

    Serina

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 2244Views