search

afs1jes / Clarins-US-IR-Migration

0 stars 0 forks source link

Load Finance - LBC #78

Open AVHuntley opened 1 year ago

AVHuntley 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 LBC TransactionsFin_xlsx 2023-03-31 19-28-35.xlsx

Same as Ecom, says it loaded in Jan 2022 but A3 is showing no data.