Long an overlooked add-on product for GP, I recently have been drawn to it by a new client acquisition. They are using it extensively in an integration to SOP from CRM (they use CRM for invoicing their customers and the results integrate to SOP.) As this integration and deferral is to SOP I will focus only on deferrals as related to SOP transactions.
The integration code that is operational today, which was written by a previous consultant, writes directly to four GP deferral tables.
PP000011 Deferral Profiles Header WORK
PP000042 Deferral Profile Allocated
PP000100 Deferral Header Work
PP000101 Deferral Line Work
Of course the related SOP table for all this data is SOP10102, which is the SOP Distribution Work and History table. As you may know deferrals are made off the transaction distribution (window) in GP.
The above tables link to each other based on the following common columns:
PP_Module - This is 5 for SOP.
PP_Record_Type - This correlates to the SOP Type, which is 3 for Invoice.
PP_Document_Number - This is the invoice/document number in SOP.
PPOFFSEQ - This seems to correlate to the SEQNUMBR column in SOP10102.
PP_Sequencer - This appears to be a sequence number for the deferrals.
Here's my take on the contents of the above table, again with respect to SOP integrations, subject to change as my understanding grows. :)
PP000042 Deferral Profile Allocated
This table appears to be the "master" deferral record, as it does no more than add the Deferral Profile column to the other linking columns.
PP000011 Deferral Profiles Header WORK
This table grabs the deferral profile information from the Deferral Profiles Header table PP000010.
PP000100 Deferral Header Work
This table contains the controlling header information for the deferral including the total amount of the deferral and the start/ending dates.
PP000101 Deferral Line Work
This table is the detail period deferral that is created for the transaction, which will post the GL.
Again I will update this with more detail as I can.
No comments:
Post a Comment