Manipulating Inventory POs

 7 Replies
 2 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Kat V
Veteran Member
Posts: 1020
Veteran Member

    Does anyone here do anything to customize the inventory POs? 

     

    We have a inventory location that has a room within their room - the POs just all go out from the location - it's essentially a large bin group - so when the pallets come in, they are a pain to put away.  The PO doesn't sort by bin or bin group.

    Has anyone made it do so?  Or somehow otherwise identify PO lines without creating a separate inventory loc on IC02?

    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
      The Put Away report should sort by bin. You might want to create your PO by the one big bin location to as least keep that location separate.
      David Williams
      JonA
      Veteran Member
      Posts: 1163
      Veteran Member
        Our clean room is basically a room within the main storeroom. All bins within the clean room start with C and as David said, the putaway report prints in bin order so we can easily identify which items go in the clean room.
        Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
        Kat V
        Veteran Member
        Posts: 1020
        Veteran Member
          That's what I thought. Their problem is that when the POs go out, Cardinal is palletizing them - so the items are scattered in the different pallets. I cannot send bin info to Cardinal, let alone make them understand to palletize by bin group.

          But I figured I'd ask. It's amazing what people have made Lawson do.
          Mike Bernhard
          Veteran Member
          Posts: 101
          Veteran Member
            Hi Kat. You probably know this already since you mentioned that you wanted a solution that does not require a separate IC02, but for the purpose of sharing other options to others that may read this post---you can achieve what you want by having your distributor set up a separate Ship To Account number for this area. Once you have this new number, you can then create a separate IC02 (typically this is achieved by setting up a Lawson perpetual or par location). You would then setup the ED40 records for this IC02 so that the EDI module sends the correct Ship To Account number when POs are transmitted for this IC02 location via EDI.

            This process should trigger the distributor to segregate the supplies for this IC02 location onto its own pallet. Of course your distributor has to be willing to do this and if you need more than a handful of Ship To account numbers, you will likely be asked to use your distributor's Low UOM program (for Cardinal this is the Valuelink program).
            Kat V
            Veteran Member
            Posts: 1020
            Veteran Member
              Yes - that was what I suggested - if we need to communicate separate location to outsiders then make it a separate location.

              My users are feeling that this is more a Cardinal issue - the multiple distribution centers are creating multiple pallets. So instead of three massive pallets, they are getting 8 smaller ones. Any of the lines on any of the 8 pallets might belong to the internal clean room, causing the traffic to increase and increasing the chances of contamination.

              But they don't want the "hassle" of having separate locations.

              Any future readers of this thread - Mike is correct. Create IC02s for each unique loc. Even if "physically" they may be the same.
              Red
              Veteran Member
              Posts: 87
              Veteran Member
                Folks,
                Strictly from an EDI perspective, there is another answer (though I hesitate to say is it easier): use of a Purchase From in tandem with the new/discrete Ship To accounts and the ED40.

                In the ED40, the outbound translation field for IC Locations (tp_O_SHIPTO) is dependent on four variables: IC Location Code, Vendor, the Vendor Purchase From, the Company. A switch between Purchase Froms can be used to differentiate the vendor's Ship To accounts. Depending on your set up, the separate Purchase Froms could also cause the orders to split to discrete Purchase Orders. Okay, so now that I am thinking about it, just having separate Purchase Orders may be enough to get your supplier to bundle things in a more coherent fashion.

                Anyway, we do this all the time with our med/surg distributors to differentiate Bulk accounts, JIT accounts and 3PL accounts for the same IC Location.

                I know that I have been inactive on this site for a while, but if you have questions, let me know and I will try to respond back.
                Enjoy,
                Red

                Learn from the Past. Prepare for the Future. Act in the Present.
                Kat V
                Veteran Member
                Posts: 1020
                Veteran Member
                  Oh that might work. It's Cardinal so we're going down to the req loc but depending on what the items are, it might not be that big of a switch.