Search results for query: *

Hi I'm trying to work out how to do two things at the same time on the PM Separate Check Remittance Report on GP9: Limit the number of records in the body to 30 If there are more than 30 records to include on the report, for these to go onto additional pages with a total at the end or a...

Manny I'm not sure exactly what you want to do, but.. If you want the GL posting date - this would be TRX date If you want the date that the originating transaction was posted, then that would be Originating Posted Date. Aside from that, the account transactions smartlist doesn't seem to...

Could they start using account aliases? This would speed up entry for commonly used codes. If there are a large number of alises then the aliases could be integrated in to save time.

Try opening enterprise manager and checking the following: Right-click on the tempdb database, select Properties, then Options. Ensure that the Recovery model is set to Simple. See if this resolves the problem. If not, then another possibility is that you have a problem with your report...

MineChrista Try the CUSTBLNC field in RM00103 (Customer Master Summary). Regards

Hi You should be able to void these Purchase Orders (using the void button which should be next to the delete button in the Transactions > Purchsing > Purchase Order entry window). Hope this makes sense.

If you go to Tools > Setup > Posting >Posting and choose Payroll as the series and select 'All' as the Origin, you should get a list showing all of the reports that can be set to automatically generate when posting. If you can locate the (un)desired report on the list, you can untick the...

If you have Manufacturing installed, you would need to go into Dynamics Utilities and choose the 'Convert manufacturing' option. Once you've done this and installed the latest Service Pack for manufacturing, this should (may) resolve the problem. Regards LC

I've come across a similar problem when attempting to print one particular invoices - GP just crashes for that particular document. I would recommend attempting to void and re-enter that transaction.

Jymm This sounds like an issue that has cropped out in the past in GP with Smartlist, so maybe this will work for IM as well. If the account number is the same for a number of lines on a journal, it's important to also ensure that the Sequence Numbers in the GL Distributions table are different...

You would need to modify this in Report Writer. If you want this to appear at the bottom of every page, then you would need to add the test to the Page Header (PH), if it was just at the bottom of each invoice then you would need to add the text to the Report Header (RH). You can add text by...

You could check in Enquiry > Transaction by Debtor to see if you can locate these transactions. Are they 'OPEN' or are they WORK? If they are OPEN do they have any apply information against them? If you want to check the integrity of your data, you could always try running Check Links (of...

I'm no SQL expert by any means, but this seems to do the trick: SELECT * FROM GL20000 INNER JOIN GL00100 ON GL20000.ACTINDX = GL00100.ACTINDX AND GL20000.SOURCDOC = 'BBF' AND GL00100.PSTNGTYP = '0' Although I think that GP business logic is that you wouldn't...

Try SmartList (or Explorer) - Inventory Transactions. Search for document type = (for example) "return" and for the item number that you are interested in and this should list all of the transactions making up the figure. If you have a large number of tranactions listed for the item, it may be...

Hi Did you post these debit notes in a batch? If so, you should go to Transactions > Sales > Receivables Batches and check if the batch is still listed there. You may get the opportunity to select the batch from the list and print an edit list (i.e select the batch and click the print icon)...

OK - this has now been submitted to MBS and has been recognised as a problem which will hopefully be fixed in GP9 SP2.

I've run a dexsql.log on the server and it appears that the error message is coming up after the stored procedure 'sp_rename' is run on table EDCVAT04 (this is a European VAT Daybook feature). sp_rename is attempting to rename a column in this table BUT the column's name has already been...

Hi Everyone One of our customers has done a test upgrade to GP9. If a user 'bombs out' (i.e. doesn't logout of Great Plains properly), and then goes back in and tries to delete their login they get the following messages: GPS Error 58 ODBC Error 37000 SQL error 15248 (SQL Server Driver) The...

Hi all: I'm trying to locate a user manual (preferably in pdf format) for GP 8.0. I need to brush up on my GP knowledge for an upcoming interview. Does anybody know where I could locate this on the web? Thanks _________