Spreadsheet: 773523d1647894120-if-lookup-formula-needed-please-quite-simple-example
Sheet: Finance_MonthlyReview_Trans (2)

Finance - GL Entries
Settings:
Account: | 913010 - Net Sales TS
Period: | 2022 - Feb
Status: | All
Region: | 2-826-01 - United Kingdom General
Navision | Account | Posting Date | Acquisition | Month | Profitcenter | Region | Document No. | GL Entry |  | SWOJobNo | Description | CustomerNo | CustomerName | Customer
United Kingdom | 320100 - Sales - Services SS/TS | 2022-02-28 00:00:00 |  | 2022 - Feb | 02.50 ENTERPRISE | 2-826-01 | GB0222 REVREC | 2121037 - RevRec FF/71/228/35,750/70.00/22,530 |  | GB-OPP-149009 | TS_HSF_DPS/ECIF | GB-SCU-107588 | [NAME]
United Kingdom | 320100 - Sales - Services SS/TS | 2022-02-28 00:00:00 |  | 2022 - Feb | 02.60 CORPORATE | 2-826-01 | GB0222 REVREC | 2121049 - RevRec FF/106.25/296.25/37,500/38.00/37,500 |  | GB-PRJ-500187 | TS_ 27 x M365 T&M
United Kingdom | 420100 - COGS - Services SS/TS | 2022-02-01 00:00:00 |  | 2022 - Feb | 03.20 TS | 2-826-01 | NIVOLNONIC2019 | 2096749 - NIVOL 3rd Party Accrual - FY 2019 |  | GB-OPP-137811 | GDPR - step 2 | GB-SCU-112858 | Qualasept Ltd T/A Bath ASU
United Kingdom | 420100 - COGS - Services SS/TS | 2022-02-01 00:00:00 |  | 2022 - Feb | 03.20 TS | 2-826-01 | NIVOLNONIC2019 | 2096754 - NIVOL 3rd Party Accrual - FY 2019 |  | GB-OPP-138239 | Win 10 and EMS Ongoing Service | GB-SCU-113425 | Lewis Trust Group
United Kingdom | 420100 - COGS - Services SS/TS | 2022-02-01 00:00:00 |  | 2022 - Feb | 03.20 TS | 2-826-01 | NIVOLNONIC2019 | 2096774 - NIVOL 3rd Party Accrual - FY 2019 |  | GB-OPP-141954 | Trend POC | [NAME] | Endemol Shine UK Ltd
United Kingdom | 420100 - COGS - Services SS/TS | 2022-02-01 00:00:00 |  | 2022 - Feb | 03.20 TS | 2-826-01 | NIVOLNONIC2019 | 2096780 - NIVOL 3rd Party Accrual - FY 2019 |  | GB-OPP-137811 | GDPR - step 2 | GB-SCU-112858 | Qualasept Ltd T/A Bath ASU
United Kingdom | 320100 - Sales - Services SS/TS | 2022-02-10 00:00:00 |  | 2022 - Feb | 02.50 ENTERPRISE | 2-826-01 | GB-PSI-292283 | 2104844 - Orde. GB-SCO-314630/University of Manchester - CRUK MI |  | 0
United Kingdom | 320100 - Sales - Services SS/TS | 2022-02-10 00:00:00 | 008 CPX - Comparex | 2022 - Feb | 02.70 PUBLIC | 2-826-01 | GB-PSI-292285 | 2104853 - Orde. GB-SCO-314335/Foreign, Commonwealth and Development Office |  | 0
United Kingdom | 320100 - Sales - Services SS/TS | 2022-02-11 00:00:00 |  | 2022 - Feb | 02.60 CORPORATE | 2-826-01 | GB-PSI-292294 | 2105167 - Orde. GB-SCO-310680/French Connection UK Ltd |  | GB-PRJ-500036 | back up simple
United Kingdom | 320100 - Sales - Services SS/TS | 2022-02-10 00:00:00 |  | 2022 - Feb | 02.50 ENTERPRISE | 2-826-01 | GB-PSI-292360 | 2105632 - Orde. GB-SCO-313709/StoneX Financial Ltd |  | 0
United Kingdom | 320100 - Sales - Services SS/TS | 2022-02-14 00:00:00 |  | 2022 - Feb | 02.60 CORPORATE | 2-826-01 | GB-PSI-292370 | 2105775 - Orde. GB-SCO-313930/The Natural History Museum |  | 0
United Kingdom | 320100 - Sales - Services SS/TS | 2022-02-14 00:00:00 |  | 2022 - Feb | 02.60 CORPORATE | 2-826-01 | GB-PSI-292371 | 2105782 - Orde. GB-SCO-313931/The Natural History Museum |  | 0
United Kingdom | 320100 - Sales - Services SS/TS | 2022-02-14 00:00:00 |  | 2022 - Feb | 02.60 CORPORATE | 2-826-01 | GB-PSI-292372 | 2105789 - Orde. GB-SCO-313932/The Natural History Museum |  | 0
United Kingdom | 320100 - Sales - Services SS/TS | 2022-02-14 00:00:00 |  | 2022 - Feb | 02.60 CORPORATE | 2-826-01 | [NAME] | 2105796 - Orde. GB-SCO-313933/The Natural History Museum |  | 0
United Kingdom | 320100 - Sales - Services SS/TS | 2022-02-15 00:00:00 |  | 2022 - Feb | 02.60 CORPORATE | 2-826-01 | GB-PSI-292532 | 2106910 - Orde. [NAME] |  | GB-PRJ-500450 | [NAME])