🔧 Fix NULL Values

Populate missing Demander and DemanderCode_str fields using delivery point data.

🏠 Dashboard 📋 Manage Records
Total Records with NULL
3,271
Facilities Affected
7
Selected Facility Records
116

📋 Process Steps

1
Select a Facility
Choose a facility from the list below that has NULL values
✅
2
Review Records
View all records with NULL values for the selected facility
👁️
3
Choose Delivery Point
Select a delivery point to populate the NULL fields
📦
4
Update Records
Click the update button to populate all NULL values
⏳

📌 How It Works

This tool identifies records where Demander or DemanderCode_str is NULL or empty.

🏥 Select a Facility 7 facilities with NULL values

BRUNTVILLE CHC
116 records ✓
CHARLES JOHNSON MEMORIAL HOSPITAL
513 records →
Dr Pixley Ka Isaka Seme Memorial Hospital
706 records →
DUNDEE HOSPITAL
466 records →
HLENGISIZWE COMMUNITY HEALTH CENTRE
600 records →
KWAMASHU CHC
740 records →
PHOENIX CHC
130 records →

📄 Records for BRUNTVILLE CHC

116 records with NULL values
✕ Clear Selection
ID Invoice No. Order No. Description Qty Received Current Demander Current DemanderCode Status
41022 20070928 N/A 0 NULL NULL ⚠️ NULL
41021 1615004/INV9010356426 N/A 0 NULL NULL ⚠️ NULL
41020 20070927 N/A 0 NULL NULL ⚠️ NULL
41019 20070926 N/A 0 NULL NULL ⚠️ NULL
41018 20070925 N/A 0 NULL NULL ⚠️ NULL
41017 20070924 N/A 0 NULL NULL ⚠️ NULL
41016 20070923 N/A 0 NULL NULL ⚠️ NULL
41015 1700000/ N/A 0 NULL NULL ⚠️ NULL
41014 1676590/90731036 N/A 0 NULL NULL ⚠️ NULL
41013 1676579/8970119389 N/A 0 NULL NULL ⚠️ NULL
41012 1676570/80810288 N/A 0 NULL NULL ⚠️ NULL
41011 1676564/3254348 N/A 0 NULL NULL ⚠️ NULL
41010 1655632/410143374 N/A 0 NULL NULL ⚠️ NULL
41009 1655374/9010287204 N/A 0 NULL NULL ⚠️ NULL
41008 1655368/23426450 N/A 0 NULL NULL ⚠️ NULL
41007 1655366/9010256520 N/A 0 NULL NULL ⚠️ NULL
41006 20070922 N/A 0 NULL NULL ⚠️ NULL
41005 1655361/22511501 N/A 0 NULL NULL ⚠️ NULL
41004 1544555/4101438642 N/A 0 NULL NULL ⚠️ NULL
41003 1676600/IN020997 N/A 0 NULL NULL ⚠️ NULL
41002 1655528/SO023037 N/A 0 NULL NULL ⚠️ NULL
41001 1676546/9010325168 N/A 0 NULL NULL ⚠️ NULL
41000 1695394/OP/194192 N/A 0 NULL NULL ⚠️ NULL
40999 1695348/INV10297 N/A 0 NULL NULL ⚠️ NULL
40998 20070921 N/A 0 NULL NULL ⚠️ NULL
40997 1695324/9010366261 N/A 0 NULL NULL ⚠️ NULL
40996 1695252/ N/A 0 NULL NULL ⚠️ NULL
40995 1695236/ N/A 0 NULL NULL ⚠️ NULL
40994 1695227/901357245 N/A 0 NULL NULL ⚠️ NULL
40993 1695212/OP/1193974 N/A 0 NULL NULL ⚠️ NULL
40992 1695204/OP/194193 N/A 0 NULL NULL ⚠️ NULL
40991 20070920 N/A 0 NULL NULL ⚠️ NULL
40990 1695192/9010352218 N/A 0 NULL NULL ⚠️ NULL
40989 1695160/9010347607 N/A 0 NULL NULL ⚠️ NULL
40988 1695156/IN168484 N/A 0 NULL NULL ⚠️ NULL
40987 1676730/INV305571 N/A 0 NULL NULL ⚠️ NULL
40986 1676722/9010296379 N/A 0 NULL NULL ⚠️ NULL
40985 1676709/0128368 N/A 0 NULL NULL ⚠️ NULL
40984 1676659/90734471 N/A 0 NULL NULL ⚠️ NULL
40983 1676641/960734551 N/A 0 NULL NULL ⚠️ NULL
40982 1676635/INV88653 N/A 0 NULL NULL ⚠️ NULL
40981 1676632/26133237 N/A 0 NULL NULL ⚠️ NULL
40980 1676621/0128375 N/A 0 NULL NULL ⚠️ NULL
40979 1676619/37667054 N/A 0 NULL NULL ⚠️ NULL
40978 1676551/0128374 N/A 0 NULL NULL ⚠️ NULL
40977 1676546/9010321906 N/A 0 NULL NULL ⚠️ NULL
40976 1676535/0128165 N/A 0 NULL NULL ⚠️ NULL
40975 1676534/430008444 N/A 0 NULL NULL ⚠️ NULL
40974 1676532/INV66665 N/A 0 NULL NULL ⚠️ NULL
40973 1676533/INV67305 N/A 0 NULL NULL ⚠️ NULL
40972 1676527/430014528 N/A 0 NULL NULL ⚠️ NULL
40971 1676526/430014529 N/A 0 NULL NULL ⚠️ NULL
40970 1676525/3767679 N/A 0 NULL NULL ⚠️ NULL
40969 1676495/9010328950 N/A 0 NULL NULL ⚠️ NULL
40968 1676487/OPI1193942 N/A 0 NULL NULL ⚠️ NULL
40967 1676485/0128371 N/A 0 NULL NULL ⚠️ NULL
40966 1676474/80810289 N/A 0 NULL NULL ⚠️ NULL
40965 1676445/IN166663 N/A 0 NULL NULL ⚠️ NULL
40964 1674686/9010317279 N/A 0 NULL NULL ⚠️ NULL
40963 1655653/929212205 N/A 0 NULL NULL ⚠️ NULL
40962 1655641/37604890 N/A 0 NULL NULL ⚠️ NULL
40961 1655640/OP/I91204 N/A 0 NULL NULL ⚠️ NULL
40960 1655638/0126917 N/A 0 NULL NULL ⚠️ NULL
40959 1655637/411430114 N/A 0 NULL NULL ⚠️ NULL
40958 1655605/3612957 N/A 0 NULL NULL ⚠️ NULL
40957 1655587/90718516 N/A 0 NULL NULL ⚠️ NULL
40956 1655587/216131647 N/A 0 NULL NULL ⚠️ NULL
40955 1655570/OPI191077 N/A 0 NULL NULL ⚠️ NULL
40954 1655569/0128370 N/A 0 NULL NULL ⚠️ NULL
40953 1655508/429894981 N/A 0 NULL NULL ⚠️ NULL
40952 20070919 N/A 0 NULL NULL ⚠️ NULL
40951 1655505/OP/I290518 N/A 0 NULL NULL ⚠️ NULL
40950 1655496/9010259328 N/A 0 NULL NULL ⚠️ NULL
40949 1655488/0128164 N/A 0 NULL NULL ⚠️ NULL
40948 1655487/929212231 N/A 0 NULL NULL ⚠️ NULL
40947 1655486/IN165355 N/A 0 NULL NULL ⚠️ NULL
40946 1655485/F43571 N/A 0 NULL NULL ⚠️ NULL
40945 1655461/9010248432 N/A 0 NULL NULL ⚠️ NULL
40944 1655546/STR015337 N/A 0 NULL NULL ⚠️ NULL
40943 1655435/89201168 N/A 0 NULL NULL ⚠️ NULL
40942 20070918 N/A 0 NULL NULL ⚠️ NULL
40941 20070917 N/A 0 NULL NULL ⚠️ NULL
40940 20070916 N/A 0 NULL NULL ⚠️ NULL
40939 1655425/9010340573 N/A 0 NULL NULL ⚠️ NULL
40938 1655397/OP/I290997 N/A 0 NULL NULL ⚠️ NULL
40937 1655396/INV10292029 N/A 0 NULL NULL ⚠️ NULL
40936 1655380/N165353 N/A 0 NULL NULL ⚠️ NULL
40935 1628702/STRO15015 N/A 0 NULL NULL ⚠️ NULL
40934 1628682/0128369 N/A 0 NULL NULL ⚠️ NULL
40933 1628659/0126918 N/A 0 NULL NULL ⚠️ NULL
40932 1628621/0128372 N/A 0 NULL NULL ⚠️ NULL
40931 1628604/0128163 N/A 0 NULL NULL ⚠️ NULL
40930 1628566/26126185 N/A 0 NULL NULL ⚠️ NULL
40929 1615191/0126916 N/A 0 NULL NULL ⚠️ NULL
40928 1615158/0126916 N/A 0 NULL NULL ⚠️ NULL
40927 1615023/INV87103 N/A 0 NULL NULL ⚠️ NULL
40926 1589761/0128367 N/A 0 NULL NULL ⚠️ NULL
40925 1589747/0126915 N/A 0 NULL NULL ⚠️ NULL
40924 1589598/0128162 N/A 0 NULL NULL ⚠️ NULL
40923 1589593/OP1290419 N/A 0 NULL NULL ⚠️ NULL
40922 1589589/9010231190 N/A 0 NULL NULL ⚠️ NULL
40921 1569397/0126914 N/A 0 NULL NULL ⚠️ NULL
40920 20070915 N/A 0 NULL NULL ⚠️ NULL
40919 1526099/901033365015 N/A 0 NULL NULL ⚠️ NULL
40918 1695286/15/5436 N/A 0 NULL NULL ⚠️ NULL
40917 1676605/1504072 N/A 0 NULL NULL ⚠️ NULL
40916 1676603/149678 N/A 0 NULL NULL ⚠️ NULL
40915 1676602/1495011 N/A 0 NULL NULL ⚠️ NULL
40914 1655529/1482297 N/A 0 NULL NULL ⚠️ NULL
40913 20070914 N/A 0 NULL NULL ⚠️ NULL
40912 1695332/90748450 N/A 0 NULL NULL ⚠️ NULL
40911 1695331/00748451 N/A 0 NULL NULL ⚠️ NULL
40910 1676660/12252023A N/A 0 NULL NULL ⚠️ NULL
40909 1676592/80810284 N/A 0 NULL NULL ⚠️ NULL
40908 1676590/80810287 N/A 0 NULL NULL ⚠️ NULL
40907 1655506/0128373 N/A 0 NULL NULL ⚠️ NULL
📦 Step 3: Select Delivery Point to Populate NULL Fields
Facility: BRUNTVILLE CHC
Records to Update: 116
Will Update:
Demander ← dem_name
DemanderCode_str ← del_point
← Return to Dashboard