1. Print out stock list (SAP)
| Description | Program of displaying the stock status in sales storage location |
| Menu Path | Sales & Distribution>Chain Store Stock>Stock Display>Display of stock at the current point in time |
| System | SAP R3 |
Print out the stock list of store storage location for physical inventory.
1.1 Display stock– ZSD21120
1.1.1 Stock display program –Enter search fields
|
① Sales Organization: Enter the affiliate concerned such as AmorePacific / affiliate / each country, etc. (mandatory entry) ② Plant: Enter the Plant of each affiliate. ③ Storage Location: Enter the storage location of the store of which you want to display the stock status. * If you choice Type of Seatch to Customer, You can enter just customer code. ④ Brand Group/Code: Enter when you display only materials corresponding to brand group/code. ⑤ Material Code: Enter when you display only a certain material. ⑥ Material Usage: Use when you display materials based on the criteria selected, All / Regular Product / Non-Regular Product (=Promotion, etc.). * After entering the necessary key, click on the (Execute) button. |
| ①After clicking on the Execute button, the list of all materials existing in the corresponding sales storage location is displayed. |
1.1.2 Stock display program–Export the stock list in Excel file
| ① Click on the |
| ① Select [Spreadsheet] in the select list. |
| ① Select [Select from All Available Formats (Excel 2007 XSLX Format)]. |
| ① Enter the file name and save in the folder that you want. |
| ① When the Excel file is opened, process physical inventory with this document. |
2. Physical inventory in sales storage location (Manual)
Count the physical stock and compare it to the system stock. Physical inventory is classified into two types:periodic, which is carried out once a month, and special, which is carried out when a stock difference occurs. In case of periodic physical inventory, the result must be registered for all items whilein case of special physical inventory, you can adjust only certain items.
3. Register physical inventory (SAP)
| Description | Program of registering the physical inventory result in SAP |
| Menu Path | Sales & Distribution>Chain Store Stock>Physical Inventory>Physical Inventory Creation |
| System | SAP R3 |
Register the physical inventory result in SAP and request the change of inventory.
3.1 register physical inventory – ZSD21100
3.1.1 Register store information
① Sales Organization: Enter the sales organization concerned. (AP, Etude, Innisfree, etc.) ② Customer: Enter the customer code concerned. ③ Doc. Type: Select the type between Periodic/Special. ④ Count Date: Enter the date when the physical inventory is carried out. ⑤ Enter the items and click on the Register button. |
① Check the customer information displayed above after the registeration. ② When there is any problem, click on the Clear Data button for re-input. |
3.1.2 Enter periodic physical inventory–Manual input
① Create a line below by clicking on the(Add Row/Delete Row) button. ② Enter the code and quantity of materials of which periodic physical inventory has been carried out. ③ If the counted quantity is 0, you should tick[ZERO COUNT]. (Since 0 cannot be recognized in SAP, when 0 is entered, it is considered as if nothing is entered.) |
① Finish entering the information on all materials and check the information (stock, amount) of materials with a difference. ② Check the information on the quantity difference between system stock and physical stock and the posted amount (cost, consumer price). ③ You should check the status light on the left side. Status: It is marked when there is a problem in stock status such as no stock or no price information. Stock: It is marked when it cannot be processed as the quantity difference (system stock-physical stock) is less than the current system stock, that is, when re-aggregation is needed due to the delay of physical inventory registeration. ④When you finish entering, click on the Create Documentbutton. |
① In case of periodic physical inventory, you cannot create the physical inventory document if there is any missing material in the list of all materials and a pop-up appears to let you know the list of omitted materials on the screen. ② In this case, you can manually enter omitted materials in addition. When there are too many items or you want to check automatically the list of omitted materials, click on the View All Materials button so that the list of stock existing on the system at the current point in time is additionally created. |
① When you click on the View All Materials button, the omitted material is added at the bottom of the line as shown in this screen. ② After the line is created, enter the counted quantity and click again the Create Document button. |
3.1.3 Enter periodic physical inventory–Excel upload
| ① Enter the customer information and click on the [Format Download] button to download the Excel file. |
① When you execute the Excel file, you can see the designated format. ② Enter the material code and the counted quantity in accordance with the upload format. * When the stock quantity is 0, you should mark X in the quantity as in case of manual input. |
| ① You can enter the data by copy and paste and there is no problem even though the framework is removed. |
| ① After entering the customer information, click on the Data Upload button to register the Excel file. |
① Verify if the detail entered in Excel file corresponds to the detail actually registered on the screen. *You can see that the material with Zero Count ticked in the Excel file is registered as it is on the screen. ② Click the Create Doc. button. |
3.1.4 Enter special physical inventory–Manual input&Excel upload
① Select [Special] in the Document Type field. ② The follow-up process is same as in periodic physical inventory. * But in case of special physical inventory registration, you can save even though you entered only certain materials and not all items. |
4. Confirm physical inventory detail &reflect (SAP)
| Description | Process of confirming the physical inventory detail |
| Menu Path | Sales & Distribution>Chain Store Stock>Store Physical Inventory>Physical Inventory Confirmation |
| System | SAP R3 |
Check the registered physical inventory detail and confirm it. The confirmed detail will be directly posted in accounting.
The authority for confirmation differs according to the amount of physical inventory, and programs that can be used by each authority are separated.
(ZSD21131-PIC of sales, ZSD21132-Sales team manager, ZSD21133-Head of Div.)
4.1 Confirm physical inventory– ZSD21131/ZSD21132/ZSD21133
① Sales Organization: Enter the sales organization concerned. ② Sub Sales Organization: Select the sub sales channel concerned. ③ Sales Office: Select the sales office of the customer to confirm. ④ Customer: Select the customer to confirm. ⑤ Count Date: Select the period to confirm. * Only Sales Organization and Count Date are mandatory and you can enter the identifier according to the confirmation level. ⑥ When the input is completed, click on the(Execute) button. |
① The physical inventory detail registered in the selected customer and period is displayed. ② You can check the aggregated detail for the quantity difference/amount per customer. |
① When you double-click on the line to check, the registered physical inventory detail is displayed below. ② Check the detailed information such as quantity difference, reflected cost amount, etc. |
① When you finished checking, select the corresponding request and click on the “Confirm/Reject/Modify” button. ② Select Modify when a change is needed in the item/quantity of the registered physical inventory. * You cannot delete the items already registered and can only change their quantity. (But you can register items additionally.) ③ When executing Reject, the Confirmation Status becomes“Rejected” and no change occurs in the stock information. * But, the history of request/reject remains. |
① When you select Confirm, a screen to enter the posting date appears. ② The posting date is a date to reflect the physical inventory result. You can enter the today’s date in the course of the month. * But, for channels trading with distribution company, there are cases where the physical inventory result of the last day of the month is processed on the first or second day of the month. In this case, you should enter the last day of the previous month for the posting date. ③ Enter the posting date and click on the [Post] button. |
① When the confirmation is completed, the status light becomes green and the Confirmation Status becomes ‘Inventory Confirmed’. ② The information such as posting date is updated in the upper field and the cost amount of the material with quantity difference is posted in accounting. |
| ① After confirmation, click on the material document number on the right side to display the document posted in accounting. |
① You can check the profit center and the G/L account through the material document. ② When you click on the [FI Document] button, you can check the processed result in detail. |
5. Chain store physical inventory result display (SAP)
| Description | Process of checking the registered/confirmed/processed physical inventory detail. |
| Menu Path | Sales & Distribution>Chain Store Stock>Store Physical Inventory>Physical Inventory Status Display |
| System | SAP R3 |
5.1 Physical inventory status display– ZSD21150
① Sales Organization: Enter the sales organization concerned. ② Sub Sales Channel/Sales Office/Customer: Enter the level that you want to identify. ③ Physical Inventory Type: Display by selecting Periodic or Special. ④ Physical Inventory Date: Select the physical inventory date for display. ⑤ List Type: Use when you want to display by drilling down from the top organization. |
5.1.1 Physical inventory status display–Sub-sales channel level
① The report result is displayed per sub-sales channel. ② You can see the information on the number of requested/confirmed/rejected/unconfirmed cases. ③ The quantity difference (+, -),the cost amount difference and the sales amount difference of all requested cases are displayed. ④ The quantity difference and the amount difference of confirmed (approved)/rejected/unconfirmed details are separately displayed on the right side. |
① When you double-click on a certain division, the processed detailof the corresponding division is displayed below. ② You can check the information on the number of requested / confirmed / rejceted / unconfirmed cases. ③ When you double-click on the line to display in the processed detail below, you can go to the confirmation screen and check the detail per material. |
5.1.2 Physical inventory status display – Sales office level
① The report result is displayed per sales office. ② You can see the information on the number of requested / confirmed / rejected / unconfirmed cases. ③ The quantity difference (+, -), the cost amount difference and the sales amount difference of all requested cases are displayed. ④ The quantity difference and the amount difference of confirmed (approved)/ rejected / unconfirmed details are separately displayed on the right side. ⑤ The function of displaying per store/material in detail by double-clicking the line is same as in the division level. |
5.1.3 Physical inventory status display–Customer level, sum
① The report result is displayed per store. ② The follow-up step is the same as in the previous level. |
5.1.4 Physical inventory status display–Cusomer level, per physical inventory
① The physical inventory detail per storeis displayed in RAW file format andthe result is drawn. * Use this level when the RAW file is necessary such as per customer and not the sum. |
6. Approval request after chain store physical inventory (manual)
The sales office which manages chain stores aggregates periodic/special physical inventory detail once a month and requests approval to the approver of each channel. The approval request should be made based on the facts according to the physical inventory result displayed in the report.
评论
0 条评论
请登录写评论。