Postings:Inventory

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 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)	X
If - Inventory transaction is an adjustment	X
*Validate - Is the inventory transaction past the closing date	X
Update - Parameters (Qty1 is inventory transaction Qty, TranCode is inventory transaction tran code, cost is inventory transaction cost, and TranDate is 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
*Update - Quantity - Purchase order lines that are related to the inventory transaction		X	X		X
*If - PrePost TranCode is shipment or component		X	X		X
*This is going to be an OppositePostingType so Qty will be an addition		X	X		X
If - Trancode is shipment or component		X	X		X
*Update - Invoice object is AR invoice		X	X		X
*Update - Order object is Orders		X	X		X
*Delete - Relationships - Remove relationships between inventory transaction and InvTranHeader		X			X
*Delete - Relationships - Remove relationships between inventory transaction and AR invoice		X			X
*If - Trancode is sipment		X	X		X
*If - There is a order		X	X		X
*Update - Qty - 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
If - Shipment or component		X		X
*If - Auto build AssemblyCheck		X		X
*For Each - Child component of parent item		X		X
*Create - Inventory transaction component PostInventory				X
*Update - Cost - Child component GetInvValue				X
*If - Child component is auto build				X
*Update - Auto build flag on the inventory transaction				X
*If - Child component is auto build				X
*If - Parent item has componets		X		X
*Create - Inventory transaction build PostInventory				X
*If - Auto build				X
*Update - Auto build flag on the inventory transaction				X
*If - Related to a production run				X
*Update - Qty built on the production run record				X
*Update - Cost on the inventory transaction records related to the production run RecalcProductionRun		X		X
If - Qty equals zero		X		X
*Delete - Inventory transaction		X		X
*Delete - Relationships - All relationships to the inventory transaction		X		X
Validate - Enforcing existing receipt		X		X
Update - Qty & Cost - On the inventory transaction		X		X
Create - Relationships - Inventory transaction and location, inventory transaction and inventory lot, inventory transaction and shipping container, inventory transaction and address, inventory and address, inventory transaction and company, inventory transaction and person		X		X
If - Inventory transaction isn't a move		X		X
*If - Inventory transaction is receipt, adjustment, or build		X		X
*If - Inventory transaction is a receipt		X		X
*Update - Qty - purchase order lines PrePostOrders		X		X
*If - Invetory last cost date is older then transaction date		X		X
*Update - Last Cost date - On inventory		X		X
*Update - Qty & Cost - Inventory qty is in addition		X		X
*If - Inventory transaction is a shipment or component		X		X
*If - Inventory transaction is a shipment		X		X
*Update - Qty - Orderlines PrePostOrders		X		X
*Update - Qty & Cost - inventory qty is a subtraction		X		X
If - Inventory transaction is receipt, adjustment, or build and the last cost has changed		X		X
*If - This part changes price when cost changes		X		X
*Update - Price, PriceLevelA, PriceLevelB, PriceLevelC, PriceLevelD, PriceAMarkup, PriceBMarkup, PriceCMarkup, PriceDMarkup, RetailMarkup, PriceADiscount, PriceBDiscount, PriceCDiscount, PricedDiscount - On Inventory RecalcInvMarkup		X		X
Validate - Does the inventory have a negative qty		X		X
Validate - Is the inventory transaction past the closing date	X