Skip to main content
All CollectionsFinance
Work in Progress
Work in Progress

Work in Progress (WIP) Overview in ProdSys

Updated over 2 months ago

Work in Progress (WIP) is an essential feature in ProdSys that provides a clear view of the value of goods and products currently in production, including those that have been pre-invoiced. This feature helps you monitor and manage the costs associated with ongoing work, ensuring that you have an accurate understanding of your production expenses and profitability.

This step-by-step guide will show you how to use the Work in Progress (WIP) screen in ProdSys to track and analyze the value of items that are still under production.

Step-by-Step Guide to Using the Work in Progress (WIP) Screen

Step 1: Access the Work in Progress Screen

  1. Log in to ProdSys: Start by logging into your ProdSys account using your username and password.

  2. Navigate to the Work in Progress Screen: From the main menu, go to “Order”and select “Work in Progress” from the submenu.
    https://app.prodsys.com/#/economy/work-in-progress

Step 2: Understand the Available Fields

The WIP screen contains several fields that help you analyze the value of items in production:

  • Order Category: Indicates the category of the order (e.g., production order, customer order).

  • Order Number: Shows the unique number associated with each order.

  • Line Number: The specific line number within the order.

  • Line Description: A description of the line item or product in production.

  • Material Cost: The cost of materials used for the items in production.

  • Hour Cost: The labor cost associated with the production of the item.

  • Invoiced: Displays the value of items that have already been invoiced.

  • Auto/Manual: Indicates what type of logistic model chosen.

  • Value Goods in Work: Shows the current value of goods that are in the production process.

  • Value goods in work: The total value of work that is ongoing but not yet completed.

Step 3: Apply Filters to Customize the Work in Progress Screen

  1. Select Filters:

    • Use the filter options to narrow down the data displayed on the WIP screen. Common filters include:

      • Order Category: Filter by specific order categories (e.g., production orders) to focus on a particular type of work in progress.

      • Order Number: Filter by order number to view details related to a specific order.

      • Line Number: Filter by line number to analyze a specific line item in production.

  2. Combine Filters:

    • You can apply multiple filters simultaneously to refine your data further. For example, filter by both Order Category and Order Number to view only specific items under production.

Step 4: Review and Analyze Key Fields in the Work in Progress Screen

  1. Analyze Material and Hour Costs:

    • Review the Material Cost and Hour Cost fields to understand the direct costs associated with the ongoing production. This will help identify any potential cost overruns or inefficiencies.

  2. Check Invoiced Amounts:

    • The Invoiced field shows the value of items that have been pre-invoiced. Compare this with the actual value of goods in progress to understand the financial standing of your production.

  3. Evaluate Work in Progress Value:

    • The Work in Progress field provides a total value of all ongoing work. This value is crucial for assessing your inventory and production levels at any given time.

  4. Identify Automatic vs. Manual Calculations:

    • Use the Auto and Manual fields to determine which values have been automatically calculated by the system and which have been manually adjusted. This helps ensure data accuracy and identifies any potential discrepancies.

Step 5: Export and Share the Work in Progress Data

  1. Export Data:

    • Click on the “Action menu” select Export button to download the WIP data in your preferred format (e.g., Excel, PDF). This allows for further analysis or sharing with team members and stakeholders.

  2. Save Custom Views:

    • Save your customized views by clicking on the “Action menu” select Layout button. You can name and store different views for future reference, making it easier to access the information you need quickly.

  3. Share Views:

    • To share your saved views with other team members, click on the “Action menu” select Share / Unshare button.

Tips for Optimizing the Use of the Work in Progress Screen in ProdSys

  1. Regularly Update Data: Ensure the data on the WIP screen is regularly updated to reflect the most current production status.

  2. Monitor Material and Hour Costs Closely: Keep an eye on the material and hour costs to identify any cost discrepancies or areas for improvement.

  3. Utilize Filtering and Export Features: Regularly use filters and export data to maintain efficient tracking and reporting of production progress.

  4. Save and Share Custom Views: Save and share your customized views to ensure consistent analysis across the team.

Conclusion

The Work in Progress (WIP) screen in ProdSys is a valuable tool for monitoring and managing the value of goods and products currently in production. By effectively using filters, analyzing key fields, and exporting data, you can gain a clear understanding of your production costs and ensure better financial management. Start using the WIP screen today to enhance your control over the production process and maintain profitability.

Did this answer your question?