Skip to main content
Solved

Add Date of Service Column on Invoices

  • 13 September 2021
  • 8 replies
  • 273 views

Forum|alt.badge.img

I’m looking to add a "Date of Service" column to the Services > Invoice > Details grid.

I'm trying to add a column on the Details tab of the Invoices screen to show the Appointment Date for charges listed on the Details tab. It pulls this information just fine on one of my reports (relationships shown on the bottom row, Left join FSARTran to FSAppointment, in the attached image), but when I duplicate this join (the FSAppointments table to FSARTran) in the Generic Inquiry for the Invoices page, the fields are all there, and it saves with no errors, but it begins generating errors for our users. Anyone know how to add a column for Appointment Date to the Details tab of the Invoices screen?

I found the info (see image) for tying the Invoice to the Appointment Dates in the report file SO643000.RPX. All the fields seemed to be there and the tables appeared to add and relate without error. However, once I clicked Save, the system began generating errors when attempting to populate the Invoices page. It returns The multi-part identifier "FSARTran.AppointmentRefNbr" could not be bound.’

Anybody have any ideas? Thanks in advance.

 

Best answer by Naveen Boga

Hi @davidpoole21 

In the above screenshot, “Table Relations” grid, you are joining the ARTran with FSARTran, which is causing the issue.

Can you please change like below and verify.

Join FSTran with ARTran

 

 

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

greglang
Varsity I
Forum|alt.badge.img+1
  • Varsity I
  • September 13, 2021

2 things I would say here.  One we need to know how the line above is setup to relate ARTran to FSARTran and two you need to list the Service order type to the connection between the Tran and the appointment.

 

The other option would be to link by AppointmentID which is in the ARTran and FSAppointment table.


Naveen Boga
Captain II
Forum|alt.badge.img+19

Hi @davidpoole21   Are you verifying this report in newer version like (2021 R1) ?

If yes, the above fields modified in newer versions. Please join the tables using below conditions. 

Hope this helps!

 

 


Forum|alt.badge.img

Thanks to Greg Lang and Naveen B for the responses.

Greg is right; I should have included more info.  I didn’t see an AppointmentID in the ARTran table, so I couldn’t link them that way.

Yes, Naveen, we’re using 2021 R1, so maybe that explains part of it, but when I tried your suggested join conditions, I got:

 

Here is my setup:

 

 

Any further help is greatly appreciated.


Naveen Boga
Captain II
Forum|alt.badge.img+19

Hi @davidpoole21  FSARTran should join with ARTran instead of ARTran joining with FSARTran and check once.

 

 


Forum|alt.badge.img

Now I get:

 

I’m sorry to be so dense, but I don’t understand what you mean by “check once.” My config now is:

 

 


Naveen Boga
Captain II
Forum|alt.badge.img+19

Hi @davidpoole21 

In the above screenshot, “Table Relations” grid, you are joining the ARTran with FSARTran, which is causing the issue.

Can you please change like below and verify.

Join FSTran with ARTran

 

 


Forum|alt.badge.img

Sorry, I got an error and the system switched them back without my noticing.

 

That looks like it might be working now. THANKS SO MUCH!


Naveen Boga
Captain II
Forum|alt.badge.img+19

@davidpoole21 Great :) Thanks for the update.


Reply


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