Hi All
What would be the formula for the shipments received on a specific day. I designed the POP10500_T4.Status = 1 but it doesn't work.
Regards
Rashid Anwar
*This post is locked for comments
Hi Leslie
Thank you very much for you help and support.
Best Regards
Rashid Anwar
Hi Rashid,
We'd be moving into what I would consider chargeable time if I were to do that. Remember that all forum work is volunteer work for me. I still need to make a living. Anyway, I thought of another way that may be much easier to code. Since a posted receipt lives in the POP30310 table, if you tested for the number of unvoided records in that table, you could tell that something has been posted if that number increases. You could then identify those new records and send the results to whomever it needs to see them.
Kind regards,
Leslie
Thank you Leslie for your time and input.
Okay we selected the table where history transactions move but how to trigger the alert for the specific receipt posted.
I mean what should be the formula.
As you elaborated above i think posted date column of the POP30310 could be used and the formula might be POP30310_TPOSTEDDT=TODAY
This will trigger the alert and filtering the void status table will exclude the voids.
Now question is how the formula will pickup the Receipt number in the message that has been posted.
Leslie if you please design a formula to meet the above requirement i would b able to understand how does it work. And next time would be able to generate myself.
Best Regards
Rashid
Hi again,
Just thinking out loud here, but I would approach it by watching the history table. When a receipt is posted it moves to the POP30300 (header) and the POP30310 (line history). In the header file, you will find many fields you can watch. You could have SQL 'watch' the table itself and trigger whenever a new Receipt record is posted, or you could watch the POSTEDDT which represents the date it was posted. You'd need to set a filter on it (or not) to exclude voids. It would be easy for your alert to include the Receipt Number. You could get fancy and even include the item numbers (or any other field) that were included with the receipt.
What do you think?
Kind regards,
Leslie
Thank you Leslei for the response :)
Yes I want to be alerted when a receipt (shipment) is posted. It would be better if alert includes the Receipt number as well. E.g. Rashid RCT00001 has been posted.
Regards
Rashid Anwar
Regards
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
