###############################################################################
AR Price List Solution Proposal
###############################################################################

-------------------------------------------------------------------------------
Extender Solution Proposal
-------------------------------------------------------------------------------

| Prepared on: February 6, 2020
| Prepared for: Direct, Direct
| 
| Prepared by:  
| Chris Binckly  
| 2665093 Ontario Inc.  
| +1-416-996-0217  
| cbinckly@gmail.com  

This document contains a proposal for a customization that enables custom 
per item per customer pricing in AR invoices.

Problem Statement
*******************************************************************************

We require that A/R invoice detail lines for specific customer and items are
customizable and set automatically.

.. raw:: html

    <div class="pagebreak"></div>

.. raw:: latex

    \clearpage

Proposed Solution - PPITMPRC
*******************************************************************************

The proposed solution contains three components: a custom table, ``PPITMPRC``,
that contains custom prices per item per customer; a view script that 
automatically sets the AR invoice line price for imported data; a screen script
that autoatically sets the AR invoice line price for data import view the 
Invoice Entry screen.

Custom Table: Custom Pricing (PPITMPRC)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

A new custom table will be created to store custom price lists. 

- Table Name: PPITMPRC
- Fields:

  1. ``IDCUST``: Customer ID

     - Type: string
     - Size: 12
     - Mask: '%-12C'

  2. ``IDITEM``: Item ID

     - Type: string
     - Size: 16
     - Mask: '%-16C'

  3. ``PRICE``: Custom Price

     - Type: decimal

- Keys:
  
  1. ``(IDCUST, IDITEM)``: a compound key on customer and item 

Data input can be performed using the Custom Table Editor included with 
Extender, which allows records to be added manually or imported from a CSV 
file.

View Script: AR Invoice Details (AR0033)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

A new view script will be developed and added to the AR0033 view.
After the Item is set in an AR invoice line::

    idcust = AR Invoice Header IDCUST
    iditem = AR Invoice Detail IDITEM
    if (idcust, iditem) exists in the PPITMPRC table:
        update item AMTPRIC

Screen Script: AR Invoice Entry (AR2100)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

A new screen script will be developed and added to the AR2100 screen.
After the Item is set in an AR invoice line::

    idcust = AR Invoice Header IDCUST
    iditem = AR Invoice Detail IDITEM
    if (idcust, iditem) exists in the PPITMPRC table:
        update item AMTPRIC

.. raw:: html

    <div class="pagebreak"></div>

.. raw:: latex

    \clearpage

Software
********

The following software is required to run, configure, or deploy the solution.

- Orchid Extender Developer Edition
- Extender App Manager