Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Receivables Management National Account Table information

View products that this article applies to.

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

↑ Back to the top

Keywords: kb, kbnosurvey, kbinfo, kbMBSMigrate, kbMBSPartner, BemisKB850387

↑ Back to the top

Article Info
Article ID : 850387
Revision : 1
Created on : 3/1/2017
Published on : 3/1/2017
Exists online : False
Views : 442