Skip to main content
Solved

Email automation for Daily Stock Received

  • June 11, 2026
  • 3 replies
  • 51 views
M
Varsity I
Forum|alt.badge.img

Hi, I want to send an automated daily email of daily receipted stocks from Acumatica. I need them to be broken up between companies/branches and by item class if possible. Business event is what I am thinking, but I’d like to get your thoughts on how you would do it. Any recommendations are welcome 😊

Best answer by MarkD

Hi, I’ve configured this by:

  1. Creating a GI for POReceiptLine and populate all required information
  2. Exported it to Report
  3. Modify report designer and published to site
  4. Setup Business events on schedule, email notification subscriber and an automation schedule and I am now receiving the Daily Stock Receipts report on an excel spreadsheet with all the details required

3 replies

mohammadnawaz51
Varsity I
Forum|alt.badge.img+7

​@MarkD Only way is to work on Business events but cracking it is little difficult where you can use Insite table for qty changes.

https://globalpayex.com/erp-integrations/
    craig2
    Pro I
    Forum|alt.badge.img+4
    • craig2
    • Pro I
    • June 11, 2026

    Hey ​@MarkD ,

    I think you’re on the right track, a Business Event on a schedule will do the trick.  Prior to configuring that though, you’ll need to create your Report or GI.  If you are looking for what was received that day, I would look at the POReceiptLine as your starting point.  Set a date filter so it only looks at today, then start adding whatever relevant fields you need.

    You may have to do an Inner Join to InventoryItem to be able to grab Item Class, and if CompanyID doesn’t live in POReceiptLine, I would tie into its header, POReceipt.

    Once everything is set up as you like, it’s easy enough to set up the Business Event on a Schedule, and do an Email Notification as its subscriber.  Within the Email Template you can configure attaching your fancy new report to an email:

     

     Hope that gets you close, good luck!

      M
      Varsity I
      Forum|alt.badge.img
      • MarkD
      • Author
      • Varsity I
      • Answer
      • June 16, 2026

      Hi, I’ve configured this by:

      1. Creating a GI for POReceiptLine and populate all required information
      2. Exported it to Report
      3. Modify report designer and published to site
      4. Setup Business events on schedule, email notification subscriber and an automation schedule and I am now receiving the Daily Stock Receipts report on an excel spreadsheet with all the details required
        Terms & ConditionsAccessibility statement
        About Acumatica ERP system
        Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
        © 2008 — 2024  Acumatica, Inc. All rights reserved