X hits on this document

283 views

0 shares

0 downloads

0 comments

57 / 96

Flexible Solutions, Inc. – GP Reports Viewer

57

USING THE POP FIELD CHANGES [OPTIONAL]

If you decide to show revision numbers and/or what fields have changed on a Purchase Order since the last time it was printed, you can make use of the additional fields in the GPRV_POP50200 table populated when you replace Purchase Order reports using GP Reports Viewer.

T w o f i e l d s a r e a v a i l a b l e i n t h e G P R V _ P O P 5 0 2 0 0 t a b l e t o h e l p d e t e r m i n e t h e s t a t u s o f a P u r c h a s e O r d e r :

Field in GPRV_POP50200 PO_Status_Orig Change_Order_Flag

Type Smallint Smallint

The table below lists possible combination of values for these fields and what they mean:

Value of PO

_

Status

_

Orig

Value of Change

_

Order

_

Flag

Meaning

1, 2 or 4 3 3 or > 4 5 6

Any value Any value >0 0 0

Not a Change Order Change Order Change Order Closed Order Cancelled Order

To show what fields were changed on a Change Order, you can make use of the following fields:

Field in GPRV_POP50200 PO_Field_Changes_Array_1 PO_Field_Changes_Array_2 PO_Field_Changes_Array_3 PO_Field_Changes_Array_4 PO_Field_Changes_Array_5 PO_Field_Changes_Array_6 PO_Field_Changes_Array_7 PO_Field_Changes_Array_8 PO_Field_Changes_Array_9 PO_Field_Changes_Array_10 PO_Field_Changes_Array_11

Type

Field Changed on Purchase Order

Tinyint

Bill To Address

Tinyint

Purchase Address (Vendor)

Tinyint

Ship To Address

Tinyint

Shipping Method

Tinyint

Payment Terms

Tinyint

Comment

Tinyint

Trade Discount

Tinyint

Freight

Tinyint

Miscellaneous

Tinyint

Tax

Tinyint

Contract Number

A value of 0 means the field was not changed. A value of 1 will indicate that the field was changed since the last revision of the Purchase Order was printed.

Document info
Document views283
Page views283
Page last viewedSat Dec 03 20:14:53 UTC 2016
Pages96
Paragraphs1592
Words22003

Comments