Search results for query: *

I'm trying to run some VBA code to update some Access tables from a form, everything seems to be working except for the Memo, and Hyperlink fields i'm trying to update. the code just skips those fields, and then the user has to go back in and update via another form pointed towards the table i...

We are currently experiencing some major issues with all applications related to GP. GP itself takes about 10 minutes to fully start up (stuck while it's loading the home page with the various menus), and once it does, runs very slow. However, some people are able to get into the system just...

Has anyone used Binary's multi-entity plugin, and created a process server that ran reports successfully? we're getting an issue where if we run the default unmodified GP reports, everything runs fine through the process server. If we try to run the (default or modified)Multi Entity versions, we...

we have blocked our receivables clerks from being able to apply credit memos/cash receipts (don't ask why, not my call). For some reason in removing that the receivables clerk is still able to enter a CM manually through the window, but she gets a "you are not authorized" error when she tries to...

every quarter we end up writing off quite a few (this quarter was 700)receivables invoices through credit memos. i upload them through an integration, but someone else has to go in and apply them all manually. i don't see an option to apply anything in the receivables transaction destination...

One of my users ran depreciation, and ran the GL Posting process for Fixed assets. The assets are depreciated, and when i run the reconcile to GL report (and the financial detail inquiry) i'm seeing an FATRX batch associated with the depreciation transaction. However, it didn't post to the...

I have a corporate credit card feed that i need to integrate into GP. Each transaction is one row of data, but i need to enter both the credit and the debit side (there is no catchall offset account unfortunately). is it possible to enter both a debit and a credit for each line of an...

Is there a way to use a caret symbol (or something) to exclude data in a query in MS Access? I need to return a range of 5 digit numerical results, but NOT where the 3rd digit is a 5. So for example, if i had: [33300, 33500, 35000, 34500, 36000, 36500, 37000, 37500] in my dataset, and i want to...

I have a user trying to use TCodes in an FRX report that is using a tree, and includes budget data as well as Actuals. If you drill down in the report itself, you can get to the Tcode information, however, if you export the report to excel (checking the transaction detail selection) the...

I'm trying to tie together receiving data from the Receipt Line History table, and the GL account where the expense posts from Purchasing Distribution History table. essentially giving PO number, PO line/item desc, amount ordered, amount received, cost, and the GL account where what has been...

A lot of people in my group (but not all users) get the attached error on the GP homepage. Typically we've deleted the files in our temp folder and the frequency that we see it goes down. we've also tried disabling Dynamics Online Services (which we don't use), but that doesn't fix the issue...

I'm trying to put together a sproc to feed a crystal report, but i can't get the report to return any records. I'm assuming because it's reading a null value in the parameter as just that. Here's my Sproc: create PROC dbo.ACCR_RECEIPTS @vendorname varchar(50), @PONumber varchar(50) AS Select...

I have to upload changes to our employees to our AP system (every employee is a vendor, for expense reimbursement). Currently we get 1 file with the entire population from our payroll system, whether or not something has changed on a particular record. So if we hire a new person, going from 500...

We recently had some assets entered with the wrong place in service date, and the incorrect class id. but neither the GL posting, nor depreciation had been run before we caught it. we first changed the class ID, and the account group id to the new values on the general tab. But when we ran the...

This seems like it would be a simple process, but i'm hitting a wall. I have a dataset that has header level info, as well as detail, on each line. So for example: PO number, receipt number, amt ordered, amt received, price. Everything for a given PO number would be static, except Receipt number...

I wrote a query in SQL that i'd like to turn into a crystal report for Workplace (it also reads data from some GP Tables). However, going off the Stored Procedures that are out there for current reports, they seem incredibly complex for what i'm trying to do. I've never written a stored...

I'm trying to find in which table the information from the Cash Receipts Zoom screen is stored. I am able to find what screens a particular table is used by, but not the other way around. Is there a resource anywhere in GP (or outside) that does this?

We're currently getting some questions from auditors about users being able to post their own journal entries. Our policy is that a trx is created, and saved to a batch. The supervisor approves the batch and then posts it. The supervisors name is typically the "last user" and "user who posted"...

I can't seem to assign a site when i am running an integration to load our item listing. On the QTYS/SITES folder of the destination mapping, i have Site Display Options-Site ID, and Site Location Codes-CA. However, nothing seems to stick on the Item Quantities Maintenance window. Is there a...

I'm having some serious trouble getting inventory to tie to GL. the majority of the problem is that i can't find a report that will tell me the inventory transactions that posted to a given period. The closest thing i can find is the Distribution History report, which only gives posted dates, as...