Forum Discussion
Advocate IIRevenue and Expenditure Table Variance
I tried to simulate a case like yours, and this is the results...
Solution Specialist
Advocate III am getting one error but I am thinking because I probably should have given more dummy data in the file.
The error message when creating the Sales Center column in the Center Code created table says: "A table of multiple values was supplied where a single value was expected."
The real file has 150 locations that repeat by operating year. There are other fields in the report but not really relevant. The ones provided in the dummy file are the ones that I really focus on.
Any thoughts?
- BILASolution
Additionally, I think that error is because of there are different Center's names for the same Center Code in Revenue table. Check it.
- JMWDBA
As I look at it, this is indeed the case. When a location may have moved in a previous operating year, it kept the same number but took on the name of where it moved. For accounting purposes, the name in effect for that operating year remained instead of being overridden even if it was in the same city and just moved to a different address.
Then I have discovered that two of our locations have no code at all. So truly now the only thing consistent between both tables is the name of the location within an operating year. What do I do with this?
- BILASolution