Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This cannot be run for specific products, only across all products

Data Cleaning

Expand
titleData Cleaning

This page is designed to allow you to edit the sales value and the cost price for transactions held in the stock movement tables to correct mistakes made and also to correct values for reports if you change the values after delivery of the order but before invoicing.

Image Removed
Note

When clicking Save both the New Sales/Unit (the sales total for the stock movement you are adjusting) and the New Prod Cost Total (the product cost recorded against the same stock movement) are updated. Therefore if you leave either column as zero, their values against the stock movement will be set to zero, so you MUST set both each time either if you are not changing one of them. This will cause issues if you do not set them correctly.

It does not post to your accounting system any changes here are stored within Vision Commerce and also audited (only used for support purposes).

Note

This is a very dangerous tool, if used incorrectly it can adjust or amend any information that you store within your system, which can result in previous reports changing. Use with extreme caution.

Access this function

You need to enter an account code and then you will be able to pick from the transaction references, once selected you will see all the transactions for this reference, there could be one and there could be thousands.

When you have updated a movement, it will disappear from New Transactions and show in Historical Transactions when the screen is next refreshed. Please note at the time of writing, you either need to change the account code or close/reopen the screen to refresh the data on the two tabs. If you do not see updated transactions in the Historical tab a refresh is required.

Analysis Code Maintenance

Expand
titleAnalysis Code Maintenance

The Analysis Code Maintenance is used to set up the Analysis Code that is used throughout Commerce.
The Analysis Code provides an additional way of grouping and reporting.

Info

To use this screen, you would need to have set up the Analysis Type and Analysis Captions (which is normally set up by the Vision Team).

Image Removed

This screen will allow you to add the right names and a set of values against the Codes that you wish to have set up.

It ables you to archive or unarchive any of the Analysis Codes from this screen.

For each type of Analysis Code, you can input Budgets and Targets, they are used for the reporting purposes in the BI Section

Image Removed

Product Image Bulk Upload

...

The process will ask the user for a directory where the product images exist, the images should have the product code as their name. The same file extensions will be supported here which are already supported in Product Maintenance. The process will also ask the user what type of image it is, so it knows which image placeholder to upload them to in Product Maintenance.

Payment Method

...

titlePayment Method

Payment Method is used when using the posting Orders from the website, using a Payment Method ID which will map to the correct Payment Method.

If linked with your Finance System, ensure that the “Accounts System Bank/Method ID” setup in this matches exactly with the Finance System to avoid failures during the posting process.

...

When Vision Commerce is configured to post Sales Receipts to a Finance Software and the Cashbook is in use, it's important to set up a payment method for each cashbook, remembering that a cashbook is necessary for each currency that you want to post to it.

The read-only fields will show which Payment is used for the following options.

  1. Pre payment’

  2. ‘Online Pre Payment’

  3. 'Payment on Sales Docs'

  4. ‘Payment on Delivery’

For more information on this please see Payment Required

Note
  • For example, you may have a 'Credit Card' payment method, if you're receiving credit card payments in multiple currencies, you will need a payment method set up for each currency, and link each of these payment methods to the corresponding cashbook.

...