About former_member4247

former_member4247 · 02-16-2022

I know there are a ton of questions already answered about UDF and preventing them from being updated by using SP_TransactionNotification. However, none of them address blocking updates on the line item level.(or none that I have found) I added a f...

former_member4247 · 11-29-2021

I am using Visual Studio 2019 Version 16.11.7 with .Net version 4.8.04084 and Crystal reports for Visual Studio version 13 Service pack 29. Whenever I add the CrystalReportViewer (13.0.4 32 bit I think) to my VB application I can run the project in...

former_member4247 · 09-27-2021

I have a UDF setup on the Bill of Material HEADER, NOT the line item, and I would like to have it copied over to the Production Order HEADER ,NOT the line item, when the BoM Item is added to the Production order header. Is this possible? I know at ...

former_member4247 · 06-30-2021

I wrote a quet (see below) to find all batches that have been allocated to a Production order. PROBLEM: The query takes a LONG time to run, from 8-10 minutes. I am sure it has something to do with the tables I am using. Any ideas how to speed it u...

former_member4247 · 06-21-2021

I am trying to prevent batches that are locked from being transferred to a different warehouse or location. I lock the batch (OBTN.STATUS) and I added the following code to: SBO_SP_TransactionNotification declare @Batch nvarchar(50); IF (@object_...

former_member4247 · 02-17-2022

Johan, We want to capture the amount the customer ordered versus the amount we produced and shipped. U_U_XX_POQty captures the amount the customer ordered and RDR1.Quantity is the amount we produced and shipped. Currently we update RDR1.Quantity with...

former_member4247 · 02-08-2022

Quadratec Stealth LED headlights and matching fog lights. The headlights were $330 and $160 (USD) for the fog lights. Very easy to install, though I did have to take the front grill cover off.My next upgrade is LED tail lights, been waiting 6 months...

former_member4247 · 02-08-2022

I looked at those before I bought the Quadratec Stealth LED headlights and matching fog lights. The Quadratec were $330 for the headlights and $160 (USD) for the fog lights.

former_member4247 · 01-25-2022

If Rpt1 and Rpt2 use different headers or if either report uses page numbers in the footer or worse, for grouping or suppressing, this will NOT work. Crystal reports seems to treat the subreport as an object, not a report. With the report I am worki...

former_member4247 · 01-25-2022

My Daily Driver is a 2018 Jeep Wrangler 'Golden Eagle' edition. I have a 2.5" lift (with longer shocks) and 33" tires. This lifts the Jeep about 3.5" higher. It does not sound like much but it is when you get in and out of it! I have also upgraded th...

User Statistics

User Activity

SAP B1 Prevent update of a UDF in Order Detail RDR1 line item detail

Crystal Reports build failed in Visual Studio 2019 Setup project

How to copy a UDF from BoM HEADER to Production Order HEADER

Allocated Batch Query

How to block Inventory transfer when batch is locked

Re: SAP B1 Prevent update of a UDF in Order Detail RDR1 line item detail

Re: Cars, Cars, Cars.........

Re: Cars, Cars, Cars.........

Re: Is it possible to combine or Chain two different crystal reports, into one?

Re: Cars, Cars, Cars.........