Warehouse Book & Valuation

 

warehouse

This is one of the main and most complex applications of Greece Localization.

According to Greek legislation, SAP's ways of valuating materials can be only used for estimations and provision and are not accepted as a legal way of valuating materials.

For this a special application responsible for material valuation according to Greek GAPS and producing the Warehouse Book has been created by SAP.

Material Valuation

Material Valuation is a period end procedure –determines the actual value of remaining stock via predefined valuation methods (like FIFO, LIFO, WMA etc.) There are determined by the law two different ways to valuate materials a) Period valuation and b) Year to date valuation.

Valuation methods supported by SAP are:

  • First-In-First-Out (FIFO) for raw materials and trading goods (a variant for produced materials also exists but involves many assumptions). In this case the remaining stock is valuated first       using the period's goods receipts on a first-in first-out basis and the consumptions are valuated afterwards. Thus the consumption and remaining stock prices are in principle different
  • Last-In-First-Out (LIFO) for raw materials and trading goods. In this case the remaining stock is valuated first on a last-in first-out basis and the consumptions are valuated afterwards. Here also the consumption and remaining stock prices are in principle different
  • Weighted Moving Average (WMA). Remaining stock and consumptions are assigned a uniform price.
  • Fixed cost (FIX). Used for by-products. Assigns SAP Value to the production cost and uses the WMA to find the consumption and remaining stock value of the by-products.
  • Weighted Moving Average with Work-In-Progress (WMAW). Variation of WMA in that the cost of production used to determine the input part of the valuation equation is modified so as to take into account Work-In-Progress (WIP).
  • Weighted Moving Average for Plant-Level Valuation (WMAPL). Variation of WMA in which plant transfers are treated as input with values determined at the source plant. This makes sense for valuation at plant level and requires the treatment of potential circular transfers. 

Valuation Equation: A dual equation (per quantity and per value) relating initial and final stock for each valuated material within a period. There are many ways to write it down but the most generic one reads:

Qinitial stock + Qinputs = Qend stock + Qoutput

and similarly for values:

Vinitial stock + Vinputs = Vend stock + Voutputs

The left-hand side (LHS) of the equations contains known values while the right-hand side (RHS) contains objects that receive values. The valuation equation essentially amounts to a prescription of how to split the total LHS value into remaining stock and consumption values. The specific algorithm of how to do this is prescribed by the valuation method (FIFO, LIFO, WMA etc).

The ‘inputs’ to the LHS include several types:

  • Goods Receipts from Purchasing.
  • Goods Receipts from Production (direct material + expenses).
  • Other goods receipts with ‘own value’.
  • Goods receipts from subcontracting.
  • Goods receipts from other stores assigned a value and accompanied by a legal document (‘λογιστική αυτοτέλεια υποκαταστημάτων’) .
  • Material to material transfers (‘μετατάξεις’).
  • Goods receipts from material assembly.
  • Goods receipts from plant transfers (plant level valuation)
  • Other Invoiced expenses (e.g. shipping costs).

There is one such ‘double’ equation for each ‘valuated object’. The precise definition of what this ‘valuated object’ is depends on the valuation level. In the simplest form it can be identified with the ‘material’ concept (valuation level = company). Other possibilities exist, though:

  • Valuated object = material + plant (valuation level = plant)
  • Valuated object = sales order line item
  • Valuated object = project etc

Warehouse Book Ledger

  • Every Greek Company is required by law to produce a “Warehouse Book”(WHB). The WHB is a report containing both inventory and financial information on every incoming and outgoing material movement, as well as other postings having a financial effect on the stock.
  • The report is produced once per period (saved in a CD), approved by the tax authorities.
  • Looking into this report the auditor should be able to see all the material movements, the current available stock, the historical cost, the sales proceeds, the gross margin of each product and the cost of all material consumptions in the examined period.
  • The columns of WHB should be in correspondence with Analytical Ledger Accounts.
  • The value assigned to each material movement depends on the nature of the movement.
  • Negative Balances are not allowed
  • Continuous page numbering is obligatory during the fiscal year.
  • Supplementary to Analytical Ledger , General Ledger (Purchasing and Sales)
  • All Company owned stock materials (with Significant value) at company owned plants, or at third party plants and all third party stock materials stored in company’s plants should appear at WHB.
  • All Movements creating an accounting document, concerning plant to plant transfer and movements in and out a plant should appear. Movements within a plant (e.g. st.location to st.location, batch to batch etc.) are not included.


