I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name.
Now I want to add some fields to it that are not in the set of data tables already in the report.
In the "Field Explorer" I right…
We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
I have modified the original invoice footer with 2 format options by parameter field on Bill Type for user to select the format when printing. Example Footer A for Standing Billing Footer B for Tenant Billing Below is the formula from the existing sage…
I'm trying to run the HRMS and Sage Link Automatically by setting it up in the Schedule Profile Configuration and Schedule User Login Configuration under Sage Payroll Link- Sage HRMS Setup. I'm following the steps provided to me in the user guide (attached…
I have created a C# web service suing the Sage 300 objects, and all is working well except when I try to add another line to an existing order I get:
"Order Detail. Attempt to modify a different record than was retrieved."
This occurs on the code…
I need to make a minor change to the L-PB Detail with Stored contract invoice format. The CNAME in TS Billing Field Names is giving our group name instead of the Company name. We have 5 companies and I need it to give the correct Company name based on…
Hi,
I know that the Sage 50 US edition 2019 works currently with SAP Crystal reports, but I just want to confirm if SAP Crystal Reports can also work with Sage 50 CA 2019?
I saw in SAP Crystal reports knowledgebase that they can work with data source…
I'm sending adjustments to Sage 300 ERP Server for 'posted' invoices and I know that the transaction are successful because the webapi call returns a reponse code is 201 and the response message contains the information I sent but when I open the adjustment…
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…
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…
We use Sage and write software that integrates our book information system with Sage for inventory and finance functionality. The information in Sage about Mat Req Pc is clear, but I can't seem to find information about MaterReqPer and how it relates…
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,
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…
On the customization of the SO form, can we access the db connection that Sage is on for updating the temp tables, which otherwise are not accessible from another connection.
Hi,
A little background... We were asked by a client to create a.Net application to do a few things. The more effort we put in the less success we seem to be having.
We are trying to create POs, Time records, and add Cost Codes to the DB.
Reading…
I there, I'm new in Sage X3 V8
My Company has large Item descriptions with more than 30 chars lenght so we need to use both description fields, description 1 and description 2, but this 30 chars limit start to make a lot of troubles for the user becaus…
Trying to integrate Sage 500 A/P with a third party application that drips a batch file into FTP. Sage 500 processing is already automated to process the batch, but it needs something to allow it to automatically retrieve the file from the FTP server…
i am trying to integrate sage 500 with my application , but i am unable to find from where i can download sage 500 sdk ....can any one help me out ?
thank you
We'd like to take a sales order form that SAGE 100 emails to customers and instead run it through the Docusign API. This would allow our customers to e-sign for custom orders instead of printing out, signing, and scanning forms. Has anyone done this?
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…
I created a new button through Administration > Advanced Customization > Button Group for Company Summary screen with the System Act of "newemail". It was working until I installed the Sage CRM Integration for Sage 300 ERP 2014. Once it was installed…
Greetings,
I created a custom label report in Crystal using the Mailing Label and Report Wizard and it works well in Crystal. I saved it and am trying to open it from within Sage 300 2014 PU3 and I am getting the Error:LoadLibrary message.
Has anyone…