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 |