Solution description and brief application Logic

whb

The application consists of the following elements:

  • A central table which is updated on-line through user-exits from SAP ERP transactions. This table can also be updated off-line with a special program (either for performance reasons or because of wrong update due to errors in customizing) on request. Finally there are fields of these table (values) which are updated only after the productive run of the valuation.
  • A set of customizing tables where the basic parameters are defined (valuation method, printouts layout, Analytical Ledger accounts etc).
  • Programs for material valuation, print out of the warehouse book report and Analytical Ledger postings.
  • A set of tables where data are stored after the productive run of the programs mentioned above.
  • A set of utilities (programs) which perform control tasks or error corrections tasks A user exit of MM for updating the central table mentioned before (from material movements and from FI movements) 

Program logic – Sequence of execution

The application has prerequisites and specific sequence in order to give correct results.

The prerequisites are:

  • Data are entered in the system based on the posting rules and the respective customization is correct.
  • All postings that concern the period under review have been performed (Sales, Purchases etc)
  • All CO-activities for expenses allocation have been performed

The execution sequence is the following:

  • Valuation of consumables/spare parts for CO- reposting
  • CO-Activities performed for allocating/distributing the expenses to the produced materials
  • Valuation of all materials
  • Printing of Warehouse reports
  • Postings in the Analytical Ledger accounts

ELSOP News:

ELSOP has successfully completed the Contract Management Project for Nea Odos Inc.

Tuesday, 08 March 2016 16:11

neaOdos

ELSOP has successfully completed the Contract Management project for Nea Odos Inc.

View more

SAP Fiori deployment at Chipita

Monday, 16 February 2015 11:31

chipitaELSOP's Mobility Department implemented SAP Fiori and customized Purchasing Workflow and Purchase Approval apps for Chipita, one of the largest Food Suppliers in Greece. The company has presence in 65 countries with 18 production plants in 10 countries. SAP Fiori was deployed for Bulgaria and Greece as first Golive. The Solution was deploeyd within 3 weeks.

View more

ELSOP undertakes SAP roll-out project for Playmobil

Friday, 29 August 2014 10:59

Playmobil-Logo

 ELSOP Consulting Group undertakes the Roll out implementation of SAP ERP for the Greek Entity of  Playmobil in collaboration with Lufthansa Systems.

View more

SAP FIORI is now FREE for SAP Customers

Wednesday, 14 May 2014 14:13

after sup

SAP AG today announced that SAP Fiori user experience (UX) and SAP Screen Personas software will now be included within underlying licenses of SAP software. For existing customers, SAP will provide a software credit redeemable against future software sales.

ELSOP implements Qlikview at Papadopoulou

Friday, 05 June 2015 10:59

papadopoulou

ELSOP Consulting Group undertakes the implementation of Qlikview for PAPADOPOULOU S.A.

View more

SAP BW Compression - 10 times! achieved at PAPADOPOULOU

Wednesday, 01 October 2014 10:59

papadopoulou

ELSOP achieved a BW database compression from 3,5 TB to 340 GB! just by upgrading SQL to 2012 version in PAPADOPOULOU company BW system. Their queries performance is 4-5 times quicker! without any new aggregate or so. 

This was done in 2 weeks in the production system and completelly transparent to the end users.

 View more

New offer from ELSOP! Fiori Fast Start only for 10.000 EUR

Wednesday, 14 May 2014 14:13

fiori clientTake advantage of the new offer from ELSOP! Change radically your everyday enterprise reality with SAP Fiori.  No more complicated processes and delays. Do everything via your mobile device, easily and quickly and feel SAP at the tips of your fingers. ELSOP brings you all of the benefits Fiori has to offer at a really affordable fixed price! Our offer includes installation of the proper software on your environment as well as implementation of 3 Fiori applications of your choice, only for 10.000 EUR.

Read more about our offer here.

MYF Monthly Reporting

