Postings:Inventory: Difference between revisions
No edit summary |
|||
| (6 intermediate revisions by the same user not shown) | |||
| Line 23: | Line 23: | ||
| align="center" | <b> X | | align="center" | <b> X | ||
|- | |- | ||
|<b>Update</b> - PrePost Parameters Static (Trancode, InventoryID, Qty, Date, and TranDate) | |<b>Update</b> - PrePost Parameters Static (Trancode on the inventory transaction associated with the calling item, InventoryID is the Inventory, Qty on the inventory transaction associated with the calling item, Date on the inventory transaction associated with the calling item, and TranDate is current date) | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | align="center" | | ||
| Line 30: | Line 30: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b>If</b> - Inventory transaction is an adjustment | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | align="center" | | ||
| Line 37: | Line 37: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| * | | <b>*Validate</b> - Is the inventory transaction past the closing date | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | align="center" | | ||
| Line 44: | Line 44: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b>Update</b> - Parameters (Qty1 is inventory transaction Qty, TranCode is inventory transaction tran code, cost is inventory transaction cost, and TranDate is invnetory transaction date) | ||
| align="center" | | |||
| align="center" | <b> X | |||
| 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" | | ||
| align="center" | | | align="center" | <b> X | ||
|- | |- | ||
| * | |<b> *Update</b> - invoice object is AP invoice | ||
| align="center" | | |||
| align="center" | <b> X | |||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | 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" | <b> X | ||
| align="center" | | | align="center" | | ||
| align="center" | | | align="center" | <b> X | ||
|- | |- | ||
|<b> | |<b> *Delete</b> - Relationships - Remove relationships between inventory transaction and InvTranHeader | ||
| align="center" | | |||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | 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" | <b> X | | align="center" | <b> X | ||
| align="center" | | | align="center" | | ||
| align="center" | | | align="center" | | ||
| align="center" | | | align="center" | <b> X | ||
|- | |- | ||
|<b> | |<b> *If</b> - TranCode is receipt | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 86: | Line 93: | ||
| align="center" | <b> X | | align="center" | <b> X | ||
|- | |- | ||
| * | |<b> *If</b> - There is a purchase order | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 93: | Line 100: | ||
| align="center" | <b> X | | align="center" | <b> X | ||
|- | |- | ||
| * | |<b> *Update</b> - Quantity - Purchase order lines that are related to the inventory transaction | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 100: | Line 107: | ||
| align="center" | <b> X | | align="center" | <b> X | ||
|- | |- | ||
| * | |<b> *If</b> - PrePost TranCode is shipment or component | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 107: | Line 114: | ||
| align="center" | <b> X | | align="center" | <b> X | ||
|- | |- | ||
| * | | *This is going to be an OppositePostingType so Qty will be an addition | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 114: | Line 121: | ||
| align="center" | <b> X | | align="center" | <b> X | ||
|- | |- | ||
|<b>If</b> - | |<b>If</b> - Trancode is shipment or component | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 121: | Line 128: | ||
| align="center" | <b> X | | align="center" | <b> X | ||
|- | |- | ||
|<b> *Update</b> - | |<b> *Update</b> - Invoice object is AR invoice | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 128: | Line 135: | ||
| align="center" | <b> X | | align="center" | <b> X | ||
|- | |- | ||
|<b> | |<b> *Update</b> - Order object is Orders | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 142: | Line 149: | ||
| align="center" | <b> X | | align="center" | <b> X | ||
|- | |- | ||
|<b> *Delete</b> - Relationships - Remove relationships between inventory transaction and | |<b> *Delete</b> - Relationships - Remove relationships between inventory transaction and AR invoice | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 149: | Line 156: | ||
| align="center" | <b> X | | align="center" | <b> X | ||
|- | |- | ||
|<b> *If</b> - | |<b> *If</b> - Trancode is sipment | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 156: | Line 163: | ||
| align="center" | <b> X | | align="center" | <b> X | ||
|- | |- | ||
|<b> *If</b> - There is a | |<b> *If</b> - There is a order | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 163: | Line 170: | ||
| align="center" | <b> X | | align="center" | <b> X | ||
|- | |- | ||
|<b> *Update</b> - Qty - Order lines that are related to the inventory transaction | |||
|<b> *Update</b> - | |||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 212: | Line 212: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
|<b>Create</b> - Inventory transaction record with either the AP | |<b>Create</b> - Inventory transaction record with either the AP/AR invoice date or current date and the trancode | ||
| align="center" | | | align="center" | | ||
| align="center" | | | align="center" | | ||
| Line 297: | Line 297: | ||
|- | |- | ||
|<b> *Create</b> - Inventory transaction component [[Postings:Inventory|PostInventory]] | |<b> *Create</b> - Inventory transaction component [[Postings:Inventory|PostInventory]] | ||
| align="center" | | |||
| align="center" | | |||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | |||
|- | |||
|<b> *Update</b> - Cost - Child component GetInvValue | |||
| align="center" | | |||
| align="center" | | |||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
|<b> * | |<b> *If</b> - Child component is auto build | ||
| align="center" | | |||
| align="center" | | |||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | |||
|- | |||
|<b> *Update</b> - Auto build flag on the inventory transaction | |||
| align="center" | | |||
| align="center" | | |||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 311: | Line 325: | ||
|- | |- | ||
|<b> *If</b> - Child component is auto build | |<b> *If</b> - Child component is auto build | ||
| align="center" | | |||
| align="center" | | |||
| align="center" | | |||
| align="center" | <b> X | |||
| align="center" | | |||
|- | |||
|<b> *If</b> - Parent item has componets | |||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 317: | Line 338: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
|<b> | |<b> *Create</b> - Inventory transaction build [[Postings:Inventory|PostInventory]] | ||
| align="center" | | |||
| align="center" | | |||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | |||
|- | |||
|<b> *If</b> - Auto build | |||
| align="center" | | |||
| align="center" | | |||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
|<b> * | |<b> *Update</b> - Auto build flag on the inventory transaction | ||
| align="center" | | |||
| align="center" | | |||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | |||
|- | |||
|<b> *If</b> - Related to a production run | |||
| align="center" | | |||
| align="center" | | |||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
|<b> | |<b> *Update</b> - Qty built on the production run record | ||
| align="center" | | |||
| align="center" | | | align="center" | | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 436: | Line 471: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
|<b> *If</b> - Inventory transaction is a shipment | |<b> *If</b> - Inventory transaction is a shipment or component | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 443: | Line 478: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b> *If</b> - Inventory transaction is a shipment | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 450: | Line 485: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b> *Update</b> - Qty - Orderlines PrePostOrders | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 457: | Line 492: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b> *Update</b> - Qty & Cost - inventory qty is a subtraction | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 464: | Line 499: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b>If</b> - Inventory transaction is receipt, adjustment, or build and the last cost has changed | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 471: | Line 506: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b> *If</b> - This part changes price when cost changes | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 478: | Line 513: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b> *Update</b> - Price, PriceLevelA, PriceLevelB, PriceLevelC, PriceLevelD, PriceAMarkup, PriceBMarkup, PriceCMarkup, PriceDMarkup, RetailMarkup, PriceADiscount, PriceBDiscount, PriceCDiscount, PricedDiscount - On Inventory RecalcInvMarkup | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 485: | Line 520: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b>Validate</b> - Does the inventory have a negative qty | ||
| align="center" | | | align="center" | | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| Line 492: | Line 527: | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
| | |<b>Validate</b> - Is the inventory transaction past the closing date | ||
| align="center" | <b> X | | align="center" | <b> X | ||
| align="center" | | | align="center" | | ||
| align="center" | | | align="center" | | ||
| align="center" | | | align="center" | | ||
| align="center" | | | align="center" | | ||
|- | |- | ||
|} | |} | ||
<br/> | <br/> | ||