Menu

Pair QTY of SKU Halved

Paul
2012-07-20
2012-08-03
  • Paul

    Paul - 2012-07-20

    My metabox SKU items have a UOM of PAIR. It looks like EM sees that in BOM the correct qty posted (job is done and everything is finished) but the job SQU consumption shows that only half posted. The onhand qty of these SKU's also show this incorrect qty.

     

    Last edit: Paul 2012-07-20
  • Jonah Coleman

    Jonah Coleman - 2012-07-20

    What is the UOM in Solid? And what is the import multiplier?

     
  • Paul

    Paul - 2012-07-20

    Each
    1

     
  • Jonah Coleman

    Jonah Coleman - 2012-07-20

    Your import multiplier should be 0.5, since for each two parts in CV with that material you want it to associate with one of your SKU item.

     
  • Paul

    Paul - 2012-07-20

    A UCS deletes half of them so that I get pair qty's on my CV reports.

     

    Last edit: Paul 2012-07-20
  • Paul

    Paul - 2012-07-20

    Here it is...

    ; Makes Drawer guides show as pairs

    For Each DG|ROG Guide

    if rprec(AZ) = -90 then
    EDX = -DX
    End If

     

    Last edit: Paul 2012-07-20
  • Jonah Coleman

    Jonah Coleman - 2012-07-20

    Am I correct when you said earlier your BOM Qty Needed is correctly displaying pairs when you bring it in?

     
  • Jonah Coleman

    Jonah Coleman - 2012-07-20

    Oh I see it, it is in fact built into EM when an assembly is completed that if the source UOM is "each" and the SKU UOM is "pair" then it halves it as it commits them.

    I will remove that, it is left over from the days before you could specify an import multiplier.

     
  • Paul

    Paul - 2012-07-23

    Cool! Thank you.

     
  • Paul

    Paul - 2012-07-23

    So, is there a way for me to quickly double the allocations for them or do I need to manually pick them (15-20 jobs worth)?

     
  • Paul

    Paul - 2012-07-23

    Besides On Hand Adjustment. I'd like to correct the job costs too. :)

     
  • Paul

    Paul - 2012-07-23

    Nevermind, I'll just take care of it manually.

     
  • Paul

    Paul - 2012-08-01

    I know you've got more important things to do but I'm wondering where this is on your to-do list. I told the guys ont to complete any cabs until this is fixed but if it's going to be awhile I'll start fixing it manualy. Not a big deal, just wondering.

     
  • Jonah Coleman

    Jonah Coleman - 2012-08-01

    It was fixed in build 1411. I will either put out a full update today or post a fixed build of the last posted build... the current build has had less testing than I usually allow out

     
  • Paul

    Paul - 2012-08-01

    Wow, that was faster than what I was expecting! I'll understand if it comes with the overwhelming smell of baby wipes!

     
  • Paul

    Paul - 2012-08-02

    FYI, build 1412 fixed the issue but now the SKU isn't being displayed in the "SKU Consumption" breakout area in the Jobs Module. I don't know if that was intentional or not.

     
  • Jonah Coleman

    Jonah Coleman - 2012-08-02

    No for sure, is the onhand being reduced? Is this with assemblies that were already allocated once or never completed?

     
  • Paul

    Paul - 2012-08-02

    I can't tell right at the moment. My on-hands are so off that I can't tell. I should have looked at it before I completed those assemblies. This is on cabs that weren't yet completed until after the update to 1412.
    I'll check to see if I have other cabs to complete...

     
  • Jonah Coleman

    Jonah Coleman - 2012-08-02

    Was this just because you didn't refresh the job? Hoping so, because I don't see any other problems and you made the other post about a way to reload the job...

     
  • Paul

    Paul - 2012-08-03

    I maaaayaaaay have been looking at a very similarly named job that didn't have that material in it. Maybe. Either way 1414 is in and all is well!

     
  • Paul

    Paul - 2012-08-03

    Ok, scratch that, I found the job I was looking at yesterday. But in EM's defense, I was completing, un-completing, changing import multipliers and generally pushing the limits. In the pic, the opened window is the BOM of the highlighted cab 1-5.
    I'll test another set of cabs next week for completion to see if it works correctly. I don't have any reason to think that it won't.
    Thanks for your awesome program!

     

Log in to post a comment.

MongoDB Logo MongoDB