Search results for query: *

Howzit Thanks Robert. Yes this is only in the development server - wouldn't do this in live - that this is being done on. Seems to work a treat. Thanks very much. Take it Easy Man with one chopstick go hungry

Howzit No - these invoices are part of a larger batch that needs to be deleted. Only some of these invoices have been printed. I can't delete the batch at all due to the isolated invoices that have been printed. This is in our test system where we are implementing a new billing platform...

Hi Is there a way to delete Unposted SOP invoices that have been printed? We are trying to delete some documents, but GP says it can not be deleted as it has been printed. You have to void it. Any help would be appreciated. Take it Easy Man with one chopstick go hungry

Hi All We have had a third party billing platform implemented that incorporates into the GP tables. Users access and maintain the contrat data by logging into GP and opening the relevant third party form. We are trying to implement an audit trail of the contract data, by using a SQL trigger...

Howzit Thanks Victoria. I may very well put the change to the short description in play and see how that is received by the business. I don't know if the business would gp the smartlist way, due to the additional clicks, but I'll put that to them as well. If all else fails, I'll get the...

Howzit Great thanks for that. Our inventory items are Service items, so now I now know why we can not make these discontinued. My problem still exists where I would like to exclude any inactive items from the scrolling windows when creating a SOP invoice (i.e. they no longer show in the drop...

Thanks Martin Do you know hao to "Enable" this field to allow the users to select "Discontinued" for the item. Our form shows this control as disabled, and there does not appear to be anything to turn it back on. The only other way to disable these items is through the back end wich will...

Howzit We have started to make some of our inventory items to inactive (we do not have the full functionality of the inventory module - we just use the cards), but they are still showing up in the SOP Transaction Entry, lookup window. We would like for these inactive inventory items to not...

Howzit We have GP 9.0 on a SQL Server 2000 (shortly to be upgraded to SQL2005. All our users access GP and FRX via two Citrix boxes (load balancing). Our two Citrix boxes and the SQL box are both in Cannock, and the users access it from Glasgosw, London Mauritius and Spain with no...

Howzit - this is certainly valid for GP9.0 Fully applied documents will not appear in the applied documents window in the PL. This is because documents behave differently in the PL to the SL. In SL documents only go to history once they are fully applied and the paid transaction removal routine...

You should also look at the writeoff routines Tools \ Toutines \ Sales, especially where there are a lot of accounts that need clearing down. Take it Easy Man with one chopstick go hungry

Howzit How bout if isnull(me.machcode) or me.machcode = "" then MsgBox "Fill in the Machine #!" me.machcode.setfocus else end if Take it Easy Man with one chopstick go hungry

Hi We use GP9 and integrate all the PM invoices \ credit notes. I have screen shots of our integration setup but can't work out how to upload them - go figure. Our integration file uses the following fields Payable Transactions [ul square] Voucher No. Document Type [ul circle] 1 =...

Howzit On your form check the column widths of your combobox. On the basis that the bound column is the first column, the column widths should be something like 0;3.5. This means the first column will be hidden and only the second column showing. Take it Easy Man with one chopstick go hungry

Hey pwize - sorry you musta posted while I was typing. Cheers a little typo in mine [field1]-nz([field2],0) Take it Easy Man with one chopstick go hungry

Howzit Try [field1]-nz(field2],0) Take it Easy Man with one chopstick go hungry

Hi All We use the Proactis Purchase Order system in conjuction with Great Plains. I have been tasked with exporting a couple more fields out of Proactis, on receipting of the order. I understand that the view view_cus_ExportCommitmentTransaction deals with the export, but as far as I can see...

Spot on Adionne. I didn't mean what we should be using, but What I should be searching for in Enterprise Manager. Thanks for the help!! Take it Easy Man with one chopstick go hungry

If you have the form bound to the underlying table, it will write directly to the table. Create the table first, then use the wizard to create the basic input form. Take it Easy Man with one chopstick go hungry

try in your underlying query. Per your above example, this will give 1 as the result Diff:datediff("d",yourdate1,yourdate2)-1 Take it Easy Man with one chopstick go hungry