[Jeffrey Runciman]

Good point. I may not worry about it as it will still have the original invoice date as that date.

Jeff

[Jeffrey Runciman]

Thanks guys,

I was looking for something already programmed within quantum. I will try to write an update script.

Jeff

[Jeffrey Runciman]

Thanks Mike,
We will use your advise and start testing.

Jeff

[Jeffrey Runciman]

Sorry, in the subject I meant forwarded not generated
Jeff

[Jeffrey Runciman]

Thanks Pietro,
I found it after posting this. Easiest one I have done for a change.
Jeff

[Jeffrey Runciman]

Hi guys,

Sorry. Found it. I was putting in ISSUED_DATE.

[Jeffrey Runciman]

Hi Tino,

I am not sure if you solved this problem. I tried your idea and it did not work. I looked at the associated package 0045 and there is a sum that looks like it is causing it. Do you have it working for separate vendor invoices? Mine seems to sum it to the amount of the check.

Jeff

[Jeffrey Runciman]

Hi Pietro

The form does not have data in it. It is a modified version of the STD Remittance Report. We currently attach our Work Order invoice but I could not reverse engineer how that was done. My thought is that it comes from the Oracle packages. I am working on a custom SQL statement but haven’t got the hang of it yet. I am getting pretty good at SQL, XML, XLS and am using SQL Developer.

Jeff

[Jeffrey Runciman]

Thanks Mike,

It looks like you added the imgletterhead1 into the memo field as well as some others. I am not quite sure how you did that.

Jeff

[Jeffrey Runciman]

Thanks Guys,

I made a copy of the STD Remittance and did not have the option for picture. It was available on the standard report but we want to make other changes and don’t want to mess with the standard report.

Mike, I would like to do it your way but cannot find qc.requestrow[2]. I am getting the hang of calc tab and have done some sql.

Jeff

[Jeffrey Runciman]

Thanks Nazam

[Jeffrey Runciman]

Sorry, Nadim

[Jeffrey Runciman]

Hi Guys,

I try not too ask many questions but I have only joined tables in the From. Does joining in the Where work just as well? I tested the code and of course it worked.

I am also wondering the alias for OCRunner.

Jeff

[Jeffrey Runciman]

Thanks for the clarity on coc_office and coc_warehouse. It seems to be working now. I forgot to commit the changes.

Thanks for all of the help. You set me on right path.

Jeff

[Jeffrey Runciman]

I am working in SQL Developer and it shows the coc_auto_key as 29 but when I go into Quantum on the Edit Companies screen and press CTRL F10 it shows 1 as the coc_auto_key.

Jeff

[Jeffrey Runciman]

COC_AUTO_KEY is a number as well as COC_OFFICE. If I change the key, will it update the CODE in the edit screen of company management to USA or CAN even though there is no CODE in COMPANIES?

Jeff

[Jeffrey Runciman]

Thanks Nadim,

I knew I forgot something. It works with the “last”. Do you know how to deal with the underscore as criteria?

Jeff

[Jeffrey Runciman]

I looked at warehouse transfers but I need manufacturer code to location transfers. I haven’t looked at the script for warehouse transfer. Any help that way would be appreciated.

Jeff

[Jeffrey Runciman]

Hi Guys,

It looks like this is the standard return by Quantum when doing physical inventory by stock line.

Thanks for looking into it.

Jeff

[Jeffrey Runciman]

It happens when I scan the barcode label. The barcode label has the standard control number and control ID. I am going by stock line. I am sure quantum is supposed to return the part number to the scanner.

Jeff

[Jeffrey Runciman]

Hi Colin,

That is correct. The join script worked that John Boyce helped me with worked well. Now I am trying to write one for the Parts Master to change those locations.

Jeff

[Jeffrey Runciman]

Hi Colin,

I have 2 physical warehouses and 2 virtual warehouses (1 for stock parts and 1 for parts that don’t have boxes). I have been learning a lot over the last 2 weeks with lots of help.

Jeff

[Jeffrey Runciman]

Hi Clinton,

This group has been amazing. I am new to Oracle SQL and am just working on linking Train to SQL Developer. I do know loc_auto_key and mfg_auto_key. I am working on the STOCK table but will also have to do the STM table but I think that will be a bit easier.

Jeff

[Jeffrey Runciman]

Hi Guys,

I am getting closer. I am having trouble with the integer statement and begin statement giving me ora-933 and I am not sure what happening with the below. Is this SQL supposed to be run all at once? Or separate queries.

loc_key integer;

Begin

For i in Csr Loop

— Now get the loc_auto_key for your new location

Select loc2.loc_auto_key

into loc_key

From location loc2

Where loc2.location_code = ‘New Location’;

The update is pretty clear though

Jeff

[Jeffrey Runciman]

Thanks Jake,

Our locations are by mfg_code. These are within the pipeline for stock but 4 different warehouses. I am very new at Oracle’s SQL so I am having lots of syntax and not ending correctly errors.

Thanks for your help and once I get onto it a bit I will post again.

Jeff

[Jeffrey Runciman]

Hi guys,

I am having trouble with Oracle based sql with the syntax. I also am wondering if the scripts you have sent are based on fixing the master as well as the stockline. If someone can test the script that would be appreciated.

Jeff

[Jeffrey Runciman]

Thanks Guys,

I will be doing some testing and let you know the results.

Jeff

[Jeffrey Runciman]

Hi Jake,

There are no GL implications. Just location information and possibly warehouse location (we have 2).

Jeff