| 1 | RMPRPIU9 ;HINCIO/ODJ - PIP STOCK RECONCILE UPDATE UTILITY;3/8/01
 | 
|---|
| 2 |  ;;3.0;PROSTHETICS;**61**;Feb 09, 1996
 | 
|---|
| 3 |  Q
 | 
|---|
| 4 |  ;
 | 
|---|
| 5 |  ;***** REC - Create a Stock Reconciliation Transaction
 | 
|---|
| 6 |  ;
 | 
|---|
| 7 |  ; Inputs:
 | 
|---|
| 8 |  ;    RMPR6  -
 | 
|---|
| 9 |  ;    RMPR11 -
 | 
|---|
| 10 |  ;    RMPR5  -
 | 
|---|
| 11 |  ;
 | 
|---|
| 12 |  ; Outputs:
 | 
|---|
| 13 |  ;    RMPRERR -
 | 
|---|
| 14 |  ;
 | 
|---|
| 15 | REC(RMPR6,RMPR11,RMPR5) ;
 | 
|---|
| 16 |  N RMPRERR,RMPRCSTK,RMPRQGL,RMPRVGL,RMPRD,RMPRT,RMPR,RMPRUCST
 | 
|---|
| 17 |  S RMPRERR=0
 | 
|---|
| 18 |  ;
 | 
|---|
| 19 |  ; Lock the current stock 661.7 file at HCPCS Item level as we may be
 | 
|---|
| 20 |  ; reducing or increasing the quantity on hand
 | 
|---|
| 21 |  L +^RMPR(661.7,"XSLHIDS",RMPR11("STATION IEN"),RMPR5("IEN"),RMPR11("HCPCS"),RMPR11("ITEM"))
 | 
|---|
| 22 |  ;
 | 
|---|
| 23 |  ; Get current quantity on hand
 | 
|---|
| 24 |  S RMPRCSTK("STATION IEN")=RMPR11("STATION IEN")
 | 
|---|
| 25 |  S RMPRCSTK("HCPCS")=RMPR11("HCPCS")
 | 
|---|
| 26 |  S RMPRCSTK("ITEM")=RMPR11("ITEM")
 | 
|---|
| 27 |  S RMPRCSTK("UNIT")=$G(RMPR11("UNIT"))
 | 
|---|
| 28 |  S RMPRCSTK("LOCATION IEN")=RMPR5("IEN")
 | 
|---|
| 29 |  S RMPRCSTK("VENDOR IEN")=RMPR6("VENDOR IEN")
 | 
|---|
| 30 |  S RMPRERR=$$STOCK^RMPRPIUE(.RMPRCSTK)
 | 
|---|
| 31 |  I RMPRERR S RMPRERR=11 G RECU ;error 11 - problem getting current qoh
 | 
|---|
| 32 |  S RMPRQGL=RMPR6("QUANTITY")-RMPRCSTK("QOH") ;gain/loss
 | 
|---|
| 33 |  S RMPRUCST=""
 | 
|---|
| 34 |  I $G(RMPR6("NEW UNIT COST"))'="" S RMPRUCST=RMPR6("NEW UNIT COST")
 | 
|---|
| 35 |  ;
 | 
|---|
| 36 |  ; If not showing any quantity on hand then use the unit cost
 | 
|---|
| 37 |  ; of the most recent receipt or reconciliation transaction
 | 
|---|
| 38 |  I RMPRUCST="",RMPRCSTK("QOH")=0 D
 | 
