Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Hello,
I am trying to write a crystal report formula that does the following:
If an amended PO number exists in the UDF_AMENDED_PO field, then return UDF_AMENDED_PO, if not, return CustomerPONo
When I test this, when UDF_PO_NO is NULL, it returns…
I have added a UDF to our Sage 100 SO_SalesOrderHeader table. I added it to the screen and set it up to print on the packing slip (uses the same table). When I try to add it to a report (which again has the same table) its not on the list to select from…
When printing a Purchase Order with multiple pages, it will print the order total (which is in page footer b) for the last 2 pages. It usually only happens when there is 1 line item or part of a line item on the second page.
Right now
under Suppress…
I have several reports in Crystal 2016. Has anyone created interactive dashboards using crystal reports? The Business Insight Dashboard is canned and not really customizable. Sage Intelligence isn't all that friendly. Your still trapped in a little box…
My customer wants to alter the Accounts Receivable Aged Invoice Report to sort on the Salesperson number listed in the AR_CUSTOMER (name sp?) table rather than the salesperson number in the AR_AgedInvoiceRportWrk table which is the same number that is…
Hi everyone,
I see many examples of processing a report in BOI, like this one . But all of them are VB/.NET or C#. Could someone please help me translate the syntax to UDS work with Events like Column_PostValidate? Below is Bret's example of Previewing…
Hi All,
I had an issue with my receipt of goods entry...
Basically the Goods entered as Received in Warehouse 008 but its balances is reflected in warehouse 001 in Inventory valuation report.
What causes this and how do i rectified it?
First, let me say, we are a long time Sage user. Started with Mas90 back in the mid 90's. I'm really tired of the way Sage has handled their accounts. This newest issue is so annoying. Each year end we run vendor labels for files. I just find the custom…
I won't go into great detail but I am not getting the training I need from my employer and joined here to find answers to questions that I should be able to find myself in a normal working environment. I would like to fix the alignment for check printing…
Does anyone use Wells Fargo Bank for Sage 100 check printing. They require a specific font layout size and spacing that we are unable to get. If anyone has a check form for Wells Fargo I would love to get the crystal file. Any other suggestions on fitting…
Is there a specific Sage 100 table to use for a custom Crystal Report, that will show a list of all users currently logged in to the Sage 100 ERP system at any given moment?
Has anyone had any luck connecting these two tables together? I am trying to create a daily sales report that has profit based on the lot number. The problem I am running into is the OrderTierDist clears when the sales order is being invoiced and pushes…
I recently upgrade from MAS200 4.4 to MAS200 2014. the version of Crystal reports for 4.4 will not work when creating custom reports in the NEW MAS200 2014.
I need to install a full version of crystal reports 2011, it usually is on the MAS200 CD or…
Just started with this error in December 2015. Users of both DC Reader and Acrobat Standard XI, Windows 7 ,Mas 4.2. Not sure if MS or Adobe update caused the issue. Any help is appreciated!
I need to be able to review invoice line history for specific customers for a period in time(AR INIVOICEC HISTORY) Detail and Header). From that data I want to exclude specific items sold during specific date ranges(Sale items). Once I have gotten the…
Hi I was wondering if anyone can help me I need to create a report from all the RMA's that was entered for last Month ( for example) however mas 100 only gives you the option of open RMA report or RMA receipt History. what would be the easiest way for…
We have a custom Crystal report that we run every morning that shows sales based on divisions. We can input a custom date / division / etc. I have recently discovered that the report shows sales that have not been invoiced yet. For instance, I can run…
I have created a new company in MAS 100 v4.4 I coppied all of the report files from our standard company to this new company.
However when I look at the Purchase order form it is pulling information from a SYS_CompanyParameters table, which is not a…
I am creating a cross-tab report in crystal reports based on AR_InvoiceHistoryHeader and Detail. I am trying to summarize the number of shipped units per month for a particular year. I have this working fine, except that if there is no data for a given…
I have created a report that pulls from AR_InvoiceHistoryHeader, AR_InvoiceHistoryDetail, and AR_Customer. It has a parameter to pick an item and then it has a cross-tab of the quantity shipped for that item by month by customer. I know that I can put…
Looking for some guidance on this one...we have a custom report in Crystal that we use as a bill of lading. I would like to transfer this report into SAGE 100 into the Sales Order Module -Shipping - Packing List Printing - as one of the options under…
When creating a crystal report, can I have different select criteria for different records within the same report? For example, I am attempting to create a SMOI report and need current Inventory information ie, quantity on hand, average cost, etc but…
