General
What Type of 1D Barcode should I use to generate Barcodes
Unless EAN barcode type is specifically required, it is recommended you use CODE128 type barcode to generate barcodes in Ostendo
Secman64.dll Error Message - There was a problem starting secman64.dll. The specified module could not be found
This error is displayed when the user is running a 64 bit version of Outlook and the secman64.dll file is not present in the Ostendo folder. The attached file should be extracted into the Ostendo folder to resolve this problem. Versions of Ostendo ...
Moving Ostendo to a new server
This article explains how to migrate an Ostendo installation from one server to another
Sophos Antivirus software detecting Ostendo executables as suspicious
The have been reports that Sophos AV software will falsely detect Ostendo executables as suspicious and thereby treat them as such. When configuring the AV software, refer to the link for more information https://community.sophos.com/
Batch Emails going into Outlook Drafts folder
We have had some reports recently about Emails resulting from Batch Invoicing and Batch Stmt printing going straight to the Drafts box in Outlook rather than being sent. This seems to have resulted at some point from either a Windows or Office update ...
Archiving Historical Journal Records
When we post to Accounting products like MYOB AR Live, Xero, QBO and Sage Evolution, we post from 4 tables in Ostendo. JOURNALHEADER (these records will be posted as General Ledger Journals in the Accounting Software) JOURNALLINES (each journal may ...
Error Message - Setup was unable to find Ostendo installation to update
This error message is typically displayed when an Ostendo Update is attempting to be applied to an existing installation. This signifies that the registry key settings for the original installation either no longer exists or is no longer valid. ...
Database Error - Validation error for column "JOBLINEREQUIREMENTS"."PERLINESTDPRICE"
Database Error - Validation error for column "JOBLINEREQUIREMENTS"."PERLINESTDPRICE",value"*** null ***". At Trigger 'JOBLINE_ADDFIELD_INSERT' line: 162, col: 6. This error is displayed when Ostendo is attempting to resolve the Sell Price for a new ...
Ostendo User Rules - Custom Procedures
Controlling Sales Order Pricing and Discounts
Overview: Within Ostendo, we have built in some specific Stored Procedures within the database that allow technical users to include logic that maybe required specific to a sites requirements. These Stored Procedures are always called within Ostendo ...
Connecting to a 3rd Party with HTTP via Scripting
This paper uses MYOB AccountRight Live Desktop application as the sample third-party app to demonstrate how the Ostendo HTTP script functions are used to retrieve and update data from a third party app. The HTTP script functions covered are HttpGET, ...
Corrupted Fonts on PDFs
Sometimes a PDF generated from Ostendo can be viewed on one device without issue whilst on another the fonts appear to be corrupted. This problem can be as a result of the PC using Windows 10 Build 18362.1 Version 1903 or earlier. It appears if the ...
Determining Record Count and Table Sizes
When attempting to determine current database size it is useful to know each tables record count along with its size in MBs This assists with determining whether there are specific tables causing a database to dramatically increase in size. This ...
Determining an Image size from an Ostendo Table
Sometimes there is a need to determine an image size from an image field within an Ostendo table. This can be useful to determine how image sizes have increased the size of a table. This SQL displays the image sizes in descending sequence (displayed ...
Improving Performance of Opening Lists
As a database gets larger, the opening List grids can take longer to load, when 'Include Closed' Orders, 'Include Updated Status' or 'Include Fully Paid' is turned on along with Filtering and Sorting from the Grid options. This is because in order to ...
Screen Logging
File->System Settings->Environment Settings (tab)->Activate Screen Logging Ostendo allows you to trap user activity and habits enabling you to design Workflows and other tools to assist users in areas they are repetitively accessing within Ostendo. ...
Audit Logging
File->System Configuration->Audit Logging If Audit Logging is employed, you should remember that this will create records in the AUDITLOGGING Table Current records can be displayed via General->Inquiries->Inquiry - Audit Logging Audit Logging allows ...
Error Message - Setup was unable to find Ostendo installation to update
This error message is typically displayed when an Ostendo Update is attempting to be applied to an existing installation. This signifies that the registry key settings for the original installation either no longer exists or is no longer valid. ...
Database Error - Validation error for column "JOBLINEREQUIREMENTS"."PERLINESTDPRICE"
Database Error - Validation error for column "JOBLINEREQUIREMENTS"."PERLINESTDPRICE",value"*** null ***". At Trigger 'JOBLINE_ADDFIELD_INSERT' line: 162, col: 6. This error is displayed when Ostendo is attempting to resolve the Sell Price for a new ...
Ostendo User Rules - Custom Procedures
Controlling Sales Order Pricing and Discounts
Overview: Within Ostendo, we have built in some specific Stored Procedures within the database that allow technical users to include logic that maybe required specific to a sites requirements. These Stored Procedures are always called within Ostendo ...