[6.1] Invoice DBF files for Crystal...no orderline issue

Yahoo Archive
1
Hey Todd.
Â
Not sure about why the 'order' info isn't there yet.
Â
As far as getting the Order info on your own, we had a similar issue ( Sales reps, Email addresses, etc.) on our Quote form , we use a 'sub-report' w/ODBC to get an Email address ...but it can be messy, you have to make sure all users have the ODBC connection, make sure their 'launch script' references the ODBC connection , etc .
Â
 So you could try that method, just be aware of the possible headaches.

--- On Thu, 3/19/09, Todd Caughey <caugheyt@...> wrote:


From: Todd Caughey <caugheyt@...>
Subject: [Vantage] [6.1] Invoice DBF files for Crystal...no orderline issue
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Date: Thursday, March 19, 2009, 12:04 PM






I have run into an odd issue when printing Invoices (ARFORM.RPT) . When I test single, closed (posted), invoices for a version that rolls up packslip lines under the orderline level they work great. But we generally batch (group) print invoices prior to posting. The DBF files created for this do not include the order number and order line number. We've never noticed this before. But it is playing havoc with my new version which depends on the order line being available at print time. On pack slips this is working fine and we want the invoices to match.

Anyone else ever run into this before in 6.10 (or even 8.x.x)? Is there a reason why invoices, before they are posted, do not have the order info included? Is there any way (grasping at straws here) to get that info included at the pre-posting stage?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[Non-text portions of this message have been removed]



















[Non-text portions of this message have been removed]
2
I have run into an odd issue when printing Invoices (ARFORM.RPT). When I test single, closed (posted), invoices for a version that rolls up packslip lines under the orderline level they work great. But we generally batch (group) print invoices prior to posting. The DBF files created for this do not include the order number and order line number. We've never noticed this before. But it is playing havoc with my new version which depends on the order line being available at print time. On pack slips this is working fine and we want the invoices to match.

Anyone else ever run into this before in 6.10 (or even 8.x.x)? Is there a reason why invoices, before they are posted, do not have the order info included? Is there any way (grasping at straws here) to get that info included at the pre-posting stage?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.




[Non-text portions of this message have been removed]