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

    Sage 300 2012 reconcile statements error

    From the errors.log file Cross Checking Totals.... Processing Bank 1204 ... Processing Bank 1205 ... Processing Bank CASH ... Processing Bank CONVERT ... Processing Bank TD ... E: Invalid input. The total Cleared Amount for the deposit must be the same as the...
  2. mlnick

    Sage 300 2012 reconcile statements error

    I tried that and it showed the error, but didn't fix it. I made sure to check the fix option in the "Application Options" section too. We are using Product Update 1 and it appears they are up to PU5. I will try updating and then running the integrity again, but I will have to wait until...
  3. mlnick

    Sage 300 2012 reconcile statements error

    I haven't used bank services ever or really ever had a problem in it, so I am quite new to it, but not to Sage 300 in general. When opening Reconcile Statements or pressing "Calculate" an error comes up with "Invalid input. The total Cleared Amount for the deposit must be the same as the sum of...
  4. mlnick

    New to EDI need help

    1. There are defined "standard" values. I personally do not know of a free list, but you can join ASC x12 at http://www.x12.org/x12org/mbrship/benefits.cfm through which you should be able to obtain the standards. 2. This will be part of the standard mapping that you use. I always ask customers...
  5. mlnick

    Sage 300 ERP 2012 License Activation

    Thank you, I figured it out. Sage changed my client ID at some point since I last upgraded. I had entered my old one and didn't realize I had a new one.
  6. mlnick

    Sage 300 ERP 2012 License Activation

    I'm trying to install the licenses for Sage 300 2012, but it keeps giving me an "Invalid Activation Code" error when I input the activation code that I retrieved from the sage customer portal. I've installed all product updates They changed their website since the last time I upgraded Accpac...
  7. mlnick

    .NET windows app with OE1100. The w

    Try dropping the OCX on a new form. See if that works I can literally drop the OCX in a brand new VB.net project and run it right away without any code changes (and it works). No need to revert to vb6
  8. mlnick

    Accpac Finder in VB.NET (on Windows 7, 64 bit) not working

    Use Post Build Events In Visual Studio go to the properties of your project. Click on "Compile" (left side of the screen) There's a "Build Events..." button. Put the following in the "Post-build Event Command Line" section: call $(DevEnvDir)..\tools\vsvars32.bat editbin.exe /NXCOMPAT:NO...
  9. mlnick

    Accpac Finder in VB.NET (on Windows 7, 64 bit) not working

    I've come into issues with DEP and the Accpac Finder with VB.net Open a Visual Studio Command Prompt and enter EDITBIN /NXCOMPAT:NO "<FILEPATH>
  10. mlnick

    Adding functional currencies to GETRATES.AVB

    It should be Dim curTables(5) not Dim curTables(6) or alternatively you could use Dim curTables(1 to 6) When setting an array in VB using the first example, you're setting it with an implied lower bound of 0 so you would use the following: curTables(0) = "CAD" curTables(1) = "USD"...
  11. mlnick

    Accpac 6.1 release

    Well I guess I stand corrected. I was looking forward to it. That sucks
  12. mlnick

    Accpac 6.1 release

    I think the most recent release date is third quarter of 2012 with a product update in the last quarter, this was given in the last couple months, I believe. The web ui isn't going away. They have a demo of it online, so unless they want to scrap all that work, it's not going anywhere.
  13. mlnick

    Excel export - 65536 rows limitations

    The "not knowing xlsx" is at fault of Crystal Reports, not Accpac. Newer versions of Crystal Reports are able to export to xlsx. I think it was added in Crystal Reports 2010 (Not 100% sure though).
  14. mlnick

    Optional Field - Turn off validation

    Also, since you've obviously been using this field before, you will need to change it on the data you've already entered in it. Ex. If you've already entered optional field data for an item, you would have to go to ICITEMO and remove the validate option. If you don't, you won't be able to edit...
  15. mlnick

    Item on hand is negative.

    Have you checked the qtyshnocst and qtyadnocst fields for that item?
  16. mlnick

    Starting an Accpac Session usine vb.NET

    You could just use Dim session = New AccpacCOMAPI.AccpacSession session.Init("", "XY", "XY0001", "56A") session.Open("ADMIN", "ADMIN", "XYZDAT", today, 0, "")
  17. mlnick

    Accpac Integration Error

    It's not for web integration. Interop is a way to use com in .net applications (web or otherwise) I've had this same error on a windows 2008 server we use. Unfortunately I've not had time to fix it. I moved the application to a windows 2008 r2 server and it works perfectly. Try installing...
  18. mlnick

    log onto AccPac with previous days date via VB .NET code

    session.Init("", "", "", "") session.Open("", "", "", Now.AddDays(-1), 0)
  19. mlnick

    ASORGS (AS0020) decrypt password?

    I just tried this with 5.3 and it works.
  20. mlnick

    convert table from number to date

    Alternatively if for some reason you don't want to use pwformatdate, this works StringVar MyDate := ToText({APVEN.DATELASTPA}, 0, ''); NumberVar MyDate_year := 0; NumberVar MyDate_month := 0; NumberVar MyDate_day := 0; if (Length(MyDate)=8) then MyDate_year := ToNumber( MyDate[1 to 4] )...

Part and Inventory Search

Back
Top