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

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

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

  This event is produced in conjunction with Dynamics User Group (DUG) and its members. 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 Previous Blogs: D1: Understanding Database & Environments D2:   How to Create Environments D3: How to Create Companies D4: Overview License & Pricing D5: Overview Users & Security D6: My Home Page D7: Navigate in GP like BC? D8: My Playlist of Business Central  Microsoft Learn D9: Podcast - Navigating my Journey ...

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