back to top

Saleslogix Web Client v8.1 Sales Order Total Not Calculating Correctly

We recently received a complaint from a client that the Sales Order total field is not using the extended price of the products.  instead it is summing the Price field with does not allow for correct totals if the user adjusts a price or changes the quantity.

 

This used to work up through SalesLogix v8.0

 

I have submitted as a ticket to Saleslogix (8010146679).

 

It seems they have monkeyed with these business rules.  Not sure if it was because of the ERP sync they threw in there.

 

Pre 8.1
public static double GetAdjustedPrice(ISalesOrder salesOrder)
{
    double num = 0.0;
    double num2 = 0.0;
    foreach (ISalesOrderItem item in salesOrder.SalesOrderItems)
    {
        num += item.Price.Value * ((int) item.Quantity.Value);
        if (item.Discount.HasValue)
        {
            num2 += (item.Price.Value * ((int) item.Quantity.Value)) * (1.0 – item.Discount.Value);
        }
        else
        {
            num2 += item.Price.Value;
        }
    }
    return num2;
}

New in 8.1
public static double GetAdjustedPrice(ISalesOrder salesOrder)
{
    double num = 0.0;
    foreach (ISalesOrderItem item in salesOrder.SalesOrderItems)
    {
        double num2 = (item.Price.HasValue && (item.Price.Value > 0.0)) ? item.Price.Value : ((item.CalculatedPrice.HasValue && (item.CalculatedPrice.Value > 0M)) ? ((double) item.CalculatedPrice.Value) : 0.0);
        num += num2;
    }
    return num;
}

Should be:
public static double GetAdjustedPrice(ISalesOrder salesOrder)
{
    double num = 0.0;
    foreach (ISalesOrderItem item in salesOrder.SalesOrderItems)
    {
        double num2 = (item.ExtendedPrice.HasValue  ? item.ExtendedPrice.Value : 0.0);
        num += num2;
    }
    return num;
}

Since these are in the compiled SalesLogix assemblies, it is a no go for fixing these directly.  However, you can create your own void result SalesOrder entity business rule of:

            double num = 0.0;
            foreach (ISalesOrderItem item in salesorder.SalesOrderItems)
            {
                double num2 = (item.ExtendedPrice.HasValue  ? item.ExtendedPrice.Value : 0.0);
                num += num2;
            }
           
            salesorder.OrderTotal=num;
                       
            double? discount = salesorder.Discount;
            num -= num * (discount.HasValue ? discount.GetValueOrDefault() : 0.0);
            double? tax = salesorder.Tax;
            num += num * (tax.HasValue ? tax.GetValueOrDefault() : 0.0);
            double? freight = salesorder.Freight;
            salesorder.GrandTotal = (num + (freight.HasValue ? freight.GetValueOrDefault() : 0.0));

Then you can add a post execute event to the salesorderitem’s entity events for OnAfterUpdate, OnAfterInsert, OnAfterDelete of:

    salesorderitem.SalesOrder.FXSetOrderTotal();
    salesorderitem.SalesOrder.Save(); 

 

The OnAfterDelete should be this:
        if (((salesorderitem != null) && (salesorderitem.SalesOrder != null)) && (salesorderitem.SalesOrder.SalesOrderItems != null))
        {
                    salesorderitem.SalesOrder.FXSetOrderTotal();
        }

 

You also will need to add a similar cust post execute event to the sales order entity’s OnBeforeUpdate event:

    salesorder.FXSetOrderTotal();

Contact Customer FX for your CRM project
We let our expertise speak for itself - let us know how our all-star team can help on your CRM project
About the Author
Kris Halsrud
Kris Halsrud
Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Infor CRM Sync for Exchange: Action Required by August 31, 2026

Using Infor CRM Sync for Exchange with Microsoft 365? Your Exchange administrator must update tenant settings by August 31, 2026 to prevent sync disruption.

[Webinar] What’s Coming Next for Infor CRM SLX and Why v10 Matters

See what’s coming next for Infor CRM SLX, including new marketing workflows, automation improvements, and reasons to consider upgrading to v10.

Disable Caching in Infor CRM SLX Web Client

In the rare case caching is causing issues in the Infor CRM SLX web client, it is possible to disable specific types of caching by making edits using Application Architect, and then deploying.

Exploring AI Options for Infor CRM v10

I've started taking a closer look at the AI capabilities built into Infor CRM v10. Over the next several posts, I'll share what I learn. From the built-in features and supported AI providers to implementation considerations, costs, and practical use cases.

Infor CRM SLX 10.0: Delegate Ownership Changes for “Everyone” Records

Learn how the new EveryoneOwnerAssignment secured action in Infor CRM SLX 10.0 allows designated users to change ownership of Everyone-owned records without requiring Administrator access.

Related Articles

Infor CRM Sync for Exchange: Action Required by August 31, 2026

Using Infor CRM Sync for Exchange with Microsoft 365? Your Exchange administrator must update tenant settings by August 31, 2026 to prevent sync disruption.

[Webinar] What’s Coming Next for Infor CRM SLX and Why v10 Matters

See what’s coming next for Infor CRM SLX, including new marketing workflows, automation improvements, and reasons to consider upgrading to v10.

Disable Caching in Infor CRM SLX Web Client

In the rare case caching is causing issues in the Infor CRM SLX web client, it is possible to disable specific types of caching by making edits using Application Architect, and then deploying.

Exploring AI Options for Infor CRM v10

I've started taking a closer look at the AI capabilities built into Infor CRM v10. Over the next several posts, I'll share what I learn. From the built-in features and supported AI providers to implementation considerations, costs, and practical use cases.

Related Videos