StockLedgerService

The following stock actions are supported:

1) PURCHASE New items of an article are purchased for a given purchase price and stored within the warehouse.

2) STOCKTAKE All available items of an article within the warehouse are counted and the article's instock quantity is updated accordingly.

3) SALE A given amount of items of an article has been sold and is removed from the warehouse.

4) RETURN A given amount of items of an article has been returned by the customer and is added to the warehouse.

5) MANUAL The instock quantity of an article is changed manually.

6) INCOMING An arbitrary incoming amount is added to the stock.

7) OUTGOING An arbitrary outgoing amount is removed from the stock.

These actions can be roughly divided into two groups: "incoming" and "outgoing", whereas "incoming" refers to all history entries, which are related to the storage of items within the warehouse and "outgoing" refers to all entries, which are concerned with the removal of items from the warehouse:

a) "incoming":

• purchase entry
• stocktake entry with positive change amount
• return entry

• manual entry with positive change amount

  b) "outgoing"

• stocktake entry with negative change amount
• sale entry
• manual entry with negative change amount

History entries for "neutral" stocktake actions (change amount is zero) play a minor role and therefore are not listed above, since they "have no effect" and are created only for informational purposes.

To enable the computation of the inventory value (Bewerteter Warenbestand) for a given reference date, we need to link "outgoing" and "incoming" entries in a suitable way. If possible, each "outgoing" entry is therefore related to an "incoming" entry, which is called it's source lot entry. "Incoming" entries are assigned to "outgoing" entries based on their "free capacity" and in accordance with the LIFO (Last In First Out) principle, meaning "incoming" entries are assigned in their reversed creation order. The assignment process is (roughly) as follows:

1) get a list of all "incoming" entries for the given article in their reversed creation order 2) compute the "free capacity" for each "incoming" entry in the list, whereas the "free capacity" is calculated as follows: change amount of "incoming" entry minus the sum of the change amounts of all already assigned "outgoing" entries 3) Remove all entries from the list, whose "free capacity" = 0 4) Check "free capacity" of the first list entry: a) "free capacity" >= change amount of "outgoing" entry? Create a new "outgoing" entry for the given change amount and assign it to the "incoming" entry b) "free capacity" < change amount of "outgoing" entry? Create a new "outgoing" entry with change amount = "free capacity" and assign the "incoming" entry to the newly created "outgoing" entry. Remove the "incoming" entry from the list and repeat step 4) until no unprocessed change amount remains or the list is empty 5) If some unprocessed change amount remains, create a new unassigned "outgoing" entry for the remaining change amount (purchase price = default purchase price)

"Outgoing" entries created in step 4) are called assigned, whereas those created in step 5) are called unassigned. If the assignment process results in a single "outgoing" entry, this entry is called a singlepart entry otherwise the set of newly created entries is called a multipart entry.

The instock quantity of each article, which is tracked within the stock history and the one maintained by Shopware (within the article details) may differ, since Shopware updates his counter as soon as a new order has been created, whereas the one maintained within the stock history is intended to track the physical item movements and is therefore (usually) not updated before the order is completely fulfilled and all items have been shipped. To keep these counters in sync the manager class takes care of updating the Shopware counter, when creating new history entries.

Remark: The purchase price of the default customer group of the active shop is used as default purchase price.