AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • Register
Acumatica Forums

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Building Reports of...
 
Notifications
Clear all

Building Reports off the Packages Tab in Shipments  

    Last Post
RSS

danielbyrum
Posts: 7
 danielbyrum
March 20, 2020 10:02 am
(@danielbyrum)
6-20 Posts
Joined: 10 months ago

Greetings,

I'm currently working on building dynamic carton labels that pull data from the packages tab in the Shipments work space. One of the problems I'm having is getting the page to reset on a new carton. The report header is printing on every page(as it should) but the details section skips the first page and collects all data on the remaining pages. I.E., a shipment has 3 cartons. Carton 1 has 15 of X widget, 2 has 22 of Y widget and 3 has 10 of Z widget packed inside. The report is reading as label 1 - just header(SO #, PO #, description, customer); label 2 - header and 15 of X widget, 22 of Y widget; label 3 - header and 10 of Z widget. The report is pulling the correct # of cartons from the shipment and creating the correct # of labels. But the details are not mapping the contents for Box 1, Box 2, Box 3.

Let me know if I can give more detail. I tried to make it concise, but it may sound scattered.

Thanks, cheers and stay safe.

Topic Tags
ShipmentDetails report designer label carton
7 Replies
ncantral
Posts: 12
 ncantral
March 20, 2020 12:42 pm
(@ncantral)
6-20 Posts
Joined: 10 months ago

Sounds like you're close. If the label header info is in the page header section then all you should need is a page break in the detail section.

image

Include some screenshots or samples of your report if it's more complicated than that.

Reply
danielbyrum
Posts: 7
 danielbyrum
March 20, 2020 2:07 pm
(@danielbyrum)
6-20 Posts
Joined: 10 months ago

I tried page breaks, but the pages are defined by how many cartons are on the shipment. With a page break, a shipment of 3 cartons generated 5 labels, one for the 'front page' and broken pages for the remaining cartons.

 

I've attached the rpx file if anyone has some time to look through it.

jb000003.rpx

 

Reply
danielbyrum
Posts: 7
 danielbyrum
March 20, 2020 2:41 pm
(@danielbyrum)
6-20 Posts
Joined: 10 months ago
image
image
image

Here is a live example. The stock items are also tripling, but I think I have a fix for that.

Reply
ncantral
Posts: 12
 ncantral
March 20, 2020 2:58 pm
(@ncantral)
6-20 Posts
Joined: 10 months ago

I would try consolidating your two groupings into just one (SOShipment.ShipmentNbr, SOOrder.SOOrderNbr, SOPackageDetail.LineNbr). The joins also seem odd to me, but I use a third-party packing solution and don't have experience with item-level package detail in Acumatica or data to play with.

Reply
danielbyrum
 danielbyrum
(@danielbyrum)
Joined: 10 months ago

6-20 Posts
Posts: 7
March 20, 2020 3:04 pm
Reply toncantralncantral

@ncantral i like the grouping idea. I'll give that a shot. And as far as the joins, I'm still pretty new at RD, so I'm sure I could redesign those. 

 

Reply
danielbyrum
Posts: 7
 danielbyrum
April 8, 2020 12:16 pm
(@danielbyrum)
6-20 Posts
Joined: 10 months ago

UPDATE: I managed to get the report working right. And have published it! I added an action to the Shipment>Reports tab on the form, BUT it runs the report without parameters, effective returning an empty report. I noticed on the 'Shipment Confirmation' report the action type is 'Graph Action' and the action on my new report is 'Run Report'. Anyone know how I can add the box label report as a graph action? Or of another way to pull the data for the selected shipment when using the report tab?

Box label
label

 Screenshots are for context.

Reply
Tim Rodman
Posts: 2488
 Tim Rodman     ★★ All-Star ★★
May 22, 2020 10:03 pm
(@timrodman)
Over 200 Posts
Joined: 5 years ago

There are two ways to add a report to a screen:

1. Automation Steps (the old way) where you don't control the parameters.

2. A Customization Project (the new way) where you do control the parameters.

Which way did you use?

Reply
  All forum topics
  Previous Topic
Next Topic  
Related Topics
  • Alternate ID Issue
    7 hours ago
  • Support for custom fonts
    1 week ago
  • Lot Numbers beside the Item Code
    3 months ago
  • Report from Inquiry Screen
    3 months ago
  • Customizing AP Checks
    3 months ago
Topic Tags:  ShipmentDetails (3), report designer (34), label (1), carton (1),
  Forum Statistics
11 Forums
1,656 Topics
7,693 Posts
3 Online
1,110 Members

Latest Post: Timecard reports/queries Our newest member: Janetteraab Recent Posts Unread Posts

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×