Saturday, 26 April 2014 14:14

LOGO transparent2 biggerAccording Law POL 1022/31.01.2014 the Sales & Purchases Reconciliation Report (MYF) should be submitted monthly instead of yearly. The due date for submitting the data is 02.06.2014. SAP has issued 3 notes, as part of Hellenization package, with new solution for MYF reporting, without affecting the old programs.

New solution contains new set of reports and other objects, such as:

ELSOP completes “Sales Calendar” project for the Hellenic Petroleum Group

Wednesday, 09 April 2014 08:14

Sybase-Unwired-PlatformELSOP’ s mobility department completed successfully the development of the “Sales Calendar” project on behalf of the Hellenic Petroleum Group. “Sales Calendar” is a mobile application designed for tablet devices using the Android operating system in conjuction with SAP's Sybase Unwired Platform. In the scope of the business on-the-go practices that the contemporary enterprise needs demand, the user, a Sales Executive or a Sales Head, can schedule or review the working program of every week with a few clicks. A Sales Head has extended privileges including inspection of the programs committed by the Sales Executives he/she is responsible for.

New MYF monthly format, XML output - pol:1022-31-01-2014

Tuesday, 12 November 2013 10:25

LOGO transparent2 bigger

According to Law POL 1022/31.1.2014, report MYF should be provided to the Greek Authorities on a monthly basis with a specifc XML format. 

For this SAP has already announced through SAP Note 1972510 - GR: new MYF montly format, XML output, for ECC 6.0 and Hellenization C-CEE 110_600 or subsequent, the required actions .

Upgrade of the Tax Devices POL 1221 13.12.2012 – Technical Details

Tuesday, 12 November 2013 10:25

tax device casio

As you already know, the publishing in the Government Gazette (FEK 3513, 13.12.2012) and the ministerial decision POL 1221/2012, for the Upgrade of the support software for Special Secure Fiscal Device for Record Signing (SSFDRS) (Tax Devices) determine the necessary mode changes for them.

SAP has already announced through SAP Note 1825984, for ECC 6.0 and Hellenization C-CEE 110_600 or subsequent, the required actions according to the type of the device.

Tax Devces installation on new systems completed in Whirlpool Hellas

Wednesday, 25 September 2013 12:44

WHIRLPOOLType A tax device, models Casio FP500-600 with signature processor and signature processor 2. Conversion to pdf and automatic delivery of documents via e-mail as attached files with the corresponding name_a.txt and name_b.txt. Adaption to POL 1221 via selection functions to generate the e.txt file. The tax-devices were installed succesfully on hardware with 64-bit operating systems and restricted-user policies enforced. The installation is ready for sending the e.txt to the General Secretariat of Information Systems, that will apply from 01/01/2014.

View more about  Greece Tax Devices for SAP e-Invoicing

ELSOP's Mobile Basis for SAP available now on SAP Store

Wednesday, 25 September 2013 09:44

ELSOP's certified application Mobile Basis for SAP is now available to download via the official SAP Store. You can download it here.

View more

Tax Devices e-Invoicing customization completed in Sony Mobile Communications Hellas

Friday, 13 September 2013 12:47

sonyType A tax device, models Casio FP500-600 and Proline 650-750 with signature processor and signature processor 2. Conversion to pdf and automatic delivery of documents via e-mail as attached files with the corresponding name_a.txt and name_b.txt. Customization and adaption to POL 1221 via selection functions to generate the e.txt file. The installation is ready for sending the e.txt to the General Secretariat of Information Systems, that will apply from 01/01/2014.

View more about  Greece Tax Devices for SAP e-Invoicing

Tax Devices e-Invoicing customization completed in EUROSOS Assistance Hellas

Thursday, 12 September 2013 14:47

EurososType A tax device, models Casio FP500-600 and Proline 650-750 with signature processor and signature processor 2. Conversion to pdf and automatic delivery of documents via e-mail as attached files with the corresponding name_a.txt and name_b.txt files.Customization and adaption to POL 1221 via selection functions to generate the e.txt file. The installation is ready for sending the e.txt to the General Secretariat of Information Systems, that will apply from 01/01/2014.

View more about Greece Tax Devices for SAP e-Invoicing

