Inventory Module

• List Of Item
• Item Category
• Item Barcode
• Item Label
• Matrix Item
• Count Item
• Customer Item
• Vendor Item
• Release Item Reserved
• Item/Service Ordering
• Ordering By Document
• Stock Take
• Stocktake inbox
• Item/Service Price
• Stocktake Setting
• COGM Card
• COGM Card Inbox
• COGM Report
• Raw Material Usage Report
• Minimum Stock Setup
• Inventory Adjustment by Value
• Inventory Adjustment by Value Inbox
• Inventory Adjustment
• Inventory Adjustment Inbox
• Inventory Transformation
• Inventory Transformation Inbox
• Transformation Matrix
• Item/Service Price
• Current Warehouse Usage
• Warehouse Costing
• Warehouse Costing Inbox
• Bin Transfer
• Bin Transfer Inbox
• Bin Transfer Receipt
• Warehouse Transfer Request
• Warehouse Transfer Request Inbox
• Warehouse Transfer
• Warehouse Transfer Inbox
• Warehouse Transfer Receipt
• Warehouse Transfer Report
• Shipment List
• Intercompany
• Goods Receipt
• Goods Receipt Note Inbox
• Goods Receipt Cancellation Inbox
• Delivery Order
• Delivery Order Inbox
• Internal Delivery Order Report
• Delivery Order Raw
• Trip Activity
• Shipment Planning
• Shipment Planning Inbox
• Shipment Planning Declaration
• Goods Inflow Report
• Goods Outflow Report
• Stock Mutation Report
• Remnant & Scrap Goods Mutation Report
• Asset Mutation Report
• In Vs Out
• Item Exchange
• Item Exchange Inbox
• Internal Material Requisition
• Internal Material Requisition Inbox
• Internal Material Requisition Report
• Material Requirements Planning
• Transaction Journal
• Inventory
• Item Inventory
• Inventory Report by Transaction
• Warehouse Report
• Slow-Moving Inventory
• Inventory Mutation
• Stock Card Report
• Inventory Balance Report
• Inventory Location
• Production Detail Report
• Reserved Item Report
• Expired Goods
• Item/Service List
• Kokola Group Shipment vs Receipt
• BC Source Document
• Delivery Order List
• SN Report Based On User
• Outstanding SN Report
• Warehouse Return
• Report History Per Barcode
• Inventory Adjustment Report
• Picking List Report
• Shipment Planning Report
• Shipment Plan vs Actual Shipment
• Bin Transfer Report
• Receipt List
• Account Link Report
• Price Archive Report
• Price Comparison Report
• Reorder Report
• Virtual Warehouse Report
• Item Transfer Tracking Report
• Warehouse Remnant Transfer Report
• PLInvoice
• Item/Service Conversation Report
• Conversion
• Shipping & Receiving Performance Report
• Goods Shipment

List Of Item

Module Guide: Item/Service List (Item Master)

Module Location

Inventory > List Of Item

Module Objective

The Item/Service List module is the master data hub or "dictionary" for all items managed by the company. This is the place to register and manage every item—from raw materials and packaging materials to finished goods—as well as services. The data created here is the foundation for almost all other operational modules, including Purchasing, Sales, and Production.

1. Main View (Item List)

The main page of this module displays a complete list of all items (goods and services) that have been registered in the system.

View Explanation & Key Filter

This page is for viewing, searching for, and managing all item data.

• Item/Service Category Type Filter: This is a key filter to switch between different item views, such as FINISHED GOODS (as in the example), RAW MATERIALS, PACKAGING MATERIALS, etc.

• Item List: The main table displays all items with details such as Item/Service Code, Item/Service Name, and Category.

Button Functions

• [New]: The primary button to register a new item.

2. Steps to Create a New Item (Example: Finished Good)

Step 1: Start Item Creation

1. From the Main View, click the [New] button.

2. You will likely be asked to first select the type of item to be created (e.g., Finished Good).

Step 2: Fill in Basic Information

1. You will be directed to the Add Item/Service form.

2. Fill in the Item/Service Code according to company numbering standards.

3. Fill in the Item/Service Name with a clear and descriptive name.

4. Select the Costing Method (e.g., AVG for Average Costing).

Step 3: Define Item Properties (Important!)

In the View Category section, check the appropriate boxes to define how this item will be treated by the system:

• Purchase: Check if this item can be purchased from a supplier.

• Sell: Check if this item can be sold to a customer.

• Inventory: Check if the stock of this item will be managed in the warehouse.

For a Finished Good example, you would check Sell and Inventory.

Step 4: Continue to the Next Stage

After filling in the basic information, click the [Next >>] button to continue to other detailed settings (such as unit of measure, dimensions, suppliers, etc.) before saving the data finally.

Tips & Important Notes

• This module is the heart of the Inventory, Sales, and Purchasing modules. Incorrect data here will cause problems in many other transactions.

• Ensure that item naming and coding are consistent and follow the standards set by the company.

• Pay close attention to the checkboxes in the View Category section, as this determines where this item can be used. For example, if Sell is not checked, the item will never appear when you create a Sales Order.

Item Category

Module Guide: Item/Service Category

Module Location

Inventory > Item/Service > Item Category

Module Objective

The Item/Service Category module serves as the master data hub for creating and managing the hierarchical structure of all item categories and sub-categories. The categorization created here will be used to classify each item in the Item/Service List module, which is crucial for simplifying searching, filtering, and reporting processes.

1. Main View (Category Structure)

The main page of this module displays a tree view of all the categories and sub-categories that you have defined.

View Explanation

This page is for viewing and managing the category hierarchy.

• Item/Service Category Type Filter: Use this dropdown to switch between the main category types, such as RAW MATERIAL (in the example), FINISHED GOODS, PACKAGING MATERIALS, etc.

• Add Group: Use the >> Add Group << link to create a new category or sub-category.

2. Steps to Create a New Category

Step 1: Start Category Creation

1. From the Main View, select the appropriate Category Type (e.g., RAW MATERIAL).

2. Click the >> Add Group << link to open the Add Group form.

Step 2: Fill in Category Details

On the form that appears, fill in the required details:

• Category Name: Enter a new and specific category name (e.g., 'Flour', 'Sugar', 'Oil', 'Carton Box').

• You can also fill in other data such as Usage Life or Procurement Lead Time if relevant for that category.

Step 3: Save the Category

After all data is filled in, click the [Save] button to add the new category to the structure.

Workflow & Integrated Business Process

• This module is a preparatory step before you create a new item in the Item/Service List module.

• The categories you create here will appear as the options in the 'Category' dropdown when you register a new item.

Tips & Important Notes

• A logical and well-organized category structure will greatly simplify inventory searching and reporting in the future.

• You can create multiple levels of sub-categories for more detailed classification (for example, Raw Material -> Food Chemicals -> Food Flavoring).

Item Barcode

Module Guide: Item/Service Barcode (Item Barcode View)

Module Location

Inventory > Item/Service > Item/Service Barcode

Module Objective

The Item/Service Barcode module serves as an inquiry screen or a special view for seeing the list of items in the context of barcode management. This module allows users to search for and view items that have been configured with barcode settings within the system.

1. Main View (Item List)

The main page of this module displays a list of items that is similar to the main Item/Service List module.

View and Function Explanation

• View: This page displays a list of items with columns such as Item/Service Code and Item/Service Name.

• Filter: You can use filters like the Item/Service Category Type Filter (e.g., FINISHED GOODS) to screen for the items you wish to see.

• Function: This module most likely functions as a read-only view or a report. There are no buttons to create, modify, or print barcodes directly from this list page.

2. Workflow & Integrated Business Process

• Module Nature: This module is informative, not transactional.

• Barcode Setup: To set up, assign, or change a barcode for an item, you must do so through the main Item/Service List module when creating a new item (New) or editing an existing one.

• Usage: Use this screen to quickly check the list of items and see their settings, possibly to verify which items are ready to use a barcode system.

Tips & Important Notes

• Consider this module as a "view" or a "report", not as a tool to generate or print barcode labels.

• The functionality for printing barcode labels is most likely located in another separate module (for example, within a Reports module) or within the detail page of each item.

Item Label

Module Guide: Item/Service Label (Item Label View)

Module Location

Inventory > Item/Service > Item/Service Label

Module Objective

The Item/Service Label module serves as an inquiry screen or a special view for seeing the list of items in the context of label management. Similar to the Barcode module, this module most likely provides a view of information that is relevant for the label printing process, such as quantity or ordering details.

1. Main View (Item List)

The main page of this module displays a list of items that is similar to the main Item/Service List module, but with some additional columns.

View and Key Column Explanation

• View: This page displays a list of items with columns such as Item/Service Code and Item/Service Name.

• Additional Columns: Pay attention to columns such as Item, Label Qty, and Label Ordering. These columns indicate that this view is specifically intended for managing label printing quantities.

• Filter: You can use filters like the Item/Service Category Type Filter (e.g., FINISHED GOODS) to screen for the items you wish to see.

2. Workflow & Integrated Business Process

• Module Nature: This module is informative, not transactional. There are no buttons to create, modify, or print labels directly from this list page.

• Data Source: The data displayed here, especially relating to quantities, is most likely pulled from other modules such as Sales Order or Production Work Order.

• Usage: Use this screen to quickly check which items require label printing and in what quantity.

Tips & Important Notes

• Consider this module as a "view" or a preparatory "report" before printing labels.

• The functionality for actually printing the labels is most likely located in another separate module (for example, within a Reports module) or within the detail page of each item.

Matrix Item

Module Guide: Item Matrix (Promotional Grouping)

Module Location

Inventory > Item/Service > Item Matrix

Module Objective

The Item Matrix module serves as a tool to create and manage groups of items that will be subject to special sales rules or conditions. This module is commonly used to create promotional programs, product bundles, or specific price/discount rules without having to create new item codes in the system.

1. Main View (Matrix List)

The main page of this module displays a list of all matrices or promotional groups that have been created.

View Explanation

This page is for viewing and managing all existing matrices.

• Matrix List: The table will display the Matrix Item Code and Matrix Item Name of every promotion that has been created.

Button Functions

• [New Matrix Item]: The primary button to create a new matrix or promotional group.

• [Delete]: To delete a selected matrix.

2. Steps to Create a New Item Matrix

Step 1: Create a New Matrix

From the Main View, click the [New Matrix Item] button to open the matrix creation form.

Step 2: Name the Matrix

On the form that appears, provide a unique and descriptive Matrix Item Code and Matrix Item Name for your promotion (e.g., "HOLIDAY PACKAGE", "SPECIAL FLOUR PROMO").

Step 3: Select Items for the Group

In the Item/Service List section, select items one by one from the top list box, then click the >> button to move them to the bottom list box. The items in the bottom box are the ones included in this promotional group.

Step 4: Set Up Sales Conditions (Important!)

At the bottom of the form, set up the rules or conditions that apply to this group. You can:

• Define a special Sales Price if these items are purchased together.

• Set up a Discount Setting that will automatically apply.

• Set up a Free item list promotion (e.g., Buy 2 of Flour A, Get 1 of Sugar B Free).

Step 5: Save the Matrix

After all items and rules are set, click the [Add] or [Save] button to save your promotional setup.

Workflow & Integrated Business Process

• The matrix you create here will become active and can be used in the Sales Order module.

• When a salesperson sells a combination of items that matches one of the matrices and meets its conditions, the system will automatically apply the price, discount, or free item promotion that you have set up.

Tips & Important Notes

• Use this module to flexibly manage "Buy X, Get Y" promotions, bundle discounts, or special prices for specific product combinations.

• This is a very useful and powerful tool for the Sales and Marketing teams.

Count Item

Module Guide: Stock Count Sheet

Module Location

Inventory > Item/Service > Stock Count Sheet

Module Objective

The Stock Count Sheet module functions as a digital count sheet for the Stocktake or physical inventory process. This module displays a list of items along with their stock balance according to the system and provides a special column for inputting the results of the actual physical count in the warehouse.

1. Main View (Count Sheet)

The main page of this module is a list of items that has been formatted for a stocktake activity.

View Explanation & Filters

• Filters: You can filter the list of items to be counted by Item/Service Category Type, Category, and Status.

• Month Period: Select the month and year of the stocktake period to be performed.

Key Column Explanation

• Qty in Warehouse: Shows the stock quantity for each item according to the system's records before the physical count.

• Stocktake: This is the main input column. This is where you enter the quantity that you physically counted in the warehouse.

• Stocktake Balance: This column will automatically calculate the difference between the Qty in Warehouse (system) and the Stocktake (physical).

2. Steps to Perform a Stocktake

1. Prepare the Count Sheet:

   • Use the filters to display the items that will be counted (for example, all Active FINISHED GOODS).

   • You can print this page or export it to Excel to be brought to the warehouse as a checklist.

2. Perform the Physical Count: The warehouse team conducts the physical count for each item on the list.

3. Input the Count Results: Return to this module and enter the physical count results for each item into the corresponding Stocktake column.

4. Review the Difference: After all data is input, check the Stocktake Balance column. A non-zero number in this column indicates a stock discrepancy (a shortage or surplus) that requires investigation.

5. Adjustment Process: After the discrepancy is investigated and validated, the next step is to create an Inventory Adjustment transaction in another module to align the stock quantity in the system with the physical count results.

Tips & Important Notes

• This module is for the preparation and recording step in the stocktake process. The action to adjust the stock in the system is done in a separate module.

• To get an accurate Qty in Warehouse, ensure all goods movement transactions (receipts, shipments) have been fully recorded before starting the stocktake.

• This is a fundamental work tool for the Warehouse and Inventory Accountant teams, performed periodically.

Customer Item

Module Guide: Customer List (Customer Item/Service)

Module Location

Inventory > Item/Service > Customer Item/Service

Module Objective

Although named "Customer Item/Service," this module functions as a master list for all customers registered in the system. It is an inquiry screen that provides a directory or list of all customers along with their basic information.

1. Main View (Customer List)

The main page of this module displays a complete list of all the company's customers.

View and Function Explanation

• View: This page displays a list of all customers with details such as Customer Code, Customer Name, and Customer Address.

• Filter: You can quickly search for a specific customer by using the Customer Code filter at the top.

• Function: This module is informative and functions as a search or lookup tool for customer data. There are no functions to add or edit customers from this page.

2. Workflow & Integrated Business Process

• Module Nature: This module is a read-only module for customer data.

• Usage: Use this screen as a quick way to look up a customer's code, official name, or address.

• Advanced Settings: Settings for specific items or prices for each customer are most likely done in other, more specific modules, such as the "Customer Master" in the Sales module.

Tips & Important Notes

• Do not be confused by the name; the main focus of this module is to display a Customer List, not a list of items per customer.

• Consider this module as a "Phone Book" or directory for all of your customers.

Vendor Item

Module Guide: Supplier List (Supplier Item/Service)

Module Location

Inventory > Item/Service > Supplier Item/Service

Module Objective

Just like the "Customer Item/Service" module, this Supplier Item/Service module functions as a master list for all suppliers (vendors) registered in the system. It is an inquiry screen that provides a directory or list of all company suppliers.

1. Main View (Supplier List)

The main page of this module displays a complete list of all the company's suppliers.

View and Function Explanation

• View: This page displays a list of all suppliers with basic details such as Supplier Code, Supplier Name, and Supplier Address.

• Filter: You can quickly search for a specific supplier by using the Supplier Code filter at the top.

• Function: This module is informative and functions as a lookup tool for supplier data. There are no functions to add or edit suppliers from this page.

2. Workflow & Integrated Business Process

• Module Nature: This module is a read-only module for supplier data.

• Usage: Use this screen as a quick way to look up a supplier's code, official name, or address.

• Advanced Settings: Settings for specific items or prices from each supplier are most likely done in other, more specific modules, such as the "Supplier Master" in the Purchasing module.

Tips & Important Notes

• Just like the previous module, do not be confused by the name. The main focus of this module is to display a Supplier List, not a list of items per supplier.

• Consider this module as a contact directory for all of your suppliers.

Release Item Reserved

Module Guide: Un-release Reserved Stock

Module Location

Inventory > Item/Service > Un-release Reserved Stock

Module Objective

The Un-release Reserved Stock module is used to cancel the allocation or reservation of stock that was previously reserved for a Sales Order. This module is used to "release" the goods back into the available stock so they can be sold to another customer, typically after a customer cancels or changes their order.

1. Main View (Sales Order List)

The main page of this module displays a list of all Sales Orders that likely have stock currently being reserved.

View and Usage Explanation

• Filter: Use the DocType filter to select the document type, in this case, Sales Order.

• Order List: The system displays a list of all relevant Sales Orders.

• How to Use: Find the Sales Order number whose reservation is to be canceled, then click on that row to open its details.

2. Steps to Un-release Reserved Stock

Step 1: Open the Order Details

After selecting a Sales Order from the list, you will see a detail page that breaks down the ordered items.

Step 2: Enter the Quantity to be Un-released (Important!)

In the detail table, pay attention to the Order Quantity column (the quantity ordered/reserved) and the Quantity to be Un-released input column. Enter the quantity of goods you wish to return to the available stock in this column. You can un-release a partial amount or the entire quantity.

Step 3: Perform the Un-release

Click the [Un-release] button at the bottom of the page. After processing, the stock you have un-released will now return to being available stock in the warehouse.

Tips & Important Notes

• This module is the reverse of the stock allocation or reservation process that usually occurs when a Sales Order is created.

• Use this module only if you are certain a customer's order has been canceled or changed, as this action will make the stock that was held for one customer available for another order.

• This is an important functional module for the Sales Administration and Warehouse Logistics teams.

Item/Service Ordering

Module Guide: Item/Service Ordering (Internal Stock Requisition)

Module Location

Inventory > Item/Service > Item/Service Ordering

Module Objective

The Item/Service Ordering module serves as a tool to create an internal request for goods from the warehouse or to reserve stock for a specific need. This module is not for ordering goods from external suppliers, but rather for internal requests between departments or for project purposes.

1. Main View (Ordering Form)

When you open this module, you are immediately presented with a form to create a new item request.

• Initial View: This form is your worksheet. Ordered By and Order Date are usually filled in automatically.

• Main Action: To start selecting items, use the [+ Add Item/Service] link.

2. Steps to Create an Item Request

Step 1: Add Items to the Request List

Click the [+ Add Item/Service] link. An item search window will appear for you to select items from the master list.

Step 2: Find and Select Items

1. In the search window, use the filters to find the items you need (for example, by Item/Service Category Type).

2. Check the box on the left for one or more items you wish to request.

3. Click the [Select] button in the bottom-left corner of the search window.

Step 3: Specify the Quantity

The items you selected will now be in the table on the main form. Now, enter the quantity you need in the Order Quantity column.

Step 4: Submit the Request

After all items and their quantities are correct, click the [Order] button at the bottom to save and submit your request.

Workflow & Integrated Business Process

• A request created here will most likely become the basis for the warehouse team to prepare and issue the goods (Goods Issue).

• The [Order] action may automatically reduce the available stock by reserving the quantity you have requested, making it unavailable to be sold to other customers.

Tips & Important Notes

• Be sure to distinguish this module from Purchase Order (for suppliers) or Sales Order (for customers). This module is specifically for internal needs.

• This module is very useful for departments that need items from a central warehouse (for example, the marketing team needing product samples, or the production team needing additional raw materials).

Ordering By Document

Module Guide: Ordering by Document (Stock Allocation)

Module Location

Inventory > Item/Service > Ordering by Document

Module Objective

The Ordering by Document module is used to perform stock allocation or reservation from available warehouse stock to fulfill the needs of an existing source document, specifically a Sales Order. This is a critical step in the order fulfillment process to ensure that goods ordered by a customer are truly "locked in" and ready for shipment

1. Main View (Document List)

The main page of this module displays a list of source documents (e.g., Sales Orders) whose items you can allocate from stock.

View and Usage Explanation

• Filter: Use the Document Type filter to select the type of document, generally Sales Order.

• Document List: The system displays a list of all relevant Sales Orders.

• How to Use: Find the document (Sales Order) you want to fulfill, then click on that row to open its item details.

2. Steps to Allocate Stock

Step 1: Open the Document Details

After selecting a document from the list, you will see a detail page that breaks down the items within that order.

Step 2: Analyze Need vs. Availability

Pay attention to the following columns to make an allocation decision:

• Remaining Quantity: The quantity that is still needed by this sales order.

• Available Quantity: The free stock quantity that is currently in the warehouse.

Step 3: Enter the Quantity to be Ordered/Allocated (Important!)

In the Order Quantity input column on the far right, enter the quantity you want to allocate from the available stock for this order. You cannot enter a quantity larger than the Available Quantity.

Step 4: Perform the Ordering/Allocation

Click the [Order] button at the bottom of the page. This action will officially reserve that stock for this Sales Order, reducing it from the free stock.

Workflow & Integrated Business Process

• This module is the key step between the Sales Order and the Delivery Order.

• After the stock has been successfully allocated here, the warehouse team can proceed with the shipping process because the goods have been confirmed as available and are tied to a specific order.

Tips & Important Notes

• Use this module to systematically manage customer order fulfillment, especially if stock is limited and you need to prioritize which orders to fulfill first.

