Codis c o d i s
  • Products
  • Services
  • Excelerator
  • Sage
  • Partners
  • Blog
  • Support
  • Contact
  • Search

Post Stock Transfers from Excel to Sage 200

In this post, we’ll give you a quick tutorial on how you can effortlessly create and maintain Sage 200 stock items from Microsoft Excel. To see this live, book a free demo today.

View a video of this tutorial here:

     

First, let's look at the item we want to transfer in Sage 200. We want to transfer 90 of these door handles from the Store back to the Factory. So, there will be 440 in the Factory and 2,000 in the store once we have made the transfer.

Stock in Sage 200c

Open the Stock Transfers templates. These are supplied with Excelerator and there are four pre-made templates to choose from.

Stock Transfers template

In this example, we will use the template for traceable stock items. We begin by right-clicking the Stock Code cell and browsing Sage data directly from Excel. 

Browse Records

We can now use Excelerator's powerful browse and search feature to find the door handle.

Browse and Search Feature 

We can complete the remaining fields using the same browse and search functionality. 

Complete Stock Transfers Template

We can now click Save to Sage so upload this transfer to Sage. Clicking Save to Sage also checks and validates the data to ensure it adheres to Sage's rules.

Stock Transfers - Save to Sage

Excelerator confirms that data has been saved.

Save Successful
 

If we go back into Sage 200, we can see the data has been updated. We have just update Sage from an Excel spreadsheet.

Saved in Sage 

Custom spreadsheet templates

Want to download stock transfers into your existing spreadsheets? The spreadsheet designer is for you. To see the spreadsheet designer live, book a free demo.

The spreadsheet designer will allow you to choose exactly which Sage 200 stock transfer fields you would like to download, and exactly which cells in Excel they will be downloaded into. All standard fields for Sage 200 stock transfers are available to you, including (but not limited to):

  • Stock Code
  • Stock Item Name
  • Quantity
  • Stock Unit
  • Batch Number
  • Stock Location
  • Stock Bin
  • Transfer Location
  • Transfer Bin

Create your spreadsheet template in five simple steps

Open the Designer. To create your template, being by selecting the Designer button on the Excel ribbon.

The designer button in the Excel ribbon 

Once the Designer has opened, you will find the fields on the right of the template. Here, you can also enter the number of rows you'd like your spreadsheet to have. It doesn't matter if you add more rows than you need. In this example, we'll add 50 rows.

Spreadsheet Designer 

Select the fields we would like to add. They will begin to appear on the worksheet.

Selected Fields
 
Use Excelerator's powerful browse and search feature to complete the fields.

Complete All Fields 
Once you're happy with everything, click Save to Sage.

Click Save to Sage 

And there you have it, your own custom spreadsheet template ready to download, edit, create and browse on Sage 200 stock transfers. It’s as simple as that.

Where to go from here

Did you find this helpful? Check out more tutorials using Excelerator for Sage 200.

If you are looking for more detailed help, see our online Sage 200 Excelerator help.

Don’t have Excelerator? Enquire now for a free demo and find out why more than 4000 licences have been sold across the globe.

Stay up-to-date, follow us on 
LinkedIn and Twitter.

 


by Terry Silver | Dec 15, 2017
< All posts
  • Home/
  • Blog/
  • Excel to Sage 200 Tutorials
More Info
  1. Codis News
  2. Products
  3. Services
  4. Support
  5. Contact
Recent Posts
  1. Post Stock Transfers from Excel to Sage 200
  2. Post Cashbook Receipts from Excel to Sage 200
  3. Post Cashbook Payments from Excel to Sage 200
  4. Post Sales Quotations from Excel to Sage 200
  5. Post Sales Ledger Receipts from Excel to Sage 200
Follow Us
  1. Google+
  2. Twitter
  3. LinkedIn
  4. YouTube
  5. RSS
Contact


info@codis.co.uk
020 88 610 610
Codis Limited

24/25 The Shard
London
SE1 9SG

  1. Blog
  2. News
  3. Careers
  4. Partners
  5. Terms & Conditions
  6. Cookies
  7. Sitemap

Copyright © 2018 Codis Limited. All rights reserved.