Sage 300

Our fiscal year is Jan to Dec - I have some reports for funding that I need to do that would be April 1/16 to Mar 31/17. I typically have done them manually, but I don't have time for that anymore and am trying to create a report that would pick up the…

Hi support, My client is looking for a program to convert bank statement to OFX format in order to be imported into the OFX statement reconciliation in Bank service. As his office is located in China and most of the China bank does not provided…

Saturday upgraded from 6.2 to 6.3,before upgrading all customised reports were removed and after installation moved to the specified folder. Currently have customised reports in A/R and PO, the PO customised reports while printing appears an errors as…

Is it possible to create bar codes in sage 300 2016?

I'm working on amending reports for our Board of Directors - I can't figure out the formula for one of their asks. I need a column for the current quarters actuals and one for the current quarters budget. It can't be cumulative, ie the 2nd quarter can…

A customer wants to hide the "comment" field in the GL data container permanently. They have clicked it to hide it, and it stays hidden during that session. However, when they go in to a new batch, the comment field re-appears. This happens regardless…

I am trying to have my income statement summarize by account groups. In column "D" I already have D(ACCTGROUP) and it is not summarizing/consolidating by account group. This is the information I have in cells A44 to D45: \\ACCTid Z D(ACCTgroup…

Hi, How could I set up supplier terms based on invoice value in Accpac 6.2? Basically, if the invoice amoutn is less than 5,000 payment terms are 7 days, otherwise they are 30 days.

We want to print the PO number on the AP check stub but I don't see how I can link the APADV table to the correct field in the AP header (APIBH?) table. Would appreciate some insight into this. Thank you.

Is there a way (without modifications) to permanently suppress a given field in the container view of the data entry screens for specific users without doing a modification? Specifics - customer does not want some users to see prices or costs anywhere…

Are there any Time and Billing solutions that integrate with Sage 300? We are looking for solutions that are used for Accountants, Consultants, Engineers, or the service industry. Any recommendations would be appreciated.

How do I drill down in the Financial Statement Balance Sheet? I tried using FRTRN ("BALP") but it did not work thanks frank

When I select 3 invoices to pay for the same vendor, it prints out 3 pages using form APCK01.RPT. Is there a way to have all the invoices selected show on a the same stub as the check being printed? Right now, it uses 3 check forms when it could only…

Hello, I am a new user to Norming Assets module and just start to use in PPE. My company also several CIPs that need reported monthly. My question is "May i use Normming Asset in CIP? such as entry as subledge and reporting? Thanks Frank

Hello, We are looking for the solution indicated in the subject. Any suggestions will be appreciated. Thank you.

Hello friends, Anybody knows whether any third party Swedish Language pack is available for Sage Accpac? I tried Lingua pack but not sure whether they are providing this for Swedish language. Any ideas would be very helpful Regards, Pratik

Hello! When I am doing payroll and I am entering information on the employees timecards I use the arrow key on top to move between employees. I have several inactive employees and I have to go through all of them as well. Is there a way to have them…

I am totally new to the budget feature in Sage 300 ERP. I have watched and read many tutorials. From watching I understand the best thing to do is open a budget set in Sage and export it to Excel and then work in Excel using the model. I can then enter…

I'm working on a template for 2016 budget. The BOD want 3 columns - 1) Actual 2014, 2) Budget 2015, 3) Budget 2016. I can't figure out what the formula would be to pick up the Actuals for 2014. Any suggestions? I tried =FRAMTA("ABALP.2014"), also =FRAMTA…

I am using Sage 300 ERP 2014 Edition. Just beginning to familiarize myself with the budget maintenance section. I see that you can ‘lock’ a budget set but can you lock a ‘fiscal year’? I want to prevent inadvertently making changes to the previous year…

Hi, I am looking for a milestone invoicing capability in PJC module. AR invoices should be created based on the progress of project as below. 1) At the time of contract ----- (10% of total project amount) 2) 2nd billing ------- (20% of…