You’re offline. This is a read only version of the page.
40
I have automated sending out invoices by using Crystal Reports and a third party software. I have duplicated the custom invoice report in Crystal Reports and everything looks identical to the GP form except I am having trouble with the tracking numbers. It is common for our customers to enter multiple release line items, where one line will ship today and the next line will ship next week, etc. Each time we invoice, the new tracking number plus all the old ones populate in the SOP10107 table. It appears that GP is listing the tracking numbers in alphabetical order so when doing a querry, it is difficult to grab the most recent tracking number. To complicate matters, if there are two tracking numbers for the same invoice it is difficult to know which two tracking numbers are for the most recent invoice. I have seen the scripts that take care of the tracking numbers in Report Writer but with table SOP10107, there are no date fields and nothing else to link to except the SOPNUMBE. The DEX_ROW_INDEX is also not useful since it appears that the multiple tracking numbers are listed in alphabetical order.
Any Suggestions would be appreciated.
Thanks
Ed
*This post is locked for comments
I have the same question (0)
Hi Ed,
I have 2 thoughts for you off the top of my head.
1-If you can get away with changing the Description Name (which works with some clients if their Item Number itself is descriptive enough... Replace the Item Name with the tracking Number (or use the the Line Item Comment) then use VBA to copy it over to the tracking screen (if you need this.)
The above covers providing the customer with the Tracking Number and managing tracking number to line item. It does not cover ability to drill down to a carrier's site (like UPS).
2-Consider the use of Extender. This would allow you to add an additional field for each line of the invoice without comprising the Item Name or the Line Item Comment. You can still use your Crystal invoices and VBA if you want to insert the tracking number into the tracking field.
What works and doesn't work with these ideas? Thoughts?
Belinda, the GP CSI
Share
Report
All responses (
Answers (
