Page Comparison

...

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):

Product Cost
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).

...

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

Take note of ID of the last entry in Sage Financials
Only run the movement posting for up to a week’s worth of movements at a time
Run the movement posting at the end of the day when no other users are using the system
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:

...

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

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.

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

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

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.

...

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.

Versions Compared

Old Version 3

New Version 4

Key

Movement IN

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

Movement OUT

On Costs