• The "Order" action will reduce the Available Quantity in the warehouse.

Stock Take

Module Guide: Stocktake (Physical Stock Count)

Module Location

Inventory > Inventory Adjustment > Stocktake

Module Objective

The Stocktake module is a transactional module used to create an official inventory adjustment document based on the results of a physical count. After you have identified stock discrepancies using the Stock Count Sheet module, you use this module to execute that adjustment so that the stock quantity in the system once again matches the physical quantity in the warehouse.

1. Main View (Stocktake Document List)

The main page of this module displays a list of all Stocktake documents that have been created.

View Explanation

This page is for viewing the history of stocktake adjustment documents and for starting a new process.

• Document List: The table will display all adjustment documents that have ever been created, along with their status.

Button Functions

• [New]: The primary button to start the process of creating a new Stocktake document.

2. Steps to Perform a Stocktake Adjustment

Step 1: Preparation

Before using this module, ensure you have completed the physical count and have the discrepancy data from the Stock Count Sheet module.

Step 2: Create a New Document

From the main page, click the [New] button.

Step 3: Specify the Location

On the New form that appears, select the Bin Code (warehouse location) where the stocktake was performed, then click [Save].

Step 4: Detail the Adjustments (Conceptual)

After you save the location, the system will open a detail page (not shown). On that page, you will:

• Add the items that have a discrepancy.

• Enter the adjustment quantity (for example, -5 if there is a shortage of 5, or +2 if there is a surplus of 2).

Step 5: Confirm the Adjustment (Conceptual)

After all items with discrepancies have been entered, you will confirm the document.

3. Process Results

After the Stocktake document is confirmed:

1. The system will automatically update the Quantity on Hand in the warehouse to match the physical count results.

2. The system will create a journal entry to record the value of the inventory adjustment (for example, to a Stock Discrepancy Expense account).

Tips & Important Notes

• This module is the execution step after the counting process in the Stock Count Sheet module.

• This is a module with a direct financial impact because it changes the inventory value on the balance sheet and usually requires authorization from a managerial level.

• This process is crucial for maintaining the accuracy of inventory data.

Stocktake inbox

Module Guide: Stocktake Inbox

Module Location

Inventory > Inventory Adjustment > Stocktake Inbox

Module Objective

The Stocktake Inbox module serves as the approval center for all Stocktake adjustment documents that have been submitted. This is a crucial internal control step where managers from relevant departments (e.g., Warehouse and Accounting) must review and approve the physical count results before the system permanently changes the inventory quantity and value data.

1. Main View (Document List)

The main page of this module displays a list of all Stocktake documents awaiting your approval or that have already been processed.

• View: This page displays a list of Stocktake documents, complete with Document Number, Date, and the current Approval Status.

• Usage: Find and click the Document Number that you want to review.

2. Approval Process Steps

Step 1: Access and Open the Document

Open the Inbox module, then click on the Document Number you wish to review to open its detail page.

Step 2: Review the Stocktake Results

On the detail page, check the table to perform verification. Compare the system stock quantity (Qty Stock) with the physical count quantity (Qty SO) and note the figure in the Difference column. In the example above, there is no difference.

Step 3: Provide Approval

1. At the bottom of the page, find the row with your name in the "Manager / Superior concerned" section.

2. Change the Status to "Accepted" or "Approved".

3. You can provide a note or reason for the approval in the Reason column.

4. Click the save button to record your approval.

Workflow & Integrated Business Process

1. A Stocktake document is created in the Stocktake module to record the count results.

2. The document then enters this Inbox for validation.

3. After all authorized parties have approved (for example, the Head of Production/Warehouse and the Head of Accounting), the system will finally:

   • Adjust the stock quantity in the system.

   • Post the accounting journal to record the value of the stock difference (if any).

Tips & Important Notes

• Multi-level approval ensures that the stock adjustment is valid both physically (by the warehouse/production party) and financially (by the accounting party).

• This is a crucial internal control step to prevent unauthorized stock adjustments and to maintain the integrity of inventory data.

Item/Service Price

Module Guide: Item/Service Price (Item Price Management)

Module Location

Inventory > Item/Service > Item/Service Price

Module Objective

The Item/Service Price module functions as a control center for managing and updating the selling prices of all items. This module provides an efficient way to make price changes in bulk on a single screen, and also provides an audit log to track all price change history.

1. Main View (Price List)

The main page of this module is an interactive list that displays all items along with their cost price and selling price.

View and Key Feature Explanation

• View: This page displays a list of all items with columns such as Item/Service Code, Item/Service Name, COGM (Cost of Goods Manufactured), and Price (Selling Price).

• Key Feature: The Price column contains an input box, allowing you to change the selling price of each item directly on this page.

2. Steps to Update Item Prices

1. Find the Item: Use the filters at the top to search for the specific item whose price will be changed, or scroll directly through the list.

2. Change the Price: Type the new selling price directly into the box in the Price column for each relevant item.

3. Save Changes: After you have finished changing all the necessary prices, click the [Save] button in the bottom-left corner. The new price will become active immediately and will be used for all subsequent sales transactions.

3. Price Change Log (Log Update Price)

Every price change you save will be automatically recorded in a history log for audit purposes.

This log displays:

• Which item's price was changed.

• The new price that was set.

• Who changed it (Changed By).

• When the change was made (Last Change).

Tips & Important Notes

• This is a very powerful tool. Ensure you have sufficient authorization before changing prices, as it will have a direct impact on all new sales transactions.

• Use the COGM column as a reference when determining a new selling price to ensure a healthy profit margin.

• This is a crucial module for the Sales, Marketing, and Product Management teams.

Stocktake Setting

Module Guide: Stocktake Setting

Module Location

Part of the Inventory > Inventory Adjustment > Stocktake workflow

Module Objective

The Stocktake Setting screen is a crucial preparatory step in the stocktake process. Its purpose is to define the scope of the count by selecting the specific items to be included in one physical counting session. This allows for a partial stocktake (cycle count) or a more organized full stocktake.

1. Main View (Item Selection)

After you start creating a new Stocktake document from the Stocktake module, you will be directed to this page to select which items will be counted.

View Explanation

• Filters: Use the filters at the top to search for and display relevant items, for example, by Item/Service Category Type (e.g., RAW MATERIALS).

• Item List: The system will display all items that match the filters. Your task is to select items from this list.

2. Steps to Set the Stocktake Scope

This process is a continuation of the creation of a Stocktake document.

1. Start from the Stocktake Module: Open the Stocktake module and click the [New] button. You will likely be asked to select a location/Bin first.

2. Filter Items: After that, you will be taken to the Stocktake Setting screen. Use the filters to display the items you want to count.

3. Select Items: Check the box on the left for each item that you will include in this stocktake session.

4. Save Selection: After all desired items are selected, click the [Save] button in the bottom-left corner.

Workflow & Integrated Business Process

• This step is the bridge between the creation of the Stocktake document and the actual physical counting process.

• After you save the item selection here, the system will generate a formal count sheet (similar to the Stock Count Sheet module) that contains only the items you have selected.

• The next step is to use that count sheet to enter the physical count results, which will then be processed for a stock adjustment.

Tips & Important Notes

• By selecting items beforehand, the stocktake process becomes more focused and organized, especially in a warehouse with thousands of items.

• This feature is very useful for performing cycle counting, where you only count a small portion of items (for example, fast-moving items) on a routine basis, without having to count the entire warehouse.

COGM Card

Module Guide: COGM Card (Cost of Goods Manufactured Card)

Module Location

Inventory > Item/Service > COGM Card

Module Objective

The COGM Card module is a cost accounting tool used to calculate and set the Cost of Goods Manufactured (COGM) for each finished good. In this module, all cost components—from raw materials and labor to factory overhead—are gathered to determine a product's standard cost.

1. Main View (COGM Card List)

The main page of this module displays a list of all the COGM Card calculation documents that have been previously created.

View Explanation

• View: This page is a history of processed COGM documents. You can see the document's Group Code, Date, and Approval Status.

• Filters: You can search for a COGM document by a Date period or Item/Service Category (e.g., FINISHED GOODS).

Button Functions

• [New]: The primary button to start a new COGM calculation process.

2. Steps to Create/Import a COGM Card

Step 1: Create a New Document

From the Main View, click the [New] button to open the COGM Card Input form.

Step 2: Fill in Header Information

Define the Period for the COGM calculation you are about to perform.

Step 3: Input Cost Data

You have two ways to enter the cost details per product:

a) Import from Excel (Fast and Recommended):

1. Click the Download Excel Format link to download the template.

2. Fill the Excel file with the details of the Item/Service Code along with all its cost components.

3. Upload the filled file back via the Choose File button.

4. Click the [Import] button to load the data into the table.

b) Manual Input:

1. Click the [+] icon in the Item/Service List table.

2. Select the Item/Service Code.

3. Manually fill in all relevant cost component columns, such as:

   • Material Usage: Raw Material (RM) and Packaging Material (PM) costs.

   • DVL: Direct Labor Cost.

   • FOH: All Factory Overhead costs like Electricity, Gas, Depreciation, etc.

Step 4: Confirm the Calculation

After all data is filled in and validated, click the [Confirm] button. This action will update the COGM or Standard Cost value for these items in the system, which will then be used for inventory valuation and the calculation of Cost of Goods Sold.

Tips & Important Notes

• This is a very important and specific tool for a Cost Accountant.

• The accuracy of the COGM calculated here will have a direct impact on the inventory value on the Balance Sheet and the Cost of Goods Sold on the Income Statement.

• The import from Excel feature is very helpful for speeding up the process, especially if the COGM for dozens or hundreds of products needs to be updated periodically.

COGM Card Inbox

Module Guide: COGM Card Inbox

Module Location

Inventory > Item/Service > COGM Card Inbox

Module Objective

The COGM Card Inbox module serves as the approval center for all COGM Card documents (Cost of Goods Manufactured calculations) that have been submitted. This is a crucial control step where a manager (e.g., a Cost Accounting Manager or Controller) must review and approve the new standard cost calculation before that value is officially applied in the system.

1. Main View (COGM Document List)

The main page of this module is an "inbox" that displays all COGM calculation documents requiring your action.

View Explanation

This page provides a summary of all COGM calculations that are awaiting approval.

• Filters: You can search for a specific document by HPPCode, a Date range, or Item/Service Category.

• Document List: The table below will display all documents awaiting action, with columns such as HPPCode, Date, and Approval.

2. Approval Process Steps

The following is the standard workflow for an approver.

Step 1: Access the Inbox

Open the COGM Card Inbox module to see the list of COGM calculations that require approval.

Step 2: Review the COGM Calculation Details

Click on one of the rows in the table to open its detail view. In the detail view, you can check all the details of the cost components (raw materials, labor, FOH) that have been input or imported to ensure their accuracy.

Step 3: Provide Approval

After you review the calculation details in Step 2, you will find a button to grant approval (e.g., an "Approve" button) within that detail page. Click the appropriate button to complete the review process.

Workflow & Integrated Business Process

1. A COGM Card document is created and confirmed by a cost accountant.

2. The document automatically enters the queue in this Inbox.

3. A manager reviews and approves it.

4. After approval, the COGM/standard cost value in the Item/Service List will be finally updated and used for all subsequent transactions.

Tips & Important Notes

• The approval here is a very important final step. After approval, the inventory value and the cost of goods sold will use the new calculation basis.

• This is a crucial control module for the Cost Accounting Manager or Controller to ensure the accuracy of product cost data.

COGM Report

Report Module Guide: COGM Report

Module Location

Inventory > Item/Service > COGM Card > Report

Module Objective

The COGM Report module is used to generate a report that displays the current Cost of Goods Manufactured (COGM) for all items. This report is a recapitulation of the calculation results that have been created and approved in the COGM Card module, and it is used to see the list of standard product costs.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Show Item:

  • Select All to display all items, or Last Update to display items whose COGM was recently updated.

• As of Date:

  • Specify the reference date ("as of" date) for the COGM data to be displayed.

• Detail:

  • Select Summary for a concise report, or Detail to display a breakdown of the cost components.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, such as the date and the report's level of detail.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the COGM report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a list of items along with their cost of goods manufactured.

• View: This report displays the Item Code, Item Name, Price (Cost), and Update By information (who updated it and when).

• Additional Features: This report is interactive, allowing you to copy, download in CSV or Excel format, or print directly using the buttons in the top-left corner.

Tips & Important Notes

• This report is a quick way to see the standard cost (COGM) of all your products.

• Use this report for profitability analysis by comparing the COGM here with the selling price in the Item/Service Price module.

• This report is a recapitulation of the data that is final and approved in the COGM Card workflow.

Raw Material Usage Report

Report Module Guide: Raw Material Usage Report (BOM Variance Report)

Module Location

Inventory > Reports > Raw Material Usage Report

Module Objective

The Raw Material Usage Report is a crucial production and cost analysis tool. Its purpose is to compare the standard quantity of raw materials (according to the recipe or Bill of Materials - BOM) that should have been used to produce a finished good, with the actual quantity of raw materials that were really consumed during the production process. This report is used to measure efficiency and identify potential waste.

1. Report Parameters (Conceptual)

To generate an analysis report like this, you typically need to define filters such as:

• Finished Good: Select the final product whose raw material usage you want to analyze.

• Production Order: Select a specific batch number or work order for a more focused analysis.

• Production Period: Specify the production date range.

2. Reading the Report (Based on a Template)

The generated report will detail the usage comparison for each raw material for the finished good you are analyzing.

Key Column Explanation

• Item/Service Code: The code for the Raw Material or Packaging Material.

• Standard Qty: The quantity of raw material that should have been used according to the standard recipe/BOM to produce a certain amount of finished goods.

• Actual Qty: The quantity of raw material that was actually withdrawn from the warehouse and used during the production process.

How to Analyze the Report

The main focus of this report is the comparison between the Standard Qty and Actual Qty columns.

• If Actual Qty > Standard Qty, this indicates an inefficiency or waste (negative variance).

• If Actual Qty < Standard Qty, this indicates an efficiency (positive variance).

Tips & Important Notes

• This report is a key analysis tool for Production Managers and Cost Accountants.

• Use the variance found in this report to investigate problems on the production floor, such as material spills, raw material quality issues, or operator errors.

• The Actual Qty data is pulled from the goods issue transactions to production, while the Standard Qty data is pulled from the Bill of Materials (BOM) master data.

Minimum Stock Setup

Module Guide: Minimum Stock Setup

Module Location

Inventory > Minimum Stock Setup

Module Objective

The Minimum Stock Setup module is a control center for inventory management. Its purpose is to set two crucial parameters for each item:

1. Minimum Stock (Reorder Point): The lowest stock quantity limit. If the stock in the warehouse reaches this number, the system will signal that a reorder needs to be placed.

2. Reorder Quantity: The standard quantity that should be ordered when the stock reaches the minimum point.

This setup is the basis for preventing stockouts and automating the procurement process.

1. Main View (Item Setup List)

The main page of this module displays a list of all inventory items along with their current Minimum Stock and Reorder Quantity settings.

• View: This page provides a general overview of the settings for all items. You can filter by Item/Service Category Type (e.g., RAW MATERIAL).

• Action Button:

  • [Shortcut]: The main button used to open the bulk setup screen, allowing you to change the settings for many items at once.

2. Steps to Set Minimum Stock (via Shortcut)

Step 1: Open the Setup Screen

From the main page, click the [Shortcut] button to open the Specify Raw Material Stock screen.

Step 2: Select Items to be Set

1. Use the Category filter to simplify the search.

2. In the Item/Service Name list box, select one or more items to be set up. You can hold down the Ctrl key (to select one by one) or the Shift key (to select a range) on your keyboard to select multiple items.

Step 3: Enter Minimum and Reorder Values

1. Fill in the Minimum Stock field with the lowest allowed stock number.

2. Fill in the Reorder Quantity field with the standard quantity that will be ordered.

Step 4: Save the Settings

Click the [Change] button to apply these settings to all the items you have selected.

Workflow & Integrated Business Process

The data you set up here will be used by the system to generate "items to be reordered" reports or even to automatically create a draft Purchase Requisition when the stock reaches the minimum level.

Tips & Important Notes

• This setup is the heart of proactive, not reactive, inventory management.

• Review and update these values periodically (for example, every quarter) to adjust to changes in demand patterns and supplier lead times.

• This is a crucial module for the PPIC (Production Planning and Inventory Control) and Purchasing teams.

Inventory Adjustment by Value

Module Guide: Inventory Adjustment by Value

Module Location

Inventory > Inventory Adjustment by Value

Module Objective

The Inventory Adjustment by Value module is used to create an adjustment document that changes the value (cost) of an inventory item, without changing its physical quantity. It is used for specific accounting cases such as stock revaluation, cost correction, or expensing an item (for example, for samples or internal use).

1. Main View (Adjustment List)

The main page of this module displays a list of all value adjustment documents that have been created.

View Explanation

• View: This page is a history of value adjustment documents. You can see the Doc. Number, Warehouse Location, and Adjustment Status.

• Filters: You can search for a document by Doc. Number or a Date range.

Button Functions

• [New]: The primary button to create a new value adjustment document.

2. Steps to Create a Value Adjustment

Step 1: Create a New Document

From the Main View, click the [New] button to open the Add Adjustment form.

Step 2: Fill in General Information

On the form that appears, fill in basic information such as the document Date and a Memo to explain the reason for the adjustment.

Step 3: Select Item and Define the Adjustment

1. In the + Item/Service List table, click the [+] icon to add a row.

2. Select the Item/Service Code whose value will be adjusted.

3. Enter the Qty (quantity) of the item that is affected.

4. In the Price / Unit or Total Price column, enter the adjustment value. You can increase or decrease the inventory value. For example, if you want to write-off the value of 1 item, you would enter a negative adjustment equal to that item's value.

Step 4: Confirm the Adjustment

After all items and adjustment values have been entered correctly, click the [Confirm] button to process the transaction.

Workflow & Integrated Business Process

• Accounting Impact: Confirming this adjustment will automatically create a journal entry. For example, to write off an item to expense, the journal would be a Debit to Damaged Goods Expense (or a similar account) and a Credit to Inventory.

• Main Difference: Unlike a Stocktake which adjusts quantity, this module adjusts the value (in currency) of the inventory.

Tips & Important Notes

• Use this module to record events such as:

  • Damaged goods whose value must be written off.

  • Usage of goods for sample or promotional purposes.

  • Correction of a purchase price recording error.

• This is an accounting module that has a direct financial impact and must be used by authorized personnel, such as an Inventory Accountant.

Inventory Adjustment by Value Inbox

Module Guide: Inventory Adjustment by Value Inbox

Module Location

Inventory > Inventory Adjustment by Value > Inventory Adjustment by Value Inbox

Module Objective

The Inventory Adjustment by Value Inbox module serves as the approval center for all Inventory Adjustment by Value documents. This is a crucial financial control step, where a manager must review and provide authorization before an adjustment to the inventory's value is officially posted to the General Ledger.

1. Main View (Document List)

The main page of this module is an "inbox" that displays all value adjustment documents requiring your action.

View Explanation

This page provides a summary of all value adjustments that are awaiting approval.

• Filters: You can search for a specific document by Doc. Number or a date range (Start Date / End Date).

• Document List: The table below will display all documents awaiting action, with columns such as Doc. Number, Inventory Value Adjustment Status, and Approval.

2. Approval Process Steps

The following is the standard workflow for an approver.

Step 1: Access the Inbox

Open the Inventory Adjustment by Value Inbox module to see the list of transactions that require approval.

Step 2: Review the Adjustment Details

Click on one of the rows in the table to open the detail view of the adjustment document. In the detail page, you can check which item's value is being adjusted, the amount of the adjustment, and the reason for the adjustment stated in the memo.

Step 3: Provide Approval

After you review the adjustment details in Step 2, you will find a button to grant approval (e.g., an "Approve" button) within that detail page. Click the appropriate button to complete the review process.

Workflow & Integrated Business Process

1. A value adjustment document is created and confirmed by an accounting staff.

2. The document automatically enters the queue in this Inbox.

3. A manager reviews and approves it.

4. After approval, the accounting journal to adjust the inventory value (for example, to expense damaged goods) will be finally posted.

Tips & Important Notes

• The approval here is a crucial control step because this transaction has a direct impact on the Income Statement (through the expensing of costs) and the Balance Sheet (through the reduction of inventory value).

• This module is typically accessed and used by a Controller or Accounting Manager.

Inventory Adjustment

Module Guide: Inventory Adjustment

Module Location

Inventory > Inventory Adjustment

Module Objective

The Inventory Adjustment module is a general transactional module used to create adjustments to stock quantities. Unlike the more structured Stocktake module for physical counts, this module is often used for ad-hoc adjustments or quick corrections, both for increasing and decreasing stock, for various reasons (e.g., correcting input errors, found items, etc.).

1. Main View (Adjustment List)

The main page of this module displays a list of all Inventory Adjustment documents that have been created.

View Explanation

• View: This page is a history of adjustment documents. You can see the Doc. Number, Adjustment Date, and Document Status.

• Filters: You can search for a document by Doc. Number or a Date range.

Button Functions

• [New]: The primary button to create a new inventory adjustment document.

