Stock Movements (Sage Integration)

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

In the database each movement has a ‘Movement date’, and also a field to determine if the movement posting (debits/credits) have/not been sent to Sage yet (IsMovementPosted? = True / False).

The ‘Stock Movement Posting’ feature in Vision Commerce is available to automatically post through updates to the Sage nominal ledger, for example to the ‘Stock’ and ‘Cost of Sales’ accounts.

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:

Maintenance > Control Account Maintenance

This window will check to ensure that all codes entered exist in Sage, 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 Sage.  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, and the server running the Vision to Sage Manager Service.

There are a number of important rules to remember, to ensure this process is successful:

1. Take note of ID of the last entry in Sage Financials

2. Only run the movement posting for up to a week’s worth of movements at a time

3. Run the movement posting at the end of the day when no other users are using the system

4. Always save the report presented at the end of the movement posting for future reference

 The last page of the movement posting report will tell you how many postings have been made to Sage.  A final check is required to ensure that all postings have successfully made Sage:

ID of last entry in Sage Financials (prior to Stock Movement Posting)

+ Total number of postings made to Sage (from Stock Movement Posting report)

= ID of last entry in Sage Financials (after Stock Movement Posting complete)

Remember that it may take hours for all postings to be sent through to Sage by the Vision to Sage Manager depending on however many postings were sent.

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 Sage.

However if stock is receipted into the system using the ‘Stock Adjustment’ window, and the ‘Duty Paid’ box is ticked, the same principle applies as the relanded/credited stock below where the on costs are posted to Sage but added together 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.

Credited Stock

When credited stock is landed back at the warehouse, the costs associated with the original despatch and return are stored individually.  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 Sage (See ‘Stock Movement Posting’ above), all of these on costs are added together 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.