Subject: Explains how you may display pricing from Omni Price on a website. More Information: In order to display pricing you may use SQL APIs that will allow you to develop a way to display the pricing. You may download the SQL APIs from the...
Knowledge Base
Records are not populating in the Transaction Logging table (WDC12100)
Why are records not populating in the Transaction Logging table WDC12100, when bringing in orders through our sales order import process? The WDC12100 is the log table. This table contains data when Transaction Logging is enabled in the Omni Price...
Registration Keys: Invalid or not registering on GP9.0 or earlier
Issue: Your Registration Keys are showing as 'Invalid' when your Maintenance Agreement is current and the Keys appear to be correct. Cause: Sometimes it is possible that there is data stuck in the WDC40000 table which is causing the Registration...
Error: "The Registration Keys are Hexidecimal and can only contain the following characters: "0123456789ABCDEF", please check and re-enter the key."
Error: You are receiving the following error message when attempting to enter in your Registration Keys into an old version of GP, such as GP9.0 or earlier. The Registration Keys are Hexidecimal and can only contain the following characters:...
Permission errors referencing the WDC_Registration or WDC_Version_Info tables
When logging in with a user other than 'sa', I am getting permission errors referencing the WDC_Registration or WDC_Version_Info tables, what's wrong? The installation of Omni Tools on your Great Plains SQL versions system has not been successfully...
Pricing Mode Codes
What are the codes associated with the Pricing Modes? The codes are as follows: 1 - Fixed Price 2 - Fixed Adjustment 3 - % of Standard Cost 4 - % of Current Cost 5 - % of List Price 6 - % of Calculated Price 7 - % Markup - Current Cost 8 - ...
Receiving a message "The Markdown cannot be greater than the unit price"
When we enter a transaction in the SOP Transaction Entry window we are getting a message, "The Markdown cannot be greater than the unit price", even though the unit price is actually greater than the Markdown amount. How do we resolve this? On the...
Omni Price Reports
What types of reports can Omni Price provide? There are several reports that Omni Price can produce and several criteria’s that can be set. The following are the various reports available. Anything other than what these reports produce will require...
Omni Price with Integration Manager to pull-in SOP invoices
I am using Omni Price in my GP 10.0 environment. Can I use Integration Manager to pull in SOP invoices? Yes, but you would need to recalculate each Invoice that you imported via the Extras menu. Or, if the invoices are all in the same Batch, then...
Only allow items with Special Pricing to be sold option
Why do I get a “Sales are not allowed in this unit of measure” error? This message means you have checked the option to only be allowed to sell items which have a valid Omni Price contract. Once this option is selected, any item which does not get...