2. Steps to Create an Inventory Adjustment

Step 1: Create a New Document

From the Main View, click the [New] button to open the Create Adjustment form.

Step 2: Fill in General Information

On the form that appears, fill in the basic information:

• Warehouse: Select the warehouse location where the adjustment is being made.

• Date: Enter the effective date of the adjustment.

• Memo: Important! Provide a clear explanation for the reason for the adjustment.

• Method: Choose the input method, whether Manual or using a Barcode.

Step 3: Detail the Adjustment Items

1. In the table below, click the [+] icon to add a row.

2. Select the Item/Service Code whose stock will be adjusted.

3. In the Quantity column, enter the adjustment quantity.

   • Use a positive number (+) to increase stock.

   • Use a negative number (-) to decrease stock.

Step 4: Confirm the Adjustment

After all items and adjustment quantities have been entered correctly, click the [Confirm] button to process the transaction.

Workflow & Integrated Business Process

• Impact: Confirming this adjustment will directly change the Quantity on Hand in the system and create the corresponding journal entry.

• Approval: A document that has been confirmed will most likely go to an Inbox to be validated by a manager before the stock and journal changes are final.

Tips & Important Notes

• This module is very useful for quick corrections or adjustments that do not originate from a formal stocktake process.

• Always fill in the Memo with a detailed reason to maintain a good audit trail.

• Because it has a direct impact on stock and inventory value, the use of this module usually requires authorization.

Inventory Adjustment Inbox

Module Guide: Inventory Adjustment Inbox

Module Location

Inventory > Inventory Adjustment > Inventory Adjustment Inbox

Module Objective

The Inventory Adjustment Inbox module serves as the approval center for all Inventory Adjustment documents that have been submitted. This module is the final control step where a manager must review and provide authorization before an adjustment to the stock quantity is officially posted and affects the inventory records.

1. Main View (Adjustment Document List)

The main page of this module is an "inbox" that displays all adjustment documents requiring your action.

View Explanation

This page provides a summary of all adjustments that are awaiting approval.

• Filters: You can search for a specific document by Doc. Number or a date range (Start Date / End Date).

• Document List: The table below will display all documents awaiting action, with columns such as Doc. Number, Document Type (e.g., Inventory Adjustment), Adjustment Date, and Approval.

2. Approval Process Steps

The following is the standard workflow for an approver.

Step 1: Access the Inbox

Open the Inventory Adjustment Inbox module to see the list of transactions that require approval.

Step 2: Review the Adjustment Details

Click on one of the rows in the table to open the detail view of the adjustment document. In the detail page, you can check which item is being adjusted, the size of the adjustment quantity (whether it is an addition or a reduction), and the reason for the adjustment stated in the memo.

Step 3: Provide Approval

After you review the adjustment details in Step 2, you will find a button to grant approval (e.g., an "Approve" button) within that detail page. Click the appropriate button to complete the review process.

Workflow & Integrated Business Process

1. An Inventory Adjustment document is created and confirmed.

2. The document automatically enters the queue in this Inbox.

3. A manager reviews and approves it.

4. After approval, the system will finally update the stock quantity (Quantity on Hand) and post the relevant accounting journal entry.

Tips & Important Notes

• This approval process is a crucial control step to prevent unauthorized or unfounded stock changes.

• Always be sure to check the Memo and any attached documents (Attachment) to understand the context and validity of each adjustment.

• This module is typically accessed by a Warehouse Manager, Accounting Manager, or Controller.

Inventory Transformation

Module Guide: Inventory Transformation

Module Location

Inventory > Inventory Adjustment > Inventory Transformation

Module Objective

The Inventory Transformation module is a transactional tool used to record the process of transforming or converting one or more inventory items (input) into another inventory item (output). This module is very useful for recording activities such as:

• Rework: Reprocessing products that did not pass QC into usable materials again.

• Repacking: Changing packaging, for example, from bulk packaging to smaller packaging.

• Kitting/Assembly: Combining several components into a single new package item (SKU).

1. Main View (Transformation List)

The main page of this module displays a list of all inventory transformation transaction documents that have been created.

View and Key Button Functions

• View: This page is a history of transformation documents. You can see the Doc. Number, Date, Memo (which explains the type of transformation), and Approval Status.

• Action Buttons:

  • [New]: To create a new transformation transaction manually from scratch.

  • [New From Formula]: To create a transformation transaction based on a pre-defined recipe or formula.

  • [Void]: To cancel a transformation transaction that has already been created.

2. Steps to Perform an Inventory Transformation

Step 1: Create a New Document

From the main page, click [New] to open the Inventory Transformation form.

Step 2: Fill in Details

1. Select the source Warehouse and Source Bin as well as the Destination Bin.

2. Fill in the Memo with a clear description of the process being performed.

3. Items to be Converted (Input): In the top table, click [+], then select the item(s) and enter the quantity that will be consumed or transformed.

4. Resulting Items from Conversion (Output): In the bottom table, click [+], then select the item(s) and enter the quantity that will be produced from this process.

5. Click [Confirm] to submit the transaction.

3. Process Results

After the transformation transaction is confirmed and approved, the system will automatically perform two stock movements:

1. Goods Issue: Reduces the stock quantity of the INPUT items.

2. Goods Receipt: Increases the stock quantity for the OUTPUT item.

Tips & Important Notes

• This module is very useful for the Production and Warehouse teams to record simple transformation processes that occur outside of the formal production workflow.

• Using the [New From Formula] feature is highly recommended to maintain the consistency and accuracy of the input-output ratio in every transformation process.

Inventory Transformation Inbox

Module Guide: Inventory Transformation Inbox

Module Location

Inventory > Inventory Adjustment > Inventory Transformation Inbox

Module Objective

The Inventory Transformation Inbox module serves as the approval center for all Inventory Transformation transactions that have been submitted. Every transformation process (such as rework or kitting) must be reviewed and approved here by an authorized manager before the stock movements (reducing input and increasing output) are officially recorded in the system.

1. Main View (Document List)

The main page of this module is an "inbox" that displays all inventory transformation documents requiring your action.

View Explanation

This page provides a summary of all transformation transactions that are awaiting approval.

• Filters: You can search for a specific document by Doc. Number or a date range (Start Date / End Date).

• Document List: The table below will display all documents awaiting action, with columns such as Doc. Number, Request Date, Document Status, and Approval.

2. Approval Process Steps

The following is the standard workflow for an approver.

Step 1: Access the Inbox

Open the Inventory Transformation Inbox module to see the list of transactions that require approval.

Step 2: Review the Transaction Details

Click on one of the rows in the table to open the detail view of the transformation transaction. In the detail page, you can check all the information, such as the input items used, the output items produced, as well as their quantities and costs.

Step 3: Provide Approval

After you review the transaction details in Step 2, you will find a button to grant approval (e.g., an "Approve" button) within that detail page. Click the appropriate button to complete the review process.

Workflow & Integrated Business Process

1. An Inventory Transformation document is created and confirmed.

2. The document automatically enters the queue in this Inbox.

3. A manager reviews and approves it.

4. After approval, the system will finally process the stock movements: reducing the input stock and increasing the output stock.

Tips & Important Notes

• This approval process is an important control step to ensure all inventory transformation processes are valid and recorded correctly.

• This module is typically accessed by a Warehouse Manager or Production Manager.

Transformation Matrix

Module Guide: Inventory Transformation Matrix (Formula)

Module Location

Inventory > Inventory Transformation > Transformation Matrix

Module Objective

The Inventory Transformation Matrix module serves as the master data hub for creating and managing the "recipes" or "formulas" used in the Inventory Transformation module. Each "matrix" created here defines the input items, output items, and their quantity ratios for a specific transformation process (e.g., rework or kitting).

1. Main View (Matrix List)

The main page of this module displays a list of all transformation matrices, recipes, or formulas that have been defined in the system.

View Explanation

• View: This page is a list of all existing formulas. You can see the Package ID (Matrix Code), Package Name (Matrix Name), and who created it.

• Action Buttons:

  • [New]: The primary button to create a new transformation formula or matrix.

  • [Change Status]: To activate or deactivate a selected formula.

2. Steps to Create a New Matrix

Step 1: Create a New Matrix

From the main page, click the [New] button. You will be directed to the Add Package form.

Step 2: Name the Matrix (Conceptual)

1. On the Add Package form, provide a unique Package Code and Package Name for your formula (e.g., "REWORK-CHOCOLATE-TO-FLOUR").

2. After saving, you will go to a detail screen (not shown) to specify:

   • Input Items: Select the items to be consumed along with their standard quantities.

   • Output Items: Select the resulting transformation items along with their standard produced quantities.

Workflow & Integrated Business Process

• This module is a preparatory and standardization step. The formula you create here will become a selection option when you use the [New From Formula] feature in the Inventory Transformation module.

• By using a pre-defined matrix, the process of recording a transformation becomes much faster, more accurate, and more consistent because the input-output ratio is already determined.

Tips & Important Notes

• Create a matrix for every standard transformation process that is frequently performed in your company.

• This is a crucial module for the PPIC and Production teams to standardize rework, kitting, or repacking processes.

Item/Service Price

Module Guide: Item/Service Price (Item Price Management)

Module Location

Inventory > Item/Service Price

Module Objective

The Item/Service Price module functions as a control center for managing and updating the selling prices of all items. This module provides an efficient way to make price changes in bulk on a single screen, as well as providing an audit trail to track all price change history.

1. Main View (Price List)

The main page of this module is an interactive list that displays all items along with their cost price and selling price.

View and Key Feature Explanation

• View: This page displays a list of all items with columns such as Item/Service Code, Item/Service Name, COGM (Cost), and Price (Selling Price).

• Key Feature: The Price column contains an input box, allowing you to change the selling price of each item directly on this page.

2. Steps to Update Item Prices

1. Find the Item: Use the Item Name Code filter at the top to search for the specific item whose price will be changed.

2. Change the Price: Type the new selling price directly into the box in the Price column for each relevant item.

3. Save Changes: After you have finished changing all the necessary prices, click the [Save] button in the bottom-left corner. The new price will become active immediately and will be used for all subsequent sales transactions.

3. Change History (Audit Trail)

Every price change you save will be automatically recorded by the system. The Changed By and Last Change columns show who made the change and when it occurred, which is crucial for audit purposes.

Tips & Important Notes

• Ensure you have sufficient authorization before changing prices, as this action will have a direct impact on all new sales transactions.

• Use the COGM column as a reference when determining a new selling price to ensure a healthy profit margin.

• This is a crucial module for the Sales, Marketing, and Product Management teams.

Current Warehouse Usage

Module Guide: Current Warehouse Usage

Module Location

Inventory > Warehouse Management > Current Warehouse Usage

Module Objective

The Current Warehouse Usage module serves as a real-time inquiry tool for viewing the current condition of a storage location. This module allows users to check the list of items along with their quantities that are in a specific warehouse or bin, as well as to see metrics on the utilization of that warehouse's capacity.

1. Main View (Warehouse Selection)

The first page of this module displays a hierarchical structure of all the storage locations you have.

• View: This page displays a list of main warehouses, sub-warehouses (SUBWH), or subcontractor-owned locations (SUBCON).

• How to Use: Click on the name of the specific warehouse or location whose contents you want to see.

2. Detail View (Stock List by Location)

After selecting one of the locations, the system will display a detail page containing a list of all goods in that location.

Capacity Information

At the top of the page, you can see the warehouse capacity usage metrics, including:

• Maximum Capacity: The total storage space capacity.

• Current Usage: The space that has already been used by the existing goods.

Stock List

The table below displays a complete list of all items currently in that location along with their physical quantity (Qty).

Tips & Important Notes

• This module is read-only and presents inventory data in real-time.

• Use this module to perform a quick check on stock availability in a specific location without having to run a complex report.

• The capacity information is very useful for Warehouse Managers to plan space arrangement and optimize the utilization of the warehouse area.

Warehouse Costing

Module Guide: Warehouse Costing

Module Location

Inventory > Warehouse Management > Warehouse Costing

Module Objective

The Warehouse Costing module is used to record all costs related to warehouse operations. These costs can later be allocated as part of Factory Overhead or other operational costs. This module helps in tracking and managing expenditures that occur specifically in the warehouse area.

1. Main View (Warehouse Cost List)

The main page of this module displays a list of all warehouse cost recording documents that have been created.

View Explanation

• View: This page is a history of warehouse cost documents. You can see the Warehouse Cost Number, Date, Amount, and Approval Status.

• Filters: You can search for a specific document by Warehouse Cost Number or a Date range.

Button Functions

• [New]: The primary button to create a new warehouse cost recording document.

2. Steps to Record Warehouse Costs

Step 1: Create a New Document

From the Main View, click the [New] button to open the Add New form.

Step 2: Fill in Cost Details

On the form that appears, you will be asked to detail the costs:

1. Fill in the document Date.

2. Fixed Costs: In this table, add cost components that are fixed each period (e.g., warehouse rent, warehouse staff salaries).

3. Variable Costs: In this table, add cost components that are variable (e.g., electricity cost, water cost, forklift repair cost).

4. For each component, you will select the cost type, period, amount, and description.

Step 3: Confirm

After all cost components are entered, click the [Confirm] button to submit the cost recording document for approval.

Workflow & Integrated Business Process

• Accounting Impact: After this document is approved, the system will create a journal entry to record these costs (for example, a Debit to Warehouse Rent Expense and a Credit to Cash/Bank or Accrued Payable).

• Approval: A document that has been confirmed will most likely go to an Inbox to be validated by a Finance Manager or Controller.

Tips & Important Notes

• This module is an important tool for a Cost Accountant to gather and allocate overhead costs.

• Accurate recording here will help in a more precise Cost of Goods Manufactured (HPP/COGM) calculation.

Warehouse Costing Inbox

Module Guide: Warehouse Costing Inbox

Module Location

Inventory > Warehouse Management > Warehouse Costing > Warehouse Costing Inbox

Module Objective

The Warehouse Costing Inbox module serves as the approval center for all Warehouse Costing documents that have been submitted. Every recording of warehouse operational costs must be reviewed and approved here by an authorized manager before it is officially expensed and posted to the General Ledger.

1. Main View (Document List)

The main page of this module is an "inbox" that displays all warehouse cost documents requiring your action.

View Explanation

This page provides a summary of all cost documents that are awaiting approval.

• Filters: You can search for a specific document by Warehouse Cost Number or a date range (Start Date / End Date).

• Document List: The table below will display all documents awaiting action, with columns such as Warehouse Cost Number, Warehouse Costing Date, Amount, and Approval.

2. Approval Process Steps

The following is the standard workflow for an approver.

Step 1: Access the Inbox

Open the Warehouse Costing Inbox module to see the list of transactions that require approval.

Step 2: Review the Cost Details

Click on one of the rows in the table to open the detail view of the cost document. In the detail page, you can check all the details of the cost components (both fixed and variable) that have been input.

Step 3: Provide Approval

After you review the cost details in Step 2, you will find a button to grant approval (e.g., an "Approve" button) within that detail page. Click the appropriate button to complete the review process.

Workflow & Integrated Business Process

1. A Warehouse Costing document is created and confirmed.

2. The document automatically enters the queue in this Inbox.

3. A manager (e.g., a Finance Manager) reviews and approves it.

4. After approval, the system will finally post the accounting journal to record these costs.

Tips & Important Notes

• This approval process is an important control step to ensure all warehouse cost charges are valid and accurate.

• This module is typically accessed by an Accounting Manager, Controller, or Finance Manager.

Bin Transfer

Module Guide: Bin Transfer

Module Location

Inventory > Warehouse Management > Bin Transfer

Module Objective

The Bin Transfer module is a transactional module used to record the physical movement of goods from one storage location (Source Bin) to another storage location (Destination Bin) within a warehouse or between warehouses. This module is crucial for maintaining the accuracy of stock location data in the system so that it matches the physical location of the goods.

1. Main View (Transfer List)

The main page of this module displays a list of all bin transfer transaction documents that have been created.

View Explanation

• View: This page is a history of all goods movement activities. You can see the Doc. Number, Transfer Date, Source Bin Code, and Destination Bin Code for each transaction.

• Filters: You can search for a specific transfer document by Doc. Number or a date range.

Button Functions

• [New]: The primary button to create a new bin transfer document.

2. Steps to Perform a Bin Transfer

Step 1: Create a New Document

From the Main View, click the [New] button to open the New Document form.

Step 2: Fill in General Information

On the form that appears, fill in the basic information:

• Transfer Date: Enter the date the physical transfer was performed.

• Method: Choose the input method, whether Manual or using a Barcode to scan the goods.

Step 3: Detail the Items Being Moved

1. In the table below, click the [+ Add Item] link to add a row.

2. Select the Item/Service Code to be moved.

3. Specify the Source Bin and the Destination Bin.

4. Enter the Transfer Quantity of the goods being moved.

Step 4: Confirm the Transfer

After all the moved items have been entered, click the [Confirm] button to process the transaction.

Workflow & Integrated Business Process

• Impact: After the transfer document is confirmed and approved, the system will automatically update the stock quantity records in both locations:

  • Stock in the Source Bin will decrease.

  • Stock in the Destination Bin will increase.

• Approval: A document that has been confirmed will likely go to an Inbox to be validated by the Warehouse Head before the stock change becomes final.

Tips & Important Notes

• This module is crucial for maintaining the accuracy of stock location data. Always create a transfer document every time there is a physical movement of goods between racks, between areas, or between warehouses.

• Using the Barcode method can speed up and reduce input errors when processing large quantities of item transfers.

• This is a daily work module for the Logistics and Warehouse teams.

Bin Transfer Inbox

Module Guide: Bin Transfer Inbox

Module Location

Inventory > Warehouse Management > Bin Transfer > Bin Transfer Inbox

Module Objective

The Bin Transfer Inbox module serves as the approval center for all Bin Transfer documents that have been submitted. Every transaction involving the movement of goods between locations must be reviewed and approved here by authorized personnel (e.g., a Warehouse Head) before the system officially updates the stock location and quantity records.

1. Main View (Document List)

The main page of this module is an "inbox" that displays all transfer documents requiring your action.

View Explanation

This page provides a summary of all transfer transactions that are awaiting approval.

• Filters: You can search for a specific document by Bin Transfer Number or a date range (Start Date / End Date).

• Document List: The table below will display all documents awaiting action, with columns such as Bin Transfer Number, Date, Source Bin Code, Destination Bin Code, and Approval Status.

2. Approval Process Steps

The following is the standard workflow for an approver.

Step 1: Access the Inbox

Open the Bin Transfer Inbox module to see the list of transactions that require approval.

Step 2: Review the Transfer Details

Click on one of the rows in the table to open the detail view of the transfer document. In the detail page, you can check what item was moved, its quantity, as well as its source and destination locations.

Step 3: Provide Approval

After you review the transfer details in Step 2, you will find a button to grant approval (e.g., an "Approve" button) within that detail page. Click the appropriate button to complete the review process.

Workflow & Integrated Business Process

1. A Bin Transfer document is created and confirmed by a warehouse staff.

2. The document automatically enters the queue in this Inbox.

3. A Warehouse Head or manager reviews and approves it.

4. After approval, the system will finally update the stock records: decreasing the stock in the Source Bin and increasing the stock in the Destination Bin.

Tips & Important Notes

• This approval process is an important control step to ensure all goods movements within the warehouse are recorded accurately and legitimately.

• This is an important module for the Warehouse Head to validate all goods movement activities carried out by their team.

Bin Transfer Receipt

Module Guide: Bin Transfer Receipt

Module Location

Inventory > Warehouse Management > Bin Transfer > Bin Transfer Receipt

Module Objective

The Bin Transfer Receipt module is the second and final step in the process of moving goods between locations. Its purpose is to confirm the receipt of goods that have been shipped from another location. This module functions as a Goods Receipt for internal transfers, which finalizes the stock movement from "in-transit" to available stock at the destination location.

1. Main View (Receipt List)

The main page of this module displays a list of all receipt confirmation documents that have been created.

View Explanation

• View: This page is a history of all goods receipt documents resulting from a transfer.

• Button Functions:

  • [New]: The primary button to start the process of recording a goods receipt.

2. Steps to Confirm Goods Receipt

Step 1: Create a New Receipt Document

From the Main View, click the [New] button to open the receipt form.

Step 2: Select the Transfer Document

On the form that appears, in the Bin Transfer Number field, search for and select the original transfer document (that is, the shipping document from the source warehouse).

Step 3: Verify and Input the Received Quantity

1. After you select the document, the system will display the details of the shipped items in the table below, along with the Approved Quantity (the quantity that was shipped).

2. Perform a physical count of the goods you have just received.

3. Enter the result of that physical count into the Quantity Received column.

Step 4: Confirm the Receipt

After ensuring the received quantity is correct, click the [Received] button to finalize the receipt process. The stock at your location will now be officially increased.

Workflow & Integrated Business Process

• This module is the second step of a two-step transfer process, completing the shipment that was initiated in the Bin Transfer module.

• This two-step process (shipment then receipt) provides better control for transfers between physically separate warehouses, as it allows for the tracking of an "in-transit" status.

Tips & Important Notes

