Sage 300

How do you copy an Order in Order Entry and have the Optional Fields also copy? It appears to me that you may add them, but that must be manually done. Is there a way to automatically have them come across?

Can anyone recommend a Sage Specialist for writing reports in the Financial Reporter in Canada? I need help and it can't be someone who is just learning to write these things, its a little complex.

Hello all, Is there any possible way to automate the Sage 300 item number change process? I know there's a way to automate the database dump (using OrchidSystems Process Scheduler) prior to running it, but having the ability to schedule the item number…

How can we restrict or reserve one LANPAK from one IP address. We have a web store where we selling items . a customer purchases item on web store and it goes and creates an order and an invoice in sage.. The service is configured to use a sage LANPAK…

A client wants to add the invoice number to the emails subject line not only the $COMPANY_NAME. Is there a way to incorporate the invoice number either on the subject line or the pdf name without doing it manually? Thank you,

We are migrating Sage to a new server. When I move over the custom crystal forms, some of them are prompting for a sa password before running. I have checked all my database connections. There is one difference between the two database connections - when…

i want to know the status of my 3rd period in 2014 is locked or not i had tried using code below Dim mDBLinkCmpRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkCmpRW = OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READWRITE) Dim mDBLinkSysRW As AccpacCOMAPI…

I am a complete newbie to Crystal Reporting and have watched several tutorials, but they are all for stand alone spreadsheets. I have no clue how to use information within Sage to create a custom Crystal report and how to connect the two of them.

Hi Everyone, Our company has ~20 custom reports setup in Sage 300 as well as a handful of Sage Inteligence reports created by our finance team. Recently, 2 of the custom reports have started prompting for SQL login credentials at the same time Sage…

Hi folks, I work for a foster care/adoption agency and we're trying to modify our child care cost sales invoice templates in Sage. Usually our invoices have the client listed as a county department of jobs and family services, and billed to the foster…

Hi, The requirement is to to be able to run the Crystal Report on a preset day and email it out - without manual intervention. The report is not parameterized. I have hard coded the dates. Is this possible using Windows Task Scheduler or is there…

Hi, I have encounter this error when add the OCX screen into Visual Studio window form, using .Net Framework 3.5. Error: Failed to import the ActiveX Control. Please ensure it is properly registered Any solution to this?

Every time I try to "Get Info" from UI Info for PO Entry (PO1210) it crashes. I've tried several different machines and the same thing every time. I've tried uninstall and reinstalling. No luck. Sage 300 2017 PU5

Hi All, I am doing a "Field Edit Control" and would like to put in a presentation mask. From the programming guide, there is a property ".PutPresentationMask (????"). But where can I find what are the "Mask example", and what does each characters…

Hi, The client is using a custom form (not written by me). In Inventory Control, when printing labels from 'Received' or 'On File' the quantities are never what is specified - except when it is one quantity. The out put for multiple quantities is…

Hello all, I'm trying to create a SQL expression to view the value from an optional field in the APIBDO table. The report being used is a GL Transaction Detail report with the following source container join: ((([GLPOST] INNER JOIN [GLAMF] ON [GLPOST…

Hello all, We have a custom crystal report for Order Entry order confirmations. We have been printing Line Numbers on the report by using the special field "Record Number". However, we can no longer use this because if someone inserts a comment and…

I designed a report based on ICITEM,ICREORD and ICILOC that gives reorder quantities and some calculated columns for a parameterized input of location and item segment (from segment and to segment). These are dynamic parameters. The report DOES NOT…

Hi, There is a rounding error (1981.11 to 1981 for example) when cheques are printed off (July 1 Tax table ). The pre-cheque payroll register too displays this behaviour. And, the amount in words at the top of the cheque shows the right amount…

Hi, I have modified popor04 and am running it successfully on my computer on the clients data. When I run it on the clients server, I get the following: I have no parameters in the form. I always have to enter a 0 and then it prints. Haven't…

HI, I have a .AVB file and I want to see the contents of this particular file. After a lot of research I came to know its a macro file and still I m new to sage so doesn't know how to open this file to view its contents. Any help is really appreciated…

Hi, I'm developing an Order Entry macro, by using "AccpacOE1100UICtrl" object. This macro should be able to add an item and delete the item if the user selects a certain ship-to location. I'm able to add the item, but when deleting the item, the…

Customer is running Sage 300 2014, Update 2. They also use GIMS. We customized a GIMS report for them a while back and it worked fine for all users until the upgrade. Part of the customization is that we added a criteria for Style - and Style is defined…

I am trying to write a Crystal Report on Internal usage. The client wants it a certain format (different from Stock transactions Inquiry) hence the effort. I am not able to get my starting inventory formula accurately. Does anyone have some ideas on…

Dear All, I would like to reprint order confirmation with different completed status in OEORDH & OEORDD. So I edited the selection formula in crystal report (oeconf01) like that. ( ({OEORDH.COMPLETE} = 1 or {OEORDH.COMPLETE} = 2) or // order header is…