Update prices in time schedules

  • Updated

Time schedule lines contain prices: Direct Unit Cost, Unit Cost, Unit Price and the amounts calculated from them. maintool determines them when you enter or change a line. If prices or unit costs of items and resources change later, you update the prices of existing time schedule lines with the Update Prices in Time Schedules report – for one time schedule or for all at once.

Where the prices come from

  • Purchase prices (Direct Unit Cost) are determined by the Business Central price calculation from the price lists for all vendors and for the vendor in Buy-from Vendor No. of the line.
  • Sales prices (Unit Price) come from the price lists for all customers, for the customer in Sales to Customer No. (time schedule, Accounting FastTab) and for the customer's price group.
  • The Unit Cost comes from the item or the resource.

maintool recalculates a single line when you change No., Quantity, Unit of Measure Code, Variant Code, Location Code, Work Type Code or Buy-from Vendor No. If you change the Sales to Customer No. or the Currency Code in the time schedule, maintool recreates all lines with the new details after a confirmation.

Update prices with the report

  1. Search for Update Prices in Time Schedules and open the report.
  2. Under Time Schedule Line Filters, narrow down the selection if required:
    • Time Schedule No.: only this time schedule. Blank = all time schedules.
    • Time Schedule Line Type: only lines of this type, for example Resource. Blank = all types.
    • No.: only lines with this item, resource or resource group. The field can only be changed once a Time Schedule Line Type is selected.
  3. Choose OK.

The report remembers the filters used last.

Result

For all time schedule lines in the filter, maintool determines the prices again, as if you had entered the quantity again: Direct Unit Cost, Unit Cost, Unit Price and the amounts. Work orders that have already been created from the time schedules remain unchanged.

Notes and limitations

  • The report includes all time schedules in the filter, regardless of their Status and Type.
  • The Time Schedule Statistics do not show costs, but the number of flow paths and the duration, see Track dates and reinitialize a time schedule. You can see the planned costs per line in the Unit Cost and Line Amount columns of the time schedule lines.

Related articles

Related to

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request