• Always ensure the Quantity Received is filled in according to the physical quantity you counted to identify any lost or damaged goods during transit.

• This is a very important daily work module for the Warehouse Operator at the receiving location.

Warehouse Transfer Request

Module Guide: Warehouse Transfer Request

Module Location

Inventory > Warehouse Transfer > Warehouse Transfer Request

Module Objective

The Warehouse Transfer Request module is used to create an official request document to move goods from one warehouse location to another. This is the initial or planning stage in the internal stock transfer process, for example, to send raw materials to a subcontractor, move finished goods between branch warehouses, or supply goods to the production floor.

1. Main View (Request List)

The main page of this module displays a list of all warehouse transfer request documents that have been created.

View Explanation

• View: This page is a history of all transfer requests. You can monitor the Doc. Number, Destination, Shipping Status, and Goods Receipt Status.

• Filters: You can search for a specific document by Doc. Number or a date range.

Button Functions

• [New]: The primary button to create a new warehouse transfer request document.

2. Steps to Create a Warehouse Transfer Request

Step 1: Create a New Request

From the Main View, click the [New] button to open the New Document form.

Step 2: Fill in Header Information

• Select the request's destination in the Request To column (e.g., UMS - SUBCON (Subcontractor)).

• Define the Request Date and the Date needed for the goods.

• Fill in the Memo if there are additional remarks.

Step 3: Detail the Requested Items

1. In the Item/Service List table, click the [+] icon to add a row and select the item to be moved.

2. Enter the required quantity in the Quantity column.

Step 4: Save the Request

After all the requested items have been entered, click the [Save] button to save the request draft. This document will then need to be processed further (for example, approved) before the goods can be prepared for shipment.

Workflow & Integrated Business Process

• This module is the first step in the workflow for moving goods between warehouses.

• After this request is created and approved, this document will become the basis for the source warehouse to create a Goods Shipment Document.

Tips & Important Notes

• Use this module to manage the movement of raw materials to subcontractors or the transfer of finished goods between branches in a structured way.

• Ensure the Date needed is filled in correctly to help the source warehouse team in prioritizing shipments.

Warehouse Transfer Request Inbox

Module Guide: Warehouse Transfer Request Inbox (WTR Inbox)

Module Location

Inventory > Warehouse Transfer > Warehouse Transfer Request Inbox

Module Objective

The Warehouse Transfer Request Inbox (or WTR Inbox) module serves as the approval center for all Warehouse Transfer Requests. Every internal stock transfer request must be reviewed and approved here by an authorized manager before the source warehouse can proceed with the shipping process.

1. Main View (Request List)

The main page of this module is an "inbox" that displays all transfer request documents requiring your action.

View Explanation

This page provides a summary of all requests that are awaiting approval.

• Filters: You can search for a specific document by WTR Number (Request Number) or a Period date range.

• Request List: The table below will display all documents awaiting action, with columns such as WHTRequisitionNum (Request Number), WHTRequisitionDate (Request Date), and Doc_Status.

2. Approval Process Steps

The following is the standard workflow for an approver.

Step 1: Access the Inbox

Open the Warehouse Transfer Request Inbox module to see the list of requests that require approval.

Step 2: Review the Request Details

Click on one of the rows in the table to open the detail view of that request. In the detail page, you can check all the information, such as what items are requested, their quantity, and when the goods are needed.

Step 3: Provide Approval

After you review the request details in Step 2, you will find a button to grant approval (e.g., an "Approve" button) within that detail page. Click the appropriate button to complete the review process.

Workflow & Integrated Business Process

1. A Warehouse Transfer Request is created and submitted.

2. The request automatically enters the queue in this WTR Inbox.

3. A manager reviews and approves it.

4. After approval, the request's status will be updated and it becomes a valid instruction for the source warehouse to begin the goods shipment process.

Tips & Important Notes

• This approval process is an important control step to ensure that only valid and prioritized transfer requests will be processed further.

• This module is typically accessed by a Logistics Manager, Warehouse Head, or PPIC Manager.

Warehouse Transfer

Module Guide: Warehouse Transfer Shipment

Module Location

Inventory > Warehouse Transfer > Warehouse Transfer

Module Objective

The Warehouse Transfer module is the primary transactional module for executing the shipment of goods in an internal stock transfer process. After a Warehouse Transfer Request is approved, this module is used by the source warehouse to record the Goods Issue, change the stock status to "in-transit", and print the Delivery Order (DO).

1. Main View (Transfer Shipment List)

The main page of this module displays a list of all shipment documents for warehouse transfers that have been created.

View and Key Button Functions

• View: This page is a history of all transfer shipment activities. You can monitor the Doc. Number, Data Source, Destination, and shipping Status.

• Action Buttons:

  • [New]: To create a new transfer shipment document, usually based on an approved request.

  • [Print DO]: To print the Delivery Order (DO) document that will accompany the goods during shipment to the destination warehouse.

2. Steps to Perform a Transfer Shipment (Conceptual)

1. Create a New Document: From the main page, click the [New] button.

2. Reference the Request: On the form that appears (not shown), you will be prompted to select or reference the approved Warehouse Transfer Request Number. The system will then automatically load the details of the items and the quantity that must be shipped.

3. Verify and Confirm: Verify the quantity that you will physically ship, then Confirm the document. This action will reduce the stock from your warehouse (the source warehouse) and place it in an "In-Transit" status.

4. Print the Shipping Document: Return to the list page, select the document you just created, then click the [Print DO] button to print the delivery order that will be sent with the goods.

Workflow & Integrated Business Process

• This module is the second step in the warehouse transfer workflow, executed after the Warehouse Transfer Request is approved.

• The next step after this shipment process is the Goods Receipt process at the destination warehouse to complete the transfer.

Tips & Important Notes

• Ensure you only process shipments for requests that have an approved status.

• The Delivery Order (DO) document printed from here is a crucial control document that must physically accompany the goods while they are in transit.

• This is a daily work module for the Logistics and Shipping Warehouse teams.

Warehouse Transfer Inbox

Module Guide: Warehouse Transfer Inbox

Module Location

Inventory > Warehouse Transfer > Warehouse Transfer Inbox

Module Objective

The Warehouse Transfer Inbox module serves as the approval center for all Warehouse Transfer (shipment) documents that have been submitted. After the source warehouse staff creates a shipment document, it must be reviewed and approved here by an authorized manager before the goods are officially issued from the system and their status changes to "in-transit".

1. Main View (Document List)

The main page of this module is an "inbox" that displays all transfer shipment documents requiring your action.

View Explanation

This page provides a summary of all shipment documents that are awaiting approval.

• Filters: You can search for a specific document by Doc. Number, a Date range, or Item/Service Category.

• Document List: The table below will display all documents awaiting action, with columns such as Doc. Number, Transfer Date, Data Source, Destination, and Approval.

2. Approval Process Steps

The following is the standard workflow for an approver.

Step 1: Access the Inbox

Open the Warehouse Transfer Inbox module to see the list of transactions that require approval.

Step 2: Review the Shipment Details

Click on one of the rows in the table to open the detail view of the shipment document. In the detail page, you can check the consistency between the shipment document and the original request document, including the items and their quantities.

Step 3: Provide Approval

After you review the shipment details in Step 2, you will find a button to grant approval (e.g., an "Approve" button) within that detail page. Click the appropriate button to complete the review process.

Workflow & Integrated Business Process

1. A Warehouse Transfer document is created and confirmed by the source warehouse staff.

2. The document automatically enters the queue in this Inbox.

3. A manager (e.g., the Shipping Warehouse Head) reviews and approves it.

4. After approval, the goods are officially issued from the source warehouse's stock and their status changes to "in-transit". The next step is the receipt at the destination warehouse.

Tips & Important Notes

• This approval process is an important control step to ensure that only the correct goods that match the request are shipped.

• This module is typically accessed by a Warehouse Head or Logistics Manager.

Warehouse Transfer Receipt

Module Guide: Warehouse Transfer Receipt

Module Location

Inventory > Warehouse Transfer > Warehouse Transfer Receipt

Module Objective

The Warehouse Transfer Receipt module is the third and final step in the warehouse transfer workflow. Its purpose is to confirm the receipt of goods at the destination warehouse. After the goods shipped from the source warehouse arrive, this module is used to record the physical receipt, which will complete the transfer process and officially add the quantity of goods to the receiving warehouse's stock.

1. Main View (Receipt List)

The main page of this module displays a list of all transfer receipt documents that have been created.

View Explanation

• View: This page is a history of all goods receipt documents resulting from a transfer. You can track documents by Receipt Number, Request Number, and Shipment Date.

• Filters: You can search for a specific document by number or Item/Service Category.

• Action Buttons:

  • [New]: The primary button to start the process of recording a transfer goods receipt.

2. Steps to Confirm Goods Receipt

Step 1: Create a New Receipt Document

From the Main View, click the [New] button to open the Add Receipt form.

Step 2: Select the Shipment Document

On the form that appears, in the WHTDocNo (Warehouse Transfer Document Number) field, search for and select the original shipment document number (that is, the Delivery Order document from the source warehouse).

Step 3: Verify and Input the Received Quantity

1. After you select the document, the system will display the details of the shipped items in the table below, along with the Approved Quantity (the quantity that was shipped).

2. Perform a physical count of the goods you have just received.

3. Enter the result of that physical count into the Quantity Received column.

Step 4: Confirm the Receipt

After ensuring the received quantity is correct, click the confirmation button (not visible, usually Save or Confirm) to finalize the receipt process. The stock at your location will now be officially increased.

Workflow & Integrated Business Process

• This module is the third and final step of the transfer process, after the Warehouse Transfer Request and the Warehouse Transfer (Shipment).

• With the confirmation of receipt here, the "in-transit" status of the goods will be removed, and the quantity of goods officially becomes part of the available stock in the destination warehouse.

Tips & Important Notes

• Always ensure the Quantity Received is filled in according to the physical quantity you counted to identify any lost or damaged goods during transit.

• This is a very important daily work module for the Warehouse Operator at the receiving location to complete the goods transfer cycle.

Warehouse Transfer Report

Report Module Guide: Warehouse Transfer Report

Module Location

Inventory > Warehouse Transfer > Warehouse Transfer Report

Module Objective

The Warehouse Transfer Report module is used to generate a comprehensive historical report of all goods transfer activities between warehouses. This report tracks the entire transfer cycle, from shipment at the source warehouse to receipt at the destination warehouse, making it ideal for auditing and reconciling internal stock movements.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Show destination / Destination Bin:

  • Filter the report to only display transfers destined for a specific warehouse or bin.

• Period:

  • Specify the date range of the transfer transactions you wish to see, from the From date to the To date.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the date range and the destination filter (if needed) to focus the report on the data you wish to analyze.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the warehouse transfer report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report will be a complete list of all warehouse transfer transactions within the selected period.

This report tracks the workflow from start to finish by displaying key columns such as:

• Shipping Whs. & Qty. Shipped: Information from the source warehouse, showing who shipped and how much quantity was shipped.

• Receiving Whs. & Qty. Received: Information from the destination warehouse, showing who received and how much quantity was received.

By comparing Qty. Shipped and Qty. Received, you can quickly identify any differences or discrepancies that occurred during the transfer process.

Tips & Important Notes

• This report is a recapitulation of the entire workflow recorded in the Warehouse Transfer (Shipment) and Warehouse Transfer Receipt modules.

• Use this report for monthly audits to ensure all shipped goods have arrived at their destination with the correct quantity.

• This is a crucial control report for Logistics Managers and Internal Audit teams.

Shipment List

Module Guide: Shipment List

Module Location

Inventory > Shipment List

Module Objective

The Shipment List module serves as a center for viewing and consolidating multiple individual shipment documents into a single summary report or master manifest. This module is not used to create new shipment documents, but rather to summarize existing documents, typically for the purpose of organizing a single shipping route that covers multiple destinations.

1. Main View (Shipment Document List)

The main page of this module displays a list of all individual shipment documents that have been created by the system (for example, from the Sales Order process).

View and Main Button Functions

• View: This page is a history list of all shipment documents. You can see the List of Goods Carried Number, Date, and Status.

• Main Button Function:

  • [Summary]: This button is used to open the screen for creating a combined summary report/manifest.

2. Steps to Create a Shipment Summary Report

Step 1: Open the Summary Screen

From the main page, click the [Summary] button to open the Shipment List Summary screen.

Step 2: Define the Period

Set the From and To date range to display all shipment documents that will be sent within that period.

Step 3: Select Shipment Documents

1. The system will display all available shipment documents for that period in two boxes on the left (Shipment List With Carrier and Without Carrier).

2. Select one or more documents from the left boxes that will be combined into a single manifest.

3. Click the >> button to move those documents to the Selected Shipment List box on the right.

Step 4: Generate the Report

After all relevant documents have been selected, click the [Display Report] or [Export to MS Excel] button at the bottom. The resulting report is a consolidated loading list or manifest that can be given to the driver/carrier.

Tips & Important Notes

• This module is not for creating new Delivery Orders, but rather for summarizing existing ones.

• Use this feature to create a single summary document for one shipping route that covers multiple customers, which simplifies the shipping and handover process.

• This is a crucial tool for a Logistics Coordinator or Shipping Warehouse Head.

Intercompany

Report Module Guide: Intercompany Transactions

Module Location

Inventory > Receipt List > Intercompany

Module Objective

The Intercompany module is a special inquiry report that is used to track and reconcile transactions between companies that are in the same group (intercompany transactions). This report provides a comprehensive, end-to-end view by linking the Purchase Order from the buying company with the Sales Order and Delivery Order from the selling company.

1. Main View (Intercompany Transaction List)

The main page of this module displays a list of all intercompany transactions that have been recorded, allowing you to track their status.

View Explanation & Filters

• View: This page is the monitoring center for all intercompany transactions. You can see the interlinked documents in a single row.

• Filters: Use filters like Purchase Order Number or a Date range to search for specific transactions.

Key Column Explanation

• Purchase Order Number: The purchase order from the internal company that is buying the goods.

• Sales Order Number: The related sales order created by the internal company that is selling the goods.

• Delivery Order Number: The goods shipment document related to the transaction.

• Status: Shows the current status of the overall transaction process (e.g., 'Awaiting Shipment', 'Received').

2. How to Use the Report

• Use this report to verify that every intercompany Purchase Order has been correctly processed into a Sales Order and has been shipped with the corresponding Delivery Order.

• This report is crucial during the month-end closing process to reconcile the "Intercompany Receivable" and "Intercompany Payable" account balances so they can be properly eliminated in the consolidated financial statements.

Tips & Important Notes

• This module is a read-only report for tracing and audit purposes.

• The accuracy of this report depends on the correct transaction process in the Purchasing and Sales modules in each respective company entity.

• This is a crucial report for the Intercompany Accounting team or the Controller.

Goods Receipt

Module Guide: Goods Receipt Note

Module Location

Inventory > Goods Receipt

Module Objective

The Goods Receipt module is the primary transactional module used to record the physical receipt of goods from suppliers (vendors). This process is almost always based on a Purchase Order (PO) that has been created previously. Recording a receipt here will automatically increase the stock quantity in the system and become the trigger for the finance team to process the payment of the supplier's invoice.

1. Main View (Goods Receipt List)

The main page of this module displays a list of all goods receipt documents or Goods Receipt Notes (GRNs) that have been created.

View Explanation

• View: This page is a history of all goods receipt activities. You can see the Receipt Number, the related Purchase Order Number, the Supplier, and the Approval Status.

• Filters: You can search for a specific document by number, a date range, or Item/Service Category (e.g., RAW MATERIAL).

Button Functions

• [New] or [New Direct]: The primary button to start the process of recording a new goods receipt.

2. Steps to Record a Goods Receipt

Step 1: Create a New Document

From the Main View, click the [New] or [New Direct] button to open the goods receipt form.

Step 2: Select the Purchase Order (PO)

On the form that appears, the first step is to find and select the Purchase Order (PO) Number that corresponds to the arriving goods. After you select the PO, the system will automatically load the supplier details and the list of expected items.

Step 3: Verify and Input the Received Quantity (Important!)

1. Perform a physical count of the goods you have just received from the shipment.

2. In the item detail table, enter the quantity from your physical count into the input column (in the example, this column is named 'Type now'). This allows you to record if there is a partial shipment (the quantity received is less than the quantity ordered).

Step 4: Record Shipping Details

Fill in relevant logistics details such as Vehicle Number and Driver's Name.

Step 5: Confirm the Receipt

After all data is filled in, click the [Confirm] button. This action will finalize the receipt and officially increase the stock quantity of that item in your warehouse.

Tips & Important Notes

• This module is the crucial bridge between the Purchasing, Inventory, and Accounts Payable (AP) modules.

• An accurate recording of the goods receipt here is an absolute prerequisite before the Finance team can validate and pay the Supplier's invoice.

• This is a very important daily work module for the Receiving Warehouse team.

Goods Receipt Note Inbox

Module Guide: Goods Receipt Note Inbox (GRN Inbox)

Module Location

Inventory > Goods Receipt > Goods Receipt Note Inbox

Module Objective

The Goods Receipt Note Inbox module serves as the approval center for all Goods Receipt Note (GRN) documents that have been submitted. This is a crucial control step where a manager (e.g., a Warehouse Head or Quality Control) must review and approve the goods received from a supplier before the stock is officially added to the inventory and before the finance team proceeds with the payment process.

1. Main View (Receipt Document List)

The main page of this module is an "inbox" that displays all goods receipt documents requiring your action.

View Explanation

This page provides a summary of all receipt documents that are awaiting approval.

• Filters: You can search for a specific document by Goods Receipt Number, a Date range, or Item/Service Category.

• Document List: The table below will display all documents awaiting action, with columns such as the Goods Receipt Number, the related Purchase Order Number, the Supplier, and the Approval Status.

2. Approval Process Steps

The following is the standard workflow for an approver.

Step 1: Access the Inbox

Open the Goods Receipt Note Inbox module to see the list of receipts that require approval.

Step 2: Review the Receipt Details

Click on one of the rows in the table to open the detail view of the receipt document. In the detail page, you can check the conformity of the received goods (type and quantity) with the original Purchase Order (PO) document.

Step 3: Provide Approval

After you review the receipt details in Step 2, you will find a button to grant approval (e.g., an "Approve" button) within that detail page. Click the appropriate button to complete the review process.

Workflow & Integrated Business Process

1. A Goods Receipt Note (GRN) is created and confirmed by a warehouse staff.

2. The document automatically enters the queue in this Inbox.

3. A manager reviews and approves it.

4. After approval, the stock is officially increased in the system, and the Finance (AP) team gets the "green light" to proceed with the payment of the supplier's invoice.

Tips & Important Notes

• The approval process here is the final verification that the received goods match the order, in terms of type, quantity, and quality (if a QC process is in place).

• This step is key to ensuring the company only pays for goods that have actually been properly received.

• This module is typically accessed by the Receiving Warehouse Head or a Quality Assurance (QA) manager.

Goods Receipt Cancellation Inbox

Module Guide: Goods Receipt Cancellation Inbox

Module Location

Inventory > Goods Receipt > Goods Receipt Cancellation Inbox

Module Objective

The Goods Receipt Cancellation Inbox module serves as the approval center for all requests to void Goods Receipt Note (GRN) documents. This is a crucial control step where a manager must provide authorization before the system officially reverses a goods receipt transaction.

1. Main View (Cancellation List)

The main page of this module is an "inbox" that displays all GRN cancellation requests requiring your action.

View Explanation

This page provides a summary of all cancellation requests that are awaiting approval.

• Filters: You can search for a specific document by its cancellation number or a date range.

• Document List: The table below will display all documents awaiting action, with columns such as Goods Receipt Cancellation No., Goods Receipt Number (the original document to be canceled), Supplier, and Approval Status.

2. Approval Process Steps

The following is the standard workflow for an approver.

Step 1: Access the Inbox

Open the Goods Receipt Cancellation Inbox module to see the list of requests that require approval.

Step 2: Review the Cancellation Details

Click on one of the rows in the table to open the detail view of that cancellation request. In the detail page, you can check all the information, including the details of the original GRN to be canceled and the reason given for the cancellation (e.g., "date revision").

Step 3: Provide Approval

At the bottom of the page, on the row with your name, change the Status to "Accepted" or "Approved" and provide a note if necessary. Click the save button to record your approval.

Workflow & Integrated Business Process

1. A GRN cancellation request is created (usually from a separate module).

2. The request automatically enters the queue in this Inbox.

3. A manager reviews and approves it.

4. After approval, the system will finally:

   • Reduce the stock quantity that was previously added by the original GRN.

   • Cancel the accounting impact of the initial receipt.

   • Re-open the quantity on the related Purchase Order (PO) so it can be used for a correct receipt process.

Tips & Important Notes

• This approval process is very important because voiding a GRN will change the stock records and potentially affect the payment process to the vendor.

• Always check the Reason column to understand why this cancellation is necessary.

• This module is typically accessed by a Warehouse Supervisor or Logistics Manager.

Delivery Order

Module Guide: Delivery Order (Surat Jalan)

Module Location

Inventory > Delivery Order

Module Objective

