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) / How to tell if an invo...
Microsoft Dynamics GP (Archived)

How to tell if an invoice is Billed?

(0) ShareShare
ReportReport
Posted on by VinhTon 102

I'm a data guy so I know more the database and don't know how to navigate GP itself.

My guess is that Billed is synonymous with "Posted" so table SOP10100 has the unposted/unbilled invoices while SOP30200 has the posted/unbilled invoices. Can somebody confirm?

Would also appreciate if somebody show screenshot and, or directions how to tell if an invoice is billed or unbilled in GP.

Thanks ahead

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    That is correct. Unposted invoices are invoices that users are currently working on (Sales > Transactions > Sales Transaction Entry). The invoice header information is stored in the SOP10100 table, the invoice line items are stored in the SOP10200 table, for unposted invoices.

    Once invoices are posted, they become historical invoices in the Sales Order Processing module and are stored in the SOP30200 table. The invoice line items are moved from the SOP10100 to the SOP30300 table once invoices are posted.

    You must also realize that while invoices move to history from a SOP perspective, they become open documents in the AR module. This is so cash receipts can be applied to them. Also they only move to history manually, by running the Paid Transaction Removal process, to allow the AR department to send statements for customers who want to see past paid invoices on their statements.

  • VinhTon Profile Picture
    VinhTon 102 on at

    Thank you for the detailed response!

  • VinhTon Profile Picture
    VinhTon 102 on at

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    As Mariano has stated once an SOP invoice is posted it becomes an AR invoice.  The term Billed is not used in GP. Once it becomes an AR invoice you then accept cash receipts against that invoice.

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