Excel Test allocate freight costs HELP!

Joined
Jan 13, 2023
Messages
1
Reaction score
0
Country
Poland
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 AccountG/L DescriptionCredit/DebitAmountTextTrading partnerCost CenterProfit centerWBS element
6701101Freight reclass
6701102Freight reclass
6701103Freight reclass
6701999Freight reclass
6701999Freight reclass
6701999Freight 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
PlantTimeCost CtrDocumentNoGL AccountCost typeDocument Header TextMaterialMaterial DescriptionRefDocNoCoCdProductSource object nameCO object namePostg DateCreated onTotal quantityPUMValueObCur
9997099913:44:13POLAND20031118113830576701101Freight - Customer931/2020BXPPS5010687567BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
346.000​
EA
103,800.00​
PLN
9997099913:44:13POLAND20031118113830576701101Freight - Customer931/2020BXPPS5010687567BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
2.000​
EA
15,000.00​
PLN
9997099913:19:48POLAND20031118113830266701101Freight - Customer929/2020BXPPS5010687564BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
368.000​
EA
77,280.00​
PLN
9997099913:13:23POLAND20031118113830226701101Freight - Customer928/2020BXPPS5010687563BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
1.000​
EA
36,000.00​
PLN
9997099913:10:09POLAND200311.18114E+116701103Freight - Customer927BXPPS5010687562BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
224.000​
EA
47,040.00​
PLN
9997099913:03:03POLAND200311.18114E+116701101Freight - Customer926/2020BXPPS5010687137BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
2.000​
EA
15,000.00​
PLN
9997099913:03:03POLAND200311.18114E+116701101Freight - Customer926/2020BXPPS5010687137BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
356.000​
EA
106,800.00​
PLN
9997099912:55:19POLAND200311.18114E+116701101Freight - Customer925/2020BXPPS5010687136BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
357.000​
EA
74,970.00​
PLN
9997099912:47:40POLAND200311.18114E+126701101Freight - Customer924/2020BXPPS5010687134BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
2.000​
EA
15,000.00​
PLN
9997099912:47:40POLAND200311.18114E+126701101Freight - Customer924/2020BXPPS5010687134BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
449.000​
EA
134,700.00​
PLN
9997099912:36:22POLAND200311.18114E+116701101Freight - Customer923/2020BXPPS5010686391BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
494.000​
EA
103,740.00​
PLN
9997099912:28:11POLAND20031118113800866701101Freight - Customer922/2020BXPPS5010686390BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
1.000​
EA
42,000.00​
PLN
9997099911:20:20POLAND20031118113726936701101Freight - Customer920/2020BXPPS5010686105BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
183.000​
EA
63,135.00​
PLN
9997099910:50:51POLAND20031118113726776701101Freight - Customer918/2020BXPPS5010685703BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
188.000​
EA
39,480.00​
PLN
9997099910:39:22POLAND20031118113726706701101Freight - Customer916/2020BXPPS5010685570BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
486.000​
EA
167,670.00​
PLN
9997099910:33:56POLAND20031118113726606701101Freight - Customer915/2020BXPPS5010685238BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
408.000​
EA
85,680.00​
PLN
9997099910:28:02POLAND20031118113726566701102Freight - Customer914/2020BXPPS5010685235BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
456.000​
EA
136,800.00​
PLN
9997099910:28:02POLAND20031118113726566701102Other914/2020BXPPS5010685235BA01BA20031DIS SNK DC Tuzla
09/30/2020​
10/01/2020​
2.000​
EA
15,000.00​
PLN
9997099909:06:47POLAND20031118113306456701101Freight - CustomerGrbic prevozBXPPS5010672683BA01BA20031DIS SNK DC Tuzla
09/30/2020​
09/30/2020​
1.000​
EA
96,000.00​
PLN
9997099909:06:32POLAND20031118113306446701101OtherGrbic prevozBXPPS5010672682BA01BA20031DIS SNK DC Tuzla
09/30/2020​
09/30/2020​
1.000​
EA
96,000.00​
PLN
9997099909:06:00POLAND20031118113306426701101Freight - CustomerHerdes prevozBXPPS5010671511BA01BA20031DIS SNK DC Tuzla
09/30/2020​
09/30/2020​
1.000​
EA
150,000.00​
PLN
9997099909:05:33POLAND200311.18113E+116701101Freight - CustomerHerdes prevozBXPPS5010671510BA01BA20031DIS SNK DC Tuzla
09/30/2020​
09/30/2020​
1.000​
EA
150,000.00​
PLN
9997099911:47:46POLAND200311.18113E+116701101Other39-a/2020BXPPS5010663373BA01BA20031DIS SNK DC Tuzla
09/29/2020​
09/29/2020​
424.000​
EA
152,640.00​
PLN
9997099911:40:34POLAND200311.18113E+116701101Freight - Customer39/2020BXPPS5010663161BA01BA20031DIS SNK DC Tuzla
09/29/2020​
09/29/2020​
1,254.000​
EA
451,440.00​
PLN
9997099911:19:30POLAND200311.18113E+126701101Freight - Customer913/2020BXPPS5010663021BA01BA20031DIS SNK DC Tuzla
09/29/2020​
09/29/2020​
941.000​
EA
197,610.00​
PLN
9997099911:14:21POLAND200311.18113E+136701101Freight - Customer912/2020BXPPS5010663019BA01BA20031DIS SNK DC Tuzla
09/29/2020​
09/29/2020​
5.000​
EA
180,000.00​
PLN
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
11,647
Messages
27,603
Members
21,428
Latest member
dataanalyticsinsingapore

Latest Threads

Top