Supply chain | Supply Chain Management, Commerce

Retail POS - Customer account payment

(0) Share

Report

Posted on by ShawnDEV

680

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"

2020_2D00_11_2D00_18-10_5F00_56_5F00_55_2D00_Dynamics-Retail-POS-and-7-more-pages-_2D00_-Work-_2D00_-Microsoft_0B20_-Edge.png

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)
            {
                custTable.selectForUpdate(_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.

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Guanghui Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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()

Was this reply helpful? Yes No
Suggested answer

Guanghui Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

The code is here:

class\RetailTransactionServiceCustomer

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

{

container custStatus = [false,0];

AmountMST creditMax = 0;

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

#Define.UserTab('\t')

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

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

try

{

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

Was this reply helpful? Yes No
ShawnDEV 680 on at

Like (0)

Report
Copy link

Link copied!

Hi,

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..

Was this reply helpful? Yes No

Join the conversation

Community site session details

Retail POS - Customer account payment

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates

Community site session details

Retail POS - Customer account payment

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates