Stock Code Generation Matrix For SAGE 50
If you have products that have many variants it can be a real chore creating each of the SAGE Stock Records, especially if you have seasonal stock that changes frequently. Q-trix does the job that could be taking you hours in seconds! For instance, if you sell trousers that are available in seven waist sizes, three leg lengths and four colours that’s 84 possible Stock Numbers that you will have to enter into SAGE! And that’s just one product line – if you have, say, six different products with the same variants that’s almost 500 possible Stock Numbers!
With Q-trix you define the structure of your Stock Number and the possible values for each segment. Then all you need to do is to enter one stock record into SAGE – it doesn’t matter which one. Once that’s done you run the ‘Generate’ function, identify the Matrix that you want to use, quote the stock number that you entered and Q-trix generates the rest.
If there are any invalid variants you can tell Q-trix to ignore them – 34″ Reg Trousers don’t come in blue for example.
Building a Stock Code Generation Matrix
The first thing that you define is the number of characters that identify the product range.
Then you define the other parts of the code and the possible values for each part:
Press the ‘Add’ Button to add the Matrix. The Matrix is now ready for use.
Using the Matrix to generate SAGE 50 Stock Records
Select the Matrix that you wish to use.
Create one stock code in SAGE 50 e.g. 770432M01 Kiwi Trouser 32″ Reg Black.
Enter the stock number into Q-trix – it knows that the first four characters of the stock number denote the Product.
Trim all but the Product Name from the description.
If there are any variants that you do not wish to create simply click them to tell Q-trix to ignore them. When you’re ready press the Contunue button and Q-trix will generate all of the variants.
If you notice any variants that you don’t want to create in SAGE you can still click them to remove them from the list – when you are ready to continue press the Update button and Q-trix will create the remaining Stock Records in SAGE.
Q-tron reserves the right to alter Product Specification and pricing without prior notice. E&OE.
- The overall system price will depend on requirements, we will be happy to provide a written quotation on request
- The software is provided with installation, configuration and training at extra cost
- All prices will include first year support
- Support is provided upon condition of a suitable remote link (such as a VPN – virtual private network) to all sites; cover is for a 12-month period and includes all updates
- All prices are subject to VAT