Micronet Distribution Adaptor
[Sticky] Read First Before Posting
Please post in this forum topics that contain tips or advice that is related to the Micronet Distribution adaptor within the Connector software, and the connectivity between the adaptor and the Micronet Distribution business system. If you wish to post more broader topics related to the Connector then please do so in General Tips and Advice
If you have found a bug in the Connector please post it in the Bugs forum.
If you wish to discuss about an improvement or new feature you would like to see in the Connector then please post in the New Features/Improvements Wish List forum.
Please ensure that you do not post any information containing user names, passwords, or any other sensitive information that could compromise the security of a project or website relating to an organisation or person.
How does TOTECS handle Micronet Territory Exclusion Contract?
Micronet Exclusive contract works in reverse order. Any product that is part of the contract is not allowed to order by the customer in a sales territory. How do you replicate an exclusive contract in TOTECS?
Rounding line item prices to 4 decimal places when an order is submitted
Is there a way to have Micronet to import line item pricing to 4 decimal places on the lines on an order that is submitted to Micronet using the type 3 DataConnect file format?
Micronet adapter not exporting Customer Account Pricing due to the Micronet's ODBC database not responding
When running a Product Account Pricing import from Micronet, the connector was giving the following error message:
{code}
ERROR [40001] [DataDirect][OpenAccess ODBC]Transaction rollback - Statement completion unknown - No confirmation received
ERROR [S1901] [DataDirect][OpenAccess ODBC]Retix proprietary error: Implementation defined Retix error
ERROR [S403c] [DataDirect][OpenAccess ODBC]RDA_SUR_ERR_NO_SUCH_ACB
ERROR [S1901] [DataDirect][OpenAccess ODBC]Retix proprietary error: Implementation defined Retix error
ERROR [S403c] [DataDirect][OpenAccess ODBC]RDA_SUR_ERR_NO_SUCH_ACB
{/code}
What can we do about this?
How do you route Back Order Lines data export from the Micronet adapter to a generic adapter?
I have set up a Customer Account Record Back Order Lines export in a generic adapter, however in the Micronet adapter there wasn't an option to route the Customer Account Record Back Order Lines data export to the generic adapter.
How do I set up the routing?
How are address fields in sales orders submitted to the Micronet Distribution system when orders are sent as Type 3 orders
When a sales order is sent from a website hosted on the TOTECS platform to the Connector, if the sales order is sent to the Micronet Distribution using the Micronet Distribution adaptor, and the order is sent as a type 3 order, which delivery address fields are sent in the order?
Submitting orders into the warehouse that is assigned to a debtor
How do you set up TOTECS and the Connector so that orders are submitted to a warehouse that is assigned to the specific debtor?
How is a product Designated as a kitted product in the Micronet Adapter
What determines whether or not a product is determined as a kitted product in the Connector's Micronet adapter?
Discounts being applied to already discounted pricing
What can I do if the pricing on an order already has a discount from a discount matrix applied, and the order is being imported into Micronet Distribution with the discount being applied a second time?
Importing Customer Account data after debtor data has changed in Micronet Distribution system
Hello, A question came up about changing a setting for a debtor in Micronet and importing that via the Admin Centre. If I change the 'Cash Sale' setting of a debtor to 'yes', and then in the Administration Centre run a manual import for 'Customer Accounts', 'Customer Account Addresses' and 'Customer Account Contracts'. Using these settings the setting that was changed was not immediate, however the change was imported overnight. Should there be other imports selected when importing from the Admin Centre? Does this import need to be done from the Accounting Connector?
How does the Micronet Distribution adaptor export product combination data?
A question was asked on how does the Micronet Distribution adaptor within the Connector export out product combination data from Micronet's Distribution system?
When the Connector imports invoice payments into the Micronet Distribution system it causes duplicate payments to be imported
It was reported that for a Connector deployed and configured to import invoice record payments into a Micronet Distribution system, that duplicate payments were being applied to the associated debtor account. The question is why is this occurring?
Can freight and credit card surcharges that are charged as Micronet line items be assigned to different GL categories?
Micronet products are assigned by default to the TOTAL General Ledger account. TOTECS has two modes of applying freight, minimum order surcharge and credit card surcharges where the first mode applies it to the order header and the second mode as order line item under the following product codes respectively WEB_FREIGHT, WEB_MIN_ORDER, WEB_CC_SURCHARGE. These items are set to a non diminishing category so that stock is not allocated. For these products, can the fees be posted to alternative GL accounts?
How do I manage and restrict products viewable by TOTECS users from Micronet's Distribution system?
A question was asked by a pharmaceuticals wholesaler who sell general health products to pharmacies and medical clinics, but also sell a select range of licensed products to a small group of pharmacies and medical specialists. Can a TOTECS project be configured to restrict the product catalogue for each type of customer and can we manage this in Micronet's Distribution system?
What pricing structures does TOTECS support in Micronet's Distribution system?
Often eCommerce Platforms claim they integrate but this means nothing until you dig into pricing. Micronet has a very elaborate set of pricing functions that determines each customers final purchase price. Does TOTECS handle Micronet's pricing fully?
How does Micronet's Distribution system perform rounding on sales orders?
In some cases, online orders created by the TOTECS platform are out by a few cents when an order is imported by the Connector into Micronet's distribution system. The question is the TOTECS platform rounding differently to Micronet's Distribution system?
When using the Micronet Data.Connect Sales - Header import routine, can you set conditional switches for field mappings such as payment type so that a credit card payment can be allocated as a credit against the debtor account?
Micronet have customised the Data.Connect Micronet Sales - Header routine for our client in version 2.7 so that a credit card payment can have the credit applied to the order. Micronet advised that we can set the DIL_PAYMENTTYPE to a payment type (Ie. 5) setup in the company settings -> Payment Types. The TOTECS Connector Micronet Adapter creates a CSV file where one of the fields is the payment type with values 'credit', 'account' etc. If the field value is set to 'credit' we need to switch to a value of 5 when imported into the DIL_PAYMENTTYPE field and a empty string for all other values. Is there a way to set a conditional check of the incoming field data and switch it? Ie, If 'credit' then set DIL_PAYMENTTYPE=5 else empty string
Contract pricing not being applied to customer accounts when a contract contains trailing white space in its contract ID
An issue was reported where the product pricing of a contract was not being displayed to a user in a TOTECS project when the user was assigned to a customer account that should have had the contract pricing applied to the product that they were seeing. This occurred for a contract that was imported into the TOTECS project from a Micronet Distribution system.
Product Account Pricing data export in Micronet Distribution adaptor failing to export discount matrix data
It was reported within the Connector, when the Micronet Distribution adaptor was used to obtain Product Account Pricing and the "Export Category Discount Pricing" setting within the adaptor is set to Yes, the data export was failing to complete and an error was appearing in the Connector's logs with the following details:
Message: Unable to connect to Micronet29 Connector or close its connection
Technical Message: Error occurred when generating Customer Account Pricing. Exception of type 'System.OutOfMemoryException' was thrown.. Stopped at account ID: Contract ID: Discount Category: 25
How to have a flag set for products when they are assigned to a tax free taxcode
A question was asked if there is the ability to assign a flag to products in a TOTECS project using the Connector software, if products(items) are assigned to a taxcode in the Micronet Distribution system that has 0% percentage of tax applied, ie tax free.