search

afs1jes / Clarins-US-IR-Migration

0 stars 0 forks source link

Load Finance - CGNA #90

Open afs1jes opened 1 year ago

afs1jes commented 1 year ago

Updated SQL grid on FlipOnLoad sheet. Added 'dummy' column to the left of the grid that allows AccountNumber formula to get copied down correctly.

New SQL query: SELECT '' AS AccountNumber, AccountsName, AccountType FROM [Dimension].[Accounts] where AccountType = '-1'

RobSarajian commented 1 year ago

Data Load Report Jan 2022 CGNA TransactionsFIN_xlsx 2023-03-31 19-31-37.xlsx

Not matching Production. The total should be 10,870.27 income. In Dev it is -22270.65 as all of the accounts below Op profit are doubled.

RobSarajian commented 1 year ago

Book6.xlsx

Here's the Facto Fees account showing 0 Department as well as Department 000.