There’s always SOME answer, but probably a better way of doing things. We’ve had a lot of stuff happen since last time I’ve come to the forum, and since then this report has changed dramatically, although it’s still facing problems, but now they are different.
Are the Pallet Ledger Entry and Item Ledger Entry tables common among NAV builds? If not I’ll try to provide enough detail so you guys can join with my current hair-pulling session of creating this report:
the report is intended to display pallet output sorted by lot number.
My heirarchy is as follows:
The item ledger entry allows me to use the lot number to help sort the pallet ledger entry. GroupTotalFields is set to Lot No.
The pallet ledger entry has the majority of the information I need - lot numbers, pallet numbers, dates, locations, quantities, etc. I’ve set it to grouptotalfields by pallet id, which lets me sum up the possible adjustments that were made to a single pallet (positive adjustments, negative adjustments, and output). the pallet ledger entry links to the item ledger entry by lot no, item no, prod. order no., and document no.
The Item table lets me use some extended naming descriptions for the pallet’s item.
In the section designer, I use the item ledger entry groupheader to display the lot number, then use the pallet ledger entry groupfooter to show all the pallet detail (there’s other sections, but not important right now).
When the report runs, it prints the following:
the lot number
Begins printing the pallets in numerical order, skipping pallets that contain a different item number (this is fine, but I didn’t tell it to sort the items like that)
finishes printing, then repeats the same printing in step 2
prints the skipped pallets
How do I get it to only print once through? The skipped pallets only print once.