Question

Undo customer consignment stock consumption

  • 7 February 2020
  • 4 replies
  • 593 views

Userlevel 4
  • Sidekick (Partner)
  • 38 replies

I have set up customer consignment stock.
I deliver parts and then report cunsumption.

Is there any way to cancell consumption reporting?

Apps 9upd13

FYI: I have also setup custom objects to report consumption agains specific order, since there is full support in IFS standard code for that, but some reason client don’t support that. :)


4 replies

Hi Jouni,

Consumptions are reported against the original refill order. However, there is no direct way to cancel the wrong consumption. You may be required to create a new refill order.

 

Userlevel 7
Badge +15

There are  two options.  The first is to wait until your next consumption report from
your customer and then report consumption for the net difference of whatever it is they tell you and
the amount you've duplicated.  For example, in the example above, you've mistakenly reported 8 twice.  Say your customer reports 10 on their next consumption, you only report the difference (10 - 8).  Or say they've reported 6, you don't report any consumption at all.  This is a very manual way of fixing the error, but it is an option.

The second way would be to process an RMA against your customer order for the 8.  Then create a credit invoice off your RMA.  This should put the inventory back into your location and offset the invoice that you sent your customer.  What it DOESN'T do is fix your consignment stock quantity at your customer's.  In order to fix that, you need to create a refill order for the 8 and deliver that order.  Now your consignment quantity at your customer's should be correct as well. Finally, do a manual journal entry to debit Inventory and credit COGS and you should be set.

Userlevel 3
Badge +6

Hi Jouni,

As per the standard system behaviour,

A consignment stock is treated as a normal inventory location where you can check the order point level, use order point quantity, and safety stock. However, inventory transactions and inventory value reports will be affected. As long as the parts are in consignment stock, they are not considered as yours financially. This means that the parts are not received as regular parts; they have their own arrival transactions. The parts in consignment stock will not be taken into consideration when generating inventory value reports, e.g., Received Not Yet Invoiced.

Conditions for creating a consignment stock:

  • An inventory location cannot keep both normal stock and consignment stock for the same part.
  • An inventory location can keep both normal stock and consignment stock for different parts.
  • An inventory location cannot be used as a consignment stock for several suppliers, regardless of whether the parts are identical.

If Allow multiple owners for Inventory Part on one Location option is enabled in the Site/Warehouse Management/General tab, the same inventory location can have different ownership types and/or owners stock for the same part.

Also if you try to duplicate any of the key values mentioned below for the different ownership types and/or owner in the same location and part then an error message will be raised stating that the stocks do not uniquely identify the ownership information and you are not allowed to perform this transaction. The key values are Site, Part No, Configuration ID, Location No, Lot Batch No, Serial No, Eng Chg Level, W/D/R No and Activity Seq.

Return or scrap parts in consignment stock

Sometimes, parts in stock are found to be faulty or damaged, and you need either to return the parts to the supplier or to scrap them. When the financial burden should be placed on the supplier, you will use the return to supplier option. If your company should take the financial burden, you will scrap the parts in the normal way. Scrapped parts are considered as consumed and will be displayed in the invoice matching.

Userlevel 4
Badge +7

As standard it is not possible to create an RMA for a customer consignment stock, which is a pity, 
 and it is not possible to create an count inventory .  

Reply