Marni Stallings
Forum Replies Created
-
Marni Stallings
MemberJune 23, 2023 at 3:00 pm in reply to: Webinar Today (June 23 2pm EDT) Reporting 101 -
-
::
One more thing…if you are using STD cost and you do not have a roll up query to find items where the roll up does not equal the STD cost on the item card, you will continue to have variances at every output where they are not equal. We have too many items to roll up costs on all items, so I have a query that I run that shows if any component STD cost changed and/or the BOM route was updated and cost was not rolled up. It used to be a huge issue when accounting did not control all of the changes, hence the query. Now our biggest driver of variances is where STD cost changes on components or changes to BOM/Routes occur in the middle of a run. The variance will post once the PDR is finished. No way around it unless you close out all PDR’s, make changes, roll cost and then create new PDRs. We accept the small variances on the runs for these situations because we try to keep our runs relatively short.
-
::
If you have JET, you can create a query that brings in all of the information and provide the variance data at run. I export the value Entries directly into Excel from BC…faster than bringing in through JET, then my query brings in the necessary ITEM data and BOM data in two other tabs. The variance entry type lines tie me back to what hit my Production Variance line on the GL monthly. I then have a Pivot table that summarizes the variances by PDR, then I look at the big ones from there. It shows me where they over or under consumed or used different materials.
-
Marni Stallings
MemberMarch 16, 2023 at 4:21 pm in reply to: Adding Comments/Notes to Item Journals -
-
::
I apologize, I misread your reply. We cannot get Edit In Excel to work. Did you work with a VAR to setup? We are trying to setup in our TEST environment first, but they are telling me that it is all or none…Considering the power behind this functionality, it is important we test it first, so I am hesitant to give them the go ahead and enable it in LIVE and TEST. Any insight you have on your experience would be appreciated.
-