100
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
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (