Skip to main content
Solved

Trying to add Recurring Unit Price to the Service Contracts GI and getting Duplicate entries

jaymarzian
Varsity I
Forum|alt.badge.img

So the request was to add the Recurring Unit Price to the Generic Inquiry for Service Contracts [ScreenID: FS3057PL].   However, when I add the item to the results grid after joining the FSContractPeriodDet Table to the Parent Table: FSServiceContract, I get duplicate line entries on the GI.  I have tried a few things to remedy this and can’t seem to figure it out.  I tried grouping by the Service Contract ID, but it totals the amounts of the lines and that is not correct.  There should only be one line per Service Contract.

Here is the GI:
 

Here are the results:

 

 

Best answer by jaymarzian

i ended up building a custom GI that only shows a status of “active” on the FSContractPeriod table.  I am also using the “PeriodTotal” field to show my recurring fee.

 

 

View original
- John
Did this topic help you find an answer to your question?

5 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • nhatnghetinh
  • Captain II
  • 511 replies
  • June 13, 2024

Hi @jaymarzian 

FSContractPeriodDet is a detail DAC that can have many lines, so when you join FSServiceContract with FSContractPeriodDet, it will create many lines in case the Service Contract ID has many lines in the Tab 'SERVICES PER PERIOD' as shown in the screenshot below.

 

Best Regards,

NNT

I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/truongpham80
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
jaymarzian
Varsity I
Forum|alt.badge.img
  • jaymarzian
  • Author
  • Varsity I
  • 32 replies
  • June 13, 2024
nhatnghetinh wrote:

Hi @jaymarzian 

FSContractPeriodDet is a detail DAC that can have many lines, so when you join FSServiceContract with FSContractPeriodDet, it will create many lines in case the Service Contract ID has many lines in the Tab 'SERVICES PER PERIOD' as shown in the screenshot below.

 

Best Regards,

NNT

Hey NNT,

Thanks so much for responding.  I agree that this is normal behavior for items that have more than one detail line, but all of our Service contracts only have one detail line item in services per period.  I am wondering if it is perhaps picking up on two periods, but the line items are identical when they are duplicated.  Is there a way to remove duplicates from the view?

 

 

- John
jaymarzian
Varsity I
Forum|alt.badge.img
  • jaymarzian
  • Author
  • Varsity I
  • 32 replies
  • June 13, 2024

OK - I can see what is happening, but not sure how to get it to view just the one line.  Based on your filter setting for Actions, there is one line item for the current period (Search by Billing Periods) and one line item for the “upcoming period” (Modify Upcoming Billing Period). So I only need to display the current period, NOT the upcoming period.   

 

 

- John
jaymarzian
Varsity I
Forum|alt.badge.img
  • jaymarzian
  • Author
  • Varsity I
  • 32 replies
  • Answer
  • June 13, 2024

i ended up building a custom GI that only shows a status of “active” on the FSContractPeriod table.  I am also using the “PeriodTotal” field to show my recurring fee.

 

 

- John
Chris Hackett
nhatnghetinh
2 people like this
  • Chris Hackett
    Chris Hackett
  • nhatnghetinh
    nhatnghetinh
nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • nhatnghetinh
  • Captain II
  • 511 replies
  • June 14, 2024

Hi @jaymarzian 

Has your problem been resolved?

 

Best Regards,

NNT

I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/truongpham80
jaymarzian
1 person likes this
  • jaymarzian
    jaymarzian

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved