Postings:Inventory: Difference between revisions

From Epiphany
JMeyer (talk | contribs)
JMeyer (talk | contribs)
Line 86: Line 86:
| align="center" | <b> X
| align="center" | <b> X
|-
|-
|
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Qty1 inventory transaction Qty
| align="center" |  
| align="center" |  
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*TranCode inventory transaction tran code
| align="center" |
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Cost inventory transaction cost
| align="center" |
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*TranDate invnetory transaction date
| align="center" |
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|-
|
|<b>If</b> - TranCode is receipt, adjustment, or build
| align="center" |
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" | <b> X
|-
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Update</b> - invoice object is AP invoice
| align="center" |  
| align="center" |  
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Update</b> - Order object is purchase order
| align="center" |
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Delete</b> - Relationships - Remove relationships between inventory transaction and InvTranHeader
| align="center" |
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|-
|
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Delete</b> - Relationships - Remove relationships between inventory transaction and AP invoice
| align="center" |  
| align="center" |  
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*If</b> - TranCode is receipt
| align="center" |
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*If</b> - There is a purchase order
| align="center" |
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|-
|
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*If</b> - There is a purchase order
| align="center" |  
| align="center" |  
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Update</b> - Quantity - Purchase order lines that are related to the inventory transaction
| align="center" |
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;;*If</b> - PrePost TranCode is receipt, adjustment or build
| align="center" |
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*This is going to be an OppositePostingType so Qty will be a subtraction
| align="center" |
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|-
|
|
| align="center" |  
| align="center" |  
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|
| align="center" |
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|
| align="center" |
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" |
| align="center" | <b> X
|-
|-
|
|
| align="center" |  
| align="center" |  
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" |
| align="center" | <b> X
| align="center" |
| align="center" |
|-
|-
|
|
| align="center" |  
| align="center" |  
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" |
| align="center" | <b> X
| align="center" |
| align="center" |
|-
|-
|
|
| align="center" |  
| align="center" |  
| align="center" | <b> X
| align="center" | <b> X
| align="center" |
| align="center" |
| align="center" |
| align="center" | <b> X
| align="center" |
| align="center" |
|-
|-
|}
|}
<br/>
<br/>

Revision as of 17:28, 20 January 2020

Inventory

Inventory Pre Post Post Delete Create Unpost
If - Inventory units don't equal line units X X X X X
      *Convert - to the same unit Conv_Qty_Price X X X X X
Update - PrePost Parameters Static (Trancode, InventoryID, Qty, Date, and TranDate) X
      *InventoryID the Inventory X
      *Trancode on the inventory transaction associated with the calling item X
      *Qty on the inventory transaction associated with the calling item X
      *Date on the inventory transaction associated with the calling item X
      *TranDate is current date X
If - Inventory transaction is an adjustment X
      *Validate - Is the inventory transaction past the closing date X
Update - Parameters (Qty1, TranCode, cost, and TranDate) X X X
      *Qty1 inventory transaction Qty X X X
      *TranCode inventory transaction tran code X X X
      *Cost inventory transaction cost X X X
      *TranDate invnetory transaction date X X X
If - TranCode is receipt, adjustment, or build X X X
      *Update - invoice object is AP invoice X X X
      *Update - Order object is purchase order X X X
      *Delete - Relationships - Remove relationships between inventory transaction and InvTranHeader X X
      *Delete - Relationships - Remove relationships between inventory transaction and AP invoice X X
      *If - TranCode is receipt X X X
            *If - There is a purchase order X X X
            *If - There is a purchase order X X X
                  *Update - Quantity - Purchase order lines that are related to the inventory transaction X X X
      ;*If - PrePost TranCode is receipt, adjustment or build X X X
            *This is going to be an OppositePostingType so Qty will be a subtraction X X X
X X X
X X X
X X X
X X X
X X X
X X X