Author Post
WPZ 19/07/2012 15:14 WPZ

Booking in new stock

What is the best way to book in new stock into the system?

I would need to include product code, quantity, and cost price. The cost price of products can change depending on when they were purchased.

In any one delivery that we receive, some product details may already be in the system (and are simply being replenished), and some items may not have been purchased by us before (and therefore more information will need to be inputted.)

Booking in of stock will need to be completely accountable as we need to keep a very close eye on changes to stock.

I know that I can input supplier orders/delivery notes etc, but I am not sure at which point does the inventory get changed to account for the new products.
Fabio 19/07/2012 17:16 Fabio

You can work this way:

1) New items (with product code, description, photo, selling price, etc) : must be created once from ITEMS / ITEM DETAILS


2) When you receive goods you can load you inventory with
PRC / WAREHOUSE LOADING DELIVERY NOTE
OR
PRC / IMMEDIATE SUPPLIER INVOICES (WAREHOUSE LOADING)
Here you can create you supplier document, selecting items (from items codified in your inventory - point 1) and inserting quantity + cost price

When you create this document:
a) Inventory is instantly changes, and quantity added
b) Your "FIFO PRICE" and "LAST PURCHASE PRICE" is automatically updated (you can also generate selling prices based on FIFO or LAST PRICE + a determined markup rate in %)
Fabio 19/07/2012 17:16 Fabio

Sample loading note
Fabio 19/07/2012 17:17 Fabio

Item inventory and availability is automatically updated
Fabio 19/07/2012 17:18 Fabio

Item base prices already up to date
Fabio 19/07/2012 17:19 Fabio

Selling price auto-calculated from last purchase price + markup %