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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.