Search results for query: *

Is there a single table holding all vendor transactions like invoices, debit notes, credit note, adjustments and payments. i need a report with opening bal. (till date) debit credit Balance. Appreciate your help.

is there any way to use a calculated field from a sub report in the main report. we have a calculated field in the sub report and it will be further used in the main report to get a final value. Help will be appreciated.

I need to print an AP Transaction report as following :- for example Report from : 01/01/2018 to 31/12/2018 Supplier : ABC Last Year Closing Balance : 2000/- Date Doc. Type Doc. No. Debit Credit Balance...

I have to design a report showing all debit & Credit (Invoices & Payments) of vendors, which table & field will holds the information. is there any table having AP Transaction history (After Posting). Appreciate help....

We are using US payroll 6.0. need help about the time card tables before calculating and posting the monthly payroll and after posting the payroll. Appreciate help. Thank you guys.

We are using optional fileds in IC module, how can we print optional fileds along with other fields from Item master. Thanking you. zab

IN ACCPAC 6.0 the GL routine is hanging just after clicking on GL batch List the whole accpac stops... any help will be appreciated. Thanking you

We tried to print an already completed PO but failed through all means, Is there any way to Print a completed PO.... Rg Zab

Can we add additional cost in PO while making a new PO. We want to add material cost and other misc. cost separately, like one line for material and other for misc. cost. In PO setup we can setup additional cost for each vendor, but it is not showing in PO entry. Help will be appreciated. Zab

I need to print the net balance as of current date (from Transaction list) through financial reporter. which field I should use ..... Thanks

Is there any report in ACCAPC 6.0 to print only the account totals of the Report "Transactions Listing' just the totals not detail. or if we have to create a new report what tables we should use since Transactions Listing report users data pipes not direct tables. Appreciate your help.

Hi, To Print the latest bank balances, which table we can use to get the balance through crystal reports Appreciate your help.

Hi, Can we link fields in optional tables with ACCPAC tables. what is the name of optional tables holding operational fields. Appreciate your help.

I need the list of IC Transtype, please list all Transtypes. Appreciate your help. Thanks....

Hi, We are using SAGE 6.0. Can we create a single price list with multiple items for a single customer. (the customer will have a single price list more than 100 items for sale, while order entry the user can get a popup of the price for an item from the defined price list). Appreciate help. Zab

Hi I need help with SQL Query to get outstanding payment still pending with customers sorted by salesman code. All the fields are in a single table. The result need is as following :- Over due more than 6 months (180 Days) = 99999 Due amount Over due more than 3 months (90 days ) = 99999...

Hi We had a new ACCPAC installation, I copied all the users, authorization and user groups. but it is not taking the users desktop setting like each user has a folder for all his reports which is missing in new installation. Thanks

I installed Crystal reports on windows 2008 Server, it didn't install properly and doesn't open the reports also. Is any patch or product upgrade so that CR XI works with windows 2008 server. Which version works with windows 2008 server.... Thanking you zab

Hi Just installed ACCPAC 6.0 on a new machine, first installed SQL Server 2005 client. ACCPAC installed successfully also can verify the database on server. While running it is throwing error as " Invalid Database Specifications' Any Help Please. ZAB

Is ACCPAC 6.0 compatible with Windows 2008 Server ....? do we need any product upgrade ... Thanks