Initial move of storage caclulation stored procecdure

Issue No: GRN-252
Created 10/30/2015 7:40:52 AM
Type Feature
Priority Major
Status Closed
Resolution Fixed
Fixed Version 15.4
Description Need to build a base STORE to calculate storage charges.     Requirements:   # Only one period and must be “Thereafter” only set to .001333 (roughly .04 cents a month) # Must be set to Storage Rate of Daily # 0 allowance days only. # Must be able to work with effective and termination date: ## ) both blank ## effective date only (no charges up to effective date) ## termination date only (no more charges after termination date) ## both set     Store must accept   # process type ## calculate - only returns the values, but does not update storage record ## accrue - will calculate storage like calculate and return values plus add new storage charges to the storage due field in storage record and create history of the transaction. ## Bill – does both calculate and accrue process plus will update storage paid for the difference of existing storage paid and storage due. NOTE: the calling programs will create the invoice or line items to process the amount. # Key storage record of record to calculate on. # Date to calculate storage end date. # User ID signed in to the system.     Store must return   # Storage due change per unit (new storage due amount – old storage due amount) eg: .04 if calculating 1 month at .001333 rate. # Storage due change amount (storage due change per unit * open units) # Storage due total per unit (new storage due amount – new storage billed) # Storage due total amount (storage due total per unit * open units) # Storage billed per unit (new storage paid – old storage paid) when calculate or accrue, this will be 0. # Storage billed amount (storage billed per unit * open units)     Sample Storage Schedule   !pastedImage_d46424_0.png!