Contract # in the middle of an Invoice

I have a report with a Contract # in the middle of the Invoice. The Detail option is already being used for the billing information. If I use Append to capture the Contract # only half of the results will receive the data the rest is NULL. if I use Header or Footer it is the same issue. How do I capture the Contract# for all line items?

Find more posts tagged with

English

Monarch

Accepted answers

All comments

Baba_Majekodunmi_703

Hi Nicole,

From what you’ve described I would create a second model and make the contract # the detail template, then I would combine the two models together using data prep studio.

Does that make sense? Would you like an example?

If you look at the templates we have in our Monarch App Library for “Invocies” you’ll see some prebuilt templates where we’ve done this.

Nicole Gutierrez

Thanks so much. I will review the pre-built templates as we really only use the classic version of Monarch.

Nicole Gutierrez

Where do I locate the Monarch App Library?

Baba_Majekodunmi_703

Where do I locate the Monarch App Library?

Here it is: Monarch App Library

Nicole Gutierrez

Thank you so much Baba!

Baba_Majekodunmi_703

Thank you so much Baba!

By the way, you should also consider getting formally certified in Monarch....

Monarch Certification

CPorthouse

Is it possible to share a sample of the report or a screenshot showing the layout (with any sensitive info redacted)? Does the contract # appear in the same position relative to the detail? You may be able to use a multi-line sample.

Are you using Classic or Data Prep Studio? If using DPS, another option would be to use the append or footer and then use sorts and ditto's to fill in the missing values.