Customization DS1352- Site Specific SOP & POP Posting Accounts

Customization DS1352

Site Specific SOP and POP Posting Accounts

Problem Definition:

ACME is using the site swapping functionality within GP. This works fine for Sales and CoGS in the SOP module, and also the IV account in POP. ACME needs the site swapping extended to the following accounts:

Sales Transactions

  • Accounts Receivables GL
  • Trade Discount (from Document Level Field)
  • Freight (from Document Level Field)
  • Miscellaneous (from Document Level Field)
  • Tax (from Document Level Field)

 

Purchase Order Processing

  • Accounts Payable Trade
  • Accrued Purchases
  • Trade Discount (from Document Level Field)
  • Freight (from Document Level Field)
  • Miscellaneous (from Document Level Field)
  • Tax (from Document Level Field)

Solution Overview:

ACME has already set up a site segment to swap. This enhancement will use the same segment ID and number when swapping the accounts highlighted in the following sections. In either case, if a valid account number cannot be found, the original account number will be used.

Design Features:

Sales Document Posting

The highlighted accounts will have the segments swapped based on the header Site ID when an INVOICE or RETURN is posted, or an edit list is printed. The account numbers will not be updated until the sales document is posted or an edit list is printed.

Graphical user interface, application, table Description automatically generated

Purchasing Invoice Posting

POP does not use default Site ID’s in the header. As a result, the highlighted accounts will have the segments swapped based on the first Site ID found when scanning the lines of the PO INVOICE upon posting, or an edit list is printed. The account numbers will not be updated until the document is posted or an edit list is printed.

Graphical user interface, application Description automatically generated

Assumptions/Requirements

  1. The functionality described above will not work with eConnect, any software that uses eConnect, or any software that directly writes to, updates, or deletes from SQL tables.
  2. The functionality described above is intended for the GP Desktop client.
  3. National Accounts functionality is NOT used.
  4. Advanced Distribution functionality is NOT used.
  5. Unless otherwise noted in this document, reporting is not included in this estimate.
  6. Unless otherwise noted in this document, Word Template functionality is not addressed.
  7. Unless otherwise noted in this document, the enhancement will not integrate with 3rd party products. Some examples of 3rd party products would be:
  • An ISV plug-in product including WilloWare products
  • A dexterity customization designed by another developer
  • Dynamics GP Modules including, but not limited to:
  • Project Accounting
  • MDA
  • Analytical Accounting
  • Copy functionality found in SOP, POP and Inventory
  • Field Service
  • Extended Pricing
  • Manufacturing

For information on this design, or any other WilloWare customization or product, please contact us:

www.willoware.com/contact-me/