Icon

Housekeeping

This directory contains 9 workflows.

IconDaily_​Housekeeping_​BillingBlock 

IconDaily_​Housekeeping_​MissingPO 

IconDaily_​Housekeeping_​MissingPO(V2) 

IconDaily_​Housekeeping_​Rejection_​MC_​DC 

IconDaily_​Housekeeping_​YM31N 

IconMonthly_​Housekeeping_​RegionMissing 

Housekeeping_RegionMissing. 1.This workflow is to read and disposal data for region missing. 2.Matchup region codes. 3.Sent email to relevant teams

IconMonthly_​Housekeeping_​VF04-CN62 

Housekeeping_VF04_CN62. 1.This workflow is to read and disposal data for billing due list of sales organ CN62. 2.Matchup reason code in from data of billing […]

IconWeekly_​Housekeeping_​DeliveryBlock 

IconWeekly_​Housekeeping_​MissingPO_​ZTA1 

Accounting data are stored in one different file for each month. You have to loop on all Excel files in a folder, loop through all Sheet names in each Excel […]