WMS Inventory Load preserving FIFO Layers?

MP_NAV
MP_NAV Member Posts: 42
edited 2007-03-05 in NAV/Navision Classic Client
During the initial inventory load, I am trying to determine the Best Practice to load full WMS inventory while preserving the FIFO layering from the legacy system. Microsoft was not very helpful with this question and suggested I check with some folks who may have already gone through this.

Any thoughts?

Full WMS Directed Pick/Putaway 4.0 SP2 Native DB
-MP

Answers

  • ara3n
    ara3n Member Posts: 9,258
    WMS does not have layering. Load the warehouse through warehouse journal. Post it. To keep the layering, You need to load the data into Item journal, without the BIN. Post it.
    Afterwards when you run adjust whse. routine on item journal. you shouldn't get
    lines.
    You can only keep FIFO layer on item ledger at location level.

    Hope this helps.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • MP_NAV
    MP_NAV Member Posts: 42
    ara3n,

    Thank you for the response. It worked perfectly!

    -MP
    -MP
  • ara3n
    ara3n Member Posts: 9,258
    you are welcome :D

    I'm curious why MS didn't give you an answer.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • MP_NAV
    MP_NAV Member Posts: 42
    I know! Their response was simply to use the Whse. item Journal to load the quantities, and then Calc. Whse Adjustment. Which obviously is the exact procedure for WMS inventory, however it didn't help with the FIFO layering question. At least they suggested I ask in the Online Communities, but yes with as simple a solution as this I am a bit irked that they couldn't make the same suggestion you did. One of our developers suggested MIBUSO first and Microsoft as a last resort going forward.

    Thanks again!!!
    -MP

Categories