Excel Test allocate freight costs HELP!

[szymon1c]

Hello I have a small excel test but I cannot include file as a attachment here. So I will coopy some data if anybode understand please help me.

1st page Instruction

Instructions:

1. Use the report from the 'Data' tab for the journal preparation.

2. Allocate all freight costs related to product BA20031.

3. Move all the freight cost form GL account 6701101, 6701102 and 6701103 to 6701999

4. Use ‘Journal’ tab to create the posting proposal. 2nd page "Journal" Subject Reference Date Country Material Prepared by Comment G/L Account G/L Description Credit/Debit Amount Text Trading partner Cost Center Profit center WBS element 6701101 Freight reclass 6701102 Freight reclass 6701103 Freight reclass 6701999 Freight reclass 6701999 Freight reclass 6701999 Freight reclass Approved by Info: Credit is considered to be negative when it reduces a ledger account. Debit is considered to be positive when it increse a ledger account 3rd page Data Plant Time Cost Ctr DocumentNo GL Account Cost type Document Header Text Material Material Description RefDocNo CoCd Product Source object name CO object name Postg Date Created on Total quantity PUM Value ObCur 99970999 13:44:13 POLAND20031 11811383057 6701101 Freight - Customer 931/2020 BXPPS 5010687567 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 346.000​ EA 103,800.00​ PLN 99970999 13:44:13 POLAND20031 11811383057 6701101 Freight - Customer 931/2020 BXPPS 5010687567 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 2.000​ EA 15,000.00​ PLN 99970999 13:19:48 POLAND20031 11811383026 6701101 Freight - Customer 929/2020 BXPPS 5010687564 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 368.000​ EA 77,280.00​ PLN 99970999 13:13:23 POLAND20031 11811383022 6701101 Freight - Customer 928/2020 BXPPS 5010687563 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 1.000​ EA 36,000.00​ PLN 99970999 13:10:09 POLAND20031 1.18114E+11 6701103 Freight - Customer 927 BXPPS 5010687562 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 224.000​ EA 47,040.00​ PLN 99970999 13:03:03 POLAND20031 1.18114E+11 6701101 Freight - Customer 926/2020 BXPPS 5010687137 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 2.000​ EA 15,000.00​ PLN 99970999 13:03:03 POLAND20031 1.18114E+11 6701101 Freight - Customer 926/2020 BXPPS 5010687137 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 356.000​ EA 106,800.00​ PLN 99970999 12:55:19 POLAND20031 1.18114E+11 6701101 Freight - Customer 925/2020 BXPPS 5010687136 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 357.000​ EA 74,970.00​ PLN 99970999 12:47:40 POLAND20031 1.18114E+12 6701101 Freight - Customer 924/2020 BXPPS 5010687134 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 2.000​ EA 15,000.00​ PLN 99970999 12:47:40 POLAND20031 1.18114E+12 6701101 Freight - Customer 924/2020 BXPPS 5010687134 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 449.000​ EA 134,700.00​ PLN 99970999 12:36:22 POLAND20031 1.18114E+11 6701101 Freight - Customer 923/2020 BXPPS 5010686391 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 494.000​ EA 103,740.00​ PLN 99970999 12:28:11 POLAND20031 11811380086 6701101 Freight - Customer 922/2020 BXPPS 5010686390 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 1.000​ EA 42,000.00​ PLN 99970999 11:20:20 POLAND20031 11811372693 6701101 Freight - Customer 920/2020 BXPPS 5010686105 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 183.000​ EA 63,135.00​ PLN 99970999 10:50:51 POLAND20031 11811372677 6701101 Freight - Customer 918/2020 BXPPS 5010685703 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 188.000​ EA 39,480.00​ PLN 99970999 10:39:22 POLAND20031 11811372670 6701101 Freight - Customer 916/2020 BXPPS 5010685570 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 486.000​ EA 167,670.00​ PLN 99970999 10:33:56 POLAND20031 11811372660 6701101 Freight - Customer 915/2020 BXPPS 5010685238 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 408.000​ EA 85,680.00​ PLN 99970999 10:28:02 POLAND20031 11811372656 6701102 Freight - Customer 914/2020 BXPPS 5010685235 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 456.000​ EA 136,800.00​ PLN 99970999 10:28:02 POLAND20031 11811372656 6701102 Other 914/2020 BXPPS 5010685235 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 10/01/2020​ 2.000​ EA 15,000.00​ PLN 99970999 09:06:47 POLAND20031 11811330645 6701101 Freight - Customer Grbic prevoz BXPPS 5010672683 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 09/30/2020​ 1.000​ EA 96,000.00​ PLN 99970999 09:06:32 POLAND20031 11811330644 6701101 Other Grbic prevoz BXPPS 5010672682 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 09/30/2020​ 1.000​ EA 96,000.00​ PLN 99970999 09:06:00 POLAND20031 11811330642 6701101 Freight - Customer Herdes prevoz BXPPS 5010671511 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 09/30/2020​ 1.000​ EA 150,000.00​ PLN 99970999 09:05:33 POLAND20031 1.18113E+11 6701101 Freight - Customer Herdes prevoz BXPPS 5010671510 BA01 BA20031 DIS SNK DC Tuzla 09/30/2020​ 09/30/2020​ 1.000​ EA 150,000.00​ PLN 99970999 11:47:46 POLAND20031 1.18113E+11 6701101 Other 39-a/2020 BXPPS 5010663373 BA01 BA20031 DIS SNK DC Tuzla 09/29/2020​ 09/29/2020​ 424.000​ EA 152,640.00​ PLN 99970999 11:40:34 POLAND20031 1.18113E+11 6701101 Freight - Customer 39/2020 BXPPS 5010663161 BA01 BA20031 DIS SNK DC Tuzla 09/29/2020​ 09/29/2020​ 1,254.000​ EA 451,440.00​ PLN 99970999 11:19:30 POLAND20031 1.18113E+12 6701101 Freight - Customer 913/2020 BXPPS 5010663021 BA01 BA20031 DIS SNK DC Tuzla 09/29/2020​ 09/29/2020​ 941.000​ EA 197,610.00​ PLN 99970999 11:14:21 POLAND20031 1.18113E+13 6701101 Freight - Customer 912/2020 BXPPS 5010663019 BA01 BA20031 DIS SNK DC Tuzla 09/29/2020​ 09/29/2020​ 5.000​ EA 180,000.00​ PLN