Recent content by Boris10

Thank you ettiene!

That is correct, we are only supposed to pay vendor 100 and 16 goes to VAT account.

We have a new requirement in our country, whereas our company is not supposed to pay VAT portion of the vendor invoices to our vendors. So i was asked to instead credit a GL account with the VAT portion. Is this possible? So this is our scenario right now: GRV: Dr Inventory 100 Cr...

Thank you Ettienne. It does look like it can solve the problem.

Do not use direct SQL to change Accpac tables. Instead use the Accpac views as they help to populate all the fields in all the required tables. These views help to keep your DB insync. So what i would addvise is to restore your DB to the last working state (try it in a test DB). if you...

My company has a requirement of splitting its trial balance and all its operations into two divisions. So this includes splitting full trial balance into segments. E.g: 10000 ---> Rollup Account 10000-A ---> Division A 10000-B ---> Division B I have successfuly performed this operation and...

Hi Ettienne, hi Tuba. Its a simple report that pulls data from 25 Column Table with about 5000 Rows. The report simply pulls all the data and filters it based on an ID number to display A Single Record. There are no sub-reports, no complex formulas no diagrams or any other objects. I checked...

Also I have just noticed that sometimes the report opens but its completely blank with nothing visible except for the "Cancel" Button

Hi everyone, I am wondering if anyone has experienced this issue before. I am using the following code print a custom Crystal Report. The problem is from time to time, running the report ends up in a Not Responding State: On Error GoTo ACCPACErrorHandler Dim mDBLinkCmpRW As...

I have a question though: How do you know which Accpac views require parameters, passed to them, before you can extract information from them and which don't? And if a view requires parameters which parameters do they require? For example I couldn't print the AS0022 because I didn't pass the...

Amazing! It works! I had wasted 3 hours typing out the Resource Description. Thank you Ettienne!

Hi Ettienne, I tried to get information from the "AS0022" view: Dim mDBLinkCmpRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkCmpRW = OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READWRITE) Dim mDBLinkSysRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkSysRW = OpenDBLink(DBLINK_SYSTEM, DBLINK_FLG_READWRITE)...

For anyone out there still looking for ResourceID description: RECID RESOURCEID MODULE DESC 757 AMACQBTH AM ACQUISITION BATCH MAINTENANCE 758 AMACQBTHP AM ACQUISITION BATCH POSTING 759 AMADJBTH AM ADJUSTMENT BATCH MAINTENANCE 760 AMADJBTHP AM ADJUSTMENT BATCH POSTING 761 AMASSET AM ASSET...

Thank you tuba, much appreciated. I guess I will manually load the description for each ResourceID into a Database so when required will use that as a reference.

Hi Tuba, thank you for your input. I have seen u post this exact reply to this same question. I have tried and this is the result that RVspy produces: [2b00.7ff.3e68] 0 <==[14:25:58.71;t=0;ovh=0] {buffer='\41\52\53\45\54\55\50\20\20\20' -> 'ARSETUP '} [2b00.7ff.3e68] AS0022: ASSRSC...