Monday, December 8, 2008

All about SOP distributions

Microsoft MVP Victoria Yudin seems to be everywhere in these days. If you have ever wondered how GP calculates all these pesky SOP invoice accounting distributions, wonder no more! Victoria decodes in a very friendly and illustrative manner how GP decides the fate of the accounting distributions to be posted to General Ledger when an invoice is posted in the Sales Order Processing module.


If I may add one more thing about the SOP distribution types, this field is used to categorize the distributions for the purpose of verifying the distributions on a document and can be framed in one of these 23 types:


1 = SALES
2 = RECV
3 = CASH
4 = TAKEN
5 = AVAIL
6 = TRADE
7 = FREIGHT
8 = MISC
9 = TAXES
10 = MARK
11 = COMMEXP
12 = COMMPAY
13 = OTHER
14 = COGS
15 = INV
16 = RETURN
17 = IN USE
18 = IN SERVICE
19 = DAMAGED
20 = UNIT
21 = DEPOSITS
22 = ROUND
23 = REBATE


The corresponding numeric value is stored in the SOP_Distribution_WORK_HIST table (SOP10102).

Until next post!

MG.-
Mariano Gomez, MVP, MCP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com

No comments: