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!

  • Congratulations dencom 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: wysiwygGER01
  • Content: Threads
  • Order by date
  1. wysiwygGER01

    AP payment does not show in GL

    Hi, I've done a Misc AP payment in Accpac 5.5. I can see the check number in my bank but it did not create a GL batch. No error batch created either. Where could my payment be?
  2. wysiwygGER01

    macro to import exchange rates

    Hi, We're using Accpac 5.5 and I'm looking for someone to write me a macro which imports exchange rates into Accpac. The macro would get its rates from XE.com for approx 10 currencies and will run daily. Anyone here can help me with this? Please provide contact details.
  3. wysiwygGER01

    record selection vs. SQL Query

    Hi, I'm using CR 10. My report takes very long to run so I set up the below selection statements to speed up the time it takes to produce my report. (if {?AllCountries}<>"1" then {@Country} ={?SpecificCountry} else {@Country} <>"") AND year(pwformatdate({GLPOST.JRNLDATE})) = ToNumber({?Year})...
  4. wysiwygGER01

    Financial Reporter Date

    Hi, In Accpac 5.5, is it possible to choose a specific date in FR instead of reporting for a whole period?
  5. wysiwygGER01

    trial balance report

    Hello, I'm trying to write my first datapipe report by modifying the datapipe report GLTRLR1.RPT. It links to GLTRLA.dll. I modified the report file and copied the datapipe file from the original report into the directory of my report file. I deleted all reference to other DLLs from that file...
  6. wysiwygGER01

    Creating PO from OE

    Hi, I'm using the Create PO from OE tool in Accpac 5.6. It seems like I cannot create a second PO of the same Order. Which field in what table defines whether I can create a PO or not?
  7. wysiwygGER01

    macro for inserting item no in PO does not insert vendor item no

    Hello, I'm using Accpac 5.5. I've got the below code for entering a PO. When I enter a PO manually Accpac automatically fills in vendor details such as vendor item number if the item has been set up for the vendor. With my code this does not work. I would have thought by using the COMAPI it's...
  8. wysiwygGER01

    Best Practice PO entry for multi entity

    Hi, We are using Accpac 5.5 and have several countries set up as entities within 1 database. We would now want to add a purchasing entity which sells items to the countries at a mark-up price. The way it should work is that the country raises a PO which includes the mark-up price. This PO is...
  9. wysiwygGER01

    Business Intelligence for Accpac

    Hi, What are you guys using in business intelligence software? What products work with Accpac 5.5? I'm looking for an easy way of report generating and seting up dashboards.
  10. wysiwygGER01

    add fuel tax to PO

    Hi, I'm using Accpac 5.5. In some countries, i.e. Chile we are charged with an additional fuel tax when purchasing fuel. This tax however is no fixed percentage. What would be the best way of enabling users to enter a verying tax amount to a PO? I'm thinking of creating an tax class with 0%...
  11. wysiwygGER01

    post to closing period

    Hi, I'm using Accpac 5.5. Is it possible to post to a closing period or does this cause any issues?
  12. wysiwygGER01

    IC receipt more items than outstanding

    Hi, I'm using Accpac 5.5 and just noticed that I can receipt more items than what is outstanding on a PO. I'm just wondering why that is as you would only want to receipt items that are on a PO and everything over the qty on the PO should be cancelled, no? Is there a way to disable being able...
  13. wysiwygGER01

    apply AP credit note mistake

    Hello, In Accpac 5.5 I was trying to apply an AP credit note to an invoice but instead of selecting apply document in AP payments transaction type, I've selected the payment option and applied the payment to both, the invoice and the credit note. So my payment is zero in the end. Do I have to...
  14. wysiwygGER01

    PO receipt error

    Hello, We're using Accpac 5.5 and when I do a PO receipt I get the following error message: "You cannot run day end processing until other users have completed day end processing or created G/L Batches" is somebody else running day end while I do a receipt or why is it showing me that error...
  15. wysiwygGER01

    reverse PO receipt

    Hi, We're using Accpac 5.5. Is there a way to reverse a PO receipt or do I have to do an adjustment for those? Some receipts have been receipted in the system but not physically, others with the wrong quantity.
  16. wysiwygGER01

    Reports won't print - Navigation to the webpage was cancelled

    I'm running Accpac 5.4 in a Windows XP SP3 VMWare test machine on SQL Express. Everything appears to be working correct. However, when I try to print any report I just get "Navigation to the webpage was cancelled". It does not seem to be that help bug, as I can see Accpac help screens just...
  17. wysiwygGER01

    I/C item descriptions in 2nd language

    Hello, we are using Accpac 5.5. I'm looking for a way of having I/C item descriptions in a 2nd language. So for some customers I show item descriptions on purchase orders in English, for others in Spanish. How could I do that?
  18. wysiwygGER01

    GL consolidation - unit balancing account

    Hello, I'm trying to find out what the Unit Balancing Account is used for in Accpac GL Consolidation 5.5. The help says it is used where exported data is not balanced. In GL Consolidations I'm exporting balance sheet accounts only. Does that mean the balance of accounts that haven't been...
  19. wysiwygGER01

    I/C stock items

    Hello, I'm using Accpac 5.5. In I/C a miscellaneous item "Freight" has been set up which gets added as the freight component of any PO. When this item was set up it was ticked as a stock item which is obviously wrong. I'd now like to uncheck the stock item option again. I've adjusted the qty on...
  20. wysiwygGER01

    Offset invoice with payment

    Hello, I'm using Accpac 5.5 and was wondering whether there is a way of offsetting A/R invoices against A/P payments? Basically one entity of a company invoices another entity and the other way around. But instead going through the whole process of invoicing and payment in both entities, I'd...

Part and Inventory Search

Back
Top