Managing Inventory
    • PDF

    Managing Inventory

    • PDF

    Article Summary

    Available in Classic and VPC

    In the Manage Inventory menu, you can manage inventory movement between warehouses as well as warehousing/shipment management, inventory checks to check and match computerized and physical inventory, current inventory inquiry, inventory receipt and payment status inquiry, and monthly inventory closing management.

    Manage Warehousing

    In the Manage Warehousing menu, you can register the inbound shipments history and download the history as an Excel file.

    When the warehousing history is registered, the inventory is increased by the warehousing quantity. The sales items can be categorized into Produced Warehousing, shipped through direct production, Purchase Warehousing, shipped from external purchase, and Other Warehousing, which is neither produced nor purchased, for management. You can manage the warehousing for each warehouse registered in the Sales > Sales Standard Information > Warehouse Information.

    The Manage Warehousing page is laid out as follows.

    workplace-workplace-14-3_goodsreceiptpage

    AreaDescription
    ① Search windowSearch by business place, warehousing date, warehousing manager, warehousing warehouse, warehousing type, or warehousing number conditions
    Register WarehousingRegister warehousing history (See Register Warehousing)
    Delete WarehousingDelete selected warehousing history (See Delete Warehousing)
    DownloadDownload the Manage Warehousing list as an Excel file (See Download Warehousing History)
    ⑤ Warehousing History ListSearch the warehousing history list
  • Click the warehousing number to search details for the applicable warehousing history
  • Register Warehousing

    The following describes how to register warehousing history.

    1. In the WORKPLACE PC web page, click the [Service Menu] > [Sales] buttons, in that order.

    2. Click the Manage Inventory > Manage Warehousing menus, in that order.

    3. Click the [Register Warehousing] button.

    4. Enter the warehousing information and click the [Add] button.

      • The fields marked in yellow are required items.
      • Warehousing Number: The warehousing number is added automatically. (Numbering rule: PI + yyyymmdd + 6 digit sequence)
      • Business Place: Select the business place item.
      • Warehousing Warehouse: Select a warehouse of the selected business place. You can't add items unless you select a warehousing warehouse.
      • Warehousing Date: You can only select a past date including the current date.
      • Warehousing Type: Select the warehousing type.
        • Kind of Warehousing Type: Select the warehousing type (produced warehousing, purchase warehousing, and other warehousing).
      • Warehousing Manager: Select the warehousing manager.

      workplace-workplace-14-3_goodsReceiptinfo1

    5. Enter the warehousing item information.

      • Item Code: Select the item code field to select items to warehouse. When you select an item code, the Item Group, Standard, Inventory Quantity, and Inventory Unit are entered automatically.
      • Warehousing Quantity: Enter the warehousing quantity (required field). You can only enter positive integers in the Warehousing Quantity field.
      • Duplicated items can't be saved.
      • To delete the added item, click the [Delete] button.
    6. Click the [Save] > [Ok] buttons, in that order.

    Download Warehousing History

    The following describes how to download warehousing history as an Excel file.

    1. In the WORKPLACE PC web page, click the [Service Menu] > [Sales] buttons, in that order.
    2. Click the Manage Inventory > Manage Warehousing menus, in that order.
    3. Enter the warehousing conditions to be searched in the search window, and then click the [Search] button.
      • You can search the warehousing history records that match the entered conditions.
    4. Click the [Download] button.
      • The warehousing history is downloaded as an Excel file.
    Note

    The downloaded file is saved as ManageWarehousing_YYYYMMDD_XXXXXX.xlsx in the Downloads folder.

    Delete Warehousing

    The following describes how to delete warehousing history.

    1. In the WORKPLACE PC web page, click the [Service Menu] > [Sales] button.
    2. Click the Manage Inventory > Manage Warehousing menus, in that order.
    3. Select the warehousing data to delete.
    4. Click the [Delete Warehousing] button.
    5. In the notification pop-up window, click the [OK] button.
      • The warehousing data is deleted.
    Note

    You can't delete warehousing data in the following cases.

    • Warehousing data of closed month
    • If the company has set negative inventory to Now allow (Sales > Settings menu) and the inventory becomes less than 0 when deleting the warehousing data

    Manage Outbound Shipment

    In the Manage Outbound Shipment, you can register or search outbound shipment history information for items to sell. In addition to outbound shipments from normal sales, you can also manage inventory through other outbound shipment processing when outbound shipment processing is needed for purposes such as processing as loss or discard, and the inventory decreases by the shipment quantity.

    The Manage Outbound Shipment page is laid out as follows.

    workplace-workplace-14-3_goodsIssuelist1

    AreaDescription
    ① Search windowSearch by business place, shipment date, shipment manager, shipment type, and shipment number conditions
    Register Outbound ShipmentRegister new outbound shipment history (See Register Outbound Shipment)
    Delete Outbound ShipmentDelete selected outbound shipment history (See Delete Outbound Shipment)
    DownloadDownload the Manage Outbound Shipment list as an Excel file (See Download Outbound Shipment History)
    ⑤ Outbound Shipment History ListSearch the outbound shipment history list
  • Click the shipment number to search details for the applicable outbound shipment history
  • Register Outbound Shipment

    The following describes how to register outbound shipment history.

    1. In the WORKPLACE PC web page, click the [All Services] > [Sales] button, in that order.

    2. Click the Manage Inventory > Manage Outbound Shipment menus, in that order.

    3. Click the [Register Outbound Shipment] button.

    4. Enter the outbound shipment information and click the [Add] button.

      • The fields marked in yellow are required items.
      • Outbound Shipment Number: The outbound shipment number is added automatically. (Numbering rule: OC +yyyymmdd+ 6 digit sequence)
      • Business Place: Select the business place.
      • Shipment Warehouse: Select a warehouse of the selected business place. You can't add items unless you select a shipment warehouse.
      • Shipment Date: You can only select a past date including the current date.
      • Shipment Type: Select the shipment type (discard, processed as loss, or others).
      • Shipment Manager: Select the shipment manager.

      workplace-workplace-14-3_goodsIssueinfo1

    5. Enter the shipment item information.

      • Item Code: Select the item code field to select items to ship. When you select an item code, the Item Group, Standard, Inventory Quantity, and Inventory Unit are entered automatically.
      • Shipment Quantity: Enter the shipment quantity (required field). You can only enter positive integers in the Shipment Quantity field.
        • The negative inventory is not allowed for the outbound shipment quantity in this menu. However, the negative inventory is allowed for the sale registration.
      • Duplicated items can't be saved.
      • To delete the added item, click the [Delete] button.
    6. Click the [Save] > [Ok] buttons, in that order.

    Download Shipment History

    The following describes how to download shipment history as an Excel file.

    1. In the WORKPLACE PC web page, click the [Service Menu] > [Sales] buttons, in that order.
    2. Click the Manage Inventory > Manage Outbound Shipment menus, in that order.
    3. Enter the shipment conditions to be searched in the search window, and then click the [Search] button.
      • You can search the shipment history records that match the entered conditions.
    4. Click the [Download] button.
      • The shipment history is downloaded as an Excel file.
    Note

    The downloaded file is saved as ManageOutboundShipment_YYYYMMDD_XXXXXX.xlsx in the Downloads folder.

    Delete Outbound Shipment

    The following describes how to delete outbound shipment data.

    1. In the WORKPLACE PC web page, click the [Service Menu] > [Sales] button.
    2. Click the Manage Inventory > Manage Outbound Shipment menus, in that order.
    3. Select the outbound shipment data to delete.
    4. Click the [Delete Outbound Shipment] button.
    5. In the notification pop-up window, click the [OK] button.
      • The outbound shipment data is deleted.
    Note

    Outbound shipment data of a closed month can't be deleted.

    Manage Inventory Movement

    In the Manage Inventory Movement, you can register inventory movement results between business places or between warehouses and manage the history. When registering the movement results, their history is applied to the warehousing/shipment warehouse respectively. If the business places of the outbound shipment and warehousing are different, then the warehousing/shipment type is Business Place Relocation. If they're in the same business place with different warehouses, then the warehousing/shipment type is Warehouse Relocation.

    The Manage Inventory Movement page is laid out as follows.

    workplace-workplace-14-3_goodsMove

    AreaDescription
    ① Search windowSearch by inventory movement number movement date, manager, shipment business place, shipment warehouse, warehousing business place, and warehousing warehouse conditions
    Register Inventory MovementRegister inventory movement (See Register Inventory Movement)
    Delete Inventory MovementDelete selected inventory movement history (See Delete Inventory Movement)
    DownloadDownload the inventory movement list as an Excel file (See Download Inventory Movement History)
    ⑤ Inventory Movement History ListSearch the inventory movement history list
  • Click the inventory movement number to search details for the applicable inventory movement history
  • Register Inventory Movement

    The following describes how to register inventory movement history.

    1. In the WORKPLACE PC web page, click the [Service Menu] > [Sales] buttons, in that order.

    2. Click the Manage Inventory > Manage Inventory Movement menus, in that order.

    3. Click the [Register Inventory Movement] button.

    4. Enter the inventory movement information and click the [Add] button.

      • The fields marked in yellow are required items.
      • Inventory Movement Number: The inventory movement number is automatically added. (Numbering rule: WT + yyyymmdd + 6 digit sequence)
      • Manager: Select the manager to be in charge of the inventory movement.
      • Movement Date: You can only select a past date including the current date.
      • Outbound Shipment Business Place: Select the business place to ship the inventory from.
      • Outbound Shipment Warehouse: Select a warehouse of the outbound shipment business place. You can't add items unless you select a shipment warehouse.
      • Warehousing Business Place: Select the business place to warehouse the inventory.
      • Warehousing Warehouse: Select a warehouse of the warehousing business place.

      workplace-workplace-14-3_goodsMoveinfo

    5. Enter the inventory movement item information.

      • Item Code: Select the item code field to select items to warehouse. When you select an item code, the Item Group, Standard, Inventory Quantity, and Inventory Unit are entered automatically.
      • Movement Quantity: Enter the movement quantity. The movement quantity can't be greater than the inventory quantity. You can only enter positive integers in the Movement Quantity field.
      • Duplicated items can't be saved.
      • To delete an added item, select the item to delete, and then click the [Delete] button.
    6. Click the [Save] > [Ok] buttons, in that order.

    Download Inventory Movement History

    The following describes how to download inventory movement history as an Excel file.

    1. In the WORKPLACE PC web page, click the [Service Menu] > [Sales] buttons, in that order.
    2. Click the Manage Inventory > Manage Inventory Movement menus, in that order.
    3. Enter the inventory movement conditions to be searched in the search window, and then click the [Search] button.
      • You can search the inventory movement history records that match the entered conditions.
    4. Click the [Download] button.
      • The inventory movement history is downloaded as an Excel file.
    Note

    The downloaded file is saved as ManageInventoryMovement_YYYYMMDD_XXXXXX.xlsx in the Downloads folder.

    Delete Inventory Movement

    The following describes how to delete inventory movement data.

    1. In the WORKPLACE PC web page, click the [Service Menu] > [Sales] button.
    2. Click the Manage Inventory > Manage Inventory Movement menus, in that order.
    3. Select the inventory movement data to delete.
    4. Click the [Delete Inventory Movement] button.
    5. In the notification pop-up window, click the [OK] button.
      • The inventory movement data is deleted.
    Note

    You can't delete inventory movement data in the following cases.

    • Inventory movement data of closed month
    • If the company has set negative inventory to Now allow (Sales > Settings menu) and the inventory becomes less than 0 when deleting the inventory movement data

    Manage Inventory Check

    In the Manage Inventory Checks, you can register and manage the results of the regular checks on the inventory in the warehouse according to the company's internal rules, the cycle checks according to the item's importance, and the irregular checks for managing the actual inventory quantity.

    The Manage Inventory Checks page is laid out as follows.

    workplace-workplace-14-3_goodsCountlist_KO

    AreaDescription
    ① Search windowSearch by business place, inventory check date, inventory check manager, inventory check warehouse, inventory check number, inventory check type, and inventory check status conditions
    Register Inventory CheckRegister inventory checks (See Register Inventory Check)
    Delete Inventory CheckDelete selected inventory check history (See Delete Inventory Check)
    DownloadDownload the inventory checks list as an Excel file (See Download Inventory Check History)
    ⑤ Inventory Check History ListSearch the inventory check history list
  • Click the inventory checks number to search details for the applicable inventory check history
  • Note
    • The inventory check type is divided as follows.
      • Regular checks: inventory check that is conducted once a year, quarter, half-year, or month (e.g., regular checks on the fourth Friday of each month)
      • Cycle Check: inventory check periodically executed by inspecting the real inventory to match the real inventory quantity to the inventory quantity in the ledger
      • Irregular Checks: inventory check executed at any time when an unexpected inventory check is needed for specific items
    • The inventory check status is entered automatically according to the save status, which is divided as follows.
      • Checks in Progress: saved temporarily
      • Checks Completed: checks completed (saved), a stage before the inventory adjustment
      • Adjustment Completed: a stage where the inventory adjustment is completed and applied

    Register Inventory Check

    The following describes how to register inventory check history.

    1. In the WORKPLACE PC web page, click the [Service Menu] > [Sales] buttons, in that order.

    2. Click the Manage Inventory > Manage Inventory Checks menus, in that order.

    3. Click the [Register Inventory Checks] button.

    4. Enter the inventory checks information, and then click the [Add] button.

      • The fields marked in yellow are required items.
      • Inventory Checks Number: The inventory checks number is added automatically. (Numbering rule: WT +yyyymmdd+ 6 digit sequence)
      • Business Place: Select the business place.
      • Inventory Checks Warehouse: Select a warehouse for the inventory checks. You can't add items unless you select a warehouse for the inventory checks.
      • Inventory Checks Name: Enter an inventory checks name.
      • Inventory Checks Date: Enter an inventory checks date.
      • Inventory Checks Type: Select an inventory checks type.
        • Regular checks: inventory check that is conducted once a year, quarter, half-year, or month (e.g., regular checks on the fourth Friday of each month)
        • Cycle Check: inventory check periodically executed by inspecting the real inventory to match the real inventory quantity with the inventory quantity in the ledger.
        • Irregular Checks: inventory check executed at any time when an unexpected inventory check is needed for specific items
      • Inventory Checks Manager: Select an inventory check manager from the combo box.
      • Inventory Check Status: The inventory check status is entered automatically according to the save status.
        • Checks in Progress: saved temporarily
        • Checks Completed: checks completed (saved), a stage before the inventory adjustment
        • Application Completed: The inventory adjustment has been completed, and the inventory is applied.

      workplace-workplace-14-3_goodsCountinfo1

    5. Enter the inventory checks item information.

      • Item Code: Select an item code to select items to warehouse. When you select an item code, the Item Group, Standard, Inventory Quantity, and Inventory Unit are entered automatically.
      • Quantity from Inventory Checks: Enter the actual quantity of the item. You can only enter positive integers in the Quantity from Inventory Checks field.
      • Quantity Difference: The quantity difference is the "Quantity from Inventory Checks" - "Quantity on System."
      • Duplicated items can't be saved.
      • To delete an added item, select the item to delete, and then click the [Delete] button.
    6. Click the [Save] > [OK] button to enter the inventory movement information.

      • In the Inventory Check History List, the Inventory Check Status is displayed as Check Completed.
      • If the inventory check hasn't been completed, then click the [Save Temporarily] button. In the Inventory Check History List, the Inventory Check Status is displayed as Check in Progress.
      • If the inventory check has been completed, complete the inventory adjustment, and then click the [Apply Inventory] button. In the Inventory Check History List, the Inventory Check Status is displayed as Adjustment Completed.

    Download Inventory Check History

    The following describes how to download inventory check history as an Excel file.

    1. In the WORKPLACE PC web page, click the [All Services] > [Sales] button, in that order.
    2. Click the Manage Inventory > Manage Inventory Checks menus, in that order.
    3. Enter the inventory checks conditions to be searched in the search window, and then click the [Search] button.
      • You can search the inventory check history records that match the entered conditions.
    4. Click the [Download] button.
      • The inventory check history is downloaded as an Excel file.
    Note

    The downloaded file is saved as ManageInventoryCheck_YYYYMMDD_XXXXXX.xlsx in the Downloads folder.

    Delete Inventory Check

    The following describes how to delete inventory check data.

    1. In the WORKPLACE PC web page, click the [Service Menu] > [Sales] button.
    2. Click the Manage Inventory > Manage Inventory Checks menus, in that order.
    3. Select the inventory check data to delete.
    4. Click the [Delete Inventory Check] button.
    5. In the notification pop-up window, click the [OK] button.
      • The inventory check data is deleted.
    Note

    You can't delete inventory check data in the following cases.

    • Inventory check data of closed month
    • If the company has set negative inventory to Now allow (Sales > Settings menu) and the inventory becomes less than 0 when deleting the inventory check data in the "Adjustment completed" status

    View Current Inventory

    In the View Current Inventory menu, you can search the current inventory quantity managed by business place, warehouse, or item.

    The View Current Inventory page is laid out as follows.

    workplace-workplace-14-3_currentStocklist_ko

    AreaDescription
    ① Search windowSearch by business place, warehouse, item category, item group, and item conditions
    DownloadDownload the list of current inventory status as an Excel file (See Download Current Inventory Status)
    ③ List of Current Inventory StatusSearch the list of current inventory status

    Download Current Inventory Status

    The following describes how to download the current inventory status as an Excel file.

    1. In the WORKPLACE PC web page, click the [Service Menu] > [Sales] buttons, in that order.
    2. Click the Manage Inventory > View Current Inventory menus, in that order.
    3. Enter the conditions to be searched in the search window, and then click the [Search] button.
      • You can view the current inventory status that matches the entered conditions.
    4. Click the [Download] button.
      • The list of current inventory is downloaded as an Excel file.
    Note

    Downloaded file is saved as View Current Inventory_YYYYMMDDXXXXXX.xlsx in the Downloads folder.

    Inventory Receipt and Payment Status

    In the Inventory Receipt and Payment Status menu, you can view all warehousing/shipment history by warehouse. You can view all warehousing and outbound shipment history by type including normal sales outbound shipment, returned sales, other outbound shipment, sales warehousing, inventory movement, and business place relocation.

    The Inventory Receipt and Payment Status page is laid out as follows.

    workplace-workplace-14-3_inoutStocklist

    AreaDescription
    ① Search windowSearch by business place, period, warehouse, item category, item group, item, and warehousing/shipment type conditions
    DownloadDownload the list of inventory receipt and payment status as an Excel file (See Download List of Inventory Receipt and Payment Status)
    ③ List of inventory receipt and payment statusSearch the list of inventory receipt and payment status

    Download Inventory Receipt and Payment Status

    The following describes how to download the inventory receipt and payment status as an Excel file.

    1. In the WORKPLACE PC web page, click the [Service Menu] > [Sales] buttons, in that order.
    2. Click the Manage Inventory > Inventory Receipt and Payment Status menus, in that order.
    3. Enter the conditions to be searched in the search window, and then click the [Search] button.
      • You can view the inventory receipt and payment status that match the entered conditions.
    4. Click the [Download] button.
      • The list of inventory receipt and payment status is downloaded as an Excel file.
    Note

    The downloaded file is saved as InventoryReceiptandPaymentStatus_YYYYMMDD_XXXXXX.xlsx in the Downloads folder.

    Inventory Closing

    To process monthly accounting closing, you need to first control the warehousing and outbound shipment of the inventory through inventory closing.

    In the Inventory Closing menu, you can close the inventory by business place or by month to control the warehousing/outbound shipment processing.

    The Inventory Closing page is laid out as follows.

    workplace-workplace-14-3_goodsCloselist_ko

    AreaDescription
    ① Search windowSearch by business place, or year conditions
    ② Inventory closing listView the list of inventory closing

    Process Inventory Closing

    The following describes how to process the inventory closing.

    1. In the WORKPLACE PC web page, click the [Service Menu] > [Sales] buttons, in that order.
    2. Click the Manage Inventory > Inventory Closing menus, in that order.
    3. Click the [Process Closing] button on the row of the period when you process the closing.
    4. Check the details in the pop-up window, and then click the [OK] button.
    • When the Process Closing is completed, the status is changed to Closed, and the button is changed to the [Cancel] button. In the Closed status, you can't process warehousing or outbound shipment for the year and month for the closed business place from the Register Sale or Manage Inventory menu in Manage Sale.
    • To cancel the Process Closing, click the [Cancel] button on the row of the period to cancel. The status is changed to Not Closed, and the button is changed to the [Process Closing] button. In the Not Closed status, you can execute inventory movement in the Manage Inventory Movement menu.
    • You can process the closing in order, from the year and month where the initial warehousing/outbound shipment occurred.
    • If the closing of the previous month of warehousing/outbound shipment has not been processed, then you have to process the closing of the previous month.
    • If the month following the month for which you want to cancel the closing is closed, then you must cancel the closing of the following month first.

    View Inventory Change History

    You can view the inventory change history, such as an increase, decrease, or deletion of inventory and changing personnel information.

    The change history viewed in the View Inventory Change History page is the change history of Manage Warehousing, Manage Outbound Shipments, Manage Inventory Movement, Manage Inventory Checks, and Register Sales pages.

    The View Inventory Change History page is laid out as follows.

    workplace-stock-change-history1_ko

    AreaDescription
    ① Search windowSearch by the date of change, warehousing/shipment number, job page, business place, warehouse, item, and changing personnel conditions
    DownloadDownload the list of inventory changes as an Excel file (See Download Inventory Change History)
    ③ List of inventory change recordsView inventory change history
  • Changed Quantity: It displays the changed inventory quantity
  • Download Inventory Change History

    The following describes how to download the inventory change history as an Excel file.

    1. In the WORKPLACE PC web page, click the [Service Menu] > [Sales] buttons, in that order.
    2. Click the Manage Inventory > View Inventory Change History menus, in that order.
    3. Enter the conditions to be searched in the search window, and then click the [Search] button.
      • You can view the inventory change history that matches the entered condition.
    4. Click the [Download] button.
      • The list of inventory change history is downloaded as an Excel file.
    Note

    The downloaded file is saved as InventoryChangeHistory_YYYYMMDDXXXXXX.xlsx in the Downloads folder.


    Was this article helpful?

    What's Next
    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.