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 Mike Lewis 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: *

  1. Greggpb88

    Declaring dividends in Accpac/Sage300

    I am looking for advise on how to declare dividends on on Accpac As we know dividend are distributions from the Balance Sheet to the beneficial owner paid in the current year with a possible withholding tax implication. Given that they blur the lines for a BS or IS account. How are people...
  2. Greggpb88

    Accpac Daily AR Totals

    Thanks will keep hammering on, is AROBL the right table to be quering ?
  3. Greggpb88

    Accpac Daily AR Totals

    I was wondering if anyone could help me, I am to get the daily AR Balance for a customer for the past year, I have looked at building query from AROBL but is has turned our quite complex, if there a function or shortcut ? Kind regards Gregg
  4. Greggpb88

    Emailing Invoice's and PrePrinted Letter Heads

    Yikes, 800 dollar's. Holy Ships...
  5. Greggpb88

    Emailing Invoice's and PrePrinted Letter Heads

    Hi guys I am looking for some advice on how your businesses Work with regard to email invoicing? We use printed paper with out logo and the like to print a hard copy of the invoices and statements. We have started updating out system and we want to send a digital(email) as well as a hard copy...
  6. Greggpb88

    Accpac Macro finding period

    Sweet .. thanks guys
  7. Greggpb88

    Accpac Macro finding period

    Hi Guys is the any way to get the Year and Period from the a date in vba beside hardcoding whar the periods are ?
  8. Greggpb88

    How to reverse a AP Receipt(apply to) batch

    Hi guys, We have someone in the Ar module Create an receipt batch and apply a whole bunch of Unapplied Cash to the incorrect invoices on a open item system? Is there an easy way to reverse the batch the run ? They one way I think i can do it is but doing an adjustment batch on debiting the...
  9. Greggpb88

    Error with the FR in accpac

    Hi Guy when i try to run the FR on my computer I get the following error Initializing FR Error (3) : Fail in starting Print Financial Statements PrintReport : Error on running StartGL9100 in macro. Problem is found in running Financial Reporter Addin. Any Idea on how to solve it I know it...
  10. Greggpb88

    Accpac Ar/Ap import and Tax Caculation

    Thanks Very much Ettiene that is what I was looking for .. Does anyone known offhadn if it rounds or truncate fractions of cents ?
  11. Greggpb88

    Accpac Ar/Ap import and Tax Caculation

    Does anyone know how accpac does it as a standard ? maybe a white paper I could read ?
  12. Greggpb88

    Accpac Ar/Ap import and Tax Caculation

    I am wondering how accpac calculates tax ? Our VAT rate is 14% and if you look at the examples below you will see that both are sort of correct ? per line item and per total ? IN0001 PriceEx VAT PriceInc Service 1 55.55 7.78 63.33 Service 2 55.55 7.78 63.33 TOTALS 111.10 15.56 126.66...
  13. Greggpb88

    A/R Open Item

    I am looking for some advice using accpac A/R Statements We are suing open item for out account type and we offer the client a 30 days from statement credit facility Should the monthly statement we printed on the last day of the month or the first day of the next month ? It there any way to...
  14. Greggpb88

    Cash Book AP receipts

    Dont anyone know how I enter a AP Receipt into the Cahsbook ? I.e A vendor has given us a refund..
  15. Greggpb88

    Accpac cmd line importer GL, AR, AP

    oops Forgot the last requirement anyone know how to post ?
  16. Greggpb88

    Accpac cmd line importer GL, AR, AP

    Hi Guys please find attache the code that I eventually got working to load the AR transactions, still need some propper error checking but it works.. Thanks very much to the guys here for the help.. and if you have any question i will do my best to explain what I have learned here.. Dim...
  17. Greggpb88

    Accpac cmd line importer GL, AR, AP

    If you look at the code I have to to the point when I can create batches and import them I have sorted out how to set the batch number properly The only hiccup I have having it loading the filename would i have to modify the script file on a daily basis or is there an option i am missing ?
  18. Greggpb88

    Accpac cmd line importer GL, AR, AP

    Ok guys I went away and had a look and this is what I have come up with and it is not working.. Must I generate a new script file evertime i do an import ? or can i just setup the AccpacImportExport object directly ? 'All the comment on this piece of code are assumptions ' decalre all...
  19. Greggpb88

    Accpac cmd line importer GL, AR, AP

    @BlueJay07 Thanks for the info, unfortunately we are not an Accpac programming Partner, but a freight company. We are basically looking to automate some tasks, we have been through a couple of the a couple of Accpac service Certified providers each worse than the next. I ill google the net for...

Part and Inventory Search

Back
Top