The Delivery Order module is used to create the official shipping document or Delivery Order (DO) that will be sent along with the goods to the customer. The creation of a Delivery Order is based on a Sales Order whose items have already been allocated from stock. This module is the execution step in the goods shipment process.

1. Main View (Delivery Order List)

The main page of this module displays a list of all Delivery Order documents that have been created.

View Explanation

• View: This page is a history of all shipments. You can monitor the Delivery Order No., Reference Document (Sales Order), Customer, and shipping Status.

• Filters: You can search for a specific document by number, a Date range, or Item/Service Category.

• Action Buttons:

  • [New] or [New Direct]: The primary button to create a new Delivery Order.

2. Steps to Create a Delivery Order

Step 1: Create a New Document

From the Main View, click the [New] or [New Direct] button to open the Add Delivery Order form.

Step 2: Select the Shipping Reference

On the form that appears, the first step is to select the Shipping Instruction Number. This usually refers to the Sales Order whose goods have been allocated and are ready to ship. Once selected, the system will automatically load the customer details and the list of items to be shipped.

Step 3: Verify and Input the Ship Quantity

1. The system will display the Quantity on SO (the quantity ordered) and Remaining (the quantity not yet shipped).

2. In the input column Receive now or 'Ship Quantity', enter the quantity that you are physically shipping at this time. This allows you to perform a partial shipment.

3. Select the goods' picking location in the Bin Name column.

Step 4: Record Shipping Details

Fill in relevant logistics details such as Vehicle Number and Driver.

Step 5: Confirm the Shipment

After all data is filled in, click the [Confirm] button. This action will finalize the Delivery Order and officially reduce the on-hand stock quantity from your warehouse. This document can then be printed to accompany the shipment.

Tips & Important Notes

• The creation of a Delivery Order is the step that physically and from an accounting perspective removes the goods from your inventory.

• After the Delivery Order is created and the goods are shipped, the next step in the sales cycle is the creation of the Sales Invoice by the finance team.

• This is a crucial daily work module for the Shipping Warehouse team.

Delivery Order Inbox

Module Guide: Delivery Order Inbox

Module Location

Inventory > Delivery Order > Delivery Order Inbox

Module Objective

The Delivery Order Inbox module serves as the approval center for all Delivery Order documents that have been created. Before goods are physically shipped out of the warehouse and the stock is permanently reduced, a manager (e.g., a Warehouse Head) must review and give final approval to the shipping document.

1. Main View (Delivery Order List)

The main page of this module is an "inbox" that displays all Delivery Order documents requiring your approval.

View Explanation

This page provides a summary of all shipping documents that are awaiting approval.

• Filters: You can search for a specific document by Delivery Order Number, a Date range, Item/Service Category, or Shipping Status.

• Document List: The table below will display all Delivery Orders awaiting action, with columns such as the Delivery Order Number, the related Sales Order Number, the Customer, and the Approval Status.

2. Approval Process Steps

The following is the standard workflow for an approver.

Step 1: Access the Inbox

Open the Delivery Order Inbox module to see the list of shipments that require approval.

Step 2: Review the Shipment Details

Click on one of the rows in the table to open the detail view of that Delivery Order. In the detail page, you can re-check the conformity of the items, quantity, customer, and shipping address before the goods depart.

Step 3: Provide Approval

After you review the Delivery Order details in Step 2, you will find a button to grant approval (e.g., an "Approve" button) within that detail page. Click the appropriate button to complete the review process.

Workflow & Integrated Business Process

1. A Delivery Order document is created and confirmed by a warehouse staff.

2. The document automatically enters the queue in this Inbox.

3. A manager reviews and approves it.

4. After approval, the Delivery Order is considered final, and the process of permanently reducing the stock is executed by the system. This document also becomes the basis for the finance team to create the Sales Invoice.

Tips & Important Notes

• This approval process is the final control step before the goods physically leave the warehouse.

• This is an important module for the Shipping Warehouse Head to ensure there are no shipping errors.

Internal Delivery Order Report

Report Module Guide: Internal Delivery Order Report

Module Location

Inventory > Delivery Order > Internal Delivery Order Report

Module Objective

The Internal Delivery Order Report module is used to generate a summary report of all goods issued from the warehouse for internal company use. This report breaks down the total usage of each item by the department or cost center that received it, making it very useful for internal cost control and allocation.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Warehouse Location:

  • Select the source warehouse from which the goods were issued.

• Period:

  • Specify the date range for the internal goods issuance in the From and To fields for the report you wish to see.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the warehouse and the time period you wish to analyze.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a matrix that summarizes the total usage of each item by various departments.

• Rows: Each row represents the Item Name that was used.

• Columns: The columns in the middle represent each department or cost center that received the goods (e.g., PROD for Production, QA for Quality Assurance, HRD, etc.).

• How to Read: The number inside the table shows the total quantity of an item that was taken by a specific department during the report period. The Total column on the far right sums up the total usage of that item across all departments.

Tips & Important Notes

• This report is crucial for controlling internal operational costs and for the process of cost allocation per department.

• The data in this report comes from internal goods issue transactions, which may be recorded via an "Internal Delivery Order" or "Internal Item Request" module.

• This is a very useful report for Cost Accountants and Department Managers.

Delivery Order Raw

Report Module Guide: Raw Material Usage for Customs (RMSNSRpt)

Module Location

Inventory > Delivery Order > Delivery Order Raw Material Usage Report

Module Objective

This module is a highly specific reporting tool, used to track and report the usage of raw materials that are contained within finished goods which have been shipped via a Delivery Order. Its primary purpose is for reporting to Customs (BC), especially for companies operating in a Bonded Zone or receiving other customs facilities.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to generate a specific report.

Here is an explanation for each key parameter:

• Period:

  • Specify the From and To date range for the Delivery Orders to be reported.

• Source Document:

  • Select the base document to be used as a reference, generally a Shipping Instruction.

• Tracing Method:

  • Important! Select the method the system uses to trace raw material usage, for example, FEFO RM/PM (First Expired First Out for Raw Material/Packaging Material).

2. Steps to Generate and Upload the Report

1. Set Report Parameters: Define all necessary parameters, especially the Period and Tracing Method.

2. Display the Report: Click the [Display Report] button. The system will process the data: finding all finished goods shipped in the period, then "exploding" their recipe/BOM to find which raw materials have been used.

3. View the Results: The generated report will display a list of the used raw materials.

4. Link to a Customs Document: On the results screen, select the relevant Customs Submission Number from the dropdown.

5. Upload the Report: Click the [upload to BC] button to send this raw material usage report to the Customs system.

Tips & Important Notes

• This is a very specific and crucial module for maintaining the company's compliance with Customs regulations.

• The accuracy of this report is highly dependent on accurate Bill of Materials (BOM) data and disciplined recording of Delivery Orders.

• This module is typically used by the Exim (Export-Import) or Tax Accounting team responsible for customs reporting.

Trip Activity

Module Guide: Trip Activity

Module Location

Inventory > Shipment Planning > Trip Activity

Module Objective

The Trip Activity module serves as a visual calendar or agenda to monitor all scheduled shipping trip activities on a specific day. This module provides a time-based overview of the route or schedule for each shipment.

1. Main View (Activity Calendar)

The main page of this module is a daily calendar that displays time slots.

• View: This page displays an hourly agenda for the selected date (e.g., October 13, 2025).

• Navigation: You can select a different date using the calendar on the left to see the schedule for that day.

• Filter: You can choose to display the schedule based on Document or other filters.

2. How to Use

This module is most likely read-only and functions as a visual dashboard.

1. Select the date you wish to see on the calendar.

2. The screen will display all shipping activities that have been scheduled in other modules, sorted by the hour.

3. Each entry in the schedule will likely contain information such as the Delivery Order number, customer name, and driver's name.

Tips & Important Notes

• Use this module as a daily dashboard for the logistics team to monitor departures and shipping schedules.

• The data displayed here most likely comes from other modules such as Delivery Order or a more detailed shipping scheduling module.

• This is an effective monitoring tool for Logistics Managers to ensure all shipments are running on schedule.

Shipment Planning

Module Guide: Shipment Planning

Module Location

Inventory > Shipment Planning

Module Objective

The Shipment Planning module serves as a tool to plan and create shipping schedules or trip routes. Here, a logistics planner can group multiple Delivery Orders that have the same destination area into a single trip plan, set the departure and estimated completion times, and determine the vehicle to be used.

1. Main View (Planning List)

The main page of this module displays a list of all shipment planning documents that have been created.

View Explanation

• View: This page is a history of all shipment plans that have ever been made.

• Filters: You can search for a specific document by Shipment Planning Number or a Date range.

• Action Buttons:

  • [New]: The primary button to create a new shipment plan.

2. Steps to Create a Shipment Plan

Step 1: Create a New Plan

From the Main View, click the [New] button to open the Add Shipment Plan form.

Step 2: Fill in Trip Information

On the form that appears, fill in the main trip details:

• Goods Shipment Date: Enter the date the shipment plan will be executed.

• Estimated Data:

  • Estimated Start and End Time: Set the departure schedule and the estimated time of return.

  • Estimated Distance: Enter the estimated travel distance in KM.

Step 3: Select Delivery Orders and Area

1. Select Area: In the Available Area box, select the destination area for the shipment, then click the >> button to move it to the Selected Area box.

2. Select Delivery Orders: After selecting the area, the Available Delivery Orders box will display all Delivery Orders whose destination matches the selected area. Select the Delivery Orders to be included in this route, then click the >> button to move them to the Selected Delivery Orders box.

Step 4: Determine Vehicle and Packages (Conceptual)

At the bottom (details not shown), you will select the Vehicle Information (e.g., license plate number) and detail the Package List to be carried.

Step 5: Confirm the Plan

After all details are filled in, click the [Confirm] button to save and finalize the shipment plan.

Tips & Important Notes

• This is the central planning tool for the Logistics team or Dispatchers.

• By grouping Delivery Orders by area, you can create more efficient shipping routes and optimize vehicle usage.

• The plan created here will become the basis for monitoring activities in the Trip Activity module.

Shipment Planning Inbox

Module Guide: Shipment Planning Inbox

Module Location

Inventory > Shipment Planning > Shipment Planning Inbox

Module Objective

The Shipment Planning Inbox module serves as the approval center for all Shipment Planning documents that have been created. Every trip plan or shipping route must be reviewed and approved here by an authorized manager (e.g., a Logistics Manager) before the schedule is considered final and ready for execution.

1. Main View (Plan List)

The main page of this module is an "inbox" that displays all shipment planning documents requiring your action.

View Explanation

This page provides a summary of all shipment plans that are awaiting approval.

• Filters: You can search for a specific document by Shipment Planning Number or a Date range.

• Plan List: The table below will display all documents awaiting action, with columns such as Shipment Planning Number, Goods Shipment Date, and Approval Status.

2. Approval Process Steps

The following is the standard workflow for an approver.

Step 1: Access the Inbox

Open the Shipment Planning Inbox module to see the list of plans that require approval.

Step 2: Review the Plan Details

Click on one of the rows in the table to open the detail view of the shipment plan. In the detail page, you can check all the information, such as the route (area), the list of combined Delivery Orders, and the allocated vehicle.

Step 3: Provide Approval

After you review the plan details in Step 2, you will find a button to grant approval (e.g., an "Approve" button) within that detail page. Click the appropriate button to complete the review process.

Workflow & Integrated Business Process

1. A Shipment Planning document is created and confirmed by a logistics planner.

2. The document automatically enters the queue in this Inbox.

3. A manager reviews and approves it.

4. After approval, the trip plan becomes a final schedule and can be viewed in the Trip Activity module to be executed by the shipping team.

Tips & Important Notes

• This approval process is an important control step to ensure all shipping routes have been planned efficiently and logically before being executed.

• This module is typically accessed by a Logistics Manager or Head of Shipping.

Shipment Planning Declaration

Module Guide: Shipment Planning Declaration

Module Location

Inventory > Shipment Planning > Shipment Planning Declaration

Module Objective

The Shipment Planning Declaration module is used to create an accountability or declaration document for a Shipment Plan that has been completed. This module is the closing step for a trip route, where the user can record the final result or status of that trip.

1. Main View (Declaration List)

The main page of this module displays a list of all shipment planning declaration documents that have been created.

View Explanation

• View: This page is a history of all declarations that have ever been made.

• Filters: You can search for a specific document by Shipment Planning Declaration Number or a Date range.

• Action Buttons:

  • [New]: The primary button to create a new declaration.

2. Steps to Create a Declaration

Step 1: Create a New Declaration

From the Main View, click the [New] button to open the Add Declaration form.

Step 2: Fill in Declaration Details

1. Shipment Planning Declaration Number: In this field, search for and select the original Shipment Plan number whose trip has been completed and which you are about to report on.

2. Accountability Date: Enter the date you are creating this report.

3. Notes: Provide notes regarding the trip's outcome, for example, "All shipments successful" or "There was 1 rejected Delivery Order".

4. Click [Save] to save the declaration.

Tips & Important Notes

• This module is the final administrative step to close a shipment trip cycle.

• By creating a declaration, you officially confirm that a trip plan has been fully executed. This is important for tracking and auditing logistics performance.

Goods Inflow Report

Report Module Guide: Goods Inflow Report (BC Inflow Report)

Module Location

Inventory > Bonded Zone > Goods Inflow Report

Module Objective

The Goods Inflow Report module is used to generate an official report that details all goods inflow activities into a Bonded Zone. This report is specifically designed to meet the format and data requirements mandated by the Customs (BC) system.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to generate a specific report.

Here is an explanation for each parameter:

• BC Document Type:

  • The primary filter to select the type of customs document you wish to report (e.g., BC 2.3 for imports, BC 4.0 for local inflows, etc.).

• Status:

  • Filter by document status if needed.

• Period:

  • Specify the date range of the goods inflow in the From and To fields.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the Period and the BC Document Type.

Step 2: Generate the Report

After all parameters are set, click the [Display] button.

3. Reading the Report (Report Content)

The generated report is a list of goods inflow transactions that has been formatted according to Customs reporting standards.

This report contains specific customs-related columns such as:

• DOK PABEAN: The type of customs document.

• NO PEN & TGL DAFTAR: Registration Number & Date (in the Customs system).

• NO AJU & TGL AJU: Submission Number & Date.

• PENGIRIM: The name of the shipping party.

Report Features: This report is interactive. You can search for specific data or export it to other formats like Excel or PDF using the buttons in the top-right corner.

Tips & Important Notes

• This is a crucial report for maintaining the company's compliance with Customs regulations.

• This report's data is pulled from the Goods Receipt module, where customs-relevant transactions have been specially flagged.

• This module is a primary work tool for the Exim (Export-Import) team.

Goods Outflow Report

Report Module Guide: Goods Outflow Report (BC Outflow Report)

Module Location

Inventory > Bonded Zone > Goods Outflow Report

Module Objective

The Goods Outflow Report module is used to generate an official report that details all goods outflow activities from a Bonded Zone. Just like the inflow report, this report is specifically designed to meet the format and data requirements mandated by the Customs (BC) system.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to generate a specific report.

Here is an explanation for each parameter:

• BC Document Type:

  • The primary filter to select the type of customs document you wish to report (e.g., BC 2.5 for exports, BC 4.1 for local outflows, etc.).

• Status:

  • Filter by document status if needed.

• Period:

  • Specify the date range of the goods outflow in the From and To fields.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the Period and the BC Document Type.

Step 2: Generate the Report

After all parameters are set, click the [Display] button.

3. Reading the Report (Report Content)

The generated report is a list of goods outflow transactions that has been formatted according to Customs reporting standards.

This report contains specific customs-related columns such as:

• DOK PABEAN: The type of customs document.

• NO DAFTAR & TGL DAFTAR: Registration Number & Date (in the Customs system).

• NO AJU & TGL AJU: Submission Number & Date.

• PENERIMA: The name of the receiving party.

Report Features: This report is interactive. You can search for specific data or export it to other formats like Excel or PDF using the buttons in the top-right corner.

Tips & Important Notes

• This is a crucial report for maintaining the company's compliance with Customs regulations related to the outflow of goods from a Bonded Zone.

• This report's data is pulled from the Delivery Order module, where customs-relevant transactions have been specially flagged.

• This module is a primary work tool for the Exim (Export-Import) team.

Stock Mutation Report

Report Module Guide: Stock Mutation Report (BC Stock Mutation Report)

Module Location

Inventory > Bonded Zone > Stock Mutation Report

Module Objective

The Stock Mutation Report module is used to generate a stock mutation (movement) report specifically designed for Customs (BC) reporting purposes. This report details all inflow and outflow transactions for each item within a specific period, which results in a beginning balance, movements, and an ending balance, according to the format required for Bonded Zone reporting.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to generate a specific report.

Here is an explanation for each parameter:

• Item/Service Category Type:

  • Filter the report for a specific item category (e.g., Raw Material, Finished Good).

• Type Document BC:

  • Filter transactions by the relevant customs document type.

• Period:

  • Specify the mutation date range in the From and To fields that you wish to report.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the Period and the Category Type to be analyzed.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display]: To preview the mutation report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a stock mutation report that is ready to be submitted to Customs.

The report will likely display the standard mutation format:

• Beginning Balance

• Total Inflows (during the period)

• Total Outflows (during the period)

• Ending Balance

Each line will detail the movement per item with columns such as Date, Transaction Number, Item/Service Code, and other details.

Tips & Important Notes

• This report is a recapitulation of the data recorded in the Goods Inflow Report and the Goods Outflow Report.

• Maintaining the accuracy of this mutation report is crucial for audits and compliance with Bonded Zone regulations.

• This module is a crucial monthly work tool for the Exim (Export-Import) team.

Remnant & Scrap Goods Mutation Report

Report Module Guide: Remnant & Scrap Goods Mutation Report (BC Scrap Mutation Report)

Module Location

Inventory > Bonded Zone > Remnant & Scrap Goods Mutation Report

Module Objective

The Remnant & Scrap Goods Mutation Report module is used to generate a mutation (movement) report that specifically tracks leftover production items or scrap. This report is specially designed to meet the Customs (BC) reporting requirements related to the management and recording of waste or production remnants within a Bonded Zone.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to generate a specific report.

Here is an explanation for each parameter:

• Item/Service Category Type:

  • This filter is specifically set to SCRAP to ensure the report only displays leftover/waste items.

• Type Document BC:

  • Filter transactions by the relevant customs document type for scrap reporting.

• Period:

  • Specify the mutation date range in the From and To fields that you wish to report.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the report Period.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display]: To preview the scrap mutation report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a stock mutation report that is ready to be submitted to Customs, specifically for scrap items.

This report will display the standard mutation format for scrap items:

• Beginning balance of scrap.

• Total inflow of scrap (resulting from production).

• Total outflow of scrap (e.g., sold or destroyed).

• Ending balance of scrap.

Each line will detail the movement per scrap item with columns such as Date, Transaction Number, and Item/Service Code.

Tips & Important Notes

• This report is an essential component of a Bonded Zone company's reporting obligations to Customs.

• Maintaining the accuracy of this scrap mutation report is crucial for audits and compliance with regulations.

• This module is a crucial work tool for the Exim (Export-Import) and PPIC teams responsible for recording production remnants.

Asset Mutation Report

Report Module Guide: Asset Mutation Report (Capital Goods Mutation)

Module Location

Inventory > Bonded Zone > Asset Mutation Report

Module Objective

The Asset Mutation Report module is used to generate a report that tracks the movement (mutation) of fixed assets or capital goods based on quantity (number of units). In the context of a Bonded Zone, this report has a crucial function: to provide data for reporting to Customs regarding the position and movement of capital goods (e.g., machinery and equipment) that have received customs facilities.

1. View and How to Read the Report

The main page of this module is the quantity mutation report for all registered fixed assets.

Key Column Explanation

This report is read like a stock mutation report:

• Beginning Balance: The quantity (number of units) of the asset at the start of the period.

• Additions: The number of new asset units added (e.g., from purchases/imports) during the period.

• Reductions: The number of asset units that were removed (e.g., because they were sold, re-exported, or written off) during the period.

• Book Balance: The quantity of the asset that should exist according to the system's records, calculated with the formula: Beginning Balance + Additions - Reductions.

• Stocktake: This column can be used to input the results of a physical asset count.

• Difference: Shows the variance between the Book Balance and the Stocktake.

2. Usage Steps

1. Generate the Report: Open the module to display the mutation report. You can use the Asset filter to search for a specific asset.

2. Export Data: Click the [Export to MS Excel] button to download the data if it's needed for reporting or further analysis.

3. Use for Audits: This report is used as a checklist during asset audits, both by internal teams and by Customs officials.

Tips & Important Notes

• Although it is a fixed asset report, in the context of a Bonded Zone, this report is crucial for compliance with Customs regulations regarding capital goods.

• This report is used to prove the existence and quantity of machinery or equipment for which import duties have been suspended.

• This is a crucial physical control report for Asset Managers, Exim Teams, and Internal Audit Teams.

In Vs Out

Report Module Guide: IN VS OUT Report (BC In-Out Reconciliation)

Module Location

Inventory > Bonded Zone > IN VS OUT

Module Objective

