Stock transaction types
Each type of transaction that affect the stock will get tagged with a transaction type. We currently operate with the following transaction types in RamBase:
Goods received in stock
These transactions occur when a Goods reception (SSA) is registered to a status greater than 2. When a Goods reception (SSA) is registered, the Stock entry (INV) is created. At the same time, a transaction is added to the cost change log. Finally, it adds a transaction to the transactions log stating the quantity and cost.
The transaction types from 1 – 14 is goods received from outside the company, while transaction types from 21 – 32 is goods received from another location within same company (database). In addition, we have transaction type 65 which happens after a manual correction of stock.
1 – Goods reception | This is a standard Goods reception (SSA) document that is registered when goods are received to stock. |
2 - Produced goods | This is when you register a Goods reception (SSA) document with type: Production. Meaning you have produced goods that are now placed to stock. |
3 – Service | This is when you register an SSA document of type: Service. |
4 – Customer owned product | When you receive a product that is owned by your customer. This will not affect the value of STOCK (Since this is base for your accounts), but it will be registered as a transaction and affect the count so it will be possible to keep track of the movement of these products. |
5 – Return of goods | When you register an SSA that is a return from customer. |
6 – Return for repair or service | Goods received for repair or service are registered as customer owned. |
7 - Supplier owned product | If you receive something to stock that is owned by your supplier. Mostly used by auction companies. |
8 - Replacement from supplier | If you receive something to stock from your supplier that is replacing another product. |
9 - Repaired by supplier | Goods reception with type REPAIRSUPRETURN registered. |
10 - By-product of production | Goods reception with type BYPRODUCT registered from a production. |
11 - Part changed during production | Goods reception with type PARTCHGPROD registered from a production. |
12 - Part from dismantle | Goods reception with type DISMANTLE registered. |
13 – Return of unknown shipment | Goods reception document registered, and shipment/origin is unknown. |
14 – Return of materials inserted in produced products | Goods reception from production when a material inserted in a produced production is returned. |
21 - Transfer of regular goods | Goods reception received from another location within same company. |
22 - Transfer of produced goods | Goods reception of products that are produced in the same company but at a different location. |
23 - Transfer of serviced goods | Goods reception from another location within same company and the document type is Service. |
24 - Transfer of Customer owned product | Goods reception from another location within same company. Product is owned by the customer. |
25 - Transfer of returned goods | Goods reception from another location within same company. Product is returned by the customer. |
26 - Transfer of repair or service | Goods reception from another location within same company. Product is owned and returned by the customer. |
27 - Transfer of supplier owned product | Goods reception from another location within same company. Product is owned by the supplier. |
28 - Transfer of replacement from supplier | Goods reception from another location within same company. Product is sent from supplier to replace another product. |
29 - Transfer of repaired by supplier | Goods reception from another location within same company. Product is returned from supplier after repair. |
30 - Transfer of by-product | Goods reception from another location within same company. Product is a by-product from production. |
31 - Transfer of part changed during production | Goods reception from another location within same company. Product is a part that is changed from a previous production at another location. |
32 - Transfer of part from dismantle. | Goods reception from another location within same company. Product is a part that is dismantled from a previous production at another location. |
65 - Stock correction, increase | On a Goods reception item it is possible to correct the quantity of the product if it proves that it is not correct. If you correct the quantity up this transaction will occur in STOCK to log that. |
Goods out of stock
There are several ways the system will consume goods from stock and by that reducing the value of your stock. The different types of transactions that will reduce the stock quantity are listed below:
100 - Shipping advice | This is a transaction based on a standard shipping advice when goods are shipped to the customer. |
110 - Pick to production work order | Transaction occurs when products are picked from stock into a production work order. These products will be part of work in progress. |
120 - Supplier return | Transaction occurs when shipping products that are going to be returned to the supplier. |
130 - Stock correction, decrease | On a goods reception item it is possible to correct the quantity of the product if it proves that it is not correct. If you correct the quantity down this transaction will occur in STOCK to log that. |
140 - Service order | Transaction occurs then sending out goods on a service order. |
150 - Goods transfer | Transaction will occur when transferring goods from one location to another location within same company (database). |
Other transactions
60 - Undo shipping of shipping advice | Transaction will occur when undo shipping is done on a shipping advice. This will place the product back into stock and increase the stock value. |
70 - Undo shipping of supplier return | Transaction will occur when undo shipping is done on a shipping advice of type: Supplier return. This will place the product back into stock and increase the stock value. |
81 - Undo pick in production | Transaction will occur when a picked product is unpicked. This will place the product back into stock and increase the stock value. |
250 - Change of price | Transaction will occur when price is changed on a Goods reception document. Change of price can be caused by:
Change in price will either increase of decrease the value of the goods remaining in stock. If the goods have been taken out of stock, a price change will not affect the stock value back in time. It will only affect the cost of the given goods:
|
350 - Change in exchange rate, when running GM-model C (Current) | Some companies run on GM-model Current, meaning stock in foreign currency will get recalculated every day, via an automatic nightly batch job, because of new currency rates. These updates will get logged with a separate transaction. |