Reset Cumulative Quantity

Explanation

The Cumulative Received Quantity field displays the total quantity of parts ordered from the supplier so far. You can reset either this quantity or the cumulative quantity reset date, which determines the date from which receipt should be considered. If this quantity need to be reset, such as when you want to keep track of cumulative receipts for a new year or to re-synchronize delivery quantities with your supplier, you can reset the quantity displayed in this field. You can choose to start from zero (0), or you can simply change the quantity to the correct amount.

When the receipt qty at a user's system does not match with the record-keeping at a supplier, the user can agree with the supplier from an agreed date onwards the user will again re-synch with an agreed qty. By using the Cumulative Received Quantity, the user can add the relevant sync date and the execution date, to get the relevant reset amount.

If the user runs the Cumulative Received Quantity Command executed and syncs on the same date, the Cumulative Received Quantity will be 0.

The cumulative quantity reset can be done in two ways

1. Using the Cumulative Quantity Reset command to do the reset on Supplier Schedule Agreement, Supplier Schedule Agreement Part, or Supplier Schedule Agreement Parts Pages

2. Manual Updating of the Cum Received Qty or the Reset Date on the Supplier Schedule Agreement Part/ Miscellaneous

The Cumulative Quantity Reset command is available on the Supplier Schedule Agreement, Supplier Schedule Agreement Part, or Supplier Schedule Agreement Parts where the user needs to add the relevant execution date. It is the date the Cumulative Quantity Reset is to be executed for the relevant record and Sync Date that is the date that the company and a supplier agreed to count the received quantity for a specific part, the user will be able to get the Cum Received Qty on in Supplier Schedule Agreement Part/ Miscellaneous Tab.

The Cumulative Quantity Reset command will be available for line/lines on Supplier Schedule Agreement and Supplier Schedule Agreement Parts whereas it will be a header command in the Supplier Schedule Agreement Part window. It is possible to select multiple lines to run the Cumulative Quantity Reset command for line level records as well. Moreover, a history record will be updated on the Supplier Schedule Agreement Part/ Cum Quantity Reset Tab for each Cumulative Quantity Reset.

When using the Cumulative Quantity Reset Command few validations will be working on the date columns. If the Execution Date is an earlier date than the Reset Date, it is not possible to run a Cumulative Quantity Reset. If a past date is used for execution date it can't execute the background Jobs or schedule tasks either.

It is possible to manually update the value in Supplier Schedule Agreement Part/ Miscellaneous Tab either updating the Cum Received Qty or the Reset Date. If the user updates the Cum Received Qty it should be updated by deducting the Cumulative Sync Quantity from the Cumulative Qty before the reset. Also
If the user needs to have a negative value on the Cum Received Qty, it is possible to add a negative value and the value will be updated on the Cum Quantity Reset Tab.

If the user updates the Reset Date The Reset Date will be the Sync Date and the Execution date will be the System Date which is the Site Date and the relevant cumulative received quantity will be calculated deducting the Cumulative Sync Quantity from the Cumulative Qty before the reset.

Prerequisites

System Effects

The calculation of the quantity ordered from the supplier will restart from the quantity you have entered. In the Cumulative Reset Date field, you can see the accumulative base line date. Changing the cumulative receipts quantity will not affect current schedules, but will be used as for newly generated schedules.

When the user has made the changes manually or using the Cumulative Received Quantity Command. The relevant history record will be updated on the Cum Quantity Reset Tab.