Menu

Post Stock Adjustment

Save time updating

Sage 50

Stock/Product Creation
Customer/Supplier Prices
Bill of Material
Project Creation
Location Bins

Sage 200

Simply extract, edit and import

Xero

Import from Excel

50 Trans

Nominal Journals
Quotes/Invoices/Orders
Remote Orders
Product/Stock Adjustments
Sales Receipts
Quick OrderPad

200 Trans

Transaction from Manual Input

Image Alt TextImage Alt Text

Multiple Transactions from CSV file

Xero

Solve the Puzzle?

Sage 50

Help on every type of import
Demo Video of all functionality
Loads of Examples included
Online Training
We can help too…

Sage 200

Image Alt Text

Xero

Great Customer Satisfaction

Customer Comments

Full Trial with Demo Data
Low cost Subscription
Cancel anytime
From a £1 a day
Saving you hours

Simply extract, edit and import

Power of Excel

Sage 50

Quick Template Creation
Customise with:
    Formula
    Macros
    VBA

Sage 200

To reach your goals quickly

Sage 200

Sage 200 Bins

Sage 200 Warehouse & Bins

Create Sage 200 Bins
Stock Take Bins
Move Bin Stock

Fast, cost effective, easy…

Image Alt TextImage Alt Text

Manufacturing

200 Manufact.

Create BOM Stock Easily
Create Bill of Materials
Labour, Machine, Tools

Image Alt Text

Complex tasks quicker...

50 BOM

Project Accounting

200 Projects

Create Project Structure
Update Budgets
Simple Project Entry

Make life easier...

Image Alt Text50 Projects

Tags for Stock Adjustment Transactions

The following tags can be used to import a Sage Line 200 Stock Adjustment .

See Online Training for Transaction based templates for a full explanation of tags, and how PostTrans reads them to define the Extract/Import template.

Tag Name

Data Type

Description

Header Values:

THAdjType^

Text 2 HeadOnly XML

Type of Adjustment, basically sets the IN/OUT for TLQty
        In Cell Searching values:Stock Adjustment Type
                  AI, Adjustment In
                  AO, Adjustment Out
                  FO, FOC OUT
                  PI, Project Issue
                  GR, Goods Return OUT
                  WO, Write Off

THAccRef^

Text 8 Head Chg XML

Customer/Supplier Ref. Must be set to Customer or Supplier for Stock adjustment type FO or GR
    In Cell Searching values in table THADJAccCode

THTranRef

Text 20 Head Chg XML

Transaction Reference, overides vallue set on Header

THTranRef2

Text 20 Head Chg XML

Transaction Reference2, overides vallue set on Header

THTransDate

Date Head Chg XML

Transaction Date, overides the date set on Header

Project (Pro):

THProjectCode^

Text 30 Head Pro XML

Project if Project stock issue. Can be Projectcode/Phase
    In Cell Searching values in table PROJECTADJCODE

TLProject^

Text 12 Pro XML

Project
    In Cell Searching values in table ProjectCode

TLPhaseFilter^

Text 30 Pro XML

Phase Filter. If project has duplicate Project items in different phases, this can direct to correct Phase
    Sage V21 onwards
    In Cell Searching values in table PROJECTADJPHASECODE

TLCostCode^

Text 8 Pro XML

Cost Code
    In Cell Searching values in table ProjectCostCode

Important Fields:

TLPosted

Text Req

Returns `POSTED` if Trans line has been posted and will be ignored if `POSTED` (required). Also reports errors/warnings in data row

Adjustment Lines:

TLStock^

Text 30 EOF Req XML

Product Description. PostTrans stops importing after finding 5 consecutive blank cells.
    In Cell Searching values in table ProdADJCodeNoDesc

TLDetails

Text 60 XML

Details

TLQty^

Double Req XML

Quantity, ignores any lines with zero qty. This allows a long product list to be listed, and user simply edit a qty to book IN/OUT
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

Location:

TLLoc^

Text 20 XML

Location. DoubleClick to see Stock Levels
    In Cell Searching values in table AdjTLLoc

TLBin^

Text 20

Bin Location. Set to 'Unspecified' if column not in template.. DoubleClick to see Stock Levels
    In Cell Searching values in table AdjTLBIN

TLBinSetAllocP

Integer

Bin Allocation Priority 1-9 if created (settings allows this in setup button)

TLBinSetPrim

Yes/NoTF

Y Set Primary Bin if created (settings allows this in setup button)

Contra Location:

TLContraLoc^

Text 20 XML

Contra Location, Use this to move stock between locations. Set type to "1,Adjustment In" makes TLQty,TLLoc,TLBin the IN Qty/location, and thus a Ref in TLMoveLoc,TLMoveBin specify the Location and Bin to move stock from.
    In Cell Searching values in table AdjTLContraLoc

TLContraBin^

Text 20 XML

Contrat Bin Location. Set to 'Unspecified' if column not in template.
    In Cell Searching values in table AdjTLContraBIN

Value:

TLCostPrice

Currency Read XML

Cost Price

TLTotCost

Currency Read

Total Cost Price of line

TLStdPrice

Currency Read XML

Std Sales Price

TLTotSales

Currency Read

Total Sales Price for line

TLTotContraCost

Currency Read

Total Contra Cost Price of line

Stock Record (PostBack):

StBinQtyFree

Double Read

Product Qty free, updated when stock code entered

StBinQtyInStock

Double

Product Qty In stock, updated when stock code entered

StBinQtyContraFree

Double Read

Product Qty free in contra Location, updated when stock code entered. This figure is used when using to do stock take, and is compared with TLQty

