Menu

Operation Register

Sage 200:Operation Records

All of the following functionality requires the PostTrans Manufacturing Module.

PostTrans imports Operation Records, which could be manually entered with the assistance of in-cell searching, using copy and paste, imported from CSV file or extracted from Sage 200 using the Extract button.

Extract/Import Sage 200 Operation Records

Extract/Import Sage 200 Operation Records

Explanation of this type of Import

This sheet allows the user to extract/update/create Operation records used in the Sage 200 Manufacturing Module.

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.

Apart from column A these fields can be rearranged, hidden, and more columns mapped by using the Tags button to insert new tags. See 'Template Structure' section below.

Template Structure for Static Data

The template must have tag ‘Sage200manOpReg’ in cell A1 to instruct PostTrans that we are interested in Sage 200 Operation Records, and that the sheet is a PostTrans Template.  Pressing Import or Extract on a blank sheet will either open an existing example or create basic template for you to customise.

Row 1 contains a series of tags, which denote to PostTrans the data to be read/written in each column. These tags, and data columns can be rearranged to suit your needs, and the tags are added using the Tags button. See on-line Training   Deleting the Tag name, in the cell, from this row removes the Sage 200 mapping.   Table of Operation Records Tags

Close up of template Sage200manOpReg for Operation Records

Close up of template Sage200manOpReg for Operation Records

Hovering over these tags, in row 1, will show a comment which explains the tags purpose, data type and any other useful details.

Common Features

In-Cell Searching

Any Tag ending with ^ with have a in-cell search facility to look up associated values.  Use SPACE + TAB to see all values, or SPACE and TEXT to perform a text search on description. These are returned to the cell as "CODE, DESCRIPTION".  PostTrans only uses the CODE and ignores the comma and anything after it, thus data from a field would only need the CODE part of the data if from an external imported file.  

In-cell Searching can be turned off by removing the ^ from the end of the tag name, or name in first line of comment (Header cells) to disable in-cell searching for a single column, or header cell.  All in-cell searching can be turned off in SetupIn-cell searching.

Extracting the Data

The data extracted using the Extract button can be filtered, by entering criteria in row 2. Hover over cell A2 for instructions. Extracting Data

In addition to this some sheets have a OrSearch tag/column. In this case the user can paste a list of codes in column, and press Extract button, to extract those records to the sheet. Entering a single code in this column will extract a single record.

Amending Operation Records Data

Having extracted data, the user can now simply edit the Operation Records in Microsoft Excel, before re-importing it back into Sage 200. 

PostTrans uses the tagged column OrCRC to detect changes in rows.  Therefore, only records/rows which have changed since extraction are updated.  If you add or delete a tagged column, PostTrans will treat ALL rows as having changed, and thus ALL records will be updated on next Import.

Importing the Data

Simply press the Import button to validate and import the data into Sage 200.  PostTrans will read the Header cells and then process the rows of data until OrRef column contains no data. The Sage Company imported into can be set in the Setup window.

PostTrans ONLY edits those fields listed on the sheet when importing, thus any existing values, on a record, are unaffected.   New records may have default values for certain fields.

File Import Button

This can be enabled in Setup to easily import cvs, or fixed length files, into sheet for importation.   Formula can also be added, or macros/VBA to manipulate this data before importation.   Import from CSV file.

Validation

Any values and associated codes will be invalid during import.   The cursor will be moved to highlight any problems in data.

Evaluation and License

This functionality will work with Sage Demo data without a license. A license is required to import into any other Sage Company.  Pricing

Delete Records

The Tag/Column OrDelete can be used to delete records, following the usual Sage 200 rules.

What else can I do?

Other Sage 200 Extract/Import types

Frequently Asked Questions?

Got another question? It may well be covered on our Frequently Asked Questions page.

Other Useful Topics

Clear Transaction and copy down formula

PostTrans Tags which map to Sage 200

Not all these tags/columns are needed. The table below lists the required and recommended:

Tag Name

Data Type

Description

Important Fields:

Sage200manOpReg

Text Req

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

OrCRC

Text Req

Contains CRC number to help PostTrans detect changes in current row.

OrDelete

Text 1

Delete record if "X"

OrSearch^

Text 8 Req

Search for record by entering code or pasting list, at top of column, and pressing Extract button
    In Cell Searching values in table ManOpRegCode

Operation Reg:

OrRef

Text 30 EOF Req

Reference

OrDesc

Text 50 Req

Description

Options:

OrDoNotPrint

Yes/NoTF

Do not Print Operation

OrSubCont

Yes/NoTF

Sub Contract Operation

Operations Overlap:

OrOpOvQty

Double

Overlap Qty

OrOvShrinkagePerc

Double

Shrinkage %

OrOvPerc

Double

Overlap %

Operations Runtime Defaults:

OrRuHours

Integer

Run Hours

OrRuMins

Integer

Run Mins

OrRuSec

Integer

Run Secs

OrRuQty

Double

Run Qty

Operations Delay:

OrDlHours

Integer

Delay Hours

OrDlMins

Integer

Delay Mins

OrDlSec

Integer

Delay Secs

Operations:

OrNotes

Memo

Notes


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

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.


Related Example Sheets

You can easily access the example sheets by pressing Help button, on the PostTrans Toolbar to access these related examples, or downloading them from the links below.

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.

Bill of Materials:

 

Bill of Material Version (Module: Manufacturing)

Sheet:'BOM'
Import/Extract Bill of Material Versions
   Help article for BOM Items with Versions

 

Bill of Material Items (Module: Manufacturing)

Sheet:'BOM Items'
Import/Extract Bill of Material Items
   Help article for BOM Items

Manufacturing:

 

Labour (Module: Manufacturing)

Sheet:'Labour'
Import/Extract Labours
   Help article for Labour

 

Labour Group (Module: Manufacturing)

Sheet:'LabourGrp'
Import/Extract Labour Groups

 

Tool (Module: Manufacturing)

Sheet:'Tool'
Import/Extract Tools

 

Tool Group (Module: Manufacturing)

Sheet:'ToolGrp'
Import/Extract Tool Groups
   Help article for Tool Group

 

Machine (Module: Manufacturing)

Sheet:'Machine'
Import/Extract Machines

 

Machine Group (Module: Manufacturing)

Sheet:'MachineGrp'
Import/Extract Machine Groups

 

Operation (Module: Manufacturing)

Sheet:'Operation'
Import/Extract Operations
   Help article for Operations

 

Operation Resources (Module: Manufacturing)

Sheet:'Operation Resources'
Import/Extract Operation Resources
   Help article for Operation Resources