...
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.
Duty Paid Stock
For any Duty Paid stock receipted into the system on a Purchase Order, Excise Duty is not posted to Sage.
...
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.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.
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.
Â