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

    How to create restart records in Macro VBA

    Is there any documentation on this as I can see there is a AccpacDBLink.TransactionBegin and AccpacDBLink.TransactionBegin2?
  2. PhilDOakley

    How to create restart records in Macro VBA

    Exclusive access will not be an issue as this will run over night. I will try the AccpacDBLink.TransactionBegin and see how it goes
  3. PhilDOakley

    Importing large amounts of GL journal data into Sage 300 2014 PU5

    Ettienne Thanks for the comment. By import I mean the standard GL journal import from within the journal screen. Yes there is a PU5 for 2014 as this is what is installed lol My feeling is that the issue might be caused by the optional fields as I have other import without opt fld that have not...
  4. PhilDOakley

    How to create restart records in Macro VBA

    I am pushing a csv file into a GL journal using a VBA macro and want it to use the restart method as it fails sometimes. Is it possible to implement this?
  5. PhilDOakley

    Items quantities difference between location details and inventory movement in inventory control

    The issue with the report is that the transactions could be out of order so a shipment looks like it was made before a recpt. We have seen this report show negative inventory on sites where this is not enabled. We did write our own report for a client but it took a lot of work to get it as best...
  6. PhilDOakley

    Importing large amounts of GL journal data into Sage 300 2014 PU5

    I have found some interesting things while trying to import a very large amount of data (circa 350,00 csv lines as there are 2 lines of optional fields for each entry) into a GL journal batch as one entry from a CSV file. The standard 300 GL journal import process never releases memory and...
  7. PhilDOakley

    You do not have a licence to use this product on multicurrency databases

    I have seen this issue at various clients that are using RDP to access Sage. After a great deal of research i discovered that the issue is caused by windows being slow to copy over registry keys for the user when they log in. I normally see this the most at clients using RDP and running Sage as...

Part and Inventory Search

Back
Top