...
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:
Movement Type | Movement IN | Movement OUT |
Purchase Order | Â | Â |
 | Stock Receipt | PO Stock Return |
 |  |  |
Sales Order | Â | Â |
 | Sales Order Credit Note | Stock Despatch |
 | ExCellar SO Credit Note | ExCellar SO Despatch |
 | EP SO Credit Note | EP SO Sale |
Stock Adjustment | Â | Â |
 | Stock Adjustment (Where > 0) | Stock Adjustment (Where < 0) |
 |  |  |
Stock Transfer | Â | Â |
 | Stock Transfer (In) | Stock Transfer (Out) |
 |  |  |
Against each movement we store the costs associated with each (where appropriate):
...
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.
...
Movement IN
Movement Type | JD (Journal Debit) | JC (Journal Credit) |
 Stock Purchase Order (Stock Receipt) |  |  |
   Product Cost | Stock | GRN Accrual |
   Customs Duty (CCT) Cost** | Stock | Customs Duty Recovery |
 |  |  |
 ExCellar Purchase Order (Stock Receipt) |  |  |
   Product Cost | Stock | ExCellar GRN |
   Customs Duty (CCT) Cost** | Stock | Customs Duty Recovery |
 |  |  |
 EP Purchase Order (Stock Receipt) |  |  |
   Product Cost | Stock | En Primeur GRN |
   Customs Duty (CCT) Cost** | Stock | Customs Duty Recovery |
 |  |  |
 Stock Sales Order (Sales Order Credit Note)*** |  |  |
   Product Cost (Return to Stock = True) | Stock | Cost of Sales |
   Product Cost (Return to Stock = False) | Credit Note Reason Nominal A/C | Cost of Sales |
 |  |  |
 ExCellar Sales Order (ExC. Order Credit Note)*** |  |  |
   Product Cost (Return to Stock = True) | Stock | Cost of Sales |
   Product Cost (Return to Stock = False) | Credit Note Reason Nominal A/C | Cost of Sales |
 |  |  |
 EP Sales Order (EP Credit Note )*** |  |  |
   Product Cost (Return to Stock = True) | Stock | EP Cost of Sales  Accrual |
   Product Cost (Return to Stock = False) | Credit Note Reason Nominal A/C | EP Cost of Sales Accrual |
 |  |  |
 Stock Adjustment (Stock Adjustment) |  |  |
   Product Cost (Qty Moved > 0) | Stock | Cost of Sales |
 |  |  |
Â
**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.
...
Movement OUT
Movement Type | JD (Journal Debit) | JC (Journal Credit) |
 Stock Purchase Order (PO Stock Return) |  |  |
   Product Cost | GRN Accrual | Stock |
 |  |  |
 ExCellar Purchase Order (PO Stock Return) |  |  |
   Product Cost | ExCellar GRN Accrual | Stock |
 |  |  |
 EP Purchase Order (PO Stock Return) |  |  |
   Product Cost | EP GRN Accrual | Stock |
 |  |  |
 Stock Sales Order (Stock Despatch) |  |  |
   Product Cost | Cost of Sales | Stock |
   Insurance Cost | Cost of Sales | Insurance Recovery |
   Freight Cost | Cost of Sales | Freight Recovery |
   Excise Duty Cost | Cost of Sales | Excise Duty Recovery |
   Customs Duty Cost | Cost of Sales | Customs Duty Recovery |
   RHD Cost | Cost of Sales | RHD Recovery |
   Rent Cost | Cost of Sales | Rent Recovery |
   Delivery Cost | Cost of Sales | Warehouse Delivery Recovery |
 |  |  |
 ExCellar Sales Order (Stock Despatch) |  |  |
   Product Cost | Cost of Sales | Stock |
   Insurance Cost | Cost of Sales | Insurance Recovery |
   Freight Cost | Cost of Sales | Freight Recovery |
   Excise Duty Cost | Cost of Sales | Excise Duty Recovery |
   Customs Duty Cost | Cost of Sales | Customs Duty Recovery |
   RHD Cost | Cost of Sales | RHD Recovery |
   Rent Cost | Cost of Sales | Rent Recovery |
   Delivery Cost | Cost of Sales | Warehouse Delivery Recovery |
 |  |  |
 EP Sales Order (EP Sales Order) |  |  |
   Product Cost | EP Cost of Sales Accrual | Stock |
   Insurance Cost | Cost of Sales | Insurance Recovery |
   Freight Cost | Cost of Sales | Freight Recovery |
   Excise Duty Cost | Cost of Sales | Excise Duty Recovery |
   Customs Duty Cost | Cost of Sales | Customs Duty Recovery |
   RHD Cost | Cost of Sales | RHD Recovery |
   Rent Cost | Cost of Sales | Rent Recovery |
   Delivery Cost | Cost of Sales | Warehouse Delivery Recovery |
 |  |  |
 Stock Transfer |  |  |
   Insurance Cost | Stock | Insurance Recovery |
   Freight Cost | Stock | Freight Recovery |
   Excise Duty Cost | Stock | Excise Duty Recovery |
   Customs Duty Cost | Stock | Customs Duty Recovery |
   RHD Cost | Stock | RHD Recovery |
   Rent Cost | Stock | Rent Recovery |
   Delivery Cost | Warehouse Delivery | Warehouse Delivery Recovery |
 |  |  |
 Stock Adjustment (Stock Adjustment) |  |  |
   Product Cost (Qty Moved < 0) | Cost of Sales | Stock |
 |  |  |
Â
On Costs
...
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.
...