The IN VS OUT report module is a specialized reconciliation tool for Customs (BC) purposes. Its goal is to match or reconcile goods inflow documents (IN) with their corresponding goods outflow documents (OUT). This report is crucial for proving that raw materials that entered a Bonded Zone have actually been used to produce goods that were later shipped out (for example, exported).

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to generate the report.

Here is an explanation for each parameter:

• BC Document Type:

  • Filter the report by a specific customs document type that you wish to reconcile.

• Period:

  • Specify the transaction date range in the From and To fields.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the report Period.

Step 2: Generate the Report

After all parameters are set, click the [Display] button.

3. Reading the Report (Report Content)

The generated report will display a side-by-side comparison between inflow and outflow transactions.

• Report Structure: This report is divided into two main sections: IN (left) and OUT (right).

• How to Read: The system will attempt to match each outflow (OUT) transaction with its original inflow (IN) transaction. You can see the customs document details for both sides, such as Customs Document Type, Submission No., ITEM CODE, and QTY to ensure traceability.

Tips & Important Notes

• This report is a very important audit and reconciliation tool for proving material usage in accordance with Customs regulations.

• The accuracy of this report is highly dependent on the traceability of data from the production and shipping processes.

• This module is a crucial work tool for the Exim (Export-Import) team to prepare accountability reports for Customs.

Item Exchange

Module Guide: Item Exchange/Return

Module Location

Inventory > Item Exchange

Module Objective

The Item Exchange module is used to manage and record the product exchange process. This module uniquely handles two sides of a transaction in one document: the receipt of goods being returned from a customer (Items Received) and the shipment of new goods as their replacement (Items Sent).

1. Main View (Item Exchange List)

The main page of this module displays a list of all item exchange documents that have been created.

View Explanation

• View: This page is a history of all goods exchange transactions.

• Filters: You can search for a specific document by Exchange Number, Category, or a Date range.

• Action Buttons:

  • [New Item Exchange]: The primary button to create a new item exchange document.

2. Steps to Record an Item Exchange

Step 1: Create a New Document

From the Main View, click the [New Item Exchange] button to open the Add Exchange form.

Step 2: Fill in Header Information

• Select the Customer who is making the exchange.

• Define the Exchange Date.

• Important: In the Reference Number field, select Delivery Order and find the original delivery order number. This is crucial for traceability.

Step 3: Record the Items Received (Returned Goods)

In the Items Received section, click [+] and add the goods being returned by the customer along with their quantity. This will trigger a goods receipt process (stock in).

Step 4: Record the Items Sent (Replacement Goods)

In the Items Sent section, click [+] and add the new goods that will be sent to the customer as a replacement. This will trigger a goods issue process (stock out).

Step 5: Confirm the Transaction

After all details are filled in, click the [Confirm] button to submit the exchange transaction for the approval process.

Workflow & Integrated Business Process

After being confirmed and approved, this transaction will trigger two stock movements simultaneously:

1. Stock In (Goods Receipt): Increases the stock of the returned item (possibly to a quarantine or QC warehouse location).

2. Stock Out (Goods Issue): Decreases the stock of the replacement item being shipped from the warehouse.

Tips & Important Notes

• This module is an important tool for the Customer Service and Warehouse teams in managing the return and exchange process efficiently.

• Always link the exchange transaction with the original Delivery Order Number to ensure validity and ease of tracking.

Item Exchange Inbox

Module Guide: Item Exchange Inbox

Module Location

Inventory > Item Exchange > Item Exchange Inbox

Module Objective

The Item Exchange Inbox module serves as the approval center for all Item Exchange documents that have been submitted. Every item exchange transaction (both the receipt of the returned item and the shipment of the replacement item) must be reviewed and approved here by an authorized manager before the stock movements are officially recorded in the system.

1. Main View (Document List)

The main page of this module is an "inbox" that displays all exchange documents requiring your action.

View Explanation

This page provides a summary of all exchange transactions that are awaiting approval.

• Filters: You can search for a specific document by Exchange Number, Item/Service Category, or a Date range.

• Document List: The table below will display all documents awaiting action, with columns such as Exchange Number, Customer Vendor, Reference Number, and Approval.

2. Approval Process Steps

The following is the standard workflow for an approver.

Step 1: Access the Inbox

Open the Item Exchange Inbox module to see the list of transactions that require approval.

Step 2: Review the Exchange Details

Click on one of the rows in the table to open the detail view of the exchange document. In the detail page, you can check all the information, such as the returned item, the replacement item, and the original delivery order reference.

Step 3: Provide Approval

After you review the exchange details in Step 2, you will find a button to grant approval (e.g., an "Approve" button) within that detail page. Click the appropriate button to complete the review process.

Workflow & Integrated Business Process

1. An Item Exchange document is created and confirmed.

2. The document automatically enters the queue in this Inbox.

3. A manager (e.g., a Customer Service Manager or Warehouse Head) reviews and approves it.

4. After approval, the system will finally process the two stock movements: increasing the stock of the returned item and decreasing the stock of the replacement item.

Tips & Important Notes

• This approval process is an important control step to ensure all return and exchange transactions are valid.

• This module is typically accessed by a Customer Service Manager or Warehouse Head.

Internal Material Requisition

Module Guide: Internal Material Requisition

Module Location

Inventory > Internal Material Requisition

Module Objective

The Internal Material Requisition module serves as a formal system for departments within the company to create a request to withdraw materials (such as raw materials, spare parts, or office supplies) from the warehouse. This process creates a Material Requisition document that can be tracked, approved, and becomes the basis for the warehouse to issue the goods.

1. Main View (Requisition List)

The main page of this module displays a list of all internal material requisition documents that have been created.

View Explanation

• View: This page is a history of all internal material requests. You can see the Request No., requesting Department, a brief Description, and the Approval Status.

• Filters: You can search for a specific document by number, a Date range, or Item/Service Category.

• Action Buttons:

  • [New]: The primary button to create a new internal material requisition.

2. Steps to Create an Internal Material Requisition

Step 1: Create a New Requisition

From the Main View, click the [New] button to open the Add Requisition form.

Step 2: Fill in Header Information

• Fill in request details such as the Request Type.

• Select the CostCenter (the department requesting and bearing the cost).

• Provide a clear Description regarding the purpose of the material request.

Step 3: Detail the Requested Items

1. In the table at the bottom, click the [+] icon to add a row.

2. Search for and select the Item/Service Code that you need.

3. Enter the requested quantity in the Quantity column.

Step 4: Submit the Requisition

After all the requested items have been entered, click the [Confirm] button to save and submit your request for the approval process.

Workflow & Integrated Business Process

• A created and confirmed requisition will go to an Inbox to be approved by a superior or department head.

• After approval, this requisition becomes the basis for the warehouse team to prepare and issue the goods, which is usually recorded via an Internal Delivery Order.

Tips & Important Notes

• This module is an important control tool for tracking internal material usage and charging its cost to the correct department.

• Ensure you select the correct CostCenter so that the internal cost allocation is accurate.

Internal Material Requisition Inbox

Module Guide: Internal Material Requisition Inbox

Module Location

Inventory > Internal Material Requisition > Internal Material Requisition Inbox

Module Objective

The Internal Material Requisition Inbox module serves as the approval center for all Internal Material Requisition documents that have been submitted. Every material request from a department must be reviewed and approved here by an authorized manager before the warehouse can proceed with the goods issue process.

1. Main View (Requisition List)

The main page of this module is an "inbox" that displays all internal material requisition documents requiring your action.

View Explanation

This page provides a summary of all requisitions that are awaiting approval.

• Filters: You can search for a specific document by Internal Material Requisition No., a Date range, or Item/Service Category.

• Requisition List: The table below will display all documents awaiting action, with columns such as Internal Material Requisition No., Request Date, and Approval Status.

2. Approval Process Steps

The following is the standard workflow for an approver.

Step 1: Access the Inbox

Open the Internal Material Requisition Inbox module to see the list of requisitions that require approval.

Step 2: Review the Requisition Details

Click on one of the rows in the table to open the detail view of that request. In the detail page, you can check all the information, such as what items are requested, their quantity, and which department the request came from.

Step 3: Provide Approval

After you review the request details in Step 2, you will find a button to grant approval (e.g., an "Approve" button) within that detail page. Click the appropriate button to complete the review process.

Workflow & Integrated Business Process

1. An Internal Material Requisition document is created and confirmed.

2. The document automatically enters the queue in this Inbox.

3. A manager (e.g., a Department Head or Warehouse Head) reviews and approves it.

4. After approval, the requisition becomes a valid instruction for the warehouse to prepare and issue the goods (Goods Issue).

Tips & Important Notes

• This approval process is an important control step for managing the usage of internal resources and ensuring every material request is valid.

• This module is typically accessed by the requesting Department Head or the Warehouse Head.

Internal Material Requisition Report

Report Module Guide: Internal Material Requisition Report

Module Location

Inventory > Internal Material Requisition > Internal Material Requisition Report

Module Objective

The Internal Material Requisition Report module is used to generate a summary report of all internal material requests that have been created. This report breaks down the total quantity of each requested item by the requesting department or cost center, making it very useful for analyzing and controlling internal material usage.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Warehouse Location:

  • Select the source warehouse from which the goods are being requested.

• Period:

  • Specify the date range of the requests in the From and To fields for the report you wish to see.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the warehouse and the time period you wish to analyze.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a matrix that summarizes the total requests for each item by various departments.

• Rows: Each row represents the Item Name that was requested.

• Columns: The columns in the middle represent each department or cost center that requested the goods (e.g., PROD for Production, MTC for Maintenance, QA for Quality Assurance).

• How to Read: The number inside the table shows the total quantity of an item that was requested by a specific department during the report period. The Total column on the far right sums up the total requests for that item from all departments.

Tips & Important Notes

• This report is very similar to the "Internal Delivery Order Report", however, this report tracks requests, while the previous report tracks actual issues.

• Use this report to analyze material needs per department and to assist in budget planning.

• This report is a recapitulation of the data created in the Internal Material Requisition module.

Material Requirements Planning

Module Guide: Material Requirements Planning

Module Location

Inventory > Material Requirements Planning

Module Objective

The Material Requirements Planning module is the center of the MRP process. Its purpose is to automatically calculate the total requirement of raw materials and components needed to meet the targets from the Production Plan or the Sales Forecast. The system will "explode" the BOM (Bill of Materials Explosion) of all finished goods that will be made to generate a list of gross material requirements.

1. Main View (Plan List)

The main page of this module displays a list of all MRP calculation processes that have been previously run.

View Explanation

• View: This page is a history of all MRP processes. You can see the process Code, the Data Source (reference document), and its planning period.

• Action Buttons:

  • [New]: The primary button to start a new MRP calculation process.

2. Steps to Run the MRP Process

Step 1: Create a New Calculation

From the Main View, click the [New] button to open the Add Plan form.

Step 2: Select the Requirement Source (Important!)

On the form that appears, define your calculation basis in the Standard Quantity section:

• Sales Forecast: If you want to calculate material needs to meet sales targets.

• Production Plan: If you want to calculate material needs to meet an existing production schedule.

Step 3: Select the Source Document

After selecting the source type, select the specific Document Number of the Sales Forecast or Production Plan to be used as a reference.

Step 4: Run the Calculation

Click the [Next] button. The system will start the MRP calculation process. This process will take all the finished goods from the source document, look at their recipes (Bill of Materials), and accumulate the total requirement for each raw material.

3. Process Results (Conceptual)

• After the process is complete, the system will generate a list of net requirements. This is the quantity of raw materials that actually needs to be purchased, after considering the stock already in the warehouse and goods that are currently on order.

• This requirements list then becomes the basis for the Purchasing team to create a Purchase Requisition or Purchase Order (PO).

Tips & Important Notes

• This module is the heart of production and purchasing planning in a manufacturing company.

• The accuracy of the MRP calculation is highly dependent on two things: the accuracy of the Bill of Materials (BOM) data for each product and the accuracy of the current inventory stock data.

• This is a crucial module for the PPIC (Production Planning and Inventory Control) team.

Transaction Journal

Report Module Guide: Inventory Transaction Journal

Module Location

Inventory > Transaction Journal

Module Objective

The Transaction Journal module within the Inventory menu is a reporting center that is used to display, search for, and audit all accounting journal entries that specifically originate from transactions that affect inventory. It is the primary tool for accountants to trace the financial impact of every goods movement.

1. Main View (Journal List)

The main page of this module is an interactive report that displays all journal entries relevant to inventory.

View and Function Explanation

• View: This page is the reporting center for all journals that impact inventory. You can see all transaction types, from sales shipments to purchase receipts.

• Filters: You can use various filters to search for specific transactions, such as a Date range, Chart of Accounts (a specific inventory account), or Costcenter.

• Types of Inventory Transactions Displayed: This module will display all journal entries generated from inventory activities, such as:

  • Sales Shipment Journal (Delivery Sales): Records the Cost of Goods Sold (COGS) when goods are shipped to customers.

  • Purchase Receipt Journal (Receive Purchase): Records the increase in inventory value when goods are received from suppliers.

  • Internal Journal: Records internal movements such as rework (e.g., WIP TRIAL MC TINGGI DI RECYCLE), warehouse transfers, or stock adjustments.

2. Viewing Journal Details

To see the Debit and Credit details of a transaction, click on the relevant row or Journal Number. The system will display a General Journal window that details its accounting entry.

In this example, a journal for the "WIP TRIAL MC TINGGI DI RECYCLE" transaction is shown, which records a value movement within the "WORK IN PROCESS" account.

Tips & Important Notes

• This module is the most important audit and traceability tool for the Inventory Accountant and Controller.

• Use this module to verify that all physical goods movements (receipts, shipments, adjustments, rework) have generated correct and accurate accounting journals.

• This is a read-only module that summarizes all the accounting impacts of all activities throughout the Inventory Module.

Inventory

Report Module Guide: Inventory Report (Stock Card)

Module Location

Inventory > Reports > Inventory

Module Objective

The Inventory Report module is used to generate a Stock Card or Stock Mutation Report. This report is a fundamental tool in inventory management that provides a detailed and chronological transaction history for each item. This report tracks every movement of goods (in and out) as well as the movement of its value.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each key parameter:

• Item/Service Code:

  • This is the primary filter to select one or more specific items for which you want to see the stock card.

• Period:

  • Specify the From and To date range for the transaction history to be displayed.

• Show Batch:

  • Check Yes if you want the report to display details per batch number for items that are managed by batch.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially selecting the Item/Service Code to be checked and specifying its Period range.

Step 2: Generate the Report

After all parameters are set, click one of the buttons at the bottom:

• [Display Report]: To preview the stock card directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a Stock Card or a subsidiary ledger for the selected item, which begins with a Beginning Balance.

Pay attention to the following key columns:

• In: Records every stock quantity addition (e.g., from purchase receipts or production output).

• Out: Records every stock quantity reduction (e.g., from sales shipments or internal usage).

• Available: Shows the quantity running balance after each transaction.

• Balance Value: Shows the total value (in Rupiah) of the inventory balance after each transaction.

Tips & Important Notes

• This report is the most fundamental audit and traceability tool for inventory.

• Use this report to investigate stock discrepancies, track the movement of a specific item, or verify the inventory valuation at the end of the month.

• This is a crucial operational report for the Warehouse, PPIC, and Inventory Accounting teams.

Item Inventory

Report Module Guide: Available Item/Service (Stock Status Report)

Module Location

Inventory > Reports > Item Inventory

Module Objective

The Available Item/Service Report module is used to generate a comprehensive inventory status report. This report provides a detailed overview of the quantity of each item, broken down by its various locations or statuses within the company's workflow (e.g., stock in the main warehouse, stock in the production area, quarantine stock, etc.).

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Item/Service Category Type:

  • Filter the report for a specific item category, such as FINISHED GOODS.

• Period:

  • Specify the reference date ("as of" date) for the stock position to be displayed.

• Expiry Status:

  • Filter to view items based on their expiry status (for example, to only display items that are about to expire).

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the Category Type and the Period.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the stock status report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a very detailed matrix table, providing a comprehensive view of stock distribution.

• Rows: Each row represents one Material Name or item.

• Columns: The columns show the quantity of that item in various different locations or statuses, such as Warehouse Stock, Production, Transfer, etc.

• How to Read: By reading a single row horizontally, you can see the total stock distribution of one item across all areas of the company on the selected date.

Tips & Important Notes

• This report provides a more holistic view of the stock position compared to a Stock Card, which only tracks the history of movements.

• Use this report for total stock reconciliation at month-end or to understand where your stock is located both physically and in the system.

• This is an advanced report that is very useful for Inventory Managers and the PPIC team.

Inventory Report by Transaction

Report Module Guide: Inventory Report by Transaction

Module Location

Inventory > Reports > Inventory

Module Objective

The Inventory Report by Transaction module is used to generate a highly detailed stock mutation report, where each stock movement (in and out) is displayed in separate columns based on its transaction type. This report provides an in-depth analysis of where stock is coming from and where it is being used.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Warehouse Location / Bin Name:

  • Filter the report for a specific warehouse location or bin.

• Item/Service Category Type:

  • Select the item category you wish to analyze, for example, RAW MATERIAL.

• Period:

  • Specify the transaction date range in the From and To fields.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the Category Type and the Period.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a matrix that details all stock movements per item.

• Rows: Each row represents one Item/Service Name.

• Columns:

  • Beginning Balance: The stock quantity at the start of the period.

  • Stock Movement Columns: The middle section of the report displays many columns that represent the various types of transactions that cause stock to move, such as RCV (Receive), WTA (Warehouse Transfer), ENT, INC, etc. The number in these columns shows the total quantity that moved due to that transaction type.

• How to Read: By reading a single row, you can see an item's beginning balance, plus all inflows from various sources, minus all outflows for various purposes, which results in the ending balance.

Tips & Important Notes

• This report is a more detailed version of the Stock Card, which breaks down the 'In' and 'Out' columns into their specific causes.

• Use this report for in-depth analysis of the sources of your stock inflows and the destinations of your stock outflows (for example, how much stock came in from purchases vs. from warehouse transfers).

• This is a very useful analysis report for Inventory Analysts and Controllers.

Warehouse Report

Report Module Guide: Warehouse Report (Warehouse Capacity Report)

Module Location

Inventory > Reports > Warehouse Report

Module Objective

The Warehouse Report module is used to generate a report that summarizes information regarding the capacity and utilization of every warehouse and storage location (bin). This report provides a high-level view of how full each storage location is.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Warehouse Type:

  • Select the type of warehouse you want to see, for example, SUBWH (Sub-Warehouse).

• Warehouse:

  • Filter the report for a specific warehouse or select All to display all warehouses of the selected type.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the Warehouse Type you wish to analyze.

Step 2: Generate the Report

After the parameters are set, click the [Display Report] button at the bottom.

3. Reading the Report (Report Content)

The generated report is a capacity summary for each warehouse and the bins within it.

• Report Structure: This report is grouped by Warehouse (e.g., UMS, MGFI), and within it, detailed by Bin (e.g., UMSFG - UMS FINISHED GOOD, UMSRM - UMS RAW MATERIAL).

• How to Read:

  • Maximum Warehouse Capacity: Shows the total capacity (in m³) of a main warehouse.

  • Details: For each Bin, the report displays its Usage percentage and its Maximum Capacity.

Tips & Important Notes

• This report is a summary version of the capacity information displayed in the Current Warehouse Usage module.

• Use this report to quickly monitor the space utilization rate in all your warehouses in a single view.

• This is a very useful report for Warehouse Managers and Logistics Managers for planning and optimizing storage space.

Slow-Moving Inventory

Report Module Guide: Slow-Moving Inventory

Module Location

Inventory > Reports > Slow-Moving Inventory

Module Objective

The Slow-Moving Inventory Report module is used to generate an inventory aging report. This report is specifically designed to identify items that are slow-moving or even potentially obsolete because they have been stored in the warehouse for too long. This is a crucial analysis tool for managing inventory health and optimizing working capital.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Warehouse Type / Location:

  • Select the specific Warehouse Type and Location whose inventory you want to analyze.

• Inventory Aging Period:

  • Important! Here you define the time range for each aging bucket in days. The example in the image: 1,90,91,180,270,360 will create columns for the ages of 1-90 days, 91-180 days, 181-270 days, and so on.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the warehouse location and set up the inventory aging period you wish to analyze.

Step 2: Generate the Report

After the parameters are set, click the [Display] button.

3. Reading the Report (Report Content)

The generated report will be a list of items classified by their age in the warehouse.

• Report Content (Conceptual): This report will display a list of items along with their value or quantity distributed into the aging columns you have defined (for example, columns for 1-90 days, 91-180 days, 181-270 days, >360 days).

Tips & Important Notes

• The main focus of this report is the items that fall into the oldest aging columns (e.g., >180 days). These items are the primary candidates for promotional programs, clearance sale discounts, or even a write-off of their book value.

• Running this report routinely (e.g., every month or quarter) is crucial for maintaining inventory health and preventing losses due to damaged or expired goods.

• This is a strategic report that is very important for Inventory Managers, Purchasing Managers, and Finance Managers.

Inventory Mutation

Report Module Guide: Inventory Mutation Report

Module Location

Inventory > Reports > Inventory Mutation

