Sage 100

 View Only
  • 1.  Anyone out there with WO experience? I'm strugglin

    Posted 04-25-2017 12:16
    Anyone out there with WO experience? I'm struggling with something this morning. If my work order has 100 units planned, but only 90 are completed, should the system calculate the item unit cost as total costs/100 (planned) or total costs/90 (completed)?


  • 2.  RE: Anyone out there with WO experience? I'm strugglin

    Posted 04-25-2017 12:22
    I think it depends on your Cost Completion Method?


  • 3.  RE: Anyone out there with WO experience? I'm strugglin

    Posted 04-25-2017 12:24
    Based on my recall, I believe it calculates on planned quantity.


  • 4.  RE: Anyone out there with WO experience? I'm strugglin

    Posted 04-25-2017 12:27
    Here you go. Just what Beth was referring to. Cost Completion Method Select a cost completion method to determine which costs are used to calculate the completion unit cost. Note If Automatic or Backflush is selected in the Issue Method field on the Work Order Entry Header tab and the Auto Generate Labor and Auto Generate Out-Process check boxes are selected on the Work Order Entry Additional tab, labor and outside processing transactions are automatically created for work orders. Actual: The completion unit cost is based on the costs updated to the Work in Process accrual account. Work orders created with the Manual or Backflush issue method have a zero balance in the Work in Process accrual account after each completion entry is recorded. Whether the cost in the Work in Process accrual account represents the full-planned quantity or a partial quantity, the system assumes that all costs applicable to the completion entry are entered and that the cost in the Work in Process accrual account represents only that completion entry. For example, if the planned quantity for the work order is 100 items and you are processing a completion entry for the first 50 items, 100 percent of the cost in the Work in Process accrual account is used in the completion calculation for the 50 items. Work orders created when Automatic is selected in the Issue Method field on the Work Order Entry Header tab use the work order percent complete amount to allocate the costs updated to the Work in Process accrual account before the completion entry is recorded. This method leaves a zero balance in the Work in Process accrual account when the last completion entry for the work order is recorded. Planned: The completion unit cost is based on the standard costs that are calculated when the work order is created. The work order percent complete is used to calculate the cost for each completion. The Planned cost completion method may also create a positive or negative balance in the Work in Process accrual account if Yes or Available Quantity Only is selected in the Auto Issue Material field and the Auto Generate Labor and Auto Generate Out-Process check boxes are selected on the Work Order Entry Additional tab, and the automatically created material, labor, and outside processing transactions are edited. The automatically created transactions are based on the standard costs (calculated when the work order is created), and if they are edited, the variances between the standard costs and the edited costs are posted to the Work in Process accrual account. These variances are ignored by the completion calculation which always uses the standard costs. Lower of Plan/Actual: This method checks each step of the work order to determine if the standard or the actual cost is lower. The lower cost for each step determines which method is used to calculate the completion costs. If the standard cost is lower, the completion cost is calculated using the Planned Cost Completion method. If the actual cost is lower, the completion cost is calculated using the Actual Cost Completion method. This method leaves a zero balance in the Work in Process accrual account when the last completion entry for the work order is recorded.


  • 5.  RE: Anyone out there with WO experience? I'm strugglin

    Posted 04-25-2017 12:29
    Beth is correct cost completion method. that is stock. if the stock solution does not work there are a bunch of other options but you need to go third party.