...
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 Finance System yet (IsMovementPosted? = True / False).
The ‘Stock Movement Posting’ feature in Vision Commerce is available to automatically post through updates to the Sage Finance System nominal ledger, for example to the ‘Stock’ and ‘Cost of Sales’ accounts.
...
This window will check to ensure that all codes entered exist in SageFinance System, if they do not exist it will return an error when clicking the ‘Save’ button.
...
When the ‘Post’ button is clicked in the Stock Movement Posting window, it can post thousands of messages to SageFinance 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, 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:
Take note of ID of the last entry in Sage FinancialsFinance System
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 SageFinance System. A final check is required to ensure that all postings have successfully made SageFinance System:
ID of last entry in Sage Financials Finance System (prior to Stock Movement Posting)
+ Total number of postings made to Sage Finance System (from Stock Movement Posting report)
= ID of last entry in Sage Financials Finance System (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 sentFinance System.
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 |
...
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.
...
For any Duty Paid stock receipted into the system on a Purchase Order, Excise Duty is not posted to SageFinance System.
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 Finance System but added together for a single debit and a single credit to the nominal codes listed above.
...
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 Finance System (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.
...