Sage 100

 View Only
  • 1.  Has anyone figured a good method to have Im_itemc

    Posted 03-05-2014 07:43
    Has anyone figured a good method to have Im_itemcost UDF's (such as a expiration date) Carry over to new warehouse when doing inventory transfers other than manually rekeying the information. I was thinking about a script and wondering if it has been done.


  • 2.  RE: Has anyone figured a good method to have Im_itemc

    Posted 03-05-2014 08:50
    It's been a while, but I think you can accomplish this in Custom Office by passing the data through IM_TransactionPosting.


  • 3.  RE: Has anyone figured a good method to have Im_itemc

    Posted 03-05-2014 09:51
    Now that you mention it @MichaelNottoli, I did something similar for a client of mine.


  • 4.  RE: Has anyone figured a good method to have Im_itemc

    Posted 03-05-2014 09:53
    I will investigate further. It didn't seem to work for inventory transfers for me.


  • 5.  RE: Has anyone figured a good method to have Im_itemc

    Posted 03-05-2014 10:25
    I did this several years ago on 4.3 or 4.4. Lots of little steps involved.


  • 6.  RE: Has anyone figured a good method to have Im_itemc

    Posted 03-05-2014 10:37
      |   view attached
    Found my old project. I used IM_TransactionTierDist.


  • 7.  RE: Has anyone figured a good method to have Im_itemc

    Posted 03-05-2014 11:49
    Yeah but I I don't that will transfer the date from one warehouse to another. It will allow you to input it again but it doesn't know to copy from one warehouse to another. At least in my trsts


  • 8.  RE: Has anyone figured a good method to have Im_itemc

    Posted 03-05-2014 11:57
    What is your inventory method? I am pretty sure I used lots so I could attach the udf to the tier.


  • 9.  RE: Has anyone figured a good method to have Im_itemc

    Posted 03-05-2014 12:09
    Definitely lots


  • 10.  RE: Has anyone figured a good method to have Im_itemc

    Posted 03-05-2014 12:10
    Just tested an IM Transfer in v4.4. The UDF_ExpirationDate from the item in whse 000 passed to the new cost record (lot in this case) in whse 098.


  • 11.  RE: Has anyone figured a good method to have Im_itemc

    Posted 03-05-2014 12:11
    It attaches find the issue is that when you transfer it doesn't know to copy the date. It is a manually entire field. Frankly it make sense that it would. I think a script will be necessary


  • 12.  RE: Has anyone figured a good method to have Im_itemc

    Posted 03-05-2014 12:17
    Let me test tonight. It could be broken in v2013