Module Objective

The Inventory Mutation Report module is used to generate a report that details all stock movement transactions (mutations) within a specific time period. Unlike a Stock Card which usually focuses on one item, this report can display all transactions for various items at once, thus providing a general overview of goods in-out activity.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Item/Service Category Type:

  • Filter the report for a specific item category.

• Period:

  • Specify the transaction date range in the From and To fields.

• Inventory Detail:

  • Select Summary to see total movements, or Detail to see each individual transaction.

• CostCenter:

  • Filter transactions that are only related to a specific department or cost center.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the Period and the Inventory Detail level.

Step 2: Generate the Report

After all parameters are set, click the [Display] button.

3. Reading the Report (Report Content)

The generated report is a chronological list of all stock movement transactions that match your filters.

This report displays details for each transaction, including:

• Date and Transaction Number.

• The Item/Service Code and Item/Service Name that moved.

• Qty: The quantity that moved. A negative number indicates goods out, and a positive number indicates goods in.

• Price and Total: The value of the movement transaction.

Report Features: This report is interactive, allowing you to search for specific data or export it to other formats like Excel or PDF using the buttons in the top-right corner.

Tips & Important Notes

• Use this report to get a general overview of warehouse activity in a single period.

• This report is very useful for tracking all types of movements, including sales, purchases, transfers, and adjustments, in a single view.

• This is a report that is frequently used by Warehouse Managers and Inventory Accountants for monthly analysis and reconciliation.

Stock Card Report

Report Module Guide: Stock Card Report

Module Location

Inventory > Reports > Stock Card Report

Module Objective

The Stock Card Report module is used to generate a "Stock Card," which is a report that provides a detailed and chronological transaction history for one or more specific items. This report is a fundamental tool for tracking every goods movement (in and out) and validating the ending balance.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Warehouse / Select Bin:

  • Filter the report for a specific warehouse location or bin.

• Item/Service Code:

  • The primary filter to select one or more specific items for which you want to see the stock card.

• Period:

  • Specify the transaction date range in the From and To fields.

• For Accounting:

  • Check Yes if the generated report requires value details or other accounting information.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially selecting the Item/Service Code to be checked and specifying its Period range.

Step 2: Generate the Report

After all parameters are set, click one of the buttons at the bottom:

• [Display Report]: To preview the stock card directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a Stock Card or a subsidiary ledger for the selected item, which begins with a Beginning Balance and details every transaction.

• Report Content (Conceptual): Although the details are not visible, this report will display:

  • The Beginning Balance.

  • A chronological list of transactions containing In, Out, and Ending Balance columns for quantity.

  • If the "For Accounting" option is selected, the report will also display the value (price) of each movement and the ending inventory value.

Tips & Important Notes

• This report is very similar to the Inventory Report (Stock Card) that was discussed previously, and most likely presents the same data with a slightly different format or filters.

• Use this report to investigate stock discrepancies or to track the complete history of a specific item.

• This is a crucial audit report for the Warehouse and Inventory Accounting teams.

Inventory Balance Report

Report Module Guide: Inventory Balance Report

Module Location

Inventory > Reports > Inventory Balance Report

Module Objective

The Inventory Balance Report module is used to generate a report that displays the ending balance (quantity and value) of inventory items as of a specific date. This is a "stock position" report that provides a quick overview of the total quantity and value of the inventory that the company holds.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Item/Service Category Type:

  • Filter the report for a specific item category, for example, FINISHED GOODS.

• Item/Service Code:

  • Select one or more specific items whose balance you want to see.

• Period:

  • Specify the reference date ("as of" date) for the balance to be displayed.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the Period (balance date) and item filters if necessary.

Step 2: Generate the Report

After all parameters are set, click the [Display Report] button at the bottom.

3. Reading the Report (Report Content)

The generated report is a list of items along with their balance quantity and value on the selected date.

This report displays important details such as:

• Item/Service Code and Item/Service Name.

• Inventory: The ending balance quantity of the item.

• Transaction Value: The total value (in Rupiah) of that inventory balance.

• Price Receipt: Likely shows the last purchase price or cost price.

Report Features: This report is interactive, allowing you to search for data or export it to other formats like Excel or PDF using the buttons at the top.

Tips & Important Notes

• Use this report to quickly find out the position and total value of your inventory at the end of the day, end of the month, or any other specific date.

• This report is a summary of all transactions recorded in the Stock Card up to the selected date.

• This is a very important report for accounting purposes (inventory valuation on the balance sheet) and for warehouse management.

Inventory Location

Report Module Guide: Inventory Location Report

Module Location

Inventory > Reports > Inventory Location

Module Objective

The Inventory Location Report module is used to generate a report that shows the physical position or location of every item in the warehouse. This report provides detailed information regarding which warehouse and bin an item is stored in, along with its quantity at each location. It is a crucial report for warehouse operations.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Warehouse Location / Bin Name:

  • Filter the report for a specific warehouse location or bin.

• Item/Service Category Type:

  • Select the item category you wish to analyze, for example, RAW MATERIAL.

• Item/Service Code:

  • Select one or more specific items whose location you want to see.

• Only Those with Inventory:

  • Check Yes to only display items that have a stock balance (greater than zero).

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, for example, select a Warehouse Location and Category Type to be checked.

Step 2: Generate the Report

After all parameters are set, click one of the buttons at the bottom:

• [Display Report]: To preview the inventory location report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a Stock Position Analysis list for the items you selected.

This report displays important details such as:

• Item/Service Code and Item/Service Name.

• Warehouse and Bin Location: Shows where the item is physically stored.

• Available: Consists of Qty (quantity) and Amount (value) columns for what is in that location.

• Lot No. and Expiry: Important information for items managed by lot or expiration date.

Tips & Important Notes

• Use this report to help warehouse operators in the goods picking process quickly.

• This report is very important for the Stocktake process, as it can be printed as a guide to know which items should be in each location.

• This is a crucial daily operational report for the Warehouse team.

Production Detail Report

Report Module Guide: Production Detail Report

Module Location

PPIC > Reports > Production Detail Report

Module Objective

The Production Detail Report module is used to generate a detailed report of all production activities that occurred within a specific period. This report typically displays the production output from each machine or production line, which references the related production documents.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Machine:

  • Select All to display the results from all machines, or Machine Code to focus on one specific machine.

• Period:

  • Specify the production date range in the From and To fields for the report you wish to see.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the date range and the machine filter (if needed).

Step 2: Generate the Report

After the parameters are set, click the [Display Report] button.

3. Reading the Report (Report Content)

The generated report is a chronological list of all production results that match your filters. This report is titled Section Transfer Report.

This report displays important details such as:

• The production Date.

• The Item/Service Code and Item/Service Name that was produced.

• The Machine and Section that produced the item.

• The Doc. Number and Work Order Number (Nomor SPK) as transaction references.

Report Features: This report is interactive, allowing you to search for specific data or export it to other formats like Excel or PDF using the buttons in the top-right corner.

Tips & Important notes

• This report is crucial for the PPIC and Production Manager teams to monitor daily production output.

• Use this report to track the performance of each machine or to reconcile the production output quantity with the work orders (SPK).

Reserved Item Report

Report Module Guide: Reserved Item Report

Module Location

Inventory > Reports > Reserved Item Report

Module Objective

The Reserved Item Report module is used to generate a report that details all inventory items that have been ordered or reserved for a specific purpose. This report is crucial for knowing how much stock is already "tied up" by transaction documents (such as Sales Orders or Internal Requisitions) and is not available for other uses.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• View based on:

  • Select Document to see items reserved based on their source document. You can choose the document type such as:

  • Sales Order: Reservations for customer orders.

  • Internal Material Requisition: Reservations for internal needs.

  • Warehouse Transfer: Reservations for transfers between warehouses.

• ReservedDate:

  • Specify the reservation date range in the Start Date and End Date fields.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the View based on document type and the date Period.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [View Report]: To preview the report directly on your screen.

