[Sandy Runyon]

Speaking with CC, I see how to allow users to see one or both of the companies. How do you handle if you have more than 2 companies? Say Company 1, Company 2 and Company 3. I want user A to only have access to Company 1 and company 3. There does not seem to be an option for that. Maybe it is the version we are on.

[Sandy Runyon]

Mike,

Thank you for the information. I did the Script, Schedule Table/View Snapshot.

Greensboro_Item_Interface_’||qc_utl_pkg.to_char_sysdate(‘yyyymmdd’)||’.csv, worked perfectly. The event ran and exported to a file location with todays date at the end.

Thank you again for always checking in on the forum!!

Sandy

• This reply was modified 4 days, 14 hours ago by  sandy.

[Sandy Runyon]

Mike,

I think I got it. Greensboro_Cust_Interface_’||qc_utl_pkg.to_char_sysdate(‘yyyymmdd’)||’.csv

[Sandy Runyon]

Looking at event manager, I will have to do a script Type of event. I will create a View and have the data exported to a file. Once that is done, the file will be sent as an FTP.

[Sandy Runyon]

I did the event as SQL in Event Manager Template. I can create a View if that is easier, but I am not sure how to add the expected File name with the date at the end.

[Sandy Runyon]

Thank you Mike. Appreciate it.

[Sandy Runyon]

@John,

How did you handle the GL codes (chart of accounts) when the Company is added to the same Schema? Seems you cannot have the same GL number with a different Company to keep the same numbers separated by the Company. Added an A or extra number?

I am testing in Training right now while I wait for the invoice to be paid.

[Sandy Runyon]

Invoice date is not accurate. The value being returned is the date for the last invoice and not the specific invoices for each line. This is the issue I have also so I was trying the different dates within the table. No duplicates now but not sure how to bring in the invoice date.

SELECT

aa.VENDOR_INVOICE,

rd2.ENTRY_DATE Received,

aa.VEND_INVC_DATE ,

aa.VEND_INVC_TOTAL ,

rd2.PN ,

c.COMPANY_NAME ,

ph.PO_NUMBER

FROM

AP_ACCOUNT aa

LEFT JOIN AP_DETAIL ad ON aa.APA_AUTO_KEY = ad.APA_AUTO_KEY

LEFT JOIN RR_DETAIL rd ON ad.RRH_AUTO_KEY = rd.RRH_AUTO_KEY

LEFT JOIN PO_DETAIL pd ON rd.pod_auto_key = pd.POD_AUTO_KEY

LEFT JOIN RC_DETAIL rd2 ON pd.POD_AUTO_KEY = rd2.POD_AUTO_KEY

LEFT JOIN PO_HEADER ph ON pd.POh_AUTO_KEY = ph.POh_AUTO_KEY

LEFT JOIN COMPANIES c ON aa.CMP_AUTO_KEY = c.CMP_AUTO_KEY

WHERE aa.APA_AUTO_KEY = 193888 and

TO_CHAR(aa.ENTRY_DATE, ‘yyyy’) = ‘2026’

AND TO_CHAR(rd2.ENTRY_DATE, ‘yyyy’) = ‘2026’

AND pd.QTY_REC != 0

ORDER BY 1 desc

• This reply was modified 2 months, 1 week ago by  sandy.

[Sandy Runyon]

Sure…

SELECT

DISTINCT aa.VENDOR_INVOICE,

rd2.ENTRY_DATE Received,

aa.ENTRY_DATE Invoice_Date,

aa.LAST_PAYMENT_DATE ,

aa.VEND_INVC_DATE ,

aa.VEND_INVC_TOTAL ,

rd2.PN ,

c.COMPANY_NAME ,

ph.PO_NUMBER

FROM

AP_ACCOUNT aa

LEFT JOIN AP_DETAIL ad ON aa.APA_AUTO_KEY = ad.APA_AUTO_KEY

LEFT JOIN PR_HEADER ph2 ON aa.APA_AUTO_KEY = ph2.APA_AUTO_KEY

LEFT JOIN RR_DETAIL rd ON ad.RRH_AUTO_KEY = rd.RRH_AUTO_KEY

LEFT JOIN PO_DETAIL pd ON rd.pod_auto_key = pd.POD_AUTO_KEY

LEFT JOIN RC_DETAIL rd2 ON pd.POD_AUTO_KEY = rd2.POD_AUTO_KEY

LEFT JOIN PO_HEADER ph ON pd.POh_AUTO_KEY = ph.POh_AUTO_KEY

LEFT JOIN COMPANIES c ON aa.CMP_AUTO_KEY = c.CMP_AUTO_KEY

WHERE aa.APA_AUTO_KEY = 193888 and

TO_CHAR(aa.ENTRY_DATE, ‘yyyy’) = ‘2026’

AND TO_CHAR(rd2.ENTRY_DATE, ‘yyyy’) = ‘2026’

AND pd.QTY_REC != 0

ORDER BY 1 desc

The issue is that the rd2.entry_date and aa.entry date are not accurate once I pull in the rc_detail. I am specifically testing one PO that was received three separate days and were also paid three separate days. Thought this was going to be simpler than this. I have another query pulling from RC_Detail first, but when I pull in RR_Detail, the lines duplicate. Instead of three lines I get nine.

[Sandy Runyon]

We are looking at something like this. We use Paylocity for clocking in/out and the techs still log on to Tasks using Generic BC. We are looking into getting Paylocitie’s API to see if we can upload the Shift Start and Shift End data into Quantum. Not sure if this is going to work but we want to us this for reports.

[Sandy Runyon]

Thank you Mike.

I found documentation I did from back in the day. We have a reg file that I ran that fixed the issue. The file name is NoToolbars.reg. It reset his toolbars for PO and Part Master.

Thanks again!!

[Sandy Runyon]

Thank you Mike. I have looked everywhere. I am unable to locate it.

[Sandy Runyon]

Hey mike! Yes, that is what I need to do but I do not know the code to pull left or right of a field in Forms Designer. SQL and Crystal, I got it. Not in Forms Designer.

[Sandy Runyon]

Thank you, Alex. I appreciate it. Not sure why I didn’t think of that.

[Sandy Runyon]

Can anyone respond to this? We are having the same issue and are about to create Tasks and a BOM for the subs on the main WO instead of creating subs. We need our labor to be accurate.

Thank you in advance.

• This reply was modified 9 months, 1 week ago by  sandy.

[Sandy Runyon]

Thank you. That is what we were planning but didn’t know if we had to do it this way. Thank you!!!

[Sandy Runyon]

Mike,

When I run the query I get the last invoice date for all three records. If I run the data only from one table it shows the three separate dates. I even tried a sub select and still not showing accurate. Do you think there is any other way to pull invoice with receiving?

[Sandy Runyon]

Yes, I was hoping there was a way to do it without doing it by condition code. Looks like we may not be able to use this feature.

Thank you Mike!!

[Sandy Runyon]

Is there any way I could get the script?