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


Procedure

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

Result

Freight & brokerage invoices and payments have been recorded and reconciled.  Variances and aged items have been posted to the Freight Variance account.

Comments

None