Postings:Inventory: Difference between revisions

JMeyer (talk | contribs)
No edit summary
JMeyer (talk | contribs)
 
(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" |
|-
|-
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*InventoryID the Inventory
|<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" |
|-
|-
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Trancode on the inventory transaction associated with the calling item
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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" |
|-
|-
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Qty on the inventory transaction associated with the calling item
|<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
| align="center" |
|-
|-
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Date on the inventory transaction associated with the calling item
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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
| align="center" |
| align="center" |
|-
|-
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*TranDate is current date
|<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" | <b> X
| align="center" |
| align="center" |
| align="center" |
| align="center" | <b> X
| align="center" |
| align="center" |
|-
|-
|<b>If</b> - Inventory transaction is an adjustment
|<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" | <b> X
| align="center" |
| align="center" |
| align="center" |
| align="center" |
| align="center" |
| align="center" | <b> X
| align="center" |
|-
|-
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>*Validate</b> - Is the inventory transaction past the closing date
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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
| align="center" |
|-
|-
|<b>Update</b> - Parameters (Qty1, TranCode, cost, and TranDate)
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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
|-
|-
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Qty1 inventory transaction Qty
|<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
Line 93: Line 100:
| align="center" | <b> X
| align="center" | <b> X
|-
|-
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*TranCode inventory transaction tran code
|<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" |  
| align="center" | <b> X
| align="center" | <b> X
Line 100: Line 107:
| align="center" | <b> X
| align="center" | <b> X
|-
|-
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Cost inventory transaction cost
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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
|-
|-
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*TranDate invnetory transaction date
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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> - TranCode is receipt, adjustment, or build
|<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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Update</b> - invoice object is AP invoice
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Update</b> - Order object is purchase order
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Delete</b> - Relationships - Remove relationships between inventory transaction and AP invoice
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*If</b> - TranCode is receipt
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*If</b> - There is a purchase order
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*If</b> - There is a purchase order
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Update</b> - Qty - Order lines that are related to the inventory transaction
| align="center" |
| align="center" | <b> X
| align="center" | <b> X
| 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" |  
| 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?AR invoice date or current date and the trancode
|<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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Create</b> - Inventory transaction component [[Postings:Inventory|PostInventory]]
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Update</b> - Cost - Child component GetinvValue
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*If</b> - Child component is auto build
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*If</b> - Child component is auto build
| align="center" |
| align="center" |
| align="center" |
| align="center" | <b> X
| align="center" |
|-
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Update</b> - Auto build flag on the inventory transaction
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*If</b> - Related to a production run
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Update</b> - Qty built on the production run record
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*Update</b> - Qty built on the production run record
| align="center" |
| align="center" |  
| align="center" |  
| align="center" | <b> X
| align="center" |  
| align="center" |  
| align="center" | <b> X
| align="center" | <b> X
Line 436: Line 471:
| align="center" |  
| align="center" |  
|-
|-
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*If</b> - Inventory transaction is a shipment
|<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*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" |
| align="center" | <b> X
| align="center" | <b> X
| align="center" |  
| align="center" |  
| align="center" | <b> X
| align="center" |  
| align="center" |  
|-
|
| align="center" |  
| align="center" |  
| align="center" | <b> X
| align="center" |
| align="center" | <b> X
| align="center" |
|-
|
| align="center" |
| align="center" | <b> X
| align="center" |
| align="center" | <b> X
| align="center" |
|-
|
| align="center" |
| align="center" | <b> X
| align="center" |
| align="center" | <b> X
| align="center" |  
| align="center" |  
|-
|-
|}
|}
<br/>
<br/>