Skip to main content

Dynamics GP to Business Central - Payables & POP Tables

 

Payables and Purchase Order Processing (POP) are essential components of any ERP system—they manage vendor transactions, purchases, payments, and procurement workflows. In both Dynamics GP and Business Central, these modules ensure smooth handling of accounts payable, inventory purchasing, and vendor payments.


Payables Tables

GP TableDescriptionBC TableBusiness Central Equivalent
PM00100Vendor Class1383Vendor Template
PM00200Vendor Master23Vendor
PM00201Vendor Summary25Calculated from Vendor Ledger Entry
PM00202Vendor Period Summary25Calculated from Vendor Ledger Entry
PM00203Vendor Accounts93Vendor Posting Group
PM002041099 Period Detail10010
10016
1099 Form Box
1099 Adjustment
PM00300
Vendor Address
23
2224
224
Vendor main address
Remit Address
Order Address
PM00400Keys MasterN/ANot applicable in BC
PM10000
Work/Unposted Transactions
38
39
Purchase Header
Purchase Line
PM10100GL Distributions (unposted)39
81
Purchase Line or
Gen. Journal Line
PM10200Apply To Work/Open25
380
Vendor Ledger Entry +
Detailed Vendor Ledger Entry
PM10300Unposted Payments81Payment Journal Line
PM10400Manual Payments81Payment Journal Line with Bank Bal. Account
PM20000Open Transactions25Vendor Ledger Entry (Open = TRUE)
PM30200Historical Transactions25Vendor Ledger Entry (Open = FALSE)
PM30300Apply To History380Detailed Vendor Ledger Entry
PM30600GL Distributions History25Vendor Ledger Entry
PM80100Batch Headers232Gen. Journal Batch
MC020103Multicurrency PM Transactions25Vendor Ledger Entry with Currency Code
SY06000Vendor EFT Info288Vendor Bank Account



Purchase Order Processing Tables

GP TableDescriptionBC TableBusiness Central Equivalent
POP00101Buyer Master13Salesperson/Purchaser
POP10100Purchase Order Work (header)38Purchase Order Header (Unposted)
POP10110Purchase Order Line Work (line detail)39Purchase Order Line (Unposted)
POP10150Purchase Order Comment (header)7
39
Standard Text (code + description)
Purchase Order Line Comment
POP10300Receipt Work (header)38Purchase Header (Unposted)
POP10306Purchasing Receipt User-DefinedN/AExtension or Customization
POP10310Receipt Work Line (line detail)39Purchase Line (Unposted)
POP10330Serial / Lot Work308Number Series for Serial/Lot Numbers
POP10390Receipt Work Distributions93Vendor Posting Group
POP10500Receipt Line Quantities39Purchase Line
POP10550Line Item Comment (line detail)39Purchase Line Comment
POP10600Purchasing Shipment Invoice Apply380Detailed Vendor Ledger Entry (apply/unapply)
POP30100Purchase Order History (header)510Purchase Header (Posted/Archived via Archiving Extensions)
POP30110Purchase Order Line History511Purchase Line (Archived or historical view)
POP30300Receipt History (header)120Purch. Rcpt. Header (Posted)
POP30310Receipt Line History121Purch. Rcpt. Line (Posted)
POP30330Serial / Lot History336Item Tracking Line (Posted)
POP30390Distribution History122
123
Posted Invoice (History)
Header
Line
POA40003PO Approval Control1530Workflow Step Instance


Comments

Popular posts from this blog

D365 Business Central - Table Information Page

  Whether you're a Business Central power user, consultant, or developer, sometimes you just want a quick look under the hood of your environment. That’s where Table Information comes in—a hidden gem in Business Central that gives you insight into what’s happening behind the scenes. Why Use the Table Information Page? Understanding what tables are being used, how large they are, and how many records they contain is especially helpful when: Diagnosing performance issues  Cleaning up test or training environments  Estimating storage impact  Reviewing customizations or ISV extensions  Step-by-Step: How to Access Table Information Here’s how you can view detailed info about every table in your current company: Go to “Tell Me” Search Press Alt + Q or click the magnifying glass 🔍 in the upper-right corner. Type: “Table Information” Select the Table Information page from the search results. Explore the Page You’ll see a list of all tables...

DUG Webinar: Dynamics GP to Business Central - The Ultimate Beginner's Guide

This session is designed to give you a head start in working with Business Central so you quickly feel at home in transitioning from Dynamics GP to BC without the hustle of reading through hundreds of pages of documentation. What you'll learn: Mastering the user interface of Business Central Navigating in Business Central Editing records in Business Central Creating new records in Business Central Finding records in Business Central Personalizing the user interface of Business Central Being prepared to work with Business Central on a daily basis

GP Assessment Tool

Migration Assessment :    Migration assessment (bcmigrationassessments.com) Microsoft official Documentation:    Migrate on-premises GP data to Business Central online overview - Business Central | Microsoft Learn