Finance : Query LID Transactions

[csoroka]

I got the following error when I tried to open up this template: The page cannot be displayed because an internal server error has occurred.

[kclark-a3]

update

model now builds with no error message from the server.

[csoroka]

I ran this report in the current prod and the new prod (2019 Org Budget) and added up all the amounts for all the rows Jan-Dec and they didn't match up. Can you look into this?

[kclark-a3]

Update

LID is currently being worked on by Jim. Once he's done, I provide another update.

[kclark-a3]

Update

LID amounts tie in both production and new system.

LIDTransactionsQueryfor_2021RevisedBudget.xlsx LID Query for 2021 Revised Budget.xlsx

[csoroka]

When I compare the current system results to new production I can see that the Row_ID column is missing, along with the "Account Code" displaying company code instead of the 4 digit account code. Although having the Company code on the report is helpful, so we would like that to remain on the report.

[kclark-a3]

In .Net row_id is itemization id. LID Query for 2022 Original Budget.xlsx

[csoroka]

Good morning - The account code is still incorrect on this report and is pulling the company code in error instead of the four digit account code. Thank you for correcting the other issues.

[AVHuntley]

Is the "company code" the 3-letter acronym that appears before the 4-digit account number on many accounts (e.g., FAL, FDN, HLD)? Assuming it was, I made a change to the formula in the ACCT CODE column (column H). Now, that column should show both the 3-letter acronym and the 4-digit code, if both exist:

I think that behavior more closely mirrors what I saw in this model on the current/old system. Can you take a look and let me know if this fixes the issue you'd identified?

[csoroka]

This is perfect, thank you