Anyone done this before? I have a few ideas on how to do it, but they all seem over-complicated for what I’m trying to achieve.
2 Likes
Nope. Never done it. Kind of interested to see what people come up with. Is it possible? Does the statement even reference the Ship To? Wouldn’t it by nature only care about the bill-to?
If it naturally already includes ShipTo references, you could add a grouping to the report on ShipTo, then page break between the groups. You’d have to look at the calculations and re-write so they total on the ShipTo instead of the “whole” customer. Probably also need to re-do the header so it refers to the Ship To info instead of the Customer info. Even then, you are stuck with a multi-page statement. Does that get the job done? Or do you need it to be separate reports altogether?
1 Like
NOPE
MAKES SENSE TO ME
FUN WITH SUBREPORTS
DOESN’T THAT SOUND LIKE FUN
You pretty much nailed my initial plan, here. The only change is that I had to bring in InvcDtl to get the ShipTo num, then add the ShipTo, so 2 new RDD Tables. Still haven’t solved the multi-page statement, though. Gotta figure out a good way to break it up. I could pretty easily execute the whole thing in a function and then save each page as a separate file, but if any of the ShipTos have more than one page… that’s an issue. My current thought is to add an additional filter for the ShipToNum, then when the user prints for the customer, I instead call a function and print it several times, filtered with a different ShipTo each time.
I don’t think this is possible. There are invoice types other than shipment invoices that won’t have a ship to at all, so which statement do you put them on? Nothing will ever tie out. I think if they need different statements then those need to be different customer IDs.
2 Likes
The blank ship to is still a ship to…
Having said that, I completely agree though. Review the business case for this request. Can it be carried out another way? This is a major renovation of that report.
1 Like
Regular ship-to’s plus the possibility of One Time Ship-tos?
3 Likes
yeah - no thank you.
Thanks Epicor…
3 Likes
Honestly, this is actually great. If you didn’t have this, any query that needs addresses for orders / shipments with blank ShipToNum and actual ShipToNums would need a calculated field on all the address fields.