|---|
| 39 |  . F RMPRT=3,9 D  Q:RMPRERR!(RMPRD'="")
 | 
|---|
| 40 |  .. S RMPRD=$O(^RMPR(661.6,"ASTHIDS",RMPR11("STATION IEN"),RMPRT,RMPR11("HCPCS"),RMPR11("ITEM"),""),-1)
 | 
|---|
| 41 |  .. Q:RMPRD=""
 | 
|---|
| 42 |  .. K RMPR
 | 
|---|
| 43 |  .. S RMPR("IEN")=$QS($Q(^RMPR(661.6,"ASTHIDS",RMPR11("STATION IEN"),RMPRT,RMPR11("HCPCS"),RMPR11("ITEM"),RMPRD)),9)
 | 
|---|
| 44 |  .. S RMPRERR=$$GET^RMPRPIX6(.RMPR)
 | 
|---|
| 45 |  .. Q:RMPRERR
 | 
|---|
| 46 |  .. S:+RMPR("QUANTITY") RMPRUCST=RMPR("VALUE")/RMPR("QUANTITY")
 | 
|---|
| 47 |  .. Q
 | 
|---|
| 48 |  . Q
 | 
|---|
| 49 |  E  D
 | 
|---|
| 50 |  . S:RMPRUCST="" RMPRUCST=RMPRCSTK("UNIT COST")
 | 
|---|
| 51 |  . Q
 | 
|---|
| 52 |  I RMPRUCST="" D
 | 
|---|
| 53 |  . S RMPRUCST=0
 | 
|---|
| 54 |  . I +RMPR6("QUANTITY"),+$G(RMPR6("VALUE")) D
 | 
|---|
| 55 |  .. S RMPRUCST=RMPR6("VALUE")/RMPR6("QUANTITY")
 | 
|---|
| 56 |  .. Q
 | 
|---|
| 57 |  . Q
 | 
|---|
| 58 |  I RMPRERR S RMPRERR=12 G RECU ;error 12 problem with cost
 | 
|---|
| 59 |  ;
 | 
|---|
| 60 |  ; calculate the gain/loss for value
 | 
|---|
| 61 |  S RMPRVGL=$J(RMPRQGL*RMPRUCST,0,2)
 | 
|---|
| 62 |  ;
 | 
|---|
| 63 |  ; Create a 661.6 Reconciliation Transaction record
 | 
|---|
| 64 |  S RMPR6("COMMENT")=$G(RMPR6("COMMENT"))
 | 
|---|
| 65 |  S RMPR6("SEQUENCE")=1
 | 
|---|
| 66 |  S RMPR6("TRAN TYPE")=9
 | 
|---|
| 67 |  S RMPR6("LOCATION")=RMPR5("IEN")
 | 
|---|
| 68 |  S RMPR6("USER")=$G(DUZ)
 | 
|---|
| 69 |  S RMPR6("VENDOR")=RMPR6("VENDOR IEN")
 | 
|---|
| 70 |  S RMPR6("VALUE")=$J(RMPR6("QUANTITY")*RMPRUCST,0,2)
 | 
|---|
| 71 |  K RMPR6("IEN")
 | 
|---|
| 72 |  S RMPR11("STATION")=RMPR11("STATION IEN")
 | 
|---|
| 73 |  S RMPRERR=$$CRE^RMPRPIX6(.RMPR6,.RMPR11)
 | 
|---|
| 74 |  I RMPRERR S RMPRERR=61 G RECU ;error 61 if problem with 661.6
 | 
|---|
| 75 |  ;
 | 
|---|
| 76 |  ; Create 661.69 Gain/Loss record
 | 
|---|
| 77 |  K RMPR
 | 
|---|
| 78 |  S RMPR("TRANS IEN")=RMPR6("IEN")
 | 
|---|
| 79 |  S RMPR("GAIN/LOSS")=RMPRQGL
 | 
|---|
| 80 |  S RMPR("GAIN/LOSS VALUE")=RMPRVGL
 | 
|---|
| 81 |  S RMPRERR=$$CRE^RMPRPIXB(.RMPR)
 | 
|---|
| 82 |  I RMPRERR S RMPRERR=61 G RECU ;error 61 if problem with 661.69
 | 
|---|
| 83 |  ;
 | 
|---|
| 84 |  ; Adjust stock for gain/loss
 | 
|---|
| 85 |  I RMPRQGL=0 G RECU ;no gain loss so just exit
 | 
|---|
| 86 |  I RMPRQGL>0 G RECGN ;adjust for stock gain
 | 
|---|
| 87 |  ;
 | 
|---|
| 88 |  ; Adjust for stock loss
 | 
|---|
| 89 | RECLS K RMPR
 | 
|---|
| 90 |  S RMPR("STATION IEN")=RMPR11("STATION IEN")
 | 
|---|
| 91 |  S RMPR("LOCATION IEN")=RMPR5("IEN")
 | 
|---|
| 92 |  S RMPR("HCPCS")=RMPR11("HCPCS")
 | 
|---|
| 93 |  S RMPR("ITEM")=RMPR11("ITEM")
 | 
|---|
| 94 |  S RMPR("UNIT")=$G(RMPR11("UNIT"))
 | 
|---|
| 95 |  S RMPR("VENDOR IEN")=RMPR6("VENDOR IEN")
 | 
|---|
| 96 |  S RMPR("ISSUED QTY")=0-RMPRQGL
 | 
|---|
| 97 |  S RMPR("ISSUED VALUE")=0-RMPRVGL
 | 
|---|
| 98 |  S RMPRERR=$$FIFO^RMPRPIUF(.RMPR)
 | 
|---|
| 99 |  I RMPRERR S RMPRERR=71 G RECU ;error 71 problem with adjusting
 | 
|---|
| 100 |  K RMPR
 | 
|---|
| 101 |  S RMPR("STA")=RMPR11("STATION IEN")
 | 
|---|
| 102 |  S RMPR("HCP")=RMPR11("HCPCS")
 | 
|---|
| 103 |  S RMPR("ITE")=RMPR11("ITEM")
 | 
|---|
| 104 |  S RMPR("RDT")=$P(RMPR6("DATE&TIME"),".",1)
 | 
|---|
| 105 |  S RMPR("TQTY")=RMPRQGL
 | 
|---|
| 106 |  S RMPR("TCST")=RMPRVGL
 | 
|---|
| 107 |  S RMPRERR=$$UPCR^RMPRPIXJ(.RMPR)
 | 
|---|
| 108 |  I RMPRERR S RMPRERR=71
 | 
|---|
| 109 |  G RECU
 | 
|---|
| 110 |  ;
 | 
|---|
| 111 |  ; Adjust for stock gain
 | 
|---|
| 112 | RECGN K RMPR
 | 
|---|
| 113 |  S RMPR("STATION")=RMPR11("STATION IEN")
 | 
|---|
| 114 |  S RMPR("LOCATION")=RMPR5("IEN")
 | 
|---|
| 115 |  S RMPR("HCPCS")=RMPR11("HCPCS")
 | 
|---|
| 116 |  S RMPR("ITEM")=RMPR11("ITEM")
 | 
|---|
| 117 |  S RMPR("UNIT")=$G(RMPR11("UNIT"))
 | 
|---|
| 118 |  S RMPR("VENDOR")=RMPR6("VENDOR IEN")
 | 
|---|
| 119 |  S RMPR("QUANTITY")=RMPRQGL
 | 
|---|
| 120 |  S RMPR("VALUE")=RMPRVGL
 | 
|---|
| 121 |  S RMPR("DATE&TIME")=$G(RMPR6("DATE&TIME"))
 | 
|---|
| 122 |  S RMPR("SEQUENCE")=RMPR6("SEQUENCE")
 | 
|---|
| 123 |  S RMPRERR=$$REVI^RMPRPIU1(.RMPR)
 | 
|---|
| 124 |  I RMPRERR S RMPRERR=71
 | 
|---|
| 125 |  G RECU
 | 
|---|
| 126 |  ;
 | 
|---|
| 127 |  ; exit points
 | 
|---|
| 128 | RECU L -^RMPR(661.7,"XSLHIDS",RMPR11("STATION IEN"),RMPR5("IEN"),RMPR11("HCPCS"),RMPR11("ITEM"))
 | 
|---|
| 129 | RECX Q RMPRERR
 | 
|---|