Is there a different table for posted and unposted payable's invoices?

(0) Share

Report

Posted on by Community Member

Okay, so I recently coded something to check the PmPaidTransactionHistTable to ensure that there were no duplicates and ran into an issue due to the fact that unposted transactions which were still in "work" were not checked. So I'm wondeirng if there's a different table for those invoices. Here is my code btw,

Dim CustomerMasterTableID As PmPaidTransactionHistTable
        Dim CustomerMasterInvoiceVendor As PmPaidTransactionHistTable
        Dim TabErr As TableError
        Dim VendErr As TableError
        CustomerMasterTableID = Dynamics.Tables.PmPaidTransactionHist
        CustomerMasterInvoiceVendor = Dynamics.Tables.PmPaidTransactionHist
        ' Find the proper keys
        CustomerMasterInvoiceVendor.Key = 1
        CustomerMasterTableID.Key = 3
        ' Used Vendor and Invoice to symbolize the two variables that I was looking for; vendorname and invoicenumber.
        CustomerMasterTableID.DocumentNumber.Value = invoice
        CustomerMasterInvoiceVendor.VendorId.Value = VendorId
        'Retriving the error
        TabErr = CustomerMasterTableID.Get()
        VendErr = CustomerMasterInvoiceVendor.Get()
        If TabErr = TableError.NoError And VendErr = TableError.NoError Then
            Error 123
        Else

        End If
        CustomerMasterInvoiceVendor.Close()
        CustomerMasterTableID.Close()

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

L Vail 65,271 on at

Like (1)

Report

RE: Is there a different table for posted and unposted payable's invoices?

Hi,

I have a blog post that reviews how the data moves through the tables in the core modules of GP.

dynamicsconfessions.blogspot.com/.../data-flow-and-table-names.html

Kind regards,

Leslie
Peter Muchira 1,912 on at

Like (0)

Report

RE: Is there a different table for posted and unposted payable's invoices?

Hi,

You may check the following:

PM10000 - PM_Transaction_WORK

PM20000 - PM_Transaction_OPEN

PM30200 - PM_Paid_Transaction_HIST

Hope it helps.
Suggested answer

drummerboy_10 on at

Like (0)

Report

RE: Is there a different table for posted and unposted payable's invoices?

Dynamics GP has three different table types which transactions move through - WORK, OPEN and HISTORY. The 10000 tables are the WORK tables, the 20000 tables are the OPEN tables and the 30000 tables are the HISTORY tables.

I think you might find Mark Polino's excel table reference a great and valuable tool:

http://mpolino.com/gp/excel-based-table-and-field-reference-for-dynamics-gp-2013/