Dynamics Community Forum Thread Details

Hi,

Writing a report on the pricelist tables and hit a strange issue, whereby request page filter on "code" shows the list of pricelists correctly on Cronus, but shows a list of customers on the copy production company in same sandbox environment.

I've stripped it back to bare minumum to test/recreate:

report 50851 "test report"
{
    ApplicationArea = All;
    Caption = 'test report';
    UsageCategory = Administration;
    ProcessingOnly = true;
    dataset
    {
        dataitem(PriceListHeader; "Price List Header")
        {
            column(Code; "Code")
            {
            }
            column(Description; Description)
            {
            }
        }
    }
}

When I run this within Cronus, on the request page I filter by "code" - the drop down correctly shows a drop down list of price lists.

Within the same sandbox [same environment- which is a recent copy of the production environment], if I run it on client's main company, instead of the drop down showing a list of pricelists, on the "code" field I'm seeing a list of customers. See screenshot showing the pricelists configured in the background most starting "IMP" vs drop down on "code" field showing customer codes.

- Both Cronus and the copy production company are obviously using the "new" pricing experience

- Both have a valid prcelist set up in Sales & Receivables setup -> prices -> Default Price List Code. Both have "use your custom lookup" disabled in same place.

- Both are using the default "Lowest price" on the price calculation method page.

- Being in same environment, there's no custom extension enabled on one but not the other.

I'm guessing it's somehow looking at the assign-to field and picking up that it's set to customer and re-mapping the code field in the request page UI... but why not also on Cronus? Guessing it's data somehow but not sure what other settings it would be looking at?

Any ideas?

Thanks,

No record found.