Product: Dynamics GP (Standard & Advance)
Issue: When exporting a document from Transaction Manager into Dynamics Great Plains (Standard/Advance), the Integration Activity Detail screen shows a failed status with the following description: 'Primary Bill-To Address ID (PRBTADCD) does not exist in the RM00102 table'
Reason: The Bill-To Address ID being referenced does not exist in the RM00102 (Customer Address Master) table in Dynamics GP. This can occur in two ways:
A Bill-To Address ID is being sent from Transaction Manager but does not match any address on the Customer record in GP
No Bill-To Address ID is being sent, causing GP to fall back to the customer's default Bill-To address — which is missing or has been deleted from the RM00102 table
Solution - Translate the Bill-To Code
via the Address Table
Use this solution if a Bill-To code is being sent from Transaction Manager but does not match a valid address ID in Dynamics GP. You can use the Address Table to translate it to a matching value.
Navigate: Transaction Manager → Trading Partners → (Partner) → Translations → Address List
Fill Out: The following fields:
EDI Code — the Bill-To code being sent from the Trading Partner
Bus Sys Code — the matching Address ID from the Dynamics GP Customer record
Type — set to Bill To
Solution - Add the Missing Address Card
in Dynamics GP
Use this solution if the Bill-To address does not yet exist in Dynamics GP and needs to be created.
Navigate: Dynamics GP → Cards → Sales → Customer → (Customer) → Bill To (magnifying glass) → New
Enter: The Address ID and complete the required address fields
Save: The new address record
Note: The Address ID must exactly match what is being sent from Transaction Manager — either through a translation in the Address Table or directly from what the Trading Partner sends.
Solution - Fix the Default Bill-To Address
on the Customer Card
Use this solution if no Bill-To Address ID is being sent with the order data. In this case, Dynamics GP falls back to the default Bill-To address stored on the Customer record. If that address was deleted from the RM00102 table but is still referenced on the Customer card, this error will occur.
Navigate: Dynamics GP → Cards → Sales → Customer → (Customer)
Check: The Bill To field for the default Bill-To Address ID
Verify: Click the magnifying glass next to the Bill To field — if the address ID does not appear in the lookup list, it has been deleted from the system
Correct: Either:
Set the default Bill-To address to a different valid address already on the customer, or
Re-create the missing address record (see Add the Missing Address Card in Dynamics GP solution) and re-assign it as the default
Additional Resources
rev 08/05/2026