We have a record in customer shipment entry with 7 lines in it, but when we print ‘Packing Slip’ it only prints lines 1, 2, 6 and 7!!!
This order is already closed and invoiced. All lines are shipped through job number.
Does anyone have any clue why packing slip wouldn’t print all lines?!! All lines status are shipped/complete.
Are lines 3, 4, and 5 components of a sales kit (probably line 2)?
All lines are the same type, a configured part called MISC. It is a non-stock item. No sales kit.
First thing I always do when troubleshooting report printing issues, is to print (or preview) it using the Epicor supplied Style (which I never change, leaving the RDL and the RDD unchanged). This will let you know if its a problem with the source data, vs the reporting system.
Lines 3-5 have qty’s, and also show on the invoice you mentioned?
So 7 lines, all with P/N MISC, which are configured parts (all 7 are different?), and built on their own jobs?
I tried with default styling for sure, thats what I always do to to be sure it is not from custom reports…
Original reporting also skips lines 3, 4, 5.
While we use the MISC configured part, we never actually configure them per line so basically all lines you can say are the same, what we do is we enter product description as they are different from each other, so on Order Entry level all of them are PartNUm= ‘MISC’ but the descriptions are specific for product.
They all have jobs generated with materials attached to jobs, all jobs are engineered and released. Order has been shipped in September and invoiced after.
When I check shipped lines they all show on Customer Shipment Tracker, they show in Order Tracker shipment tab, and they are all invoiced (One invoice number).
This is very weird!!
Change the output type to XML, and preview it.
Then in the XML, look for the lines. If they are in the XML, then they’re getting hidden in SSRS.
Just did it and they are missing from XML as well. So they are not being generated for some reason!
FWIW - the Customer Shipment Entry form doesn’t typically show the PackLine value. It defaults the the OrderLine. In the following, PackLine only shows because I turned it on.
And notice there is no line 1. Someone must have created the packer and removed line 1 after line 2 was created. But all four lines do show on my print out.
As you can see the grid doesn’t show the job numbers but when you go to line details you can see them.
If you go to the Lines -> List sheet on Customer Shipment, do all the lines have the same Invoice number?
f you open up the Invoice (in Invoice Tracker ) for one of the missing lines and go to one of the missing packer lines, what shows here:
Anything jump out?
Yes. This order only has one invoice.
This order originally has 9 lines, two of which are void lines (1 and 9).
What do you see if you try previewing the Shipping labels?
Shipping Labels previews for all the lines in the packing slip. I do not miss anything in there.
I assume selecting “Both” would give you all the labels, but the Pack Slip would still be missing those lines. Give it a try
Correct! Still missing those lines.
I did a query on OrderDtl for this order and line 4 (The first line that doesn’t show up on print) has a ‘CreateNewJob’ field set to 0 where all others are set to 1. That is the only difference I can see in database level.
Any idea maybe it could trigger something?
Looking at the PackSlip.RDL the rows in the [Details] group have various expressions in their visibility. Like:
=(Ucase(Fields!OrderLine_KitFlag.Value)="C" and Fields!OrderLine_KitPrintCompsPS.Value= False) or (Fields!Calc_DspMatDur.Value=0 and Ltrim(Fields!Calc_DspMatMod.Value)="" and Fields!Calc_DspLabDur.Value=0 and Ltrim(Fields!Calc_DspLabMod.Value)="" and Fields!Calc_DspMiscDur.Value=0 and Ltrim(Fields!Calc_DspMiscMod.Value)="")
=(Ucase(Fields!OrderLine_KitFlag.Value)="C" and Fields!OrderLine_KitPrintCompsPS.Value= False) or Ltrim(Fields!Calc_OrdRelRef.Value)=""
Any of those set in the OrderDtl table? (like OrderDtl.KitFlag)
I generated the temporary SSRS table and checked values in ShipDtl_935f8e61a45c46a6b4fb757c2280ae90:
They are all the same. But at least all lines are generating as we can see in the temp table.
Ok I found something weird!!!
OrderLine_KitParentLine all missing (In print) lines reference to line 3!! WHY? How do I fix this?!!
