| |
IRIS
Enterprise - PostTrans Examples
|
Name |
Description |
|
Timesheet |
This
spreadsheet shows how to import Timesheet information in to IRIS
Enterprise
Detailed Timesheet Import
>> This sheet will post many timesheets into Exchequer Job
Costing for each Employee and day
Summary Timesheet Import
>> This sheet imports total hours for each week onto Exchequer Enterprise
Uses
: Remote timesheet entry. We recommend the Professional version
since it display popups for easy code selection, for remote data entry.
Video
: Create
remote Timesheets, using popup lookups |
|
Quick Order pad |
This
spreadsheet allows a user to take an order quickly, then import it into
IRIS Enterprise. Simply enter the account code, and enter the
quantities to order in Qty column. You will need to fix the OLE references
to allow it to display price, description
Demonstrates:
Ignore 0 qty, e-mail (Professional
version),
fax printing (Professional
version),
General Exchequer notes, Alarmed Exchequer Notes, the use of Exchequer OLE
to get stock Qty free and current prices, Grouping of stock
Uses
: Cheap alternative to TeleSales module
Remote order entry. We recommend the Professional version
since it display popups for easy code selection, for remote data entry.
Video
: Create
Quick order pads for Telesales operations |
|
NOM |
These
spreadsheets allow a user post Nominal journals into IRIS Enterprise
Contra Nom with Jobs
>> Post a simple journal, into Exchequer Enterprise, with contra
lines
Nom with Jobs
>> Post a simple journal, into Exchequer Enterprise, with Job
Costing information
NOM
>> Post a simple journal, into Exchequer Enterprise, with different
currencies
NOM with Credit and Debit Cols
>> Post a simple journal, into Exchequer Enterprise, with
Traditional Credit/Debit columns
NOM in diff cur
>> Post a simple journal, into Exchequer Enterprise, with
Traditional Credit/Debit columns + different currencies with exchange
rates specified on each line.
Uses
: Automate repetitive Nominal Journals
Automate
repetitive Currency based Nominal Journals
Video
: Create
Nominal Journals |
|
ADJ |
This
spreadsheet shows how to import stock adjustment information in to IRIS
Enterprise
ADJ
>> This sheet will post a Stock Adjustment for Quantities specified in “In/Out” column. If a location in specified in M3, then will contra to this location
Allocate Stock
to a job
>> This sheet will post a Stock Adjustment for Quantities specified in “In/Out” column.
And allocate stock to a job
Uses
: Move Demo stock to and from a VAN location easily.
Help automate repetitive large IRIS
Enterprise stock adjustments
Allocate
stock to a Exchequer Enterprise job
Video
: Create
Stock Adjustments |
|
SQU |
This
spreadsheet shows how to import Sales Quote information in to IRIS
Enterprise with revision History
SQU
>> This sheet will post a Sales Quote for Prices/Quantities specified. This sheet also saves to "C:\" + "SS00003" * "xx.xls" (Your Ref) automatically, as specified in
cells N2 and N3. The reference to the saved sheet is then automatically added to the Links in Exchequer.
Quote Revision History
Therefore a user can open a template, create and post a quote into Exchequer, this spreadsheet could hold a wealth of other information
regarding the quote or job. The Quote spreadsheet can easily be access from the Links button in Exchequer, and the quote can then be
modified and reposted. PostTrans will then save a new revised copy of the quote, with a new link to quote template.
Uses
: Quote Revision History
Allows detailed information to be stored with quote
Demonstrates:
General Exchequer notes, Alarmed Exchequer Notes, Automatic Linking to
Transaction in Exchequer Enterprise with revision tracking
Video
: Sales
Quotes with revision history |
|
Other
Transactions
Not
covered in examples above |
This
spreadsheet shows how to import Other types of Transaction information in
to IRIS Enterprise which are not covered above.
SOR
>> This sheet will post a Sales Order for Prices/Quantities
specified into Exchequer. see "Quick Order Pad" as a
better example
Video
: Create
Sales Orders
PIN
>> This sheet will post a Purchase Invoice for Quantities/Prices specified for job.
SRI
>> This sheet will post a Sales Receipt with Invoice for Quantities/Prices specified. Payment details are entered in H4,H7 and H8.
Change cell C3 to PPI for Purchase Payment
PPI
>> This sheet will post a Purchase with Payment with separate lines. PostTrans will break in to
separate transactions when the account code in column E changes value.
SJI diff cur
>> This sheet will post a Sales Journal Invoice posting to four new accounts with different currencies. PostTrans will break in to
separate transactions when the account code in column E changes value or the date in B.
PPI from file
>> This sheet will post a PPI's for cheques/BACS payment produced in an external bespoke system. A simple file is imported into this sheet to create the journals in IRIS Enterprise
SIN from file
>> This sheet will post many SIN's. PostTrans will break in to separate
transactions when the account code in column E changes value or the date in B.
Uses : This allows an external system to create a simple file, which can be easily imported into Exchequer
Cost effective integration into
|
|
Order
from cheapest Supplier
(Professional
version) |
This
spreadsheet shows how to Import Stock, Import Stock prices into the
Alternative stock codes database, and then use this information to raise
purchase orders, to order from cheapest Supplier within IRIS
Enterprise. More
information
To
use example you must first import data in "Stock Alt Code DB"
and "Discounts" then use "POR Entry" to choose
cheapest supplier
POR Entry
>> Allows user to specify the stock they want to
purchase. Then as it is being posted into IRIS Enterprise, the
operator can view suppliers, together with prices and discounts
given. The operator then select who to purchase from and finally the
POR's are raised for stock in Exchequer Enterprise.
Discounts
>> Allows importation of discounts suppliers may give
Stock Alt Code DB
>>
Uses
: Save money by ordering from cheapest supplier |
|
Import History |
This
shows demonstrates some of the rounding problems which may be experienced
if importing from an external system, such as importing the history from a
redundant accounts package. |
|
Update
Lines
|
These
sheets were developed to allow transaction fields to updated
Update Lines
>> This Sheet allows the user to update existing lines, on
un-posted transactions, within Enterprise. It simply loads the specified Transaction, then searches for the
Stock Code within the Transaction. If it exists then updates the Specified fields. If the item is not on the transactions then it is added to the Transaction.
Uses
: Adjust the time booked to a job on an SOR
Fill in the finished Issue figure on an WOR, therefore a whole batch of WOR's can be finished
Update TLUsers
>> This Template was written to update user fields on each transaction line for a Stock item between two periods. This allowed the customer to post back revised cost, for each stock item, months after the transaction has been posted, for reporting purposes. |
Examples
Spreadsheets for Importing Data
These
can be invaluable when setting up IRIS Enterprise, and maintaining complex data,
such as BOM's, Alternate code DB, Discount Matrix, etc.
|
Name |
Description |
|
Customers and Stock |
These
spreadsheets allows Exchequer Enterprise Customer/Supplier/Stock records
to be imported/extracted/updated, plus the other associated records:
Import Cust and Supp
>> >> Allows importation, extraction, and amendments, to made
to the IRIS Enterprise, Customer and Supplier database. More
information
Import Stock
>> Allows importation, extraction, and amendments, to made to the
IRIS Enterprise, Stock database. More
information
BOM
>> Allows importation,
The
following are only available in the Professional version of PostTrans:
Stock Sup Eq Opp DB>> Allows importation, extraction, and amendments, to made to
the IRIS Enterprise, Stock superceding, opportunity, equivalent
database More
information
Stock Alt Code DB
>> Allows importation, extraction, and amendments, to made to
the IRIS Enterprise, Stock alternative code database More
information
Stock Discounts
>>
Allows importation,
Account Discounts
>> Allows importation, extraction, and amendments, to made to
the IRIS Enterprise, Account discount database More
information |
|
GL
and Bank Rec |
These
spreadsheets allows Exchequer Enterprise General Ledger records to be
imported/extracted/updated, plus the other associated records:
Import GL codes
>> Allows importation, extraction, and amendments, to made to the
IRIS Enterprise, General Ledger structure More
information
Bank Rec
>> Imports data to allow automatic Bank reconciliation |
|
Jobs
(Professional
version) |
These
spreadsheets allows Exchequer Enterprise Job costing records to be
imported/extracted/updated, plus the other associated records:
Job
>> Allows importation, extraction, and amendments, to made to the
IRIS Enterprise, Job Costing database More
information
Job
Analysis >> Allows importation, extraction, and amendments, to
made to the IRIS Enterprise, Job Analysis codes database More
information
Job
Rate >> Allows importation, extraction, and amendments, to made
to the IRIS Enterprise, Job Charge/Cost Rates database More
information
Job
Employee >> Allows importation, extraction, and amendments, to
made to the IRIS Enterprise, Job Costing Employee database More
information
At
present this Job Costing functionality will not Amend or Import data |
Examples
Spreadsheets for Serial/Batch and Multi-Bins
|
Name |
Description |
| Stock
Take |
Stock
Take Spreadsheet, similar to sheet below |
|
bins
serial batch |
This
spreadsheets allows shows how to use Exchequer Enterprise Serial/Batch and
Multi bins with PostTrans:
Video
: Stock
Take for Serial/Batch/Multi-Bins
ADJ with Serial/Batch/Multi-Bins
It
is suggested that you:
1) Import Stock, via “Import Stock” sheet.
This includes Exchequer Enterprise
Serial/Batch
and Multi-bin stock items
2) Purchase the stock, via “PIN” sheet. This creates stock
levels within
IRIS Enterprise
3) Optionally stock take, via “Stock Take” sheet
4) Optionally Sell stock, via “SIN” sheet
5) Optionally Adjust stock, via “ADJ” sheet
|
|
