Postings:Inventory: Difference between revisions
From Epiphany
| Line 86: | Line 86: | ||
| align="center" | <b> X | | align="center" | <b> X | ||
|- | |- | ||
| | | *Qty1 inventory transaction Qty | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | |||
| align="center" | <b> X | |||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | |||
|- | |||
| *TranCode inventory transaction tran code | |||
| align="center" | | |||
| align="center" | <b> X | |||
| align="center" | <b> X | |||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | |||
|- | |||
| *Cost inventory transaction cost | |||
| align="center" | | |||
| align="center" | <b> X | |||
| align="center" | <b> X | |||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | |||
|- | |||
| *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> *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> *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> *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> *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> *If</b> - TranCode is receipt | |||
| align="center" | | |||
| align="center" | <b> X | |||
| align="center" | <b> X | |||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | |||
|- | |||
|<b> *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> *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> *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> ;*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 | |||
|- | |||
| *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" | <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 | ||
|- | |- | ||
|} | |} | ||
<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 |