|
We are 405 CD.When we use a T transaction, it updates the inventory and creates two inventory history (ITH) audit trail records that can be viewed in INV300.
Let's suppose we transfer 1,000 of an item from warehouse 69 to warehouse 21.As a result of the transaction, the inventory in 69 has gone down by 1,000 while what is in 21 has gone up by 1,000 for that item. Also, the COSTS of the items by facility have changed, because we are on last cost & a transfer of quantity also brings with it the cost of what was transferred.
In our case, warehouses prefixed 6* are a distribution facility that only has material costs, while those prefixed 2* are a production facility that has a break down of labor overhead etc. Thus, inventory transferred between those facilities can have the effect of messing up costs where same item in different facilities with different cost structures. So if you have similar situation & not want to mess up your cost structure, then do not use T transaction to transfer between such facilities. Instead use DRP, or some other approach acceptable to your company.
In INV300 we see a T line for 69 with a minus 1,000 and a T line for 21 with a plus 1,000.
When we do a T transaction, we have to tell it what item is going from where to where in what quantity, and specify a REASON why we are doing this. Depending upon how your company has the rules setup in ITE transaction effects, this might work a little differently for you.
We probably have lots more of the item in our total company than the 1,000 in our example. BPCS keeps track of how much of the item we have, by warehouse, location, lot.
IIM file has grand total of the item, all facilities, the works IWI file has total by item by warehouse ILI file has total by item by warehouse location ILN further breaks this down by lotWhen you do an inventory transfer, the quantity in IIM stays the same, while IWI ILI gets updated. On-Hand is not stored one place, rather it is computed from opening balance for the month, issues to production & shipments, receipts from production and vendor POs, and adjustments. I oversimplify. Transfers count as adjustments.
INV500 has a bunch of transaction codes, but we use INV510 for the T transactions, JIT600 for shop order backflusing, and other programs for customer order inventory effects.
Hi All, Could someone explain to me how the transaction actually works? If I'm transferring out of one location and putting it into another, how is that quantity used in the effect code? Thanks, Paul Hirschmann Lance, Inc. Business Analyst ( IT Logistics) Email: phirschmann@xxxxxxxxx Office: 704-557-8350 -- This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. Delivered-To: macwheel99@xxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
