web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / table that contains in...
Microsoft Dynamics GP (Archived)

table that contains invoices in GP

(0) ShareShare
ReportReport
Posted on by Community Member

Hi everyone

I need to find out the table that contains invoices in GP

Regards

Thuli

*This post is locked for comments

I have the same question (0)
  • Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    Purchase or Sales invoices, do you use the SOP module?

    The answer is to check out victoriayudin.com/gp-tables

    where you will find all the information you need on the table names.

    There will be header and lines tables and other related tables to consider too to get things like document holds, comments etc

    Tim

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    If you are using SOP (Sales Order Processing) to invoice your customers, the tables involved are these:

    SOP Tables

    SOP10100

    SOP Header on unposted documents

    SOP10200

    SOP Line items on unposted documents

        (For Kits, there is one record per kit component)

    SOP10101

    Commissions on posted and unposted documents

    SOP10103

    Payments on posted and unposted documents

    SOP10105

    Sales Taxes on posted and unposted documents

    SOP10106

    User Defined fields on posted and unposted documents

    (Also contains the transaction-level comment))

    SOP10107

    Tracking Number(s) on posted and unposted documents

    SOP10201

    Serial/Lot Number(s) on posted and unposted documents

    SOP10202

    Line Comment(s) on posted and unposted documents

    SOP30200

    SOP Header on posted documents

    SOP30201

    Sales Deposits on posted documents

    SOP30300

    SOP Line items on posted documents

       (For Kits, there is one record per kit component)

     

    The SOP Type tells you what kind of document you’re dealing with. Only the Invoice and Return documents can post.

    SOPTYPE (SOP Document Types):

    1

    Quote

    2

    Order

    3

    Invoice

    4

    Return

    5

    Back Order

    6

    Fulfillment Order

     

    If, instead of SOP, you are using the Invoicing module, you’ll need to look in these tables

    IVC10100

    Invoicing Header on unposted documents

    IVC10101

    Invoicing Line Items on unposted documents

    IVC10102

    Serial and Lot Numbers

    IVC10103

    Line Item Comments

    IVC10200

    Payments on documents

    IVC10400

    Commissions

    IVC10500

    Sales Tax

    IVC30101

    Invoicing Headers on posted documents

    IVC30102

    Invoicing Line Items on posted documents

     

    If you are simply entering documents directly in the Receivables Management module, you’ll need to look at the tables below. Keep in mind that once a transaction is posted from either the SOP or Invoicing module, they are moved to the RM posted sales documents table:

    Receivables Documents

    RM10301

    Receivables unposted sales documents

    RM10201

    Receivables unposted cash receipts

    RM10501

    Receivables commissions on unposted documents

    RM10601

    Receivables Sales Tax on unposted documents

    RM20101

    Receivables posted sales documents

    RM30101

    Receivables history sales documents

    RM30601

    Receivables Sales Tax history

    RM30501

    Receivables commissions history

     

    The RMDTYPAL (RM Document Type) field tells you what kind of receivables document you have.

    Receivables Document types

    0

    Reserved for balance carried forward records

    1

    Sales / Invoice document

    2

    Reserved for scheduled payments

    3

    Debit memo

    4

    Finance Charge

    5

    Service / Repair document

    6

    Warranty document

    7

    Credit memo

    8

    Return document

    9

    Payment document

     

    In all of the sales, invoicing, or receivables documents be sure to exclude voided documents. VOIDSTTS =0 for not voided, =1 for voided.

    Kind regards,

    Leslie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans