Forward Material Withdrawal—Exercises 

Basic Data Setup

Margin List for Material Withdrawal Forwarding

Purpose: The purpose of this exercise is to register a rule that will automatically calculate the sales price by adding a margin to the cost amount. This rule can be applied to any customer and/or project.

Windows:
Margin For Material Withdrawal/Standard Margin
Project Details/Pricing

  1. Open the Margin For Material Withdrawal window and click the Standard Margin tab. 
  2. In the header, enter the ID and name of a margin list (rule). Save the information. 
  3. Create a new record and select the applicable report code and percentage (margin). If different margins are needed, use different report codes, each with a percentage. Remember that the report code must be of the Material type.
  4. Open the Project Details window, click the Pricing tab, and connect the margin list to the actual project.

Specific Margin for Material Withdrawal

Purpose: The purpose of this exercise is to register a margin to be applied to a specific project activity. Use a specific margin as an effective way to override general margin specified in Margin List exercise above. 

Windows:
Margin For Material Withdrawal/Specific Margin

  1. Open the Margin For Material Withdrawal window. 
  2. On the Specific Margin tab, enter those names in the Project ID, Subproject ID, Activity ID, and Report Code fields to which you want to apply the specific margin when you forward material (articles) issued from inventory. A wildcard (%) can be used on any level of the project structure specification.
  3. Specify the percentage (margin) to be applied to the specific project. This percentage will override the percentage set by any standard margin list that may apply to the same project.

Main Exercises

Material Withdrawal

Purpose: The purpose of this exercise is to show how to withdraw material (articles) from inventory and prepare for invoicing.

Windows:
Project/Project Info/Procurement
 Project Transactions

  1. To issue articles from inventory, see the Issuing Material From Inventory exercise.
  2. Specify the number of units to be issued (be careful not to exceed the inventory quantity, which is shown in the same window). When saving, you will get a message that the articles have been issued from inventory.
  3. The Create Project Transaction window will open. From the List of Values, select the report code of type Material you want to use. In this window, you can also override the issued quantity and change the currency. Verify that the sales price and margin are calculated correctly in accordance with the margin rule that applies to your project.
  4. Save the information.
  5. Open the Project Transactions window and query for the applicable project activity and report code transaction(s). Verify that a material withdrawal record has been created with the correct quantity, internal price, and sales price.
  6. Add an invoice comment to the actual record. 

Return to Inventory

Purpose: The purpose of this exercise is to return material from the project back into inventory.

Windows:
Project/Project Info/Procurement

  1. Open the Project Info window and click the Procurement tab. Then select the article you want to return to inventory (make sure that at least one item has been issued).
  2. Right-click and then click Return to Inventory.
  3. The Create Project Transaction window will open. Specify the report code and override the quantity and currency if necessary. Note: The quantity will be specified as a negative number.
  4. Verify that the issued quantity has been reduced in accordance with the returned quantity. 
  5. Also verify that a project transaction has been created to account for the return.