Just some info for anyone on less than 10.2 (ie problem fixed in this release) trying to balance their GL to the stock sts report. The stock sts report does not report stock where the bin and potentially warehouse transferred to does not case match the master table, ie if your master table bin was say 1A2B for example and someone transferred stock to 1a2b it would not appear on the stock sts report. This is possible if staff manually enter this value.
Epicor have a sql script that converts the case to match the master table case but its a work around, ie as soon as someone enters a bin that doesn’t case match it will occur again unless you apply a BPM to warn the user or possibly hard error it. Based on the number of tables and fields updated this problem would definitely be larger than just this report.
Apparently this issue has been fixed in 10.2. Below are the tables (60) the script processes.
ABCCode, ActBook, APInvHed, BankAcct, BookingRule, CashHead, CCTag, CCWhsABC, CheckHed, COASegAcct, COASegValues, ConsSrcAcctBal, Customer, EcoCoPart, EcoMtl, EcoRev, EntityGLC, ExtCompany, GLAccount, GLAcctDisp, GLBook, GLCntrlAcct, GLCurBal, GLJrnDtl, GLJrnDtlMnl, GLPeriodBal, IM, InvcDtl, InvcHead, JobHead, JobMtl, LaborDtl, OpMasDtl, OrderDtl, OrderRel, Part, PartBin, PartDtl, PartMtl, PartPlant, PartQty, PartRev, PartTran, PartWhse, PlantConfCtrl, PlantWhse, PODetail, POHeader, PORel, Quotedtl, QuoteOpDtl, ResourceGroup, SerialNo, ShipDtl, ShipHead, SNTran, TranGLC, UOMConv, Warehse and WhseBin.
Hope this helps, it would have been nice to know this 3 months ago.
Cheers,
Paul