Skip to main content

changes for stf

  • 1. stf transactions (data entry) over the intranet had problems when solomon tries to do a "release now" action.

  • 2. further analysis by LPE shows that the intranet module hasn't completely emulated the "transfers" transaction of solomon, in that the items transferred did not have corresponding serialized entries in LotSerT

  • 3. relations: Batch 1:1 TrnsfrDoc, Batch 1:n INTran, INTran 1:n LotSerT

  • 4. look up for LotSerT.LotSerNbr will come from LotSerMst (where all serialized items are built up)

  • 5. SELECT LotSerNbr FROM LotSerMst WHERE InvtId='1002122' AND SiteId='LOG-MCS' AND Status = 'A' AND WhseLoc='MAIN' AND QtyOnHand > 0 ORDER BY LotSerNbr ASC


Popular posts from this blog

Valentine Surprise

Each year, on Valentine's day, I usually surprise my darling wife with a letter/card, or a bouquet of roses. As it was a yearly thing, I knew she sort of expected these surprises; she'd look surprised, but I knew she wasn't really. Occasionally, she does get surprised. Like that time back in Cebu when I bought her a rather intricate bouquet of flowers. Her head spun when she found out how much I paid for it. Surprise! This year, however, is different. I was not able to prepare anything for her. I didn't get her anything, thinking that I'd just make up for it with dinner, or something. Yes, I didn't plan for this and I feel lousy actually. Last night, after my daughter gave me and my wife her home-made Valentine greeting cards, my wife started chiding me about what I was going to give her the next day. I gave her my usual "I'm not telling" smile and silently kicked myself. I wished I already had something ready, and I found myself already longing fo

Migs in the Office!

Miguel got real bored at home and wanted to go and meet his classmates. Since school doesn't start until the 7th, I decided to take him with me to the office. He immediately got busy with the miniclip games and ignored Mjolnir the whole time! [gallery type="rectangular" ids="3167,3166"]