StBinQtyContraInStock

Double Read

Product Qty In stock contra Location, updated when stock code entered

StBinContraLastCost

Text 16 Read

Last cost of Contra Bin

StStockUOM^

Text 20 Read

Returns the UOM for stock item
    Changes in this cell will recalc other cells. Delete ^ to disable this calculation.

Batch/Serial Details:

TLSellByDate

Date Pro XML

Sell lBy Date

TLUseByDate

Date Pro XML

Use By Date

TLBatSerial^

Text 30 Pro XML

Batch Ref or for Serial then a comma seperated list or list with each on new line. DoubleClick to see Stock Levels
    In Cell Searching values in table AdjTLBatSerial

TLBatSerRef

Text 30 Pro XML

Batch/Serial Ref. Searching is provided on AO when location/BIN has been entered

TLSerBatType

Text 10 Read

Returns Ser/Bat if a Serial No/Batch traceable item

TLSupplier^

Text 20 Read

Batch/Serial Supplier
    In Cell Searching values in table Supp

Other:

THWoCategory^

Text 20 Head Chg XML

Write Off Category
    In Cell Searching values in table WOCategory

Analysis Codes:

TLAnal1^

Text 60 XML

Analyisis code 1 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_01

TLAnal2^

Text 60 XML

Analyisis code 2 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_02

TLAnal3^

Text 60 XML

Analyisis code 3 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_03

TLAnal4^

Text 60 XML

Analyisis code 4 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_04

TLAnal5^

Text 60 XML

Analyisis code 5 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_05

TLAnal6^

Text 60 XML

Analyisis code 6 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_06

TLAnal7^

Text 60 XML

Analyisis code 7 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_07

TLAnal8^

Text 60 XML

Analyisis code 8 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_08

TLAnal9^

Text 60 XML

Analyisis code 9 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_09

TLAnal10^

Text 60 XML

Analyisis code 10 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_10

TLAnal11^

Text 60 XML

Analyisis code 11 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_11

TLAnal12^

Text 60 XML

Analyisis code 12 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_12

TLAnal13^

Text 60 XML

Analyisis code 13 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_13

TLAnal14^

Text 60 XML

Analyisis code 14 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_14

TLAnal15^

Text 60 XML

Analyisis code 15 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_15

TLAnal16^

Text 60 XML

Analyisis code 16 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_16

TLAnal17^

Text 60 XML

Analyisis code 17 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_17

TLAnal18^

Text 60 XML

Analyisis code 18 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_18

TLAnal19^

Text 60 XML

Analyisis code 19 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_19

TLAnal20^

Text 60 XML

Analyisis code 20 - Setup View >> Analaysis code menu option will list mapping numbers and values
    Sage V2015 onwards
    In Cell Searching values in table AnalCust_20

Default Locations:

THDefaultLoc^

Text 20 HeadOnly Chg

Setting this will set the default location for TLLoc on each line
    In Cell Searching values in table Loc

THDefaultContraLoc^

Text 20 HeadOnly

Setting this will set the default location for TLContraLoc on each line
    In Cell Searching values in table Loc

Header:Before Posting:

THBefSWCompany^

Text 6 Head Chg Pro

This will cause PostTrans to change company before posting if different from current Sage Line 50 Company. Thus can be user to post transactions into different companies, thus intercompany transactions are possible. It uses a 6 letter company code, which found by pressing the Select Company button in system setup.
Posting to multiple companies
    In Cell Searching values in table CompanySelect

THBefDisplayMess

Text 60 HeadOnly

If contains value, then this text is displayed, and import cannot take place until this text if clear. Thus you can your own formula, macro or VBA code to stop import until a certain condition.
Validating Transaction before posting

THBefDisplayMessYN

Text 60 HeadOnly

If contains value, then this text is displayed. Asks Yes/No to continue
Validating Transaction before posting

Header - After Posting:

THAftProcessSheet

Text 60 HeadOnly Pro

After posting this sheet, switch to work book with this name, and post that. Allows back to back purchase orders, or multiple company transfers. PRO
Posting multiple sheets

THAftSwitchSheet

Text 60 HeadOnly Pro

After posting this sheet, switch to work book with this name PRO
Posting multiple sheets

Header - After Save:

THAftSavePATH

Text 60 HeadOnly Pro

If THAftSavePATH and THAftSaveFilename specified, will save as PATH + ‘\YYYMM\’ + Filename + "_0000.xls". YYYMM can be overridden with value in THSaveSubDirectory cell.
Saving template after posting

THAftSaveSubDir

Text 60 HeadOnly Pro

See THAftSavePATH
more about saving

THAftSaveFilename

Text 60 HeadOnly Pro

See THAftSavePATH. Example ‘ABAP01’ will saveas ABAP01_0001.xls.
more about saving

Import File:

THImportFullName

Text 500 HeadOnly

Full PATH and Filename of the file just imported using the Import button. This is required if you set the directory to move file after posting transaction.
File Import instructions

THImportFileName

Text 500 HeadOnly

Filename of the file just imported using the Import button
File Import instructions


Req = Field is required    EOF = End of file, Stop when no more values    

XML = Un-attended PostTrans XML API for Sage 200

Head  A header tag can be used in header section, before row 30, of the transaction template.  Or in the rows data of data, below row 30, of the template like a traditional CSV importer.

With data type Yes/No fields, if cell starts with 'y' or 'Y' is taken as TRUE

Where ^ denotes a In Cell Code Search, delete ^ at end of tag, to turn off code search

All Text fields are trimmed (spaces before) by default. Add ' to the end of the tag name to stop this.