Sage 100 2018 Customizer question PO Receipt of Goods Date UDF to post thru to IM Cost file

SUGGESTED

Sage 100 2018 Customizer question

All Inventory items are FIFO Valuation

Client wants a Date UDF added to the PO Receipt of Good Lines

I added the Date UDF to the PO Receipt of Good grid

I need to know the steps on how to get this Date UDF to post thru to the IM Cost file when PO Receipt of Goods is updated and attached to the Cost Tier.

Any help would be greatly appreciated.

Thanks

Parents
  • 0

    Generally, you start at the destination, look at the available data sources, and try to find a path to the data entry point you want.  Not everything is possible.

    Note: Sage added lot / serial expiry dates in recent versions, if that is your goal.

  • 0 in reply to Kevin M

    The items are FIFO.

    The items are manufactured in China. When the items are put in containers and are being shipped the client does a Receipt of Goods and put in in a "Shipping" warehouse (800). The shipment takes anywhere from 60-90 days. They want to attach an ETA delivery date when they do the Receipt and have this date post to the IM Cost file tier.

    Their customers call and ask when to expect to receive the items. They want to be able to look up the item in IM Inquiry and see the date.

  • 0 in reply to Doc102208
    SUGGESTED

    Try going through IM_TransactionPosting.  Not tested, but that might work as a middle step.

  • 0 in reply to Doc102208

    We have the exact same situation. I created UDFs and put them into the PO header for Completion Data and Arrive date. These dates are when the product is finished in China and when we expected them here. I carried over the date they arrived here into the Line Detail and then added this to the inquiry screens you can see the date we expect it at the warehouse.

Reply
  • 0 in reply to Doc102208

    We have the exact same situation. I created UDFs and put them into the PO header for Completion Data and Arrive date. These dates are when the product is finished in China and when we expected them here. I carried over the date they arrived here into the Line Detail and then added this to the inquiry screens you can see the date we expect it at the warehouse.

Children
No Data