Alternative Stock
Requires PRO version of PostTrans
Demonstration Video
The video shows how to use PostTrans for Sage 200, to import, or amend stock records, Alternate code database, in Sage 200 from within Excel.
| Sage 200 Easily Import/Amend - Alternate Stock Codes Records from within Excel | |||
| 0:00 | Intro | ||
| 0:33 | Product demo | ||
| 0:50 | Extract Stock Records with Alternate Stock Codes | ||
| 1:20 | Edit Sage 200 Alternate Stock code | ||
| 3:40 | Import amended Sage 200 Alternate Stock codes | ||
| 4:00 | Prove the update in Sage 200 | ||
Download Stock Alternative Record Extract/Import Template
see 'Stock Alt' sheet
To use the template, with Sage 200, install PostTrans. Download
Trial with Sage demo company. Purchase a month subscription for Live Sage Company. Price
Watch the On-line Training course on how to use and customise the templates.
Tags StAltCode1-5 can be specified, to extract/amend or import stock Alternative Stock. When extracted tag StAltCode1-5 contains the Alternative Stock code and description. To delete a Alternative Stock record from the list, simply delete the code in StAltCode1-5 cell, and press Import.
Tags of interest:
|
Tag |
Description |
|
StAltCode1-5 |
Alternative Stock code. Anything after comma is ignored. |
|
StAltP1-5 |
Preferred Flag. Last YES read is taken as Preferred |
Set StAltP1-5 to YES to change the allocation of preferred Alternative Stock. When the data is extracted, StAltP1 contains the preferred Alternative Stock, thus the first column is the preferred Alternative Stock.