Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MBresnan
  • Content: Threads
  • Order by date
  1. MBresnan

    INSERT INTO VBA statement not working for Memo or Hyperlink fields

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

    Server issue, or application?

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

    Process Server issues with Binary Reports

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

    User unable to integrate credit memos but can enter them manually

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

    Applying receivables credit memos during integration

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

    Missing FATRX batch?

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

    Integration manager, creating both sides of an entry from one line of data

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

    exclusion in access queries? (caret symbol usage?)

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

    Exporting transaction level detail in FRx

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

    Linking POP30310 (Receipt Line History) and the GL Account number (POP30390?)

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

    Script error in GP 10 on the homepage

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

    with a parameter in a sproc, how do i get null to mean all values?

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

    Comparing 2 tables, returning only what is different?

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

    Making changes to existing Fixed Asset records

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

    Formula applied to grouping?

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

    Turning a SQL Query into A Stored Procedure for Crystal Reports 2011

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

    Similar to table usage screen, but the other way around?

    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?
  18. MBresnan

    Last User/User who Posted

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

    Inventory Item Integration Assigned Site?

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

    Reconciling Inventory balance to GL

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

Part and Inventory Search

Back
Top