Skip to main content



No record found.

Dynamics 365 Community / Forums / Commerce forum / Retail POS - Customer ...
Commerce forum
Suggested answer

Retail POS - Customer account payment

Posted on by 674

Hi All,

I tried to test the payment with customer account in a retail POS. However I received the following message

"Customer ... does not exist or its acocunt is blocked"


However, this customer is not blocked at all. Also, of course this customer exists in CustTable as well.

I debugged the related pieces of code and found that  the record is not retrieved from the database even if  the _custAccount (004009) was passed to this find() method correctly. 

    static CustTable find(CustAccount   _custAccount,
                          boolean       _forUpdate = false)
        CustTable custTable;

        if (_custAccount)
            if (_forUpdate)

            select firstonly custTable
                index hint AccountIdx
                where custTable.AccountNum == _custAccount;

        return custTable;

What is the way to solve it? Should I set a real-time service profile in order to make it work? 

Thank you. 

  • ShawnDEV Profile Picture
    ShawnDEV 674 on at
    RE: Retail POS - Customer account payment


    I already debugged that method you mentioned and if I step into methods called from this method, I come down to CustTable find () ..

    Then the record is not retrieved although the parameter is passed correctly..

    I can restart IIS but I don't think that will solve the issue.. But will try..

  • Suggested answer
    Guanghui Profile Picture
    Guanghui on at
    RE: Retail POS - Customer account payment

    The code is here:


    public static container validateCustomerStatus(CustAccount _custAccount, AmountMST  _salesAmount, CurrencyCode _currencyCode)


           container   custStatus = [false,0];

           AmountMST   creditMax = 0;

           TypeOfCreditmaxCheck creditMaxCheck = CustParameters::find().CreditMaxCheck;


           if (_currencyCode != CompanyInfoHelper::standardCurrency())

               _salesAmount = CurrencyExchangeHelper::amountCur2MST(_salesAmount, _currencyCode);



               if (!CustTable::checkExistAndOpen(_custAccount, _salesAmount))


                   custStatus = [false,strFmt("@RET4170018", _custAccount)];



    Please check the database and determine if CustTable::checkExistAndOpen(_custAccount, _salesAmount)) will return true, and restart IIS or SQL server service if necessary

  • Guanghui Profile Picture
    Guanghui on at
    RE: Retail POS - Customer account payment

    How about other tender type, such as pay cash, credit card?

    can you run job to push the customer  data into channel database if you are sure customer is not blocked?

    can you show what's the call-stack which contains the CustTable.find() 

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,513 Super User

Martin Dráb Profile Picture

Martin Dráb 225,862 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans