it
Forum Replies Created
-
Perhaps you are correct. Technically it isnt different.
You can submit the request as an enhancement to CC if you like.
http://www.componentcontrol.com/tech_support/notice_page.html
-
We do the exact same thing with our banking accounts to so we can easily seperate the transactions.
What I meant by manual entries was this.
If your inventory accounts (for example) are 1200 series.
When you add inventory or sell inventory, Quantum should automatically make
the appropriate adjustments to the 1200 accounts.
If you have to do a manual journal entry, perhaps because you do not want to reconize a dollar amount right away, or some other reason, I do not recommend making the entry into the 1200 account directly. Leave that account for QC to automatically do what it needs to do. Instead, create a seperate account, perhaps 1201 for manual adjustments.
This then keeps the manual entries seperate from the QC entries and if you have balancing issues, you can more easily research them and find out if your manual entries are causing the imbalance, or if it is QC.
If you never make manual journel entries into the accounts that QC automatically hits, then if there is a problem, it is pretty hard to argue that it is due to human error through manual adjustments.
I hope that makes sense.
-
Tony,
You need to do a subreport.
It is really pretty simple.
Two ways to accomplish this.
Insert a sub report at the detail level and in the sub report use the Parts_Master Table.
First, using a formula field, take the PN that is not stripped
and strip all the characters out of it. Use this formula field now to link to the sub report and link it to the PN_stripped field.
If you are already using the parts_master table, then just use the stripped PN.
But, if you only want one instance of the PN on the primary report, group it by stripped pn and place your detail (and sub report) in the group footer. Then, surpress the detail.
Supress the header and detail bands of the sub report.
Place a running total in the report footer. The running total should be set to do a count of the stripped_pn field.
The result will be a total count of that PN in the parts_master table. You can also do a count and filter it based on the active part flag and master part flag. This will return three totals. One total showing you the count for active parts, one for inactive parts, and one for alternate part records.
The second way is the same as above, exect simply place your running totals in the group footer and reset the counter for each group.
Seagate Complete Reference to Crystal Reports is a great book. I am self taught in Crystal, but I’ve been using it for 14 years. I recommend you research user forums online and join them. I learned a great deal just by doing that.
-
Tony,
This already exists. If you open a part number record and click your XRef button you will see a check box in the top left corner that says Avref. Click that and it will pull down all alternates that match either the PN or the NSN values in the part master record.
Additionally, you can click the Price Lines button and see an even broader match by clicking the avref check box.
Lastly, if you want to import the avref data, that functionality is available through the Data Services module.
I recommend you review the help files to learn the details of the Avref integration.
-
We use the Contact management module to record our Westwind Fleet support calls.
We also use for recording our export compliance issues and our customer account related activities.
It is a good module, but you need to plan out how you are going to use. The module is not the problem for things like this. The problem is the users and getting them to actually record the information you are trying to capture.
-
link the following tables.
audit_trail to parts_master
audit_trail to sys_users
In your report, add the following fields
PN
Description
audittrail_descr
audittrail_stamptime
Set your record filter to be as such.
{AUDIT_TRAIL.SOURCE_TABLE}=”PNM”
and
Left({AUDIT_TRAIL.DESCR},14)=’Added New Part’
and
{AUDIT_TRAIL.STAMPTIME} = Today
and
{PARTS_MASTER.ACTIVE_PART}=”T”
and
{PARTS_MASTER.MASTER_FLAG}=”T”
Run the report at the end of every day and it will show you what part numbers
were added for the day.
-
In order to identify those in reports, you have to do the following.
Include the stock reservations table and the WO_Operation table.
Make the both left outer joins.
Then, filter anything where the WO_Operation WO_TYPE is equal to LOT.
You would link the Stock to the Stock Reservations, Stock Reservations to WO_operation in a left outter join, then include in your filter a not(WO_Type=”LOT”) statement.
-
We submitted a list to Component Control and they will (hopfully) announce the progress of these efforts at the conference this year.
-
Thank you for the kind words.
The applications to manage your remote connectivity in order to gain access to Quantum are done by other, third party, developers which are all available on the Apple and Droid market places.
However, you must have the proper environment setup to allow for the connectivty.
I am planning on addressing all facets of the remote connectivity setup through Windows Terminal Server (not citrix).
-
The quote and work order functionality is done by using the Work Order templates. Basically, you setup your “work plans” applicable to a charge. This is represents quoting the job (I’ll call it a C check for example).
Then, if there is a BOM listing that you are quoting specific pricing for the parts, you add those parts.
To make it easier, you could create quotes for specific jobs as templates, then copy the quotes to duplicate them.
You should consider looking at the Work Order Quote module. It is very robust, but the only down side is that the Work Order must be created first, then you launch the quote from the work order.
-
Tony,
The problem with this is that no one in the parts listing sector will play with Component Control because they are a direct competitor. When I worked at CC, we were having lengthy discussion with Bruce Langsen (former President of ILS and now retired) to integrate ILS and Quantum. ILS Wanted to use QC as an online solution.
The talks fell apart and The Stock Market was born. ILS then bought out the software company ARMS and began to offer it as an ERP solution.
I have asked many of my contacts at ILS if this would ever happen and they so no. Component Control would like to see it, but ILS doesnt want to play.
-
Tony,
This already exists. In fact, this is going to be the topic of one of my lectures.
-
Actually this querry has some line commented out. You can uncomment the table name and change the WO_BOM table name with another table name to see this reverse. Dont forget to comment out the field name before you run it.
-
I have posted Tony’s OCDia instruction under the Presentations link.
-
We have used the shop control module for some time. The questions you pose are all relative to your operation, your ability to administer it and your knowledge of the system. Familiarity breads productivity. So, that being said, it will be difficult to implement it without the right guidence, proper procedures documented, and willingness from all involved parties to make it work.
Now that I’ve given the lecture, what specifically do you want to know?
-
Dave,
We have used the shipping module for many years. I have built a bridge to a third party shipping software, and we do barcoded status updates with it as well as a variety of custom documents. It is deployed in all seven of our regional offices.
What would you like to know?
-
Julie, this will require several steps.
You can use the DIA tool (Firebird) or OCDia tool (Oracle) to import the locations.
We did this a while back for a new warehouse we setup. Be aware if you use the barcode equipment do NOT use the ~ symbol in your location codes. The barcode unit does not recognize it.
Once you have created your locations, you will need to label them. Unfortunately there is no easy way in QC to print the location labels. But, it can be done. We created our own barcode label reports in Crystal to help speed up the process.
Once your locations are labeled, you should use the barcode system to do the transfers if you have it. If you do not, you might consider getting it. By doing the transfers using the barcode location validation routine, one bin at a time, this will allow you to find any discrepancies in the stock. If you use the barcode location transfer it will transfer all product in one location to another location. But, that means you will move the discrepancies to the new location as well.
There is a function in QC in the inventory module, global menu that allows you to transfer all parts from one location to another. But, hereto you will move any discrepancies to the new location. It can be a dangerous function.
Once you have moved everything, your old locations should be reported on to see if anything remains in them. If so, clean up the remaining stock. Once that is done you can merge the locations into the new ones to get rid of them. That function is in the User -> system setup menu.
-
One option is to print the forms to PDF and put the revision numbers on the PDF files as your master outline.
However, the revision number would not print from QC. We are ISO 9001,9002 and ASA certified and this approach has been fine for us.
To answer your question about the forms designer, yes that is the only way to modify the forms in QC. The forms are created with program code and pulling data from the QC tables. If you do not understand the basics of either database management, or programing you wont be able to do much with it at all.
-
Tom,
I know C&L out of Australia has developed their own application to do bulk scanning and then match it to the respective stock lines. Chris use to be on the board, but quit a couple years ago. I dont know if they would be willing to share their technology with you, but you could try it.
The other thing to obtain a dedicated scanner, like one of the models we identified in this posting.
The reality is you will always have to select your scanning device and scan through the proprietary scanner software. There is no way around this.
-
Steve, your best bet is to use Crystal Reports. It can provide extracts in a variety of forms.
If there are specific SQL statements you are looking for I can offer limited help. But, it sounds to me like you need some robut reporting, and that reporting can be automated.
-
Ok – now I see. You are actually talking about two things. One is a discount off of list and the other is a markup from cost.
There is a markup table in the cmpany records. So, perhaps you use the discount functions for your vendors and the markup functions for your customers.
You cannot have both in the same company record though. Otherwise, how would the system know to markup from cost or discount from list price for a particular customer.
I still think the system can do what you are after.
-
Anthony,
We have several companies in our structure. I create a complete set of documents for each company/branch. It is a bit of work, but makes it much easier to manage. Especially when dealing with our over seas companies as they may have certain requirements that we do not need.
You have two companies but one DB. Does that mean you are using a multi company license? As in accounting companies?
Can you share some code that you are having trouble with? We might be able help if we have a better understanding the specific issue.
-
Lydia,
Thanks for the reply. We do not use the quick check functions at all because it has posed significant challenges in managing the GL. We just do manual checks then adjust things accordingly after the payable has been created.
For the record, I am no accountant so forgive me if I do not use the proper terms. To be honest, I try to avoid accounting, but I’ll give it a shot.
In our company, we often create GL Batches where entries are made to adjust balances on accounts. For example, we may defer a payable to another month, so accounting will manually adjust the AP accounts through a journal entry. Then, adjust the money back in later.
So, when a PO is created, for example, and the Vendor Invoice is posted.
Ap Suspense is hit (2010 account) and AP is hit (2000) (I know there may be more, but bare with me)
The account which QC uses for the AP entries (2000) and/or (2010) is the one that should not have manual entries input into. A different account for manual entries should be created, like a 2099 (AP Adjustments) account. Then, on your reporting the 2099 account is included or excluded on your bottom line numbers to balance.
I know I am probably not making a great deal of sense, but I am trying to explain as best as I can in my non-accounting way. I guess the easiest way to put it is to not do any manual journel entries into accounts which Quantum uses automatically and to keep manual adjustments outside of those accounts.
It may require custom reports to be built, but that is easier than tyring to reconcile.
-
This conversation is really hitting home. I have tried communicating this to Todd for some time, as well as other managers at Component Control. I often get the typical patronizing dismissal.
In fact, just yesterday I brought it up again and for the benefit of the group I will share the email exchange.
As a preface, I upgraded last August and began reporting bugs in September. We had custom programming in that release, and more in the works at the time.
I was told on multiple occasions that the release was ready. Even at one point I was given the go ahead to download the release and began doing so. Literally in the middle of downloading the release (this was in December I believe) it was yanked out and I was told the release wasn’t ready and wouldn’t be ready for two more weeks. Two weeks passed, and I was told the second week of Jan. The second week of Jan passed so I checked again. This is the email exchange.
From me to Pietro (who seems to be one of the few people you can rely on there)
“So – what is the status? Am I going to get an upgrade and help removing the (other) database?
Communication just dropped off.”
Reply from Max to me
“Paul –
Will or Roque will contact you to schedule the upgrade for the afternoon.
Thanks,
Max”
William ended up contacting me and we had an exchange to try and schedule the upgrade, here is the relevant comment from that exchange….
“…..Additionally just to confirm this is only to upgrade a test environment correct? As version 9.1.1.0 is not yet available for production….”
My question back to William
“No, it is for our live database.
I’ve been waiting on this release since September of last year.
That’s five months!
I was told it was ready last week. Now I’m being told it is not ready.
What is the deal?”
Tony then replied to my question
“Hello Paul,
The upgrade is available, since it’s a new release William was suggesting to have it installed in your test environment before upgrading your live to avoid any unforeseen problems in your production system and avoid any possible down time.
Since you do not have a test environment to take the upgrade you can take into your live production system however please be aware you will be the first customer going live with it in a production environment. We do have several customers running the new version in their test servers and early reports look good.
I will have William coordinate a time with you to upgrade.
Thank you!”
I replied to Tony with this question
“Thank you for the clarification.
I am curious to know at what point are releases considered available for live upgrades?
I don’t think I have ever been told a release is ready.
It seems to me that Component Control is a multimillion dollar, international company
With hundreds of customers worldwide. It should be capable
Of releasing a stable product.
From the user stand point, this is a frustrating thing to push the
Testing and responsibility of stability of the product on to the user.
I make this comment as a representative of the QUE Group. This, and the lack of
Timely response from Tech Support have been hot topics lately.
Paul”
And.,.. the final reply
“Paul,
Quantum is a highly configurable and robust system; we recommend that all customers take upgrades into their test system as a standard practice before going live with it regardless of how long the release has been available.
This is typically an industry standard for software such as ours that has a major impact on the companies that rely upon it.
The release has been tested here and made available to our clients such as yourself and is considered stable. As far as being notified of when a release is ready we are working a system that will notify our customers when a release is available.
Since we have a partnership and open communication I thought you would appreciate to know that you are first to take the upgrade especially since it will be going into live without upgrading test.
Would you like William to schedule an appointment with you?
Thank you for taking the time to express your concerns and being an active part of the QUE Group.
Please feel free to let me know if there is anything else I can do for you.
Best Regards,
Tony Bagalini”
I will let you make your own conclusion to this exchange. To me, it is disappointing that this is the reply provided and further amplifies the very issue I was once again trying to bring to their attention.
Perhaps it is me. Perhaps I am reading something into that is not there. I dont know, but I would be curious to know if others have similar experiences and/or feel the same.
-
Interesting. We have the same challenge here. There are many, many things that impact your aging. Here are some of the things we did to reconcile.
I dont know what you mean by PPL Inventory. The AP aging reports have nothing to do with inventory. They have to do with payables. You can create a payable manually and it will show on your aging report, but it will not have any corresponding inventory records.
1. I did a querry against the database to sum up all of AP accounts in an open status.
Then, I compared that amount to the AP Aging report and the AP Overdue report. These three numbers should match.
What this does is tell me if the problem resides in reporting, or the GL data. The overdue and aging reports should always match. They are just different ways of looking at the same data.
A side note: you should understand that the aging reports look at the header of the AP records to get their numbers. The GL reports look at the details of the AP records to get the their numbers. The detail is the same as the GL details.
So, you are trying to compare and reconcile two sets of numbers derived from two different sources (or in database terms, two different tables)
If the GL totals do not match the reports, then the problem is in the GL entries.
So, what impacts the GL and NOT the aging?
1. Manual entries. If you are creating manual entries (journal entries) into the AP accounts directly isntead of doing them through the actual AP transaction, you will create an imbalance. Why? Because the AP transaction you are trying to adjust or impact will not know about the GL entries you entered manually.
If you are going to make entries into the AP accounts directly, DO NOT enter them into the same accounts that QC would hit automatically. That way you wont interefere with the systems designed debits and credits. Create a special AP account to do those entries in.
This will provide visibility to
A. system bugs. If you arent touching the accounts used by the system, imbalances will show up immediatly and you can investigate them.
B. Incorrect entries. If you enter something into your special account and make a mistake, it will be apparent right away.
So, for this first item, you need exclude your manual entries and see if your accounts balance.
2. I created a report in Crystal that filters system created entries and manual entries in the GL. I grouped in by amount and this gave me an idea where to start to look. This exposed my manual entries to the GL hiting the AP accounts. You can do the same thing in Excel by extracting the GL Detail from the search grid. After investigating the entries, we discovered incorrect entries were being made because there was a lack of understanding on how the Operational side of QC works with the GL side of QC.
Now, one thing to watch out for. If you have a GL batch that is created by the system and you change the account number to point to an AP account, it is still marked as a system created entry and you can lose visiblity of this very quickly.
There are other things that will impact your AP as well… or not. For example adjustments to a closed PO are allowed but do not roll to the payable. At least in some prior versions they allowed this, which crazy.
We have had issues in the past with PO returns, PO void recieivng and RO void receiing incorrectly hitting the AP and AP Suspense accounts.
You need to approach this in a very systemamtic way. Break down the elements that impact AP and understand what data elements the reports are giving you. You cannot get the GL and AP aging to match if you are making direct entries into the the AP accounts outside of the AP module. It just wont happen.
To sum it all up.
1. Do AP Aging and AP Overdue match? If so, your AP Header’s are correct.
2. Does your GL match the two reports above? If not, your probem is in the GL accounts.
3. Understand what you are looking at and where the data is coming from in the system.
4. Eliminate manual entries.
5. Eliminate the overriding of account numbers in GL batches.
Define new procures with an understanding that the accounts which the system hits automatically (this goes for all accounts) are NOT the accounts you should make adjustments to. Create a “sub ledger” of adjustment accounts if need to in order to isolate potential problems.
-
Very good point Eric. And, I agree, however, if they did that it would dilute the value of the SMA and make users less dependant on Component Control.
-
There are a few reasons for this. Frankly, I think they are creating their own monster.
The development team has lost sight of the product functionality. Because of this development is often buggy or incomplete. Then, the support staff that tests the product hasnt got a clue how to test, let a alone how the product functions fully and in a real world invironment. Because of this, they are innondated with calls.
That creates a bottle neck. Then, they are scrambling to fix the problems, which breaks other things and repeats the cycle all over again.
They need to do some serious Lean Six Sigma analysis within their organization and implement some change otherwise they will begin to lose market share as competitors take advantage of the industry goliath that trips over its own feet and no longer works in the best interest of the customer.
It is dissapointing to say the least.
-
Tom, the scanner module we use is HP Scanner Model Scanjet N6310
-
Tom,
We scan all paperwork for each part. We also photograph each part during the recieving process. Our benchmark for receiving is 7 minutes. That is to unpack the item, scan and photo paperwork and parts, print QA documents, label the part, inspect the part and put the part on the shelf.
Some items take a bit longer, some take a bit less. I have actually timed it with a stop watch and averaged it. I did this in order to streamline processes and procdures.
We currently stock about 23,000 parts in our 20,000 sqft warehouse and receive on average about 35 to 40 orders a day. This does not include our Lot receiving.
Our entire operation at our primary facility is run with one manager and two clerks plus one QA inspector.
I think your operation could be streamlined through a variety of methods.
1. Are you using the receiving inspection module? Items scaned against the main line item are copied to the serialized items saving time.
2. Is your document server the same server as your domain controller? If so, it should be moved and the hard drive should be a top of the line, very fast drive.
3. How far is your warehouse from the first switch in your network? If it is more than 100 feet, you should put in a switch at the recieving stations to boost the signal. This might help a tiny bit.
4. What resolution are you scanning at? The higher the resolution, the slower the scan. We scan in gray scale at 150 px resolution.
5. What type of scanners are you using? We use a moderatly high end HP flat bed with a document feeder.
6. What paperwork are you scanning? Is it all actually necessary? We went through our process from beginning to end and overhauled it completely. When we began asking why (the six sigma why five concept) at every stage we discoverd there was a ton of work being done “because that’s the way its always been done”.
7. Scanning make take some additional time, but can that time be recouped somewhere else in the process? You need to look at your process throughout the it’s lifecycle. It make take an extra minute in one step, but that extra minute could save 5 minutes later on down the road.
-
With regards to the RO history grid in the Companies module, it is not shown here because the company is associated with the RO header. It would be way too much data to show each PN for the company. That is why you are seeing the header data from the companies and the item data from the Inventory module.
-
Please be more specific. Are you receiving in the recieivng inspection module or in the individual modules? If individual modules, which module?
Is your PN marked as track time life? Are you using the Force Slip option?
-
RO History has a column called New Part Number. It is assumed the RO went out under the PN you are looking at in the inventory window. The New Part Number column shows the PN which it came back as in case it was modified.
If you are not seeing this column, perhaps you need to right click on your grid and choose reset browse. You can also drag this column left or right, then right click on the grid and save to personal settings if you want it visible all of the time.
-
Michael,
After reading your post again, I see that you are speaking of the WO header not the bill of materials.
The same still applies though. Just replace the WO_BOM table with the WO_OPERATION table. You still need the stock reservations table in between the wo_operation and the stock tables. Also, I neglected to specify in my previous post that your join to the stock table should also be a left outter join.
-
Michael, you are missing a table.
You need to link the following
from the WO_BOM.WOB_AUTO_KEY to Stock_Reservations.WOB_AUTO_KEY (Left outter join) from Stock_Reservations.STM_AUTO_KEY to STOCK.STM_AUTO_KEY
You should also link from WO_BOM.PNM_AUTO_KEY to PARTS_MASTER.PNM_AUTO_KEY and display on the report the PN that the BOM is linked to and the PN shown on the stock line because you can reserve alternate part numbers.
Lastly, for best performance, you should group your report on a field value in the BOM table, and then show your stock line data in the DETAILS of the report. The reason for this is when you have a many to one relationship in the tables, (one BOM record to mulitple stock line records) this provides a good way to manage the report data.
-
Well the simple solution is to train people to inspect the stock line and look. However when a stock line is on hold it is not visible in the stock summary screen or in the reservations screen so when quoting or doing a sale the stock on hold isn’t even available. The way I see it if your sales people are quoting parts then comitting it to a Customer then a sales order should be created and the stock line reserved. This alone will make the item unavailable and show the order as open. Every day at your sales meetings (assuming you have a daily meeting) these open orders should be reviewed. Then canceled or processed accordingly. This approach (managing the orders and salespeople) will then begin to build a history for customers. So you would be able to see which customers are creating orders and then canceling. This becomes a negotiating tool for future orders. The other part is training your customers. If they think they can get you to hold the product while they shop around to see if they can find it cheaper and then cancel with no penalty if they do find it cheaper… they will take advantage over time. So beyond this the only other thing I could suggest is to do something on screen scripter. But I’m still not seeing how they are going to quote or sell a stock line that is on hold as it just isn’t available unless you open the part record and then click the stock icon or hit f9. If this is what is happening when quoting parts, the system isn’t being used very efficiently.
-
That can be done with a Crystal Report. There is no way to do multiple PN searches in Quantum.
However, you could use the Quick Item Entry function in the Quote module to enter them into a quote and then use the Quote Worksheet document which provides a large amount of data for each item on the quote, including alternate stock.
-
The most cost effective way to do this would be to jus create a report that shows any parts you have quoted, and preselected stock lines, that are older than 48 hours. Then, someone would have to go in and remove the HOLD flag. This assumes that the user would select the HOLD flag after they quote it which would prevent it from showing up in any stock reservation screens.
Another way to do this would be to get the Event Manager module and have a custom script written that looks through the quotes and flags any preselected stock lines as holds. Then removes the holds if they are past the 48 hour mark.
Manual holding and un-holding using a report is inexpensive.
Automated with the event manager is costly.
-
Lisa,
I think if you provided a bit of an outline of your questions that would help.
Please post your concerns.
-
Each customer can have a single set discount %
If stock line is pre-priced, then that stock line will override default discount. If stock line is not pre-priced then customer discount is calculated, I believe from the List Price derrived from the Parts Master record.
The discount matrix works for both customers and vendors. You just need to setup a new set for your customers and assignment.
Bascially, if you have a group of parts assigned to discount group A.
The vendors will have a 60% discount off of list (for example) because your price is 60% below list. Your customers, for the same discount group A, might have a 20% discount off of list, because what you sell it for is only 20% below list price.
For the margins, you can’t do both. Either you are using margin adjustments or discounts. One contradicts the other. Your best bet to manage the margins is the price lines. It is not perfect, but it may work well enough to achieve your goal. Also, you define minimum margins per user, at a line item level. This, however, would require an approved supervisor to override the item entry if the margin does not fall within the defined levels.
I think, honestly, what you really need is to define a policy and procedure for establishing your pricing, then hold people accountable to it. You cannot program your way out of people doing the right thing.
-
Crystal has build in aging functions or you can use the DateDiff function.
Here is an example of the DateDiff function
numbervar X:= DateDiff (“d”,{RO_DETAIL.ENTRY_DATE},ToDay);
numbervar X;
Here is an example of the Aging function
{AR_ACCOUNT.ENTRY_DATE} in Over90Days;
you can also do straight out calculations with the date functions.
-
We use the group field as well. We foud this to be the most suitable as it is incorporated into the part search capabilities, and you can do mass assignments to the parts through the global menu based on part number pattern.
Additionally, if you have the screen designer/scriptor module you can add your own drop down menu to input the ATA chapters.
-
You need look into the Discount matrix. That is designed to allow for multi level discounts by group where you can assigned variuos customers to certain discount groups.
You should also look at the price line fucntions for multi qty discounts.
All of these can be managed and overriden in the PO, SO, WO, RO
-
The wireless barcode scanner from Worth Data is the only unit that works
with the barcode capabilities, expect for some of the labor tracking functions
in the work order module. For that stuff you can use pretty much any trigger scanner
as those are just text translators.
For the wireless stuff, you will need the base station and at least one hand held unit.
http://www.worthdata.com – verify with CC which model works with Quantum as Worth has come out with new models recently.
For the barcode printer, the Zebra 2880 series is a die hard reliable unit.
-
You can email me the report and I will take a look at it. pstewart@worthingtonav.com
if you wish.
-
when creating reports that you are exporting from Crystal you have to make sure you have complete column alignment. Additonally, when you export you must specify in the export properties if you are aligning the columns based on the header, group or detail data elements. Although your problem appears to be random, it is not.
-
The table that holds this information is called CALL_USERS
You may need a tool like SQLDeveloper to map the tables.
-
Eric,
I think the problem is that you are not assigned, or appending your % to the value assigned to the string variable. I am just guessing.
For example. If you do a querry using Interactive SQL like this
select * from parts_master where pn like ‘12%’ it will return all parts that have the number 12 in them. Notice the % sign is within the sigle quotes. If you do your querry like this
select * from parts_master where pn like ’12’% it will fail.
So, if you are assigning a value to a string variable, like this for example…
stringvar X := ‘123’;
select * from parts_master where pn like stringvar X % will fail
You must also include the % sign. So it should be
stringvar X := ‘123’+’%’;
select * from parts_master where pn like stringvar X will suceed.
-
After reading your note futher, I wrote this for the PO header. So, whatever screen you are putting it into make sure that the form at the same form notes field available.
To test it place this in the btnOKClick procedure of the PO Header.
It should look like this.
procedure BtnOKClick(Sender: TObject);
Begin
Form.Dataset.FieldByName[‘NOTES’].AsString:=Form.Dataset.FieldByName[‘NOTES’].AsString+’TEST’+#10;
End;
When you edit the PO header and click OK it should insert the word TEST and a new line.
-
No. It does not turn the notes recap into an editable field.
What this does is take the existing notes and append another line of text to the notes.
It would be applied when adding or editing a line item, or adding or editing the header.
Specically, I have create a completely automated Purchase Request process outside of the Qunatum purchase request module. The user is required to submit the request. My scripts look at this and append to the notes each of the user’s actions so that an audit trail is created at to when they submitted the request or when it was approved for example.
-
Leonard is correct. You want to add a second instance of the companies table to your report and ditch the subreport. You can do that with all tables, but be cause you dont carried away with it because you will run into performance issues.
Now, your mention of dropping records off of the report. Please ellaborate on that. Do you mean once they have been received, once they have been shipped? What is your criteria?
Are you using the shipping module, the receiving inspection module? What tables are you working with?
I tried opening your report but it required a user account to be setup. You can email
me directly if you want additional help. pstewart@wothingtonav.com