Discussions related to Crystal Reports development.
Moderator: Lisa Ennis
- Posts: 22
- Joined: Mon Nov 17, 2014 6:14 pm
In 2.6 in the GUI and database both reflect endorsement charges.
However, in 3.0 both reflect endorsement charges in the GUI, but not in the expected places in 3.0
File ‘X’ is reflecting endorsement charges in the 3.0 database, specifically:
Endorsement (XML) field data:
However, file ‘Y’ is not reflecting any data whatsoever in the above XML field.
Do you know of any issues?
Should we be looking in another place?
- Posts: 906
- Joined: Wed Jan 15, 2014 3:50 pm
- Location: Raleigh, NC
If I understand your question, you are saying that you are writing directly to the Select SQL tables: You are not allowed to write nor modify any SoftPro installed data table.
Much of the information is maintained in the order and tables may be used for reading only.
Bob Richards, Software Developer, SoftPro
- Posts: 77
- Joined: Thu Sep 11, 2008 1:57 pm
I believe the data Colin is looking at data stored in the pt.TitleCharge. Data writes to this table when a transaction is initially posted. If that table does not have what you need, you may need to join back to the Title and Endorsement tables in the pfm schema using the ChargeSource in the pt.RevenueDetail table.