AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
Updating Prepare In...
 
Notifications
Clear all

Questions Updating Prepare Invoice grouping logic in Process Orders

 
Everything Else
Last Post by Tim Rodman 5 years ago
2 Posts
2 Users
0 Reactions
1,585 Views
RSS
KDYoung
Posts: 26
 KDYoung
Topic starter
December 18, 2020 3:04 pm
(@kdyoung)
Eminent Member
Joined: 6 years ago

We have a situation where customers come into the facility multiple times/day or week to get product.  We are just using an Invoice type sales order (no shipments) to record the shipment by entering warehouse/location in the sales order.  Upon prepare Invoice it creates invoice and processes inventory issue, etc.  This works fine one by one.  However, we would like to be able to create consolidated invoices for the day/week using Process Orders screen.  I know that we can choose Prepare Invoice in that screen and it will create one invoice for all the orders for that customer that met the criteria entered on top.  We need it to apply additional grouping.  For example, in one day or week, 12 sales orders/invoices, 5 have PO/Cust Order Number 1234 and 7 PO/Cust Order Number 5678.  If I just ran wide open it would create one invoice with all 12.  I need it to create 2 invoices, one for each PO/Cust Order Number.  Actually, these are all for Projects and I'd need that to be the first group within the selected invoices then PO number - but my dilemma is the same.

Obviously the user can just select the invoices they want grouped together manually, process then select the next group manually, process and so on - but this won't be acceptable as there is a large number of orders/invoices each day during bust season.

Is there some obvious config I'm missing that would solve this or do I need to have that functionality customized?

Any thoughts appreciated.


1 Reply
Tim Rodman
Posts: 3199
 Tim Rodman
Admin
March 15, 2021 3:20 am
(@timrodman)
Famed Member
Joined: 10 years ago

Hi @kdyoung,

 

I can't think of a way to do this off the top of my head, but I recommend posting this in the new official Acumatica Community Forums:
https://community.acumatica.com

 

For the foreseeable future, the Forums here will focus on the Reporting Tools in Acumatica (Dashboards, Generic Inquiries, Report Designer, ARM Financial Report Writer, Velixo, Excel, Power BI, etc.) and also discussions that are too “transparent” to be allowed in the new official Acumatica Community Forums. For more info about how AUGForums.com compares to the new official Acumatica Community Forums, checkout this post:
https://www.augforums.com/augforums-com-vs-the-official-acumatica-community


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,527 Topics
  • 10.9 K Posts
  • 21 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • amassey
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×