Process Freight & Brokerage MBPP
When To Do This
Perform this procedure when freight, brokerage and other costs have been accrued for merchandise received.
Business Process Overview |
Use this procedure to process freight, brokerage and other cost component invoices and variances. |
Input - Required Fields |
Field Value/Comments |
None |
None |
|
|
Output - Results |
Next Steps |
None |
None |
Key Notes
None
1. Perform one of the following:
If |
Go To |
The freight and brokerage invoice was posted by the LLS intercompany interface (ZFILLS) |
Step 2 |
The freight and brokerage invoice is from a third party vendor and must be posted manually in SAP |
Step 5 |
2. Verify the invoices posted correctly to the LLS intercompany vendor number APINT1051 using transaction code FBL1N Vendor Line Item Display.
Refer to ATP.02_FBL1N_BPP for detailed
instructions.
3. Run the payment process to clear the LLS intercompany vendor account using transaction code F110 Process Automatic Payments.
Refer to ATP.02_F110 BPP for detailed
instructions.
The next time the payment process is completed,
the intercompany accounts will be cleared. The intercompany entries between
Mast or beauty Avenues and LLS will be generated automatically.
4. Go to Step 10 to create freight and brokerage reports.
5. Perform one of the following:
If |
Go To |
The invoice will be entered individually in SAP |
Step 6 |
The invoice will be uploaded from Excel to SAP |
Step 8 |
6. Enter the third party vendor freight or brokerage invoice using transaction code F-04 Post with
Clearing.
Refer to ATP.02.06_OTHER COST_BPP for
detailed instructions.
Clear the invoice against the accrual by
the PO number located in the assignment field. Post any differences to the
appropriate variance account or back to the accrual account if partial invoice.
7. Go to Step 9 to pay the vendor.
8. Upload the invoice from Excel to SAP using transaction code ZGLUPLOAD GL Excel Journal Entry Upload.
Refer to ATP.01_MBPP.08-SM35_BPP
for detailed instructions.
Enter the PO, quantity and amount
in the appropriate fields in the Excel template to facilitate automatic
clearing using ZFBCLEAR.
Field |
Value |
Purchase order number BBSEG-EBELN |
PO number |
Quantity BBSEG-MENGE |
Quantity invoiced |
Order unit BBSEG-MEINS |
EA |
Allocation (Assignment) BBSEG-ZUONR |
PO number |
9. Pay the third party vendor using transaction code F110 Process Automatic Payments.
Refer to ATP.02_F110 BPP for
detailed instructions.
10. Perform one of the following:
If |
Go To |
Analyzing the Freight or Brokerage Accrual account for aged items |
Step 11 |
Analyzing the Freight or Brokerage Variance account for variances posted |
Step 12 |
Generating the Freight or Brokerage Variance report |
Step 13 |
11. Analyze the Freight or Brokerage Accrual account for aged items using FBL3N GL Line Item Display to download open items to Excel and age the items by Document Date.
Refer to ATP.01_FBL3N_BPP Display GL Line
Items for detailed instructions.
12. Analyze the Freight or Brokerage Variance account using FBL3N GL Line Item Display.
Refer to ATP.01_FBL3N_BPP Display GL Line
Items for detailed instructions.
Use FBL3N dynamic selection, filter, sort
and subtotal functionality to analyze the data on-line. Change and save the
layout to show desired fields. Download data to Excel for further analysis.
13. Prepare the Freight or Brokerage Variance Report by downloading the freight or brokerage data to a pre-designed Excel template with calculation formulas.
Refer to ATP.02.06_FREIGHT_BROKERAGE_VAR
Freight or Brokerage Variance Report for detailed instructions.
Use the FBL3N layout named FB_VREPORT and
the Excel template named Freight Report.xls.
14. This activity is now complete
Freight & brokerage invoices and payments have been recorded and reconciled. Variances and aged items have been posted to the Freight Variance account.
Comments
None