Recent content by jonbarr

Thank You Vick400. Yes, it turned out you were right. We needed to record delivery instructions specific for each AddressID, so the notes field was added at our request many years ago, and that fact had been forgotten. The connecting link was in a table called ORM00102.

Hi Jaz Nice to hear from you again, and thanks for your reply. In the "Debtor Maintenance" window, on the DebtorID line, there is a magnifying glass, then a note icon. Notes entered here are stored on SY03900 and can be retrieved when this table is linked to RM00101. No problem. In the "Debtor...

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...

Thanks Therese, I should have been able to find that myself, but somehow it got overlooked ! Your prompt reply was much appreciated.

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

Have you checked Tools/Setup/Sales/Sales Order Processing/Orders to see if the Options "Allow Separate Fulfillment Process" and "Allow Invoicing of Unfulfilled or Partially Fulfilled Orders" checkboxes have been ticked ? Otherwise, can you give some details of your problems ? " Having a lot of...

We upgraded from 7.0 to 8.0 13 months ago. From memory, in 7.0 we had 'Options' as a drop down menu, but in 8.0 we get to Options in the drop down menu called 'Extras'. (so its an extra step) Options shown in our current setup are: Add Item Drop Ship Item Allocate or Fulfill Open Item Detail...

Thanks for your reply Brian. Unfortunately, the existing fields do not include my formula. I need to be able to sort on my formula name, not the name from an existing field, and then suppress the first character to show only the required display name.

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"...

Yes, that works fine, lbass. More than one way to skin a cat, hey ? Thank you for demonstrating the 'replace' function - yet again I've learnt something new from your posts .

Thanks for your reply, synapse. I agree your formula is much simpler, but I had already tried that and get the error message "Too many arguments have been given to this function" with the cursor flashing just before the 'totext'. Maybe it's a version 8.0 thing. Meantime, Paul's less simple...

Great ! That did it. Thanks paul

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")...

why can you not use if (name = DEN) print name If this is not what you are looking for, you need to give more details.

Ramesh I'm not quite sure what you mean. I use Crystal also, and to get transaction history I use tables IV30200 and IV30300. If you are using 'Bins' or 'Lots' or 'Serial Numbers' then you would need to access more tables. The data in these tables is History so it is only available after...