51
When the invoice is automatically made from the Invoice Setup for Agreements, how do we control that workflow to map another field. At the very least we need to map the associated Agreement so we can write a workflow that copies over some other information to the Invoice. Little surprised the system doesn't already do this by default.
But I can't seem to find where this automatic behavior is managed. Is it a workflow or a Relationship or something else?
Hi jdaniel1,
When you set Invoice Setup, you need set up Agreement invoice Products, it can be related to current agreement.
However, Out of the box the Invoice entity doesn’t have a relationship to Agreement, and Agreement has 1:N relationship with Invoice Product.
So you need create one lookup to agreement firstly, then copy agreement value from invoice product to the new lookup on the invoice through workflow.
Refer to the following link for detailed steps:
=====
Or you can refer to Gabriel idea, use flow to update Invoice with value from the 'Agreement' lookup field of 'Agreement Invoice Date' entity when 'Invoice' lookup field updated.
You also need create one lookup to agreement firstly--build 1:N relationship between Agreement and Invoice entities.
Agreement and Agreement Invoice Date is 1:N
Invoice and Agreement Invoice Date is 1:N
Hi Daniel.
Field Service controls when the invoices are created from this table Agreement Invoice Date (msdyn_agreementinvoicedate). The msdyn_invoicestatus will update to Processed (690970001), and the field msdyn_Invoice (lookup) will be populated with the new invoice.
You can trigger your custom logic on the update of the field msdyn_Invoice to update the new invoice.
I have done it many times with Flow.
Updating the Invoice Status Reason (statuscode) to Billed (4). Field Service will create records on the actual table.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (