Search results for query: *

7.6.100a Macola (SQL) Crystal Reports v7.0 I am working on a Vendor Performace report and have run into a problem. I would like to compare when we receive materials on a PO against the request date of the PO. I can do this part fine, however the problem comes in when I want to determine if...

Macola 7.6.100a SQL I am having some funkiness in SFDTLFIL_SQL that I cannot explain and I hope that you all can help. We currently have Production Associates recording activity against Shop Orders on the Shop Floor using the Shop Floor Activity Transaction screen in Shop Floor Control. I...

Hello everyone, I have a Crystal Report in a webproject that I am using that has a subreport in the reportheader. The report is defined as a strongly typed report in the VB.Net IDE. I have no problems drilling down into the subreport when viewing the Crystal Report with Crystal...

This is a newb type question and I really should know the answer to this but I am using CR v7 and I have a formula that uses nested ifs (or how I wish this version supported CASE statements). Based on the criteria of the if statements I would like to execute a block of code for each possibility...

Macola v7.6.100a - SQL We are using Variable Lead Time to calculate shop order start dates in MRP. Until recently we have not had our standard lot sizes sufficiently large enough to meet the integer datatype of the field. I have changed 3 parts to a larger standard lot size which fixes the...

I am having a problem with using Mod(%) math in a SQL query with the IMINVLOC and OEORDLIN tables. I want to do a modulus division of OEORDLIN_SQL.qty_ordered by IMINVLOC_SQL.recom_min_ord to check customer order quantities for valid amounts. I have the following SQL Query but it gives me an...

Hello everyone, I am currently using Macola 7.6.1 and I am trying to develop an ASN type solution for one of our internal customers, and if it works well, possibly many of them. My problem is finding when particular customer orders are invoiced. I can link the customer order data from...