Search results for query: *

Hi, Is there a quick and easy way to copy the GL integration for one database to another? We have a fairly customized integration for one company that we need copied to another and don't want to do this manually. Thanks!

Hi, I've clearly missed a setup or feature somewhere but i'm drawing a total blank ... we allow non-inventory items on POs and in most of our other databases they go through our payables clearing, but in the company I'm looking in they don't ... what have I missed?

Hi, We're being audited regarding our software licenses and an external company is suggesting we should be paying for licenses for VBA since Sage is installing VBA which is used for macro development. While we're still working through this I'm wondering if anyone out there is aware of a...

I've seen the other flavours of this error before, but never the optional field. I'm assuming the recommendation is the same to use RVSPY/SQL Profiler to figure out which record is causing the issue in POINAHO and delete that record and post?

Hi, We're in the process of researching how to import existing POs in to an environment that has PT in place and I'm wondering if there's a way to bypass PT. We're migrating an existing company A (no PT) in to an existing company B (PT) and company A has between 100-125 open POs that we're...

Going to do some testing, but I'll also ask here can you .Browse "ITEMNO LIKE ""%TEST%""", True and if so will it function like SQL with the % before, after or both or should this simply be done using CS0120?

Hi, In Sage 2014 there's a field on the Item screen which says "Alternate Item" and I've tried finding what table that information is stored in but can't ... can someone tell me where that's stored? Thanks, Ian

Hi, Fairly simple question that I want confirmation on, if I .Order a view then follow with a Do loop that where the first statement is a .Browse, does the view retain the order even after every .Browse or does the .Order need to be in the Do loop? For example I have scenario A, but want to...

Hi, Not sure if this is the right area, but I'm trying to write some code to open/read from an encrypted text file. So far I have: Option Explicit 'File Stream Objects Private objFSO As Object Private objPasswordFile As Object 'Strings Public strAdminPassword As String Private Const...

Hi All, I can't seem to find a non-Excel/Sage applicable version of this question/answer, so I'm creating a post where I'd like to know how it's possible to programmatically determine the name of the project (located in the project explorer or tools-project properties-project name)? I'm trying...

Hi All, I can't seem to find a non-Excel version of this question/answer, so I'm creating a post where I'd like to know how it's possible to programmatically determine the name of the project (located in the project explorer or tools-project properties-project name)? I'm trying to do some...

Hi, I've been informed on the board from earlier posts that when .Inserting records you're required to .Compose and in many cases .Process to call business logic, however I'm wondering if the same thing holds true for .Update? I can see how you may/should .Process on certain values (account...

Dabbling more and more and wondering what some of you pros think about using some of the Accpac controls instead of standard MS controls. Consdering things like the grid, period picker, etc ... also wondering if there's a combo box control? Are there any advantages/disadvantages to using these...

Going to post a larger question, possibly, after this one ... in lot the macros I'm recording and using for my examples I see either "temp = ViewName.Exists" or "ViewName.Read". What are the purposes of these properties/methods? Is .Exists used for On Error Goto AccpacError testing and not a...

Last question of the week ... In previous posts I've had it described to me that .Compose is similar to joins in that it combines the objects together and I'm trying to understand the implications of .Browse after .Compose: mDBLinkCmpRW.OpenView "GL0001", vGLAMF 'i believe i need this and not...

Hi, I'm starting to get a little deeper in to the API and now I'm trying to use the API to look up the fiscal years, periods and the end dates of the periods to populate combo boxes on a form. I've started off with: Set FiscalCalendar = mDBLinkCmpRW.GetFiscalCalendar Simple enough so far, at...

Possibly the question I'm asking best suited to use CS0120, but using .Browse is there a way to find the max and min values? For example, if I'm browsing CSCRD and I want the max rate date for a specific currency. Just trying to understand if there's functionality I'm not aware of and how...

Hi, Simple question on the difference between the 3 values I see in the help for the RecordCreate method of a view: 0 (view_record_create_noinsert) - does this create a "temp" batch and not actually insert the record until later .insert/.post methods are called? 1 (view_record_create_insert) -...

If I open a view, say ICHIST, and .Browse to a certain record based on DAYENDSEQ, ENTRYSEQ and LINENO, after I've completed with that record how do I remove the filter on that record to return all the results that were originally in ICHIST? .Browse "", True?

Hi, I see there's a datatype AccpacCurrency (declare curFunctional as AccpacCurrency), however I don't see any methods or properties for this datatype. Does it simply act as a 3 character string or is there more to this data type?