leo
Forum Replies Created
-
After experimenting, I came up with a solution.
1) Join parts_master to uda_checked via pnm_auto_key –> auto_key
2) join uda_checked to user_defined_attributes via uda_auto_key.
I’ve attached a figure to illustrate in case anyone else needs it.
-
Inside of the lot you would add the charge from the vendor – we have it setup as a “labor” charge. It would then apply to the lot.
The process is “Global”, “List Charges” , “Add” then add the respective charge. -
This is a very old thread but I can not find any way to do a partial release of stock. I’ve tried the above method but actually can’t find a COST tab – what am i missing. Any help would be appreciated.
-
report sent to Glen and Anne-Marie. I hope it helps.
-
We used Preactor for a while and it would help with scheduling products back and forth on the Ghant chart. It was helpful – we never got to the stage of implementing inventory piece parts as we handled that with CC. I wasn’t a primary user on the system I just saw the reported results.
-
You can reverse reversing entries. I do it at times to move entries between months.
-
We integrated 2 sets of books from Quantum and in the end I’m glad we did. We had a lot of inter-company transactions so the double entry was a pain to maintain and when we consolidated I was glad it was gone. In the end our setup was simpler but it really depends on how much is flowing back and forth between the 2. If you need two sets of financials and don’t have a lot of employees using both then you maybe better off leaving them separate and consolidating in Excel.
-
We implemented it and were doubling up with a manual process until we had the process working in Quantum. 3 years later we abandoned the module. It is clunky, does not show employees that are not at work during a week (if they don’t scan in the week it doesn’t show the supervisor someone is missing. When they return from vacation it will back populate all the unsigned in times. The supervisor would have to go back and edit and approve all the times for that employee for the last 2 weeks). This is one of many issues. Quantum will brush this off by offering Event Manager scripts to handle these type of thing but of course they are additional money once you paid for a poorly executed module.
Embraer paid this module and they abandoned it as well (according to an employee at the Que group).
You are better off pursuing a payroll company with scan in and out capability.
-
There is now a function in Quantum to make Companies “Historical”. It is good but really incomplete in thought process. You can make a company “Historical” but it can have open AP, AR, Invoices or any of modules attached to it. Tread lightly.
-
Honestly this is the first system I’ve worked in that wasn’t concerned with being GAAP compliant. The whole point of a system in the first place is to track the accounting of goods and services to make business decisions. The “as designed” response to me has always been a pet peeve of mine since we started with CC.
-
I agree it is wrong. We just switched to manual time cards so i’ll have a look for inaccuracies. It bothers me when they say “it is by design” but the “design” totally conflicts with GAAP (generally accepted accounting principals) which are globally accepted standards. I’m not sure who they have in terms of a team accounting consultant but either those people aren’t an actual accountant or no one asks those types of questions when they are designing it.
-
We are on 10.10.15 and we were told that the negative issue issue is “by design”. I guess they don’t care that auditors don’t like to see sales as negative even though they are natural credits – and overall this is just bad/ non complaint accounting .
To go one step further the system is now doing adjustments to AP backwards from POs. We currently have an open ticket T12380. We put in an adjustment to a received PO to correct it to the vendor invoice and it puts the adjustment in backwards and actually makes the J/E backwards. So another manual adjustment will be required to fix it.
-
You would just reverse the entry. You would never enter negatives instead a DR becomes a CR and a CR becomes a DR. You can adjust them all manually as per normal journal entries or you could use the reversing entry function. Open the journal entry and go –
>Global
>>Reversing Entry Batch
-
For trace I would just create a credit in that account and then clear that credit through an adjustments account. Then setup the payable for the correct vendor and clear the expense through that adjustments account as well. Put in a few notes and you have good trace and it will be easy for someone else to follow.
-
I would agree on using Quick Check as well. It will apply a credit against the PO that is outstanding and will be applied properly as payment once the PO is received. Until that point it will show as a prepayment.
-
The closest I have seen to what you want is in the system. Under the “invoice detail report” it has work by type. The report itself is overly detailed and hard to get any trends out of but it does have the details. Historically the report has been known to show cores as “expensed” even though they aren’t. If anyone has a better report I would be interested as well.
-
I would like to reopen this question. We are considering this module but i was wondering if there was any feedback (good or bad). Any info would be appreciated.
-
We also use Preactor and have for about 2 years now. We were getting anywhere with planning inside of Quantum so we picked Preactor based on its ability to interface. Given it’s flexibility you could use it for work orders or manufacturing orders.
-
When you setup Charges in Quantum for PO’s/RO’s/Sales etc there is the Editing Charge window. In that window, depending on the source of the charge, there are different GL account setup as defaults. Defaults can be different dependent on source. For example Freight may have a inventory account for Freight charges but you can also use Freight as a charge in the Sales windows – one would be a sale GL and the other an expense GL. You are best to go to the PO/RO that produced the wrong GL account and inspect the charge item to see how it was setup in the background. It maybe as simple as correcting the GL account for the source.
-
There is also Adaptive Insights – it isn’t cheap but also handles budgeting. It can be an import solution or can be directly connected to Quantum and other sources as well. https://www.adaptiveinsights.com/
-
Quantum considers all transactions as FOB your dock and revenue is recognized on posting. I don’t know of any mechanism in the system that can determine if your shipment has been received (FOB customer dock). The only method I could think of would have to be a manual handling of items in the shipping manager that wouldn’t post the invoice until it was manually checked with the freight forwarder and then manually posted by a user. Not sure if that helps or not.
-
I tried both methods and had the same results. As a work around we will do manual adjustments in the ledgers. It is unfortunate that something that has worked for us for 13 years now no longer functions for us. Being a foreign currency company we are in the minority and many of these issues tend to be overlooked. Hopefully they are timely with the tracker.
-
I would be interested in this as well. Thanks in advance.
-
if you assign consignment codes to the lots then you maybe better off pulling a sales report based on the consignment code. It tends to pick up items with the consignment code both in and out of the lot. That would at least give you a good indication of what has been used up. (it is the invoice detail report under invoice management-hopefully i am understanding your question here).
On the other end wouldn’t you just be better off pulling an inventory report by consignment code as well? It would cover the remaining costs.
-
i would be interested in this as well.
-
Sorry i was out of the office last week and missed the thread. The report has been sent to Abi for the library.
Leo
-
Abi one of the reasons you can balance day to day but not week to week or month to month is the GL system allows for back dating of transactions. Depending on your GL setup it may use the invoice date of the post date for adjusting the ledger. In a lot of ways you maybe better off not only looking at dates but also looking at GL batch numbers because a GL batch number is in sequence. The entry date can also help here.
For instance you can balance today but once it is balanced you can do entries tomorrow to today’s date. The bigger problem comes in when you are 25 days into a month and something gets posted to the first week. It becomes harder to find but typically using the GL batch number and sometimes the entry date (versus the posted dated or transaction date) will help. Good luck!
-
We use a bolt on MRP called Preactor. http://www.preactor.com/ . It can handle production planning, resource planning and it can backflush into to Quantum in terms of estimated complete dates. It can be scaled as well and is better than anything in Quantum. We’ve had good succes with it for labour planning and machine planning. We haven’t implemented inventory planning but it is an option.
-
We use basic billing and we flip to a Sales Order before the invoice. It gives a little more flexibility on the “ship to address” and other items before shipping. Not sure if that is an option for you or not.
-
We use Quantum accounting (not the bridge) and we have issues monthly as well. There is always an adjustment. Sources vary from parts being setup with the wrong GL account associated with it, receiving core issue (very outgoing value) and overall random issues. We’ve been on Quantum accounting for 12 years – it is better than it was in the beginning but we still have issues every month.
-
As a word of advice – the enhancement requests tend to be directed from the Que Group board – it tallies the submissions during Que Group to come up with the short list of items that affect all users. If i had a bit of advice if you really want something then make connections at the Que group and sell your idea to others and co-ordinate the submission (in all seriousness you may want to write the submission down and give the “idea” to others to write down on the surveys). A co-ordinated effort would easily make it into the top 5 requests as individual submissions tend to be thought of during the moment and a lot of people tend to miss what they truly want in enhancements.
-
i would like a copy as well. Thanks.
-
Overhead rates are entered in with the Skills under the setup menu. As you enter in Skill burden rates you will find Fixed and Variable rates underneath that will populate as you use the individual skills.
-
Similar to part warning on individual stock lines you can click on the “hold line” flag which should block most activity related to the unit – not sure it will for your requirement but it may. I don’t know of a blanket solution but this may help if you have individual items you need to block.
-
The report has been forwarded to you both. I’m an accountant not an IT person so I tend to use tables instead of SQL commands. It can probably be done more efficiently but it is fast to run anyway.
-
Thanks Andre – looks like we will be staying on 10.5.59 for another while. Foreign currency does tend to be an ongoing issue for some reason.
-
Abigail – not sure I 100% understand your question but the core returned serial number comes from exchange.core_serial_number – not sure if that was an oversight. The connection to the exchange table is through the SOD_Auto_key.
-
I have an open core report that shows exchanges and returned cores that are blank (essentially an open core report) but it is for open cores. I’ll send you it – it may help you in designing a report as it already has the table connections in the background. Basically if you have it for all cores instead of open you will be able to see all cores and the serial numbers of the returned core that came back.
-
The only way I can think of that can trace what John Doe has done on WO’s in a day would be in the Time and Attendance module. If he had scanned into the system you could see what work he has done on which WOs. It is good information but it requires the module to get to it (as far as I know). We have the module and that is primarily what we use it for. In conjunction with Crystal Reports and the report scheduler we have daily reports that go to our managers to show them what each of their employees worked on throughout the day.
To Megan’s point though I don’t think you can get everything you listed above in one report because essentially they involve different work functions. For instance our floor people don’t tend to change the status of WOs – they change tasks within it but not the status itself. It would require a few places to look or a few reports.
I hope that helps.
-
Under the General Ledger Utilities there is a GL account merge so accounts you think were redundant but had activity can be merged. (Not sure if this is an admin function or not). User>System Setup>Maintain System Tables>General Ledger Utilities. One word of caution is if you ever think you need to reconcile back to these numbers in these accounts you should have a GL extract over to a Access database or similar so you would still have access to it. Once the GL accounts are merged it does it for all – past and present.
-
Not sure if it makes you feel any better but CC wrote a summary report for us that pulled a bunch of general ledger together for us a couple of years ago and during the last upgrade the report stopped functioning. We have been over 6 months trying to get it fixed by them even though they tell you the reports they write for you are supported for future upgrades. You get tired of complaining to get it fixed after a while and learn to live without it. I think that is the new strategy there in terms of how work load is dealt with – eventually the customer will get tired of complaining and will just stop.
-
We aren’t in Europe but we are in Canada and we sell in US dollars and our home currency for taxes is Canadian. If I had my time back I would have set up our base currency in US dollars and done monthly currency conversions for tax agencies on a spreadsheet. Most of the reports and forms in Quantum assume you are using US dollars as currency. We have customized a lot of our reports separately through Crystal Reports to get around the currency issue. Reports in our home currency are useless as we sell in US dollars. I’ve tried to bridge this with CC many times as I feel the software should be accommodating to international companies. CC only offers reports to handle the conversion on a pay for basis. I’m not sure if that advice helps but I did make the recommendation to another Canadian company and they setup in US dollars and get all of the functionality from CC that I don’t get and its all for free. Tax agencies will accept a monthly conversion so it’s the best of both worlds.
-
We are currently looking at scheduling and planning as well. I was wonder if anyone used (or tried) to used the Microsoft Project functionality and if anyone has experienced any success with implementing it? Feedback would be appreciated .
Leo
-
I appreciate the second opinion. I keep thinking of it then backing away from it as I keep poking holes in my own logic. Maybe it is better to go a bit more comprehensive. Thanks.
-
Hey Paul,
Trying to get visibility to the number of transactions posted (by line) for AP. It is a a fair amount to harness as AP do reconciliation of the RO, PO items, deferred receiver transactions as well as items that are data entered. Any help would be great.
-
We use exchanges from lots and do core charges. We do not use the lot module to calculate the payable to the consignee. We use manual calculations based on the consignment code. It’s a work around but it is more accurate.
-
We’ve recently gone live with Time and Attendance but do not currently use exports. We’ve noticed that the module will pay both approved and non-approved hours into the payroll export. Are we the only ones who noticed that or is it something in our setup?
-
I found the solution to my problem about an hour after posting. You can connect GL_TRANS directly to CONSIGNMENT_CODES via CNC_AUTO_KEY. The crystal reports works correctly after making this change.
-
this worked great – thanks
-
Thanks Kevin. I stumbled upon the same solution as you while experimenting with those tables in Crystal. 😀