ELSOP's Mobile Basis for SAP available now on Google Play

Thursday, 08 August 2013 14:33

Get it now on Google PlayELSOP's certified application Mobile Basis for SAP is available via the Google Play store.

View more

ELSOP's application Mobile Basis for SAP, certified by SAP AG

Monday, 05 August 2013 12:02

sap certified mobile appELSOP is the first SAP Partner in Greece and one of the few in the world that earns a certification for a custom made mobile solution. Mobile Basis for SAP is designed to offer remote administration services for any SAP system. The application is available for purchase in the official SAP Application Store and a demo version for Android users can be downloaded from Google Play.

View more

ELSOP develops a SAP Mobile Platform (SUP HWC) hybrid Field Service application for Natural Gas Company

Monday, 15 July 2013 13:31

Natural Gas CompanyELSOP's Mobility Department implemented a pilot Field Service application for Natural Gas Company, the only natural gas distributor and trader in the area of Attica, Greece. This Field Service application is hybrid, crossplatform and was developed on SAP Mobile Platform (SUP HWC).

View more

ELSOP develops the SD Credit Release, a SAP Mobile Platform (SUP HWC) hybrid application for Hellenic Petroleum

Friday, 12 July 2013 09:31

Hellenic PetroleumELSOP's Mobility Department implemented the Sales Distribution Credit Release application for Hellenic Petroleum, the largest oil supply, refining and trading company in Greece. SD Credit Released is a hybrid, crossplatform application developed on SAP Mobile Platform (SUP HWC).

View more

ELSOP develops the SD Credit Release, a SAP Mobile Platform (SUP HWC) hybrid application for Hellenic Fuels

Thursday, 11 July 2013 10:38

Hellenic FuelsELSOP's Mobility Department implemented the Sales Distribution Credit Release application for Hellenic Fuels, a leading company in retail fuels business in Greece. SD Credit Released is a hybrid, crossplatform application developed on SAP Mobile Platform (SUP HWC).

View more

ELSOP develops the SD Credit Release, a SAP Mobile Platform (SUP HWC) hybrid application for EKO

Wednesday, 10 July 2013 11:31

EkoELSOP's Mobility Department implemented the Sales Distribution Credit Release application for EKO, one of the largest energy groups in South East Europe and a leading Greek company in the oil sector. SD Credit Released is a hybrid, crossplatform application developed on SAP Mobile Platform (SUP HWC).

View more

ELSOP completes SAP roll-out project for Total Hellas

Thursday, 09 May 2013 11:07

TotalELSOP Consulting Group completed succesfully the SAP roll-out project for Total Hellas. Total is a French multinational integrated oil and gas company and one of the six "Supermajor" oil companies in the world.

View more

ELSOP completes SAP roll-out project for Italcementi Group

Wednesday, 09 January 2013 10:23

Ital CementiELSOP Consulting Group completed succesfully the SAP roll-out project for Italcementi Group. Italcementi Group is a multinational company, one of the leaders in production of cement, ready-mix concrete and construction aggregates.

View more

ELSOP installs Mobile Basis on Papadopoulos

Wednesday, 14 November 2012 10:47

PapadopoulosELSOP Consulting Group installed its custom made Mobile Basis application on Papadopoulos, one of the largest greek companies, with many years of presence in the biscuit industry and bread substitute segment. Mobile Basis by ELSOP is a SUP native Android application purposed for SAP system administration.

View more

Tax Devices customization completed in Syngenta Hellas

Wednesday, 12 September 2012 15:12

SYNGENTA HELLASType A tax devices , models Casio FP500-600 and Proline 650-750 with signature processor and signature processor 2. Conversion to pdf and automatic delivery of documents via e-mail as attached files with the corresponding name_a.txt and name_b.txt files.

View more about Greece Tax Devices for SAP

Tax Devices customization completed in Arla Foods Hellas

Monday, 12 September 2011 14:23

ARLA

Type B tax devices, model: DM100, DM1000.

Automatic conversion and storage through the SAP of the printed documents which have passed from the tax device as PDFs. Ability to search documents in PDF format from the SAP system.

View more about Greece Tax Devices for SAP

Customers: