Shared Transactions - Shared Payments - Sourcing Segments

Overview

Shared Payments copies segment values from each line of the vendor bill onto the Advanced Intercompany Journal Entry (AICJE) it creates. A segment is copied only when its Shared Transaction Sourcing record has a value in Shared Payment: To Shared Payment on the Advanced Configuration subtab. To set up standard segments, see Shared Transactions - Shared Payments - Transaction Line Sourcing.

Values always come from the bill's lines, not its header. To put a different value on the AICJE, such as a location in the paying subsidiary or the bill's header department, store that value in a custom transaction line field and source that field instead. This article covers location first, then the same setup for any segment.

Sourcing location

Each location belongs to a single subsidiary, so the location on the bill is not valid in the paying subsidiary. Use a second location field for the paying subsidiary's lines.

  1. Go to Customization > Lists, Records, & Fields > Transaction Line Fields > New. Label the field "Destination Location" or another name your users will recognize. Set Type to "List/Record" and select the "Location" list. Check Store Value, then apply the field to purchase transactions so it appears on both expense and item lines.

  1. Go to Netgain > Setup > Shared Transaction Sourcing and create a new sourcing record. In Transaction Line Copy Column, select Destination Location. On the Advanced Configuration subtab, set Shared Payment: To Shared Payment to Location.
  2. Open the native Location sourcing record (created when Shared Transactions is installed) and confirm Shared Payment: To Shared Payment is also set to Location.

Sourcing a different value for any segment

Use the same pattern when the AICJE needs a value other than the one on the bill line. For location, use the Sourcing location section above instead. A common case is a company that sets department on the bill header and wants that department on the AICJE's accounts payable lines, instead of the department from each expense line.

  1. Create a custom transaction line field for the segment, for example a List/Record field pointing to Department. Check Store Value and apply the field to purchase transactions so it appears on both expense and item lines.
  2. Fill the field on every bill line. A default value, a workflow, or a script can copy the header value onto each line.
  3. Create a new sourcing record. In Transaction Line Copy Column, select the custom field. On the Advanced Configuration subtab, set Shared Payment: To Shared Payment to the segment, for example Department.
  4. Open the native sourcing record for that segment and clear Shared Payment: To Shared Payment. If both records are set, the native value overwrites the custom one. This doesn't apply to Location, which uses the setup above.

Was this article helpful?