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!

Nm i found it ... I did overlook it like 134897584 times

trmeupey: clearly I'm missing something ... where is this option in the setup (Create G/L Entries box for non-inventory expenses from Receipt/Retur)? I guarantee you I've looked at whatever screen this is on, but I must be overlooking it.

The entries are in there, but the GL accounts for these items aren't there ... typically in our other databases the consumable non-stock items flow through the payables clearing.

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?

lol I see now ...

yea i see that, but altset looks like an auto-increment counter that links to another table ... in my example above the altset value = 61 which is a lookup in another table ... which table? is it the rowid of the same table, doesn't look like it can be.

if i do a select * from icitem for itemno = '01123-50830' i see nothing related to the alternate item no of "0112350830" with no dash ... what is the field name?

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

I'm setting the project name, how do I reference it though?

I have 4 macros (in reality I have like 100 different macros) I'm working with and what I'm trying to do is create a non-hardcoded way that when I create my error log text file it contains the project name, company, user, etc and I really didn't want to hard the project name as I go and update...

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

I'm using 6.3 version 9971 which says VBA Retail 6, 4.9970 ... I'm using the macro editor in Sage 300

Is there a reference that needs to be added for this?