Search results for query: *

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

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

Dear all, I am currently looking for a list of RESOURCEID DESCRIPTIONS so that I can print out a user friendly list of Authorisation Groups. After Searching the web, I found an answer from Jay Converse saying that such information is contained within the AS0001 view. I have tried to extract...

Hi, I am trying to install a workstation set up (6.0A) on a windows 7 operating system. I have successfully installed Accpac on the workstation. However, when I run it, I get an error saying: "Cannot connect to Sign on Manager". I have searched the web for solutions. I found that running RegAcc...

Hi Everyone i am trying to write a software that aquires the measurements taken by a scale at a weighbridge. I have written the below code, however, i am not getting any Mscomm1.input information. What am i not doing right? Please find the code below: Private Sub UserForm_Initialize() Call...

Hi everyone, I am trying to figure out how to print macro criteria on AccpacReport. I am talking about a custom Crystal Report being generated by a macro containing selection criteria. For example: from date and to date. Would anyone have any idea how to display the selected criteria on an...

Hi, i am building a crystal report and calling it using Accpac API. However, i would like to make it so that the user can select the printer as he/she prints. Dim rpt As AccpacCOMAPI.AccpacReport Set rpt = ReportSelect(report, " ", " ") Dim rptPrintSetup As...

Hi everyone. I am calling a Custom Crystal Report from Accpac macro using Accpac API. I have recorded a macro to get the fill of the code and checked the web for tips on this proceedure. However, after modifying the OERPT.INI and placing my report in the OE60/ENG folder i am still getting the...

Hi Everyone i trying to create a task scheduler programmatically. I am stack on creating a weekly trigger. I am trying to allow the user to select days from monday to sunday. The problem i am having is that i can only create a trigger with one of the 7 days. How can i assign all 7 days to the...

Hi Everyone, i have been developing ACCPAC 6.0 VB Macros that print out Crystal Reports. I am able to do that successfully, however, i need to install crystal reports on every client machine in order for the VB macro to run from that machine. Is there a way to go around this problem?

Hi Everyone, i have recorded a macro to create a batch, a new entry and add a detail to that enrtry in Asset Management Acquisition. The code that was recorded fails to run. I cant figure out why. I am getting the following errors: 1. You must Enter a least one detail before you can add the...

Hi everyone, i am making an application that performs a back up and allows the user to set different time intervals to do the back up. My Application programmatically creates/updates/deletes tasks in the Windows Task Scheduler based on user input. My plan is to package this application with a...

Hi every one. I am trying to develop a simple independent application using vb, which requires little user intput and runs independently and continuously after the user set the settings. All i want to do is periodically run operations on the database, depending on setting provided by the users...

Hi Everyone, I have recorded a macro that submits a PO for approval in PW. Now i am trying to insert the result of my code into the macro so that a PO is created from another macro. The code works and allows me to enter a PO and it even appears in the PW Purchase Order Entry Screen. However, i...

Hi everyone, just wanted to consult on the issue of directly deleting from ACCPAC SQL Tables by passing SQL queries. Is there absolutely no way of making sure that data integrity is maintained once ACCPAC tables are directly deleted from. Or is there a posibillity that something can go wrong. I...

Hi i know this topic has been discussed numerous times, however, i am failing to implement solutions that i found on the net. Could any one assist me. How can i copy a range of cell (from a single column) from an already opened Excel document and paste them respectively into a flexgrid column?

Hi everyone, I am trying to customize PW Purchase Requisition Entry Form. Would any one have any idea how to add an extra column to the Requisition Detail grid. I came across this code on greytrix but failing to make it work: Private Sub ACCPACIC1550UICtrl1_OnUIAppOpened() On Error GoTo...

Is there a way to add a drill down button to each row of a report, allowing you to extract the id of the row and opening a VB UI. Therefore, opening the record that has the same id as the one drilled upon in the crystal report. Thank you

I was wondering if there is a way to run subtotals in vba on a flexgrid. I have a flexgrid which is populated with inventory issues by department. I am trying to get subtotals per department. I was looking up with rollup in SQL but i am getting too many nulls in the flexgrid together with rubish...