Search results for query: *

Using GP vers 8.0 and Crystal Reports. I am trying to display the Notes entered in the "Debtor Address Maintenance" window in a Crystal Report. I have used RM00101 and SY03900 linked on NOTEINDX to show notes for each Debtor, with no problem. However Debtor Address details are all stored in...

GP V8.0 I'm trying to enter an Item Site Description into a Crystal Report, but have not been able to find the table for Site Setup showing the "Description". Can anybody tell me where this table can be found ?? Many Thanks in advance

CR V8.0 I want to be able to suppress the first character in a string. I have used a formula to give me a list of names which are a combination of letters and numbers. I am grouping on this formula. Now I want to sort these names in a specified order. If I use the "Specified Order"...

Using CR 8.0 I have a string field of 14 digits to show phone numbers. I would like to display the result in the following format (780)123-4567 Extn. 9999 I have used the following formula adapted from answers found in previous threads - Picture({RM00102.PHONE1},"(XXX) XXX-XXXX-Extn.-XXXX")...

CR ver 8.0 ODBC database Great Plains ver 8.0 I'm not sure if this is a Crystal problem, or a Great Plains problem. I have created a Crystal Report to show the notes added to an order by using SOP30200 (Orders History) linked to SY03900 (Notes Table) with a left outer join on NOTEINDX. Table...

how can I include the file properties which can be viewed when opening Tools/properties/statistics on an excel spreadsheet

GP ver 8.0 CR ver 8.0 I have created a Crystal Report to show the notes added to an order by using SOP30200 linked to SY03900 with a left outer join. Table SY03900 shows 5 fields NOTEINDX DATE1 TIME1 DEX_ROW_ID TXTFIELD I have inserted TXTFIELD into the report and it is displaying the results...

CR vers 8.00 SQL database I need to calculate the margin on each line item of an invoice. Problem is, I need to include in the Item Cost a share of the cost for the pallet the Item is sitting on. We use over 20 different types of pallet (i.e. 20 different costs ), but only one type per invoice...

Using GP v 8.00 We have some National customers who require invoices to be sent to the branch which ordered and received goods from us, rather than to Head Office. This is not provided for at present, as each customer can have only one "Bill To" address. In the past, we have dealt with this...

Using GP ver 8.0 We are getting some strange costings when processing stocktake variances. We had assumed that costs were based on Current Cost. Checking the Help data on this subject revealed the following comment "Cost information for variance transactions will be based on the cost of the...

GP 8.0 Table IV00102 has a field called ATYALLOC for Quantity Allocated. For some Items I am getting a bigger number here than what shows in Item Allocation Enquiry window. I have tried all of the Module Restrictions and Site variables, but cannot track where the extra orders are coming from...

I want to show transactions that occured in a set time frame last year with a start date of exactly a year ago, and a parameter of a number of days up to 180 after that date. I imagine the formula would look something like Currentdate - one year + (number of days from parameter) Can anyone...

Using CR 8.0 with ODBC database. I am trying to compare data in our live system with data in our "Test Company" which is a stored mirror of the live system that can be used to test new procedures. This means I am looking at the same field of the same table in two different databases. I have...

I have accidentally deleted a shortcut to a macro and want to re-instate it with the same shortcut key as before. Re-installing the macro was no problem, but the previously used shortcut key is no longer shown as being available to select. Is there any way to make the old shortcut key...

We have recently upgraded from version 6 to 8. Our SOP invoices in version 6 showed the field "Due date" and allowed this to be manually changed from the default supplied from Payment Terms. We sometimes need to enter a new value due to shipping delays, or when an invoice from a previous month...

We have GP ver 6.00 and shortly will upgrade to 7.5. We are using Crystal v 8.0 and would like to make these reports easily available to all of our 16 GP users. Has anyone used the Rockton "Crystal Integration" product, and if so what are your thoughts or comments it ? We would also like some...

We have GP ver 6.00 and will shortly be upgrading to 7.5. One problem we have is that in Debtor Cards the "Ship to Address ID" is always greyed out and cannot be changed. As our debtors frequently change their address details, we find this most inconvenient, and wonder if there is any way to...

Using CR v 8.0 and ODBC with SQL server I need to create a report to show a summary of production costs for different processes. Different processes use the same components, so it is necessary to identify which Assemblies relate to which process, and then total the components by type for each...

GP v6.0 Can anyone suggest an easy way to reverse a Production Assembly Entry. We have a complicated Bill of Materials, and if too much production is entered in error , it is a major task to identify the exact quantities of each component item and enter reversing entries for each item as...

Using GP ver 6.0 I'm trying to create a Crystal Report to give me details of the original (ordered) and actual (invoiced) price for Purchased Items. I need data for both Open Orders and those that have been moved to History. The closest report in GP that I have found is the "Purchase Order...