By using this website, you agree to our Terms of Use (click here)
I am trying to create an Export Scenario for Invoices. It is mostly header information and I want to include the Ship To Address from the Invoice in the results.
I am using the Invoices and Memos screen for the source.
When I map the Ship To Address of the Invoice, and run the export, the Ship To Address fields repeat for every invoice included in the results. It looks like the address is from the first record in the results and repeated for all subsequent records.
How do I prevent the Address information from being repeated and show the Ship To address associated with the Customer/Invoice?
Solution is to add "=Every" on the Key Field.
In this instance, I was exporting Invoice information which included an address. The key field for invoices is the "Reference Nbr." field.
Adding the following mapping row solved the issue for repeating column values:
Source Object: Invoice Summary
Field/Action Name: Reference Nbr.
Target Field/Value: =Every