16 Cost Sheet Eng 1l6v2e

16 Cost sheet

This documentation and training is provided to you by beas group AG. The documents are neither approved nor in any way acknowledged or endorsed by SAP. For SAP Business One, only the documentation and training officially released by SAP shall be binding upon SAP. SAP shall not be responsible for any content of this documentation and training and this documentation and training shall not be binding upon SAP in any way. The official current SAP Business One documentation and training for SAP Business One is available at http://service.sap.com/sbocustomer/documentation and http://service.sap.com/sbocustomer/training.

© beas group 2011 / Page 2

Requirements for this Tutorial

You will need a good grasp of:  The basics of SAP financial ing / cost centers  be.as basics

© beas group 2011 / Page 3

Learning Targets

After working through the lesson, you will be able to:  Understand how to integrate cost ing  Transfer bookings into cost ing  Create a cost sheet

© beas group 2011 / Page 4

Agenda

Master data resources 1: General 2: Work with cost ing / cost sheet

© beas group 2011 / Page 5

SAP / be.as master data and interfaces SAP chart (GL/s)

SAP SAP Profit Center

be.as import table (Finance Data)

be.as cost center allocation to SAP profit center

Cost center group

© beas group 2011 / Page 6

Distribution key

Map SAP <-> be.as cost element through Assigment table

Distribution key

Cost element group

be.as

General

(Cost type / Cost element ing)

Profit center

Journal entry

Cost element

SAP Cost center ing

Cost element Clearing cost center

be.as

Cost element ing

Distribution key Distribution key Clearing cost center

Cost center 1

Clearing cost center

Cost center 2 allocation key

Cost center 1

© beas group 2011 / Page 7

Cost center 2

General

Distribution of costs (SAP chart)

SAP

Map to SAP profit certer (production, management)

Allocated clearing cost center Distribution key

Cost center

Cost Elements

V_1000 Allocation energy V_2000 Allocation lease

4000 Production 5000 Stock

xxx xxx

Direct Costs xxx xxx

Distribution Key

be.as

U_1000 Allocation Production U_2000 Allocation Stock Cost Center

© beas group 2011 / Page 8

Cost Center

Cost Elements

Costsl

5100 Stock for raw goods 5200 Stock for finished goods 4100 Assembly 4200 Packing

xxx xxx xxx xxx

xxx xxx xxx xxx

Agenda

Master data resources 1: General 2: Work with cost ing / cost sheet

© beas group 2011 / Page 9

Work with cost ing (Cost elements / Cost types)

SAP Profit center = be.as Cost center

Construction 3000

SAP s = be.as Cost elements 4240 energy costs 4500 vehicle's costs 4210 lease costs

© beas group 2011 / Page 10

Production 4000

Stock 5000

Assembly 4100

Stock for raw material 5100

Packing 4200

Stock for finished goods 5200

Work with cost ing (Create statement cycles)

Create master data (sequence)

1. Create statement cycle 2. Create cost centers 3. Create cost types 4. Create distribution and allocation keys 5. Asign cost types to financial s

© beas group 2011 / Page 11

Work with cost ing (Create statement cycles)

© beas group 2011 / Page 12

Work with cost ing (Create cost centers)

© beas group 2011 / Page 13

Work with cost ing (Create cost types)

© beas group 2011 / Page 14

Work with cost ing (Create distribution keys)

© beas group 2011 / Page 15

Work with cost ing (Assign s to costs types)

© beas group 2011 / Page 16

Work with cost ing ( incoming invoice)

© beas group 2011 / Page 17

Work with cost ing Data import from SAP (ing)

© beas group 2011 / Page 18

Work with cost ing (Cost sheet)

© beas group 2011 / Page 19

Work with cost ing Extended Profit / Loss statement

Definition of own Structures – Display results in a report or export to Excel Cost sheet menu -> Master data -> Structures for profit and loss statement

Definition of own structure for the report of a profit and loss statement

Any number of structures can be defined

© beas group 2011 / Page 20

Work with cost ing Extended Profit / Loss statement Create rows for structure: Position: order in report Kind: select (currently only cost unit) for output in report Type: Budget. Output of defined budgets for cost unit Current: currently determined value for cost unit Object: select for output in report (Dropdown list – right click) Available objects: Category (block / area header) Cost type; cost center; cost type group; cost center group Sum; Sum % Special buttons: Re-position: re-numbering in by increment of 10-er (sum objects considered). Refresh: reload data Via Menu cost sheet -> reports cost sheet -> profit and loss statement a screen with the results of the structure definition is opened.

© beas group 2011 / Page 21

Selection: for „cost type“, „cost center“, „cost type group“ and „cost center group“: select via dropdown list for the respective object for „Sum“: enter comma-separated position numbers to be summed up for „Sum %“: 2 position numbers, comma-separated, which to be related percentaged. Example: Pos 10 is percentage of Pos 20 -> enter: 10,20 Designation for output: designation of row, used in Profit / Loss statement

Work with cost ing Extended Profit / Loss statement

Display of results

© beas group 2011 / Page 22

Summary

Now you can:  Understand how to integrate of cost ing  Transfer bookings into cost ing  Create a cost sheet

© beas group 2011 / Page 23

Thank you for your participation!