I have incorrectly defined a product with the "Stocked" checkbox and have generated an invoice and shipment. I want to remove the checkbox and to be able to post the shipment and MatchShip. How should I do this?
A: In order to realise the correction, you need to follow the steps below:
void the shipment - this will automatically lead to the voiding of the Shipment-Customer Invoice Match;
modify the product by de-selecting the Stocked checkbox; if the product is not necessarily a product, it is recommended you define it as a service;
generate the new shipment and make sure that the Shipment-Customer Invoice Match has been obtained;
if this match has not automatically been generated, then you need to manually create it in the Matching Shipment-Invoice window;
from this moment, the new documents will be posted (automatically or manually) with 0 value.
I have incorrectly operated a material receipt on a warehouse different from the one of the shipment ( with Force shipping rule). All the documents have been posted and the costs are at organization level. How can I correct the stock between the warehouses?
A: In order to realise the correction, you need to follow the steps below (this answer is only valid for the Organization costing level and for the products with lot):
enter an Internal Material Receipt with the respective quantity, with price equal to 0, for the respective product and instance, on the warehouse where the material receipt was registered, on the date of the adjustment;
post the Internal Material Receipt - this will lead to the corresponding quantity being entered in the costs, thus updating the costs to 0;
enter an Inventory Move with the respective quantity, from the warehouse of the material receipt towards the warehouse of the shipment;
post the Inventory Move - this will be posted with 0 value, the costs will not be influenced, since the aggregation level is "organization";
void the Internal Material Receipt - this can be done, since the onhand quantity exists at warehouse level and it needs to be voided (brought to 0) and, from the costs perspective, there are no restrictions due to the fact that the inventory move has not influenced the costs, so that these will also arrive at 0 value;
post the voided pair of the Internal Material Receipt - the costs will also be corrected, arriving at 0 value;
verify the reports: Current Storage Detail and Storage Balance Report - we need to obtain 0 quantity and value for the respective product and the affected instance.
The Check Cost Queue report returns data. How can I correct these data?
A: The report displays the quantities present in the cost queue as compared to those calculated in the cost details, at the time you run it. The Synchronize Costs process can only correct a part of these desynchronizations. You cannot correct the situations where too many cost details lines have been consumed (i.e. it runs on negative values). You need to analyse all these situations separately and apply corresponding correction measures.