Transaction Broker
Transaction Broker supports Sage accounting Software UK
  • Key Features
  • Screenshots

Transaction Broker – Import & Export of Information

The object of transaction broker module is to bring information in and out of Interprise automatically. Each item line below would be an export and an import. Transaction Broker has a translation feature where data in one system is different to the other.

 

 

Customer

  • New Customer records Template
  • Amend or Update Customer Record
  • New Sales Invoices & Credit Notes Template
  • New Sales Orders Template
  • Sales Order Confirm Qty Pick
  • New Sales Receipts
  • New Customer Refunds
  • Update Customer Part Codes and Descriptions for Items
  • Update Customer Specific Prices
  • New Opening Balances

Supplier

  • New Supplier records Template
  • Amend or Update Supplier Record
  • New Purchase Invoice and Credits Template
  • New Purchase Orders Template
  • New GRN Linked to Purchase Order
  • New GRN Not Linked Purchase Order
  • New Supplier Bill Linked to GRN
  • New Supplier Bill Not linked to GRN
  • New Purchase Payments
  • New Supplier Refunds
  • Update Suppliers Cost Price, Usual Order Qty, Qty in Stock like icon button manually
  • Update Suppliers Part Costs and Descriptions for Items/li>
  • Opening Balances

Stock

  • New Stock Item Template (All types Stock, Matrix, Kits etc)
  • Amend or Update Stock Item
  • New / Update Normal Price List
  • Update Wholesale / Retail Price Base and Other Currencies
  • Stock Take Update Qty in Stock

Accounting

  • New Journal
  • New Nominal Codes
  • Update Budgets by Fiscal Year
  • Update Budgets by Fiscal Year & Period

Bank

  • New Bank Payment
  • New Bank Receipt

Any problem files are moved to a problem directory and a list of failed files are viewable by a user with a message as to why they got the error. We also have an email alert for failed files.

Files will be moved to a Imported directory and stamped as imported so they cannot be imported again by mistake.

Transaction Broker will accept Excel files (with correct headings) or CSV (fixed width) files or XML. We have defined layouts of these files.

 

You can setup as many company data sets as required.

You can setup as many company data sets as required.

Customer Example, we can import and export customers and invoices.

Customer Example, we can import and export customers and invoices.

You can specify the location where the import files are going to be, also if on a schedule how often it will look for the files.Also there is an export option to export the same information to a folder on an interval and whether it’s a complete dump or just new invoices in this case.

You can specify the location where the import files are going to be, also if on a schedule how often it will look for the files. Also there is an export option to export the same information to a folder on an interval and whether it’s a complete dump or just new invoices in this case.

The template button shows the field layouts for anyone who was going to provide a file for the system to import. The export would also follow the same format.

The template button shows the field layouts for anyone who was going to provide a file for the system to import. The export would also follow the same format.

The template shows the field, the type and whether its mandatory or optional. It also shows where the default value will be taken from if not in the file. And a helpful list of possible values taken from the database.

The template shows the field, the type and whether its mandatory or optional.
It also shows where the default value will be taken from if not in the file.
And a helpful list of possible values taken from the database.

Very important for imports is when data in one system is not same as another. In the case of currency for example one system may have it as 1,2,3, another GB, FR, DE etc. so we allow you to translate a value to another in the system. If the Interprise value comes from the database you get a pull down on the field.

Very important for imports is when data in one system is not same as another. In the case of currency for example one system may have it as 1,2,3, another GB, FR, DE etc. so we allow you to translate a value to another in the system. If the Interprise value comes from the database you get a pull down on the field.

Another good feature is allowing multiple values = the same thing in IS as well. Like above I have said that 1 and 11 = GBP

Another good feature is allowing multiple values = the same thing in IS as well. Like above I have said that 1 and 11 = GBP

The start option allows you to set the schedule per database.

The start option allows you to set the schedule per database.

Email option for file problems

Email option for file problems

We have a file log or audit trial of problems and successful files

We have a file log or audit trial of problems and successful files