Receivables Management National Account Table information

Work anywhere from any device with Microsoft 365

Upgrade to Microsoft 365 to work anywhere with the latest features and updates.

Upgrade now

TechKnowledge Content


National Accounts use the existing Corporate Customer Number dynamics field to define the relationship between a parent customer and its child customers.

RM_NationalAccounts_MSTR (RM00105)

To open the National Accounts window, point to Sales on the Cards menu, and then click National Accounts .

Each parent company is defined as a single record in this table. This record stores the Customer Number for this parent customer, as well as storing the four options listed above regarding parent companies.

RM_Customer_MSTR (RM00101)

Within this table, the Corporate Customer Number field will contain the customer number for that particular customer's parent customer. If the particular customer record is for a parent customer, then the Corporate Customer Number field should still populate with the parent customer's Customer Number.

RM_Cash_WORK (RM10201)

When you enter cash receipts for the parent customer, the RM_Cash_WORK table will store the cash receipt record with a Customer Number that is assigned to the parent customer.

RM_Applied_OPEN (RM20201)

For a parent company's cash receipt that is applied to child customer invoices, this table will store the apply records by using the following rules:

• The Customer Number field in these records will store the customer number for the child customers.
• The Corporate Customer Number field in this table will store the parent customer's customer number value.

This article was TechKnowledge Document ID: 18562

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.