Postings:Inventory: Difference between revisions
From Epiphany
| Line 233: | Line 233: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b>If</b> - There is an InvTranHeader | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | |||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b> *Create</b> - Relationships - Inventory transaction and InvTranHeader | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | |||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b> *If</b> - InvTranHeader is related to a InvTranDetail with the same qty, same item, and doesn't have another inventory transaction attached | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | |||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b> *Create</b> - Relationships - Inventory transaction and InvTranDetail | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | |||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b> *If</b> - There is an order | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | |||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b> *Create</b> - Relationships - InvTranDetail and Purchase Order/Order | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | |||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
|} | |} | ||
<br/> | <br/> | ||
Revision as of 20:05, 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 | ||
| Update - Inventory Qty - AP (subtracting the PrePost Qty, if PrePost TranCode is shipment or component then adding PrePost Qty), AR (adding the PrePost Qty, if PrePost Trancode is receipt, adjustment, or build then subtracting the PrePost Qty) | X | X | X | ||
| Delete - Inventory transaction record | X | ||||
| Update - Qty - If TranCode is shipment update orderlines, if TranCode is receipt update purchase orderlines PrePostOrders | X | ||||
| Create - Inventory transaction record with either the AP?AR invoice date or current date and the trancode | X | ||||
| Create - Relationships - inventory transaction and either AP/AR invoice, inventory transaction and inventory, inventory transaction and either purchase order/order, inventory transaction and production run | X | X | |||
| Update - Qty & Cost - On the inventory transaction related to the invoice PreSHIPorREC | X | X | |||
| If - There is an InvTranHeader | X | X | |||
| *Create - Relationships - Inventory transaction and InvTranHeader | X | X | |||
| *If - InvTranHeader is related to a InvTranDetail with the same qty, same item, and doesn't have another inventory transaction attached | X | X | |||
| *Create - Relationships - Inventory transaction and InvTranDetail | X | X | |||
| *If - There is an order | X | X | |||
| *Create - Relationships - InvTranDetail and Purchase Order/Order | X | X |