1,445
We receive all our inventory into a lot. We use this lot to specify items bought for a specific sale. Each lot has a unique # or is listed as stock. We need a report so we can tell what has not been billed out. Is there a report to list every item with each lot #? Currently we have to use Crystal but the report is flawed and does not pull everything - we have found we are missing quite a few items. Is there something in GP that we can use?
Thanks,
Michelle
*This post is locked for comments
I cleaned the report using report writer and got a great suggestion. I changed the destination to file, tab delimited and then ran it. I then opened it up in Excel and it made the columns perfect. Just thought I would share. It has saved a ton of heartache.
:) Michelle
Woohoo - another happy user!! :)
Michelle,
Are you sure it's not saving your changes? Have you granted yourself access to the modified report under Alternate/Modified Forms & Reports in Security?
No, there is no way to export a Report Writer report into Excel neatly and unfortunately, the report is not available as a SmartList.
What you might do is take a look at the report design in Report Writer and note the tables/fields the report is using to verify your Crystal report design.
There's a report called 'Lot Number List' in Inventory reports that lists every lot in inventory along with the quantity available. This isn't exactly what 'hasn't been billed out' but it may be helpful to you.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (