pam.prince
Forum Replies Created
-
Thanks Nadim. That did the trick for the most part. There’s a handful of transactions where it didn’t work but for the purposes of my report, I don’t care about that data anyway. I really appreciate that quick response.
-
We are experiencing the same thing and we are spending way too many man hours fixing something that should just work!
-
Hi Paul,
Thank you so much for responding. And, please, get on your soapbox!
So, if I understand you correctly, you would NOT invest in a tool like this, instead you would monitor through benchmark KPI’s at each stage?
One of the things that draw me to this software is the visual of the process and the deviations from the standard process.
Thanks,
Pam
-
Echo everyone’s thoughts and concerns. Will be interesting to see how the next year or so plays out.
Paul, could you forward the details on the VQ Wizard to me as well? Sounds like something we may be interested in as well. Not sure that I will have any support from the Exec in investing more money in Quantum but it never hurts to ask.
-
Hi Duane,
A better tool is Project Audit Log under the GL Drop Down. It came out in version 10.5 I believe. I’ve spoken about it at the conference the last two years. If you go find the accounting presentations on this website you can find out more.
Pam
-
Hi Alonda – YOY – Year over Year. 🙂
Hi Kelly – We’ve merged lots of companies and never noticed anything. Is there a specific screen that you are viewing YOY data? Or are you viewing this in a custom crystal report? If it’s a report, it could be your report settings need to be looked at.
Thanks,
Pam
-
Also very interested in this. We briefly looked into Honeywell’s voice recognition software but never pursued it very deeply.
-
Hi Anna,
Sounds like good CP. Keep us updated on how you guys proceed.
We haven’t rolled it out yet, but we thought we would use contact manager to help manage electronic approvals of RO’s. There’s no system block with contact manager but at least it’s an electronic system of approvals.
Pam
-
We have similar procedures at Avmax other than we have not tried to automate the communication through email alerts or printing. Instead we have stores monitor the requisition management screen. We use BOM statuses (22 unique statuses) to direct the work flow. At a high level, the floor requests a part. Stores sees the request in req management. They search our inventory and if we don’t have any they change the BOM status to PO request. Our purchasing is also monitoring req management for specifically this status. If the part is expensive and requires customer approval before purchase another status is used to notify the PM’s to review and get approval.
Now that we have more experience with Event Manager we will likely automate notification at some stages of our status change. For example, it’s on our radar to create an event to notify the project manager when a BOM status is set to PM review. We have used the “manager” field on the WO/WP header to list the PM.
-
Hi Paul,
Thanks for the recommendation. No, we have not set it up as a subreport. I will try that.
Pam
-
Hi Sally – Can you send it my way? pam.prince@avmax.com
-
Glad to hear you had such a great experience with Thiago, Gabrielle.
Avmax has also hired Thiago for training and I second every comment Gabrielle made.
-
Thanks for the quick response, Nadim. That makes so much sense.
-
Hey Anthony,
Re: your statement…”Also, adding a quick vendor quote from a part doesn’t create a Vendor Quote which seems odd.”
Double check your Vendor Quote settings under system settings. There’s only one and if you flag it then vendor quotes will be created.
Good luck.
Pam
-
Also interested in this topic. We do it the same way as you, Abigail. It’s painful when doing a huge order.
-
That worked perfectly!! Thanks for the quick response.
-
Hi Abigail,
How are you removing the stock-line? Are you voiding from the SO or doing something else?
Thanks,
P
-
Thanks Andre and Pietro. I will try those options. Glad we aren’t the only ones experiencing this.
-
Copy me too, please! Sounds like a great report.
-
Yes, there is a way with a combination of the Term Code Formulas and Term Code tables.
Our Quantum had a lot of this canned, we just needed to complete the setup on the term code table the way we wanted. We needed to pick a formula, set the discount rate, and add in the AR/AP Distributions for the accounting entries.
-
LOVE this idea.
For those going to QUE Group, don’t forget about the enhancement requests on the final survey. The QUE Group board does take those seriously and they can also put some pressure on CC for this enhancement if enough of us ask for it.
-
Hey Anna,
There’s another pretty good thread going on 10.8. I’ve listed all the bugs that Avmax has encountered so far. We just took our prod env up to 10.8.24.
http://quegroup.org/f_bugs/4578491
Good luck!
P
-
There’s another thread going that I think you should go read. Lots of information about 10.8.
-
Hi Everyone,
Haven’t updated you guys in a while. We’ve found and reported a number of bugs in 10.8.22. We just upgraded to 10.8.24 last night.
T8943 – Fixed in 10.8.24 – Performance enhancement of WIP Valuation Report. Report would not complete for us in 10.8.22 – let the report run for over 45 min before giving up.
T8938 – Change currency on WO/WP header from default. Create WO quote. The currency on the WO quote does not match the WO/WP header. The quote continues to pull the default.
T8665 – Reported this earlier in this thread. Flagging button now works in 10.8.24 but the access violation error still exists. Supposedly there is a patch that we just missed out on.
No Tracker Yet – PO & RO Costs on the stock line not reporting properly as the series number changes due to exchanges/repairs.
T9069 – Work Package -> Job Card Analysis. When you hit the ellipse beside “Task Type” we get ORA-06502. List will not pull up. Must type the task type in.
T8998 – Many, many shortcut keys were broken in the billing screen. They have fixed them in 10.8.24 EXCEPT they broke “I” for Inspect. “I” now opens Filter. 🙁 I’ve reported the new problem.
Thanks,
P
-
Oops – one more….
Receiver Reconciliation – new report and log
We can’t get the new GRNI report or Receiver Reconciliation Log to retrieve all the open receiver data. We’ve let both run for over 4 hours and nada. CC has taken a copy of our test database to see what’s going on. (no tracker yet)
-
Hi Everyone,
I’ve finally sifted through our power user testing results. Here’s the additional bugs we found.
SO Type 6 Exchange/GL Does not resolve properly – The repair cost from the WO is not resolving the Division and Department segments from the SO. COGS account defaults to 00’s for all GL segments. (no tracker yet) **This is likely specific to our setup**
Deposit Invoice/Foreign Exchange – Create customer deposit in foreign currency linked to a WO/WP. Change the exchange rate. Create a billing and apply the deposit. The system doesn’t do a foreign exchange gain/loss entry. Instead it leaves a hanging balance in the customer deposits account in the GL. T8863
WO/WP credit memos – When flagging items to pull to the credit memo the flag button does not work. You can double click and use the short cut key to flag items. It’s just the button that does not work. T8865
WO/WP credit memos – After flagging items to pull to the credit memo, you hit apply. Once you hit apply you get an access violation error. You hit ok and it looks like nothing has pulled to the billing window. You escape out of the billing window and you get an access violation error on the WP/WO window. Escape out of that. Search the billing for the credit memo you just created and everything opens up and looks good. Proceed as normal. T8865
WO/WP Quote – Global -> Pricing -> Set Labor Billing Rate. Flagging button and shortcut key does not work. Only way to flag items is to double click. T8852
Stock Audit/PI Batches – The adjustment from a PI batch shows in stock audit but the PI batch is not linked and there is no GL information showing for the adjustment. (no tracker yet)
Purchase Request/Exchange Type – If you add an “exchange†item and go back into the item a 2nd time the exchange type changes to an outright type. (no tracker yet)
-
Hi Gabrielle,
Likely the PO/RO Deferred Receiver Flags are unchecked on the Company Master.
Find an AP that your receiver created. Inspect that company and edit it. On the first tab under the first column of fields there are two check boxes with PO Deferred Receiver and RO Deferred Receiver titles. If there is NO check in the box then upon receiving the AP will automatically be created, by-passing the deferred receiving process.
If this isn’t the problem then let me know and I will think about it some more. 🙂
Pam
-
We completed our initial test. We only found 1 new bug.
Create a new cash receipt. Hit the “Add” button. Type in an AR Account Number and hit OK. We get an Information error “Find Field SYSTEM_COMPANY is not valid for qcbARAccount”. We hit ok and we are still able to proceed with the transaction. Everything flows smoothing from there.
The tracker is T8786.
We are now prepping for our power user test. I will report back any bugs we may find in that more thorough test.
-
At Avmax we do it similar to Andre and Jae. We have a “test” environment that is separate from our “production” environment with a current copy of data from our “production” environment.
Our testing is slightly different, though. My team reviews the patch notes for what may interest us, reviews our current bug list, and then tests our standard business processes plus the bugs/patch list.
If we don’t come across any “show-stopper” bugs, we then proceed with a power user test. Instead of having people test at their desk, we actually put together a lab and have everyone test together (there’s usually between 16-20 people testing for approx. 4 hours). We provide flow charts for the business processes we want them to test that includes every department for the process. The power users write their control numbers on the flow chart and pass it along down the line. If there are any business processes we haven’t covered that the power users want to test, they are free to do so, they hand write a flow chart and pass that down the line. These flow charts end with the Accountant who is reviewing all the GL entries.
If the power users find a bug, they screenshot and document the steps they were doing to create the issue. That document gets emailed to my team.
We report the bugs to CC and make a determination if we are able to proceed with the upgrade now or if we have to wait for a fix. We’ve never had so many bugs that we had to redo a power user test. Usually “show-stopper” bugs are found in my team test and we don’t proceed with a power user test until we are fairly certain that that test will not uncover anything major.
The difference between the two different tests is the number of business processes we test. For example, my team tests Type 1 SO exchanges as we do a lot of those but we don’t bother testing SO Loans. Our power users do test that function, though.
-
Thanks Andre! We are doing our initial test on Monday. Once we have pulled together our bug list I will post it here.
-
We are going to go into testing on 10.8 in the next week or so. We are currently on 10.7.111.
Andre, are you able to share your current bug list on 10.8.15?
-
Hi Andre,
When we ship the serviceable unit we don’t physically have inventory. So to track that financially we have another asset account in the GL called “Awaiting Cores”. This shows that we have an outstanding asset but segregates the parts that we don’t physically have from the ones we do have. Helps with physical counts and also valuing the assets. How long has the core been outstanding? If it gets too long, potentially we won’t get the core back from the customer. We wouldn’t want to say we have an asset on our books that isn’t real.
Hope that makes sense.
Pam
-
Thanks for sharing your script, Andre.
🙂 This report is the one that should tie to the GL but ops uses it too so it’s more operationally focused than accounting focused.
There’s two issues that our accounting department runs into with this report:
1/ Timing – This reports from the SO module and reports regardless as to whether we have invoiced for the exchange yet or not. So, we run into timing issues at month end where our sales team has started an SO Exchange and they have reserved a part but we didn’t get around to shipping/invoicing it. That core will show on this report yet we don’t have a corresponding JE.
2/ Quote/Exchange to SO/Exchange – We also have a bug when our sales team starts with a quote/exchange and converts it to an SO Exchange – the returning core value is $0 instead of the cost of the reserved stock line. In this case the report shows $0 but the GL has a value.
Not sure if either of these issues are what you are running into but thought I would share our experience.
Pam
-
Avmax hasn’t started testing yet although we do have 10.8.1 on our test environment. CC is still working on the receiver reconciliation module so we are waiting for them to put that into production before we start truly testing. We likely won’t start testing until sometime in the new year.
-
Hi Faye,
If you using the bank rec module then I would add the manual deposit as I was doing the bank rec. If you do bank rec’s monthly then I would do it at month end.
Hope that helps.
Pam
-
Hi Faye,
Do a manual credit memo through the invoice module. This will give you a form you can send to your customer.
Good luck.
Pam
-
Hi Sally – What version did this get released in?
Thanks,
Pam
-
Hi Ivonne,
We actually don’t depreciate our cores so I can’t speak to this one. Maybe someone else will jump into this conversation.
Pam
-
Hi Ivonne,
We do Type 6 Exchanges.
The trick is to make sure your SO and internal WO are linked by creating the WO from the SO through the Misc. menu. If you do this then the costs on the internal WO will accumulate in WIP like normal but when you reconcile the WO the user will be prompted to add a repair charge to the SO (I can’t remember the exact wording of the prompt). The costs then move out of WIP and into COGS instead of rolling up into inventory.
Please note that this is how it works for Cost + Ovhl SO’s. If you are doing flat rates then I’m not 100% sure of what happens. Likely the same thing but we haven’t tested it.
In 10.7 some customer did some customizations to Type 6 exchanges. If you are on that version you should look at your Sales Order Module Settings to see what your setup is. I’m not sure what this feature does as we don’t use it but it looks like it’s tied to the charge table which would effect your accounting transactions.
Another tip is to find a Type 6 Exchange in your database and review the stock audit entries for the returning core. This will tell you exactly how your system is treating the financial transactions associated with the repair. If you aren’t happy with where the system is booking the entries then you either have a process problem or a setup problem.
Hope this helps.
Pam
-
Hi Sue,
Yes, from what you described it should update the WIP Log. Might have to call Tech Support on this one. :/
Good luck.
Pam
-
Hi Tony,
I’m sorry I missed this post. I wasn’t subscribed to all the forum subjects but now that I’ve had training on the website… 🙂 This was a great idea. We should remember to do this next year.
As a presenter this year, I was starting to work on my presentation in June, I would recommend bumping up the timeline to start this dialogue by early-mid June.
Pam
-
Hi Samuel,
I don’t have any documentation I can forward you but I would recommend that you download all the help documents that Component Control has written and have included in their software.
Once you are familiar with the help documentation, then play in a “test” database. The processes aren’t too, too complicated.
If you have any specific questions while you are testing, please feel free to post here. I try to keep an eye on this forum and would be happy to answer any specific questions you have if I can.
And, if you aren’t going, I strongly recommend coming to QueGroup (July 27 – 30, 2016). There’s usually quite a crowd of accountant’s and the accounting round tables are very informative.
Good luck!
Pam
-
Hi Roger,
Can you explain more precisely what you are trying to fix?
If you try to remove something from your subledger without it hitting your balance sheet then your subledger and balance sheet won’t reconcile.
Depending on how you have your default distributions setup, the AP/AR Subledgers can be a bit tricky to print. On the print settings screen just under the “aging date” and near the middle of the screen is a section called “Include Items”. If you have prepayments to vendors set to go to a prepayment account on your balance sheet then you need to make sure to select “Standard” when running your AP Subledger for reconciliation purposes.
You may have already known that but it was something we stumbled on when we were first working with Quantum.
If you let me know more detail of what you are trying to fix I will definitely see if I can help.
Thanks,
Pam
-
Hi Roger,
If it’s a one-off check from a company, you can record it as a journal entry (or if you use the bank reconciliation function in Quantum you can add it as a manual deposit).
If you want to use the cash receipts module then you have to create a company. You don’t necessarily have to create a company with the specific name, you could create “misc. company” and then use the notes fields and scanning/images to support the transaction. By setting up “misc. company” that allows you to use it for other one-off transactions.
Hopefully this answers your question.
Pam
-
Thanks Nadim. I thought that was the problem but wasn’t sure. I tried sorting on Check Number and my report results didn’t change. 🙁
-
Oops on the typos. 🙂 I just typed the script here and didn’t actually test it.
I setup the report exactly as you indicated and I’m still missing records. For example, it pulls in a vendor invoice but not the check details related to the payment. And it is missing vendor invoices in entirety.
You mentioned to move the unique records to the Group Header. I moved all the fields that I want to report on to the header. Should I do something different there? A single check number may be used to pay multiple invoices so that field will have duplicates. I’m wondering if that’s now my problem.
I need the vendor invoice number to be the only distinct record.
Really appreciate all your advice, Nadim. Thank you so very much.
-
I did some more reading and lots of people are advising creating a group and suppressing the details in order to get distinct records. I’ve created a version doing that and now not all the AP Control records are showing and neither are the Check #’s and Check dates. So, I went from having too many records to not enough.
Any advice is appreciated.
-
Thanks for the point Nadim.
As I’m building this in Crystal, I did some googling and found a blog suggesting “Database -> Select Distinct Records”. I checked that on but I’m still getting duplicated records. Any suggestions on how to make the records distinct in Crystal?
Thanks,
Pam
-
Hi Nadim,
Thanks for the advice. I reset my joins per your recommendation and now my data is duplicated.
Here’s what my report would look like in an SQL query.
select a.vend_invc_date, a.vendor_invoice, a.entry_date, a.vend_inv_frgn_total, r.currency_code, k.ckd_number, k.tran_date from
companies c join ap_header a on c.cmp_auto_key=a.cmp_auto_key
join currency r on a.cur_auto_key=r.cur_auto_key
join ap_detail d on a.apa_auto_key=d.apa_auto_key
left join ck_detail k on d.ckd_auto_key=k.ckd_auto_key
where c.company_name = ‘XXXX’ and a.entry_date = ‘XXXX’
Did I start at the wrong place or are my joins just wrong?
Appreciate your help.
Pam
-
Nevermind, figured it out.
For those interested, I just needed to add a footer to the main page.