Hi all,
I have the following issue: Some parts of the case I could do on my own, but there are some really tricky steps inside where I do not know how to start, that’s why I m asking for help. Any advice would help me! Also please find the Dummy input csv attached.
I tried to describ it step by step:
-
Column A from Input file “Netto”, should go to Column O in the Outputfile “Betrag BW” (first values"upper part" multiplied by *-1, and then in the “lower part” original values)
-
Column B from Input file “Konto” should got to Column L in the Outputfile “Konto/(Filial-)Debitor” in the “upper part” and below in the “lower part” there should be inserted a fixed value “19129” (in this case 4 times – but depends on the rows of the input file and changes)
-
Column C from Input file “NRS” should go to the lower part of column V in the Output File. Insert in the upper rows in the Outputfile (in this case 4 rows) “CSM Fleet 09/2021”, so always with the current month.
-
Column D from Input file “Code” should go to Column T in the Output file “VBUND”, lower part should be empty
-
Column E from Input file “Text” should go to Column J in the Output file “Notiz Rechnungstext”, lower part should be empty
-
Column A in the Output file should be “Bemerkung” and empty
-
Column B in the Output file should be “Sort” and insert for “the upper part” 1, 3, 5, 7… and for the “lower part” 2, 4, 6, 8… (for sorting later)
-
Column C in the Output file should be “Bukrs” with “7777” for the “upper part” and empty for the “lower part”
-
Column D in the Output file should be “BA” with “MO” for the “upper part” and empty for the lower part
-
Column F in the Output file should be “Belegdatum” with date of today (dd.mm.yyyy)
-
Column G in the Output file should be “Buchungsdatum” with date of today (dd.mm.yyyy)
-
Column H in the Output file should be “Referenz” and empty
-
Column I in the Output file should be “Belegkopftext” and empty
-
Column K in the Output file should be “Kontenart” and “S” in the “upper part” and “D” in the lower part
-
Column M in the Output file should be “Zahlweg” and empty for the “upper part” and “x” in the “lower part”
-
Column N in the Output file should be “Zahlungsbedingung” and empty for the “upper part” and “ICUT” in the “lower part”
-
Column P in the Output file should be “StKz” and “55” for the “upper part” and empty for the “lower part”
-
Column Q in the Output file should be “GBK” and “DH99” for the whole part
-
Column R in the Output file should be “Kostenstelle” and “DH999” for the “upper part” and empty for the “lower part”
-
Column S in the Output file should be “Profit Center” and “DH99” for the for the whole part
-
Column T in the Output file should be “VBUND” and “DH999” for the “upper part” and empty for the “lower part”
-
Column U in the Output file should be “Partner” and “OMS” for the “upper part” and empty for the “lower part”
-
Column W in the Output file should be “Referenz” and “QEA#OMS999#06” for the “upper part” and empty for the “lower part”
-
In the end I would like to sort the whole file by colum “Sort” and it should look like that
here the dummy data in xls
Masterdatei_P11_Dummydata.xls (20 KB)
Thank you if anyone takes the time to look at it!
Best,
Markus