Integration - New cost adjustment method for grain industry. Price fixing of basis contract takes over an hour to post and create vouchers.

Issue No: IC-6736
Created 1/27/2019 9:58:58 PM
Type Feature
Priority Major
Status Closed
Resolution Fixed
Fixed Version 18.3
Description Specs   [http://inet.irelyserver.com/display/INV/Inventory+Cost+Adjustments+for+Grain]     This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-224917 - Unable to Price contract, Negative Cost is not Allowed|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-224917]           This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.     [HDTN-223351 - Kyle Stutzman - Basis contract|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-223351]     Cost Adj on average cost is working out to be crazy. There are 1170 adjustment entries for this bill.   Price fixing is for for 1600 bushels.   !pastedImage_d111335_0.png!   Quantity can span across multiple receipts and a voucher is created for each receipt.   !pastedImage_d111335_1.png!   Now these   * IRs are shipped * These shipments are invoiced * IRs are Transferred * These transfers are received through IR in another location * These transfer IRs is shipped * These shipments are invoiced.   A long trail of cascading transactions. Bill is making cost adj entries for all of these. This is taking a very long time. This test by Satya took over 1 hour to post the price fixing.   http://jira.irelyserver.com/browse/CT-2889?focusedCommentId=212813&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-212813   For the grain industry, this depth of cost adj is trouble than useful. All these GL entries will be hard to trace and serve no purpose for them. Looks like we have to come out with a simple cost adj option for the grain industry.   Price fixing can happen many months after the receipts. Inventory would have been long gone for these cost buckets.     # Create Cost Adjustment for the quantity billed by the Voucher and the linked IRs. # Make cogs entry for the total stock sold for the cost bucket and do not make adjustment entries for each IS/SI involved. # Make inventory adjustments for the total stock for the transfers made and do not make adjustment entries for each transfer involved. # Calculate the average cost. # The difference in the old and new average cost should be posted to Auto Variance as usual.   Do not have to dive deep to find all impacted transactions and make adjustment entries for each.   We can control this system behavior by setup in Item screen.