• [View via Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a detailed list of all items with a reserved status.

This report displays important details such as:

• Document: The source document number that caused the reservation (e.g., a Sales Order number).

• Reservation date.

• Item/Service Code and Item/Service Name that is reserved.

• Document Quantity and Order Quantity: The quantity that is reserved.

Tips & Important Notes

• This report is crucial for the PPIC and Warehouse teams to know the actual "Available to Promise" stock amount, which is the physical stock minus the total reserved stock.

• Use this report to track your stock commitments to various types of requests.

Expired Goods

Report Module Guide: Expired Goods Report

Module Location

Inventory > Reports > Expired Goods

Module Objective

The Expired Goods Report module is used to generate a list of all items in inventory that will or have already passed their expiration date. This report is crucial for companies that manage goods with a limited shelf life (such as food, beverages, or chemicals) to minimize losses and ensure product quality.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Warehouse / Item/Service Category Type:

  • Filter the report for a specific Warehouse or Category Type (e.g., FINISHED GOODS).

• Period:

  • Specify the date range in the From and To fields.

• Based on:

  • Important! Select the basis for the period filter:

  • Arrival Date: Displays goods that were received in that period.

  • Expiry Date: Displays goods that will expire in that period.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need. To see goods that will expire this month, select Based on: Expiry Date and set the Period for the current month.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a list of items managed by batch or lot, along with their expiration dates.

This report displays important details such as:

• Item/Service Code and Item/Service Name.

• Arrival Date: When this batch of goods was received.

• Expiry Date: The expiration date for that batch.

• Lot No: The batch or lot number of the goods.

• Qty: The remaining quantity of that batch.

Tips & Important Notes

• Use this report proactively to identify goods that are approaching their expiration date.

• Goods nearing expiration can be prioritized for sale (using the FEFO - First Expired, First Out principle) or be used for a promotional program to avoid losses.

• This report is crucial for the Warehouse Management, Quality Control (QC), and Sales teams.

Item/Service List

Report Module Guide: Item/Service List Report (Item Master Report)

Module Location

Inventory > Reports > Item/Service List

Module Objective

The Item/Service List Report module is used to generate a master list report of all items registered in the system. This report provides a comprehensive view of each item, including basic details, cost information, and price.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Location:

  • Filter the report to display items that exist in a specific location or warehouse.

• Item/Service Category Type:

  • Select the main category type you wish to display, for example, FINISHED GOODS.

• Status:

  • Check the appropriate boxes to filter items by their properties: Purchase, Sell, or Inventory.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, such as the Location and Category Type.

Step 2: Generate the Report

After all parameters are set, click the [Print] or [Export to MS Excel] button at the bottom.

3. Reading the Report (Report Content)

The generated report is a complete list of all master items that match your filters.

This report displays important details such as:

• Item/Service Code and Name.

• Current Value: The total value of the existing stock.

• Costing Method: The inventory valuation method used (e.g., AVG).

• Purchase and Sales Details: Shows information on the last purchase price and a breakdown of selling prices (for example, for Retail, Store, Distributor).

Tips & Important Notes

• This report is the printed or exported version of the master data managed in the Item/Service List module.

• Use this report for auditing master data or for distributing the product and price list to the sales team.

• This is a fundamental reference report that is crucial for almost all departments, including Purchasing, Sales, Warehouse, and Accounting.

Kokola Group Shipment vs Receipt

Report Module Guide: Kokola Group Shipment vs Receipt

Module Location

Inventory > Reports > Delivery Order > Kokola Group Shipment vs Receipt

Module Objective

The Kokola Group Shipment vs Receipt Report is a reconciliation report used to compare the quantity of goods shipped (based on a Delivery Order) with the quantity of goods received (based on a Goods Receipt) for internal transactions within the "Kokola Group". This report is crucial for identifying any differences or discrepancies during the process of transferring goods between entities or branches.

1. Report Parameters (Filter)

The main page of this module is a simple form for defining the report period.

• Delivery Order Date:

  • Specify the shipping date range in the From and To fields that you wish to reconcile.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the Delivery Order date range you wish to check.

Step 2: Generate the Report

After the parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the comparison report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report will be a side-by-side comparison list for each item shipped in the selected period.

Key Column Explanation

• Delivery Order Number: The shipping document from the source location.

• Shipped Quantity: The quantity recorded when the goods were shipped.

• Goods Receipt Number: The receipt document at the destination location.

• Received Quantity: The quantity recorded when the goods were received.

• Difference Quantity: The most important column. This column automatically calculates the difference between the Shipped Quantity and the Received Quantity. A non-zero number in this column indicates a problem that requires further investigation.

Tips & Important Notes

• This is a very important audit and control tool for intercompany or inter-branch transactions within a group.

• Use this report to track goods that are lost, short-shipped, or damaged during transit and to ensure the accuracy of stock records at both the shipping and receiving locations.

• This is a crucial report for the Internal Logistics and Internal Audit teams.

BC Source Document

Report Module Guide: BC Source Document

Module Location

Inventory > Reports > BC Source Document

Module Objective

The BC Source Document Report module is a special Customs (BC) report that is used to display the details of a single, specific customs source document. This report is used to review the item details, quantity, and value that were recorded on a BC submission document.

1. Report Parameters (Filter)

The main page of this module is a simple form for selecting the document to be displayed.

• Submission Number / Registration / Name / Date:

  • This is the primary filter to search for and select one specific BC submission document from the existing list.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Select the BC document you wish to see the details of from the dropdown.

Step 2: Generate the Report

After the document is selected, click the [Display Report] button.

3. Reading the Report (Report Content)

The generated report is a complete detail of the BC document you have selected.

This report displays important details relevant to Customs, such as:

• DOKPN, NOPEN, NAJU: Customs document reference numbers.

• NAMA BRG: The name of the goods as per the BC document.

• QTY, NILAI PABEAN: The Quantity and Customs Value of the goods.

• BM, PPN IMPOR, PPH: A breakdown of Import Duty, Import VAT, and Income Tax.

Report Features: This report is interactive, allowing you to export the data to other formats like Excel or PDF using the buttons in the top-right corner.

Tips & Important Notes

• Use this report to perform verification or an audit on the details of a BC document that has already been submitted.

• This is an important inquiry tool for the Exim (Export-Import) team to re-check the data that has been reported to Customs.

Delivery Order List

Report Module Guide: Delivery Order List

Module Location

Inventory > Reports > Delivery Order List

Module Objective

The Delivery Order List report module is used to generate a detailed report of all goods shipment documents (Delivery Orders) that have been created within a specific period. This report is crucial for summarizing all shipping activities to customers or for internal purposes.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Type:

  • Select the main category type you wish to display, for example, FINISHED GOODS.

• Shipment Note Type:

  • An important filter to choose the type of delivery order to be viewed, such as Sales Delivery Order (for customers), Purchase Return Delivery Order (returns to vendors), or Internal Delivery Order.

• Date:

  • Specify the shipping date range in the From and To fields.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the Shipment Note Type and Date.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a detailed list of all Delivery Orders that match your filters.

This report displays important details such as:

• Number: The Delivery Order number.

• Shipment date.

• Customer and Shipping Address.

• Item Code, Item/Service Name, and Qty that was shipped.

Report Features: This report is interactive, allowing you to search for specific data or export it to other formats like Excel or PDF using the buttons in the top-right corner.

Tips & Important Notes

• This report is a recapitulation of all documents created in the Delivery Order module.

• Use this report to summarize daily or monthly shipments, or to track shipments to a specific customer.

• This is a crucial operational report for the Logistics, Warehouse, and Sales Administration teams.

SN Report Based On User

Report Module Guide: SN Report Based On User

Module Location

Inventory > Reports > SN Report Based On User

Module Objective

The SN Report Based On User module is used to generate a report that tracks transaction activities (most likely related to Delivery Orders or shipments) performed by each employee or user. This report groups all transactions by the name of the employee who processed them. "SN" likely stands for Shipment Number or Surat Jalan Number.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Employee name:

  • Select All to display the report for all employees, or Selected to focus on one or more specific employees.

• Range From:

  • Specify the transaction date range in the From and To fields.

• Status:

  • Filter the report based on a specific document status.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the date range and the employee filter (if needed).

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report will be a list of transactions, grouped by employee name.

• Report Structure: This report is divided into several sections, where each section is dedicated to one Employee name.

• Report Content: Under each employee's name, the report will detail all the transactions they processed, displaying details such as Delivery Order Number, Delivery Order Date, Item/Service Code, and Quantity.

Tips & Important Notes

• Use this report to monitor the productivity or workload of each sales administration or warehouse staff member.

• This report is useful for internal audit purposes to track who was responsible for a specific shipment transaction.

Outstanding SN Report

Report Module Guide: Outstanding SN Report

Module Location

Inventory > Reports > Outstanding SN Report

Module Objective

The Outstanding SN Report module is used to generate a report that details all Delivery Orders (SN - Shipment Number) whose status is still pending or not yet fully completed. This report is important for tracking shipments that have not yet arrived, have not been confirmed by the customer, or for which the next process (such as invoicing) is not yet finished.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Account Name:

  • Select All to display the report for all customers, or Selected to focus on one or more specific customers.

• Range From:

  • Specify the transaction date range in the From and To fields.

• Currency:

  • Set the reporting currency preference, whether based on Transaction Currency or Base Currency.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the date range and the customer filter (if needed).

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report will be a list of Delivery Orders with a pending status, grouped by customer name.

• Report Structure: This report is divided into several sections, where each section is dedicated to one Account Name (Customer Name).

• Report Content: Under each customer's name, the report will detail all Delivery Orders that are still outstanding, displaying details such as the Delivery Order Number, Delivery Order Date, Item/Service Code, and Quantity.

Tips & Important Notes

• Use this report to follow up on shipments that are not yet complete.

• This report is very useful for the Sales Administration and Customer Service teams to track shipment status and ensure all processes through to billing run smoothly.

Warehouse Return

Report Module Guide: Warehouse Return Report

Module Location

Inventory > Reports > Transaction > Warehouse Return

Module Objective

The Warehouse Return Report module is used to generate a report that specifically tracks all internal goods return activities. This report is used to monitor goods returned from one location to another, for example, the return of leftover raw materials from the production floor back to the raw materials warehouse.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Return Category:

  • The primary filter to select the type or reason for the goods return that you wish to see.

• Period:

  • Specify the return transaction date range in the From and To fields.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the Return Category and the Period you wish to analyze.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the return report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report will be a list of goods return transactions that match your filters.

This report tracks the return flow by displaying columns such as:

• Shipping Whs.: The location or department that is returning the goods (e.g., Production).

• Qty. Shipped: The quantity of goods sent back.

• Receiving Whs.: The main warehouse that is receiving the returned goods.

• Qty. Received: The quantity recorded upon receipt at the destination warehouse.

Tips & Important Notes

• This report is essentially a Warehouse Transfer Report that is specifically filtered for 'Return' transactions.

• Use this report to monitor and reconcile the return of leftover raw materials from production or the return of goods from subcontractors.

• This is an important control report for the PPIC and Warehouse Manager teams.

Report History Per Barcode

Report Module Guide: History per Barcode

Module Location

Inventory > Reports > Transaction > Report History per Barcode

Module Objective

The Report History Per Barcode module is used to generate a report that displays the stock movement history (in and out) of an item, grouped by its unique barcode code. This report is a highly detailed tool for traceability and stock reconciliation at the individual unit or batch level.

1. Report View and How to Use

The main page of this module is an interactive report for tracing history by barcode.

How to Use

1. Select Item: Use the Item Code filter at the top to search for and select the item whose history you wish to see.

2. View Results: After you select an item, the table below will automatically display the history data for each barcode associated with that item.

2. Reading the Report (Report Content)

The report will display one row for each unique barcode of the item you selected.

Column Explanation

• Barcode Code: The unique recorded barcode.

• In: The total quantity ever received into the warehouse with this barcode.

• Out: The total quantity ever issued from the warehouse with this barcode.

• Ending Stock: The ending balance calculated by the system (In - Out).

• Stock Update & Difference: These columns are likely used for a reconciliation or stocktake process per barcode, where you can compare the system stock with the physical stock per barcode.

Tips & Important Notes

• This report is very useful for companies that use barcodes to track each individual unit or batch of goods.

• Use this report to trace the specific history of a product batch in case of a quality complaint or for audit purposes.

• This is a very detailed traceability tool that is crucial for the Warehouse and Quality Control (QC) teams.

Inventory Adjustment Report

Report Module Guide: Inventory Adjustment Report

Module Location

Inventory > Reports > Inventory Adjustment Report

Module Objective

The Inventory Adjustment Report module is used to generate a detailed report of all inventory adjustment documents that have been created. This report summarizes all stock correction activities, whether they originate from the Stocktake process or from the ad-hoc Inventory Adjustment module.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Type:

  • Select the main category type you wish to display, for example, FINISHED GOODS.

• Date:

  • Specify the date range of the adjustment transactions in the From and To fields.

• Sort by:

  • Choose the sorting basis for the data in the report, whether by Date or Inventory Adjustment Number.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the item Type and the Period you wish to review.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a chronological list of all stock adjustment transactions that match your filters.

This report displays important details such as:

• Date and Inventory Adjustment Number.

• Memo: The reason for the adjustment.

• Item/Service Code and Item/Service Name that was adjusted.

• Qty: The adjustment quantity (can be positive for an increase or negative for a decrease).

Tips & Important Notes

• This report is a recapitulation of all documents created in the Stocktake and Inventory Adjustment modules.

• Use this report for audit purposes to review all stock adjustments that occurred in a period and to ensure that each adjustment has a valid reason.

• This is a crucial control report for Inventory Accountants and Internal Audit.

Picking List Report

Report Module Guide: Picking List Report

Module Location

Inventory > Reports > Transaction > Picking List Report

Module Objective

The Picking List Report module is used to generate a report that summarizes all goods "picking" activities. Based on the context of previous modules, this most likely refers to a recapitulation of the Shipment List or manifest documents that have been created, which record the picking of goods from the warehouse for shipment.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Date:

  • Specify the date range in the From and To fields to see the picking lists for that period.

• Area:

  • Filter the report by the shipment's destination area, whether All or a Selected area.

• Type:

  • Select Summary to see totals, or Detail to see a breakdown per transaction.

• Sort by:

  • Choose the sorting basis for the data in the report, for example, by Customer.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the date range and other filters you need.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a list of all goods picking or shipment activities.

This report displays important details such as:

• The Picking List Number.

• The destination Customer.

• The Picking List Date.

• The destination Area.

• The status of the pick/shipment.

Tips & Important Notes

• This report is a recapitulation of the data managed in the Shipment List module.

• Use this report to review all manifests or picking lists that have been created in a single period for auditing or logistics performance analysis.

Shipment Planning Report

Report Module Guide: Shipment Planning Report

Module Location

Inventory > Reports > Transaction > Shipment Planning Report

Module Objective

The Shipment Planning Report module is used to generate a report that summarizes all Shipment Planning documents that have been created. This report is used to review all trip plans or shipping routes within a specific period.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Date:

  • Specify the date range in the From and To fields to see the shipment plans for that period.

• Area:

  • Filter the report by destination area, whether All or a Selected area.

• Type:

  • Select Summary to see totals, or Detail to see a breakdown per transaction.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the date range and other filters you need.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a list of all shipment planning activities.

This report displays important details such as:

• The Shipment Planning Number.

• The Goods Shipment Date.

• Vehicle Data and Driver Data.

• The Delivery Order numbers included in the plan.

• The destination Customer.

Tips & Important Notes

• This report is a recapitulation of the data managed in the Shipment Planning module.

• Use this report to review route efficiency and the punctuality of planned shipping schedules. This is an important evaluation report for a Logistics Manager.

Shipment Plan vs Actual Shipment

Report Module Guide: Shipment Plan vs Actual Shipment

Module Location

Inventory > Reports > Transaction > Shipment Plan vs Actual Shipment

Module Objective

The Shipment Plan vs Actual Shipment Report module serves as a performance analysis tool to compare the planned shipping schedule with its actual execution data. This report is crucial for measuring on-time performance, route efficiency, and the performance of the shipping team.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Date:

  • Specify the date range in the From and To fields to see the plan vs. actual comparison for that period.

• Vehicle:

  • Select All to display all vehicles, or Selected to focus on one or more specific vehicles.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the date range and the vehicle filter (if needed).

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the comparison report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report will be a side-by-side comparison table between planned data and actual data.

This report is divided into three main sections for each trip:

1. Planned: Displays the schedule that was planned, such as Start Work, End Work, and Distance.

2. Actual: Displays the actual execution data, such as Start Work, End Work, and actual Distance.

3. Difference: Calculates the variance between the plan and the actual, which highlights any delays or differences in distance.

Tips & Important Notes

• This report is a very important performance evaluation tool for a Logistics Manager.

• Use the Difference data to identify problems in the shipping process, such as inefficient routes, frequent delays, or vehicle issues.

• This report's data is pulled from a comparison between the Shipment Planning module and actual data that might be input by the driver or a tracking system.

Bin Transfer Report

Report Module Guide: Bin Transfer Report

Module Location

Inventory > Reports > Transaction > Bin Transfer Report

Module Objective

The Bin Transfer Report module is used to generate a historical report that details all goods transfer activities between storage locations (bins) within the warehouse. This report is used to track and audit all internal stock movements.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Location:

  • Select All to display transfers in all locations, or Selected to focus on one or more specific locations.

• Transfer Date:

  • Specify the date range of the transfer transactions in the From and To fields.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the date range and the location filter (if needed).

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a list of all bin transfer transactions that match your filters.

This report displays important details such as:

• Bin Transfer Number: The transfer document number.

• Item Code and Item Name: The goods that were moved.

• Bin Source: The origin location of the goods.

• Bin Destination: The destination location of the goods.

• Qty: The quantity of goods moved.

Tips & Important Notes

• This report is a recapitulation of the data managed in the Bin Transfer module.

• Use this report for audit purposes to ensure all physical goods movements within the warehouse have been correctly recorded in the system.

• This is an important operational report for the Warehouse Head and the Internal Audit Team.

Receipt List

Report Module Guide: Goods Receipt Report

Module Location

Inventory > Reports > Receipt List

Module Objective

The Goods Receipt Report module is used to generate a detailed report of all goods receipt activities. This report summarizes all Receipt Notes or Goods Receipt Notes (GRNs) that have been created within a specific period, and is crucial for summarizing all receipt activities from suppliers.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Shipper:

  • Select the source of the shipment, for example, Supplier (Vendor).

• Type:

  • Select the main category type you wish to display, for example, RAW MATERIAL.

• Goods receipt report type:

  • An important filter to select the type of receipt, such as Purchase goods receipt report.

• Date:

  • Specify the receipt date range in the From and To fields.

• Grouped by:

  • Choose how the data will be grouped, for example, by Supplier or Purchase Order Number.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the Report type, Date, and Grouped by options.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a detailed list of all Receipt Notes that match your filters, grouped according to your selection.

This report displays important details such as:

• SJ Supplier Nomor: The Supplier's Delivery Order Number.

• Bukti Barang Masuk: The internal Goods Receipt Note (GRN) number.

• PurchaseOrderDate: The Purchase Order Date.

• Pemasok: The Supplier's Name.

• Item/Service Code, Item/Service Name, and Qty received.

Tips & Important Notes

• This report is a recapitulation of all documents created in the Goods Receipt module.

• Use this report to summarize daily or monthly receipts, or to track the receipt history from a specific supplier.

• This is a crucial operational report for the Receiving Warehouse, Purchasing, and Accounts Payable (AP) teams.

Account Link Report

Report Module Guide: Account Link Report

Module Location

Inventory > Reports > Account Link Report

Module Objective

The Account Link Report module is used to generate a report that displays the mapping between each inventory item and its related accounts in the General Ledger. This report is crucial for ensuring that every inventory transaction will be automatically journalized to the correct accounting accounts.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Item/Service Category Type:

  • Filter the report for a specific main category type (e.g., FINISHED GOODS, RAW MATERIALS) or select [All] to display all.

• Category:

  • Filter further by a more specific item sub-category.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the category filters you wish to review.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the account link report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a list of items along with the General Ledger accounts linked to them.

This report displays important details such as:

• Item/Service Code and Item/Service Name.

• Account for purchasing item/service: The account that will be debited when this item is purchased.

• Account for purchase discounts: The account used to record purchase discounts for this item.

• Account for WIP: The Work in Process account related to this item if it is used in production.

Tips & Important Notes

• This report is a crucial audit tool for Accountants and System Implementors to ensure all initial setup is correct.

• An error in the account mapping here will cause incorrect automated journaling in all inventory-related transactions (purchasing, sales, production).

• This data is usually set up at the item master data level (in the Item/Service List module), and this report functions as a recapitulation for verification.

Price Archive Report

Report Module Guide: Price Archive Report

Module Location

Inventory > Reports > Price Archive Report

Module Objective

The Price Archive Report module is used to generate a historical report regarding changes in the purchase price of goods from suppliers. This report is used to track the history of purchase prices over time.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Approval Date:

  • Specify the date range in the From and To fields to see the archive of price changes in that period.

• Type:

  • Select All Suppliers to display the history from all vendors, or Selected Supplier to focus on one or more specific vendors.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the date range and the supplier filter (if needed).

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a history list of purchase price changes.

• Report Content (Conceptual): Although the details are not visible, this report will likely display:

  • The date of the price change.

  • The Supplier Name.

  • The Item Code and Name.

  • The Old Purchase Price.

  • The New Purchase Price.

  • Who made the change.

Tips & Important Notes

• This report is an important audit tool for the Purchasing team to track price fluctuations from suppliers.

• Use this report to analyze raw material price trends and as a basis for negotiations with suppliers.

Price Comparison Report

Report Module Guide: Price Comparison Report

Module Location

Inventory > Reports > Price Comparison Report

Module Objective

The Price Comparison Report module is used to generate a report that compares prices (both purchase price and selling price) for one or more items. This report is very useful for the Purchasing team to compare price offers from various suppliers, or for the Sales team to analyze selling price structures.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Category Type / Item/Service Category:

  • Filter the report for a specific item type or sub-category.

• Item/Service:

  • Select All or Selected to focus on specific items.

• Type:

  • Important! Choose the basis for the price comparison:

  • Purchasing: To compare purchase prices from suppliers.

  • Sales: To compare selling prices.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially selecting the comparison Type (Purchasing/Sales) and the relevant items.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report will be a price comparison list for each item you selected.

• Report Structure: This report displays each Item/Service Code in its own block. Under each item, there will be space to display the comparison data (for example, a list of prices from several suppliers if you selected the "Purchasing" type).

Tips & Important Notes

• When used with the Purchasing type, this report is a very effective tool for the Purchasing team to make better buying decisions by comparing prices between vendors.

• When used with the Sales type, this report helps the Sales team to analyze the various levels of selling prices that may apply to a single item.

Reorder Report

Report Module Guide: Reorder Report

Module Location

Inventory > Reports > Reorder Quantity

Module Objective

The Reorder Report module is used to generate a list of items whose stock has reached or fallen below the reorder point. This report automatically compares the actual stock with the Minimum Stock that has been set up, and recommends which items need to be repurchased immediately to prevent stockouts.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Warehouse Location:

  • Filter the report for a specific warehouse location or select [All].

• Item/Service Category Type:

  • Select the item category you wish to analyze, for example, RAW MATERIAL.

• Item Status:

  • Select the item status, generally Active.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the Warehouse Location and Category Type.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a list of items along with their recommended reorder quantity.

This report displays important details such as:

• Item/Service Code and Item/Service Name.

• Warehouse: The location where the item's stock is located.

• Reorder Quantity: The recommended quantity to be ordered. If the number in this column is greater than zero, it means the item's stock is already below the minimum level.

Tips & Important Notes

• This report is the automatic result of the settings you created in the Minimum Stock Setup module.

• Use this report as a daily or weekly basis for the Purchasing team to create new Purchase Orders (POs).

• This is a crucial proactive tool for ensuring a smooth supply chain and preventing production stoppages due to material shortages.

Virtual Warehouse Report

Report Module Guide: Virtual Warehouse Report

Module Location

Inventory > Reports > Virtual Warehouse Report

Module Objective

The Virtual Warehouse Report module is used to generate a report that displays the stock position within a "virtual warehouse". A virtual warehouse is a concept for representing stock that may not physically be at the main location, or for grouping stock with a specific purpose (e.g., stock allocated for e-commerce, promotional goods, etc.) without having to create a new physical warehouse location.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Warehouse Type:

  • Select the type of warehouse you want to see, for example, SUBWH (Sub-Warehouse).

• Virtual Warehouse:

  • Select All to display all virtual warehouses, or Selected to focus on one or more specific virtual warehouses.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the Warehouse Type and the Virtual Warehouse you wish to analyze.

Step 2: Generate the Report

After the parameters are set, click the [Display Report] button at the bottom.

3. Reading the Report (Report Content)

The generated report is a stock position list for the items that are in the selected virtual warehouse.

This report displays important details such as:

• Item/Service Code and Item/Service Name.

• Available: The quantity of the item that is in the virtual warehouse.

• Ordered: The quantity that has been ordered or allocated from this virtual warehouse's stock.

Tips & Important Notes

• This report is very useful for managing stock that has special treatment without having to physically separate it in the warehouse.

• The "Virtual Warehouse" concept is often used in modern business to separate stock that is sold on different channels (e.g., physical stores vs. online marketplaces).

• This is a useful report for Inventory Managers and E-commerce Managers.

Item Transfer Tracking Report

Report Module Guide: Item Transfer Tracking Report

Module Location

Inventory > Reports > Item Transfer Tracking Report

Module Objective

The Item Transfer Tracking Report module is used to generate a report that tracks or traces item transfer activities, both In and Out. This report provides a detailed view of stock movements between warehouses or locations.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Inventory:

  • Select the type of movement you wish to see:

  • In: To only display goods receipt transactions.

  • Out: To only display goods shipment transactions.

  • All: To display both types of transactions.

• Transfer Date:

  • Specify the transaction date range in the From Date and To date fields.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the movement type (In/Out) and the date period.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a list of item transfer transactions according to the filters you have selected.

• Report Structure: This report likely has two parts or different formats depending on whether you are viewing 'in' or 'out' data. Its columns will detail each transaction, including Warehouse shipment number, Transfer Date, Shipped from, Item/Service Code, Quantity, and Total Price.

Tips & Important Notes

• Use this report to audit and reconcile all stock movements between locations in a specific period.

• This report provides good traceability for every item that moves from one warehouse to another.

• This is an important report for Warehouse Managers and Internal Audit Teams.

Warehouse Remnant Transfer Report

Report Module Guide: Warehouse Remnant Transfer Report

Module Location

Inventory > Reports > Warehouse Remnant Transfer Report

Module Objective

The Warehouse Remnant Transfer Report module is used to generate a report that tracks the remaining quantity from uncompleted warehouse transfer transactions. This report is useful for monitoring goods that have been shipped but have not yet been fully received at the destination warehouse.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Receipt Date:

  • Specify the date range in the From Date and To date fields to see the transfer transactions for that period.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the date range you wish to check.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a list of transfer transactions that likely still have a remaining balance or have not been fully received.

This report displays important details such as:

• Warehouse Receipt Number: The receipt document number at the destination warehouse.

• Warehouse Shipment Number: The shipment document number from the source warehouse.

• Quantity to be Transferred: The quantity that was supposed to be transferred.

• Quantity Received: The quantity that has already been received.

• Remaining Quantity: The difference between the quantity transferred and the quantity received.

Tips & Important Notes

• This report is very useful for following up on inter-warehouse shipments that are incomplete or have quantity discrepancies.

• Focus on rows that have a number in the Remaining Quantity column to identify problems in the transfer process.

• This is an important control report for the Logistics team and Warehouse Managers.

PLInvoice

Report Module Guide: PLInvoice (Profit & Loss per Invoice)

Module Location

Inventory > Reports > plinvoice

Module Objective

The PLInvoice Report module most likely stands for Profit & Loss per Invoice. Its purpose is to generate a report that analyzes the profitability of each sales invoice. This report will detail the Cost of Goods Sold (COGS) and the selling price for each item within the invoice to calculate the profit margin.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Invoice Date:

  • Specify the invoice date range in the From and To fields that you wish to analyze.

• Currency:

  • Select the currency basis to be used in the report.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the invoice date range you wish to analyze.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a profitability analysis per invoice.

Based on the visible column titles, this report will display:

• Invoice Date: The date and number of the invoice.

• Invoice Delivery Order: The related delivery order number.

• Item/Service Code and Item/Service Name: The item that was sold.

• Qty: The quantity that was sold.

• Total COGS Amount: The total Cost of Goods Sold for that item.

• Margin: The profit earned (Selling Price - COGS).

• Revenue Percentage: The profit margin as a percentage.

Tips & Important Notes

• This report is a very powerful analysis tool for Sales Managers and Finance Management to understand which products or customers are the most profitable.

• The accuracy of this report is highly dependent on having correct COGS (Cost) and selling price data in the system.

Item/Service Conversation Report

Report Module Guide: Item/Service Conversion Report

Module Location

Inventory > Reports > Item/Service Conversion Report

Module Objective

The Item/Service Conversion Report module is used to generate a detailed report of all inventory conversion or transformation activities. This report summarizes the transactions recorded in the Inventory Transformation module, showing what items were used (input) and what items were produced (output) in processes like rework or kitting.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Date:

  • Specify the date range of the conversion transactions in the From and To fields.

• Items to be Converted:

  • Filter the report by the input (source) items, whether All or Selected.

• Converted Into:

  • Filter the report by the output (resulting) items, whether All or Selected.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the date range and other filters you need.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a detailed list of every conversion transaction.

• Report Structure: The report displays each conversion transaction in a single block, which is divided into two sections:

  • Items to be Converted: A list of the input items consumed in the process.

  • Converted Into: A list of the output items produced from the process.

• Transaction Details: For each transaction, you can see the Conversion Number, Conversion Date, and the details of the Item/Service Code and Qty for each input and output item.

Tips & Important Notes

• This report is a recapitulation of the data recorded in the Inventory Transformation module.

• Use this report to analyze rework or kitting activities, including the efficiency of material usage and the production yield.

• This is an important report for the PPIC and Cost Accounting teams.

Conversion

Report Module Guide: Conversion Report

Module Location

Inventory > Reports > Conversion

Module Objective

The Conversion Report module is used to generate a detailed report regarding inventory conversion or transformation activities that occurred on a specific date and shift. This report provides a specific view of rework or kitting processes run by the production or warehouse team.

1. Report Parameters (Filter)

The main page of this module is a simple form for defining the report filters.

Here is an explanation for each parameter:

• Date:

  • Select the specific date of the conversion activity for which you want to see the report.

• Shift:

  • Select the work shift (e.g., 1, 2, or 3) to focus the report on the activities of that shift.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Select the Date and Shift you wish to review.

Step 2: Generate the Report

After the parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a list of every conversion transaction that occurred on the selected date and shift.

This report displays important details such as:

• The Conversion Date and Shift.

• Conversion No.: The conversion transaction document number.

• Item Code and Item Name: The items involved in the conversion process (both input and output).

• Result Qty: The resulting quantity from the conversion process.

Tips & Important Notes

• This report is a more focused version of the Item/Service Conversion Report, allowing you to see activity per shift.

• Use this report for daily monitoring of rework or other transformation activities on the production floor or in the warehouse.

• This is an important operational report for Production Supervisors and Warehouse Heads.

Shipping & Receiving Performance Report

Report Module Guide: Shipping & Receiving Performance Report

Module Location

Inventory > Reports > Shipping & Receiving Performance Report

Module Objective

The Shipping & Receiving Performance Report module is used to generate an analytical report that measures shipping performance. This report compares the promised or scheduled shipment date with the actual shipment date to identify delays.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Report Type:

  • Select the type of performance you want to analyze, for example, Shipping Performance.

• Customer:

  • Select All to display all customers, or Selected to focus on one or more specific customers.

• Date:

  • Specify the date range in the From and To fields to see the performance for that period.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the date range and other filters you need.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a list of shipments, grouped by customer.

This report displays important details such as:

• Estimated Shipment Date: The scheduled or promised shipment date.

• Actual Shipment Date: The date when the goods were actually shipped.

• Status: Shows the shipment status, for example, Late if the actual date exceeds the scheduled date.

Tips & Important Notes

• Use this report to measure your shipping service level, both overall and per customer.

• Analysis of the Status column helps to identify which customers frequently experience shipping delays.

• This is an important performance evaluation report for Logistics Managers and Sales Managers.

Goods Shipment

Module Guide: Goods Shipment (Shipment Order)

Module Location

Inventory > Goods Shipment

Module Objective

The Goods Shipment module is used to create the Sales Delivery Order (Surat Jalan), which is the official document for the shipment of goods to a customer. This process is based on a Sales Order that already exists and is ready to be shipped.

1. Main View (Shipment Order List)

The main page of this module displays a list of all shipment documents that have been created.

View Explanation

• View: This page is a history of all shipments. You can monitor the Shipment Order Number, the related Sales Order Number, and the Customer.

• Filters: Use the Shipment order type filter to select Sales Delivery Order and filter by a date range.

• Action Buttons:

  • [Create Goods Shipment]: The primary button to create a new Delivery Order document.

2. Steps to Create a Delivery Order

Step 1: Create a New Document

From the Main View, click the [Create Goods Shipment] button to open the New form.

Step 2: Select the Sales Order

On the form that appears, the first step is to select the Customer and then the Sales Order (SO) Number that will be shipped. After you select the SO, the system will automatically load the list of ordered items into the table below.

Step 3: Verify and Input the Ship Quantity

1. The system will display the SO Qty. (the quantity ordered).

2. In the Receive now input column, enter the quantity that you are physically shipping at this time. This allows you to perform a partial shipment.

3. Select the Warehouse where the goods are being picked from.

Step 4: Confirm the Shipment

After all data is filled in, click the [Save] or [Save and Arrange Label] button to finalize the Delivery Order. This action will officially reduce the stock quantity from your warehouse.

Tips & Important Notes

• The creation of a Delivery Order is the step that physically and from an accounting perspective removes the goods from your inventory for a customer.

• After the Delivery Order is created, the next step in the sales cycle is the creation of the Sales Invoice by the finance team.

• This is a crucial daily work module for the Shipping Warehouse team.