Stock Movements

Overview

All stock movements in Vision Commerce are logged in the database.  These movements are available to view in the ‘Stock Movement Enquiry’ window and give a detailed breakdown on the costs associated with each movement (Stored in GBP).

Stock Movement Types

The following movement types are logged in the database:

...

Against each movement we store the costs associated with each (where appropriate):

1. Product Cost

2. 2.       ‘On costs’

   1. a.      Insurance Cost

   2. b.      Freight Cost

   3. c.       Excise Duty Cost

   4. d.      Customs Duty (CCT) Cost

   5. e.       RHD Cost

   6. f.        Rent Cost

   7. g.      Delivery Cost

   8. h.      Labour Cost

   9. i.         Overhead Cost

...

The ‘Stock Movement Posting’ feature in Vision Commerce is available to automatically post through updates to the Finance System nominal ledger, for example to the ‘Stock’ and ‘Cost of Sales’ accounts which uses the movement information logged as described above.

Debit & Credit information for the postings above can be found in the table in the ‘Stock Movement Posting’ section of this document.

Control Account Maintenance

The nominal codes where the debits and credits are posted to for each stock movement are setup in Vision Commerce:

...

This window will check to ensure that all codes entered exist in Finance System, if they do not exist it will return an error when clicking the ‘Save’ button.

Stock Movement Posting

When the ‘Post’ button is clicked in the Stock Movement Posting window, it can post thousands of messages to Finance System.  This depends on the number of non posted stock movements made up to the ‘Post to’ date specified by the user on the Stock Movement Posting window.  This process can therefore be extremely hungry on your system resources on your client machine.

...

Please refer to the table on the next page for debit/credit information for each movement posting.

Movement IN

**Excise Duty is not posted for Stock Receipts.  Customs Duty posted when, Supplier & Product Country is not in EC and ‘Customs Duty Paid’ is ticked on the Purchase Order.

***See ‘On Costs’ at the bottom of this document.

Movement OUT

On Costs

Note:  ‘On costs’ (see ‘Stock Movement Types’ section in this document) are only posted when ‘Include on cost in cost of sales postings’ is ticked in the ‘Product Group’ for the Product associated with the stock movement.

Duty Paid Stock

For any Duty Paid stock receipted into the system on a Purchase Order, Excise Duty is not posted to Finance System.

...

Despatches from this new stock item have a ‘Product Cost’ which includes these on costs.

Credited Stock & Stock

...

Transfers

The costs associated with the original despatch and return are stored individuallyare stored separately to the costs for the return, as these are two separate movements.  These can be seen in the ‘Stock Movement Enquiry’ window, you’ll notice columns for ‘Product Cost’, and all other on costs such as ‘RHD’, ‘Rent’ etc.  When this movement is posted to Finance System (See ‘Stock Movement Posting’ above),

For the return movement all of these on costs are added together combined into the new ‘Product Cost’, for a single debit , and a single credit to the nominal codes listed above.

Despatches from this new stock item have a ‘Product Cost’ which includes these on costs.

Summarised postings

Stock movement postings can be posted in summary form, this is the recommended option from Vision Commerce Version 2.4 onwards but can be used with postings prior to this version.

...