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.

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

Software¶

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

Orchid Extender Developer Edition
Extender App Manager