| Comments: a very important shift has occurred away from BKICMSTR and to BKICLOC. The units and value fields in BKICMSTR are now no longer updated or maintained and are only used for temporary calculations. The BKICLOC file now is the only file that tracks units (on hand, on sales order, on purchase order, on back order) and value (average cost, last cost). There is no longer a permanently kept "total value" field inasmuch as it can always be easily calculated (units on hand plus units on sales order at a given location multiplied by its average cost equals that location's value). Not only does this decrease the amount of record locking and eliminate synchronization problem, it also resolves a problem whereby if a user has different GL asset codes for multiple locations, average costing of inventory as to that location could not be supported as in prior versions specific cost was being received via purchase orders or adjustments, but was being sold via the no longer use BKIC.PROD.AVGC field (BKIC.PROD.LSTC is still used to represent the very last "last cost"). More fields will be added to BKICLOC in the future and to avoid naming conflicts, we'd suggest checking with this before adding fields to this file.
|