Elliott Forum
115 results found
-
Add Items as available field in Invoice Line Item group report
I run many reports under Invoice Line Item with item no and prod cat. We have many prod cat so would like to also have prod cat group for consolidated totals.
2 votesunder review · AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) respondedin Elliott 8.6, we are moving toward using Report Desk to replace Export Processor. We can consider add Product Category as a group to UDR Invoice History by item Report.
-
COP Order Inquiry should show payment details including GL account
When COP Order is entered with an amount paid in the order totals screen we are able to enter the amount paid, Check No, Check Date and Cash account. However, after an order is invoiced this information cannot be retrieved. The information does not show in the Totals screen nor in the F2 Payments Screen. It should be available in COP order inquiry Totals or in the Payments Screen.
This would make it much easier to determine which GL account payment has been posted to.
1 vote -
Support UDR Sales History Trx Edit List Reports in Elliott 8.6
In COP -> Processing -> Sales History Trx Processing -> Reports -> Edit List, we currently do not support Report Desk. We are here proposing to add UDR support for Sales History Trx Edit List. One of the main consideration is CPHSTTRX table primary key begin with Invoice Date. Most of the sales history report are limited to a particular date range. Therefore, all sales history report will have a date range. Using CPHSTTRX table as the primary table for sales analysis will result in best performance. I suggest we also join to the following tables:
* left join CPINVHDR…1 vote -
Back order Audit Trail Report csv expot
We use the Backorder audit trail report to determine what orders are ready to be picked. However the report is printed in order by item instead of order-no.
Add an option to export to csv file so it can easily be sorted.
1 vote -
Add PR Distribution Report to User Purge Control
PR Distribution Report allow purge. But the purge is not controllable under Global Setup -> System -> User Purge Control.
It is suggested that PR Distribution Report be added to User Purge Control.
1 vote -
Order inquiry History file
Is it possible to copy and order from the Order inquiry History file?
This would be important because if you purge data from Order Inquiry
to the Order inquiry History file you will not longer have access to
be able to copy old quotes/orders. Please consider supporting this idea
as an improvement for all users.2 votes -
Inv/Doc Number not displayed in Mass PO Receiving
Inv/Doc Number should be displayed in Mass PO receiving as entered in the vessel file. Currently it displays as blank.
1 vote -
Ability to import batch of AP Manual Checks assigning check # by Voucher instead of by Vendor
Currently when importing a batch of AP transactions with manual checks, if there are multiple transactions/vouchers with the same vendor number, the system will assign one manual check number to all vouchers with the same vendor number. Would like to be able to import and assign manual check numbers by voucher.
This is useful in the scenario when we have a TPA writing checks on a separate bank account that is reconciled within Elliott but there is not a need to track vendor specific AP information.1 vote -
Print Line Item Case Quantities on Packing List Form
Many customer want to know how many cases of each line item are shipping but that detail is not printed on the packing list.
Through Global setup we can already print the total number of cases on a packing list. Ship verification already gathers the case quantity information.
Since Ship Verification prompts the user to print the packing list it would be extremely helpful to print the case information. Case quantity could print in the "QTY Shipped" column below the value for each and the UOM "Case" could print below the literal "EA" value.
2 votes -
Purchase Order Receiving
When receiving on a purchase order and it asks you if you're sure because qty is over ordered amount. Be able to put in a parameter such as 12% over, otherwise not ask. Or be able to shut off the warning all together. It's an industry standard on many items that it's ok to ship within 10% over of quantity ordered. Almost everything we receive is over so the warning really doesn't help. It would help better if we could set it up to show only at 12%. Then it would be a meaningful warning that would stop me from…
3 votes -
Synchronizing Item Description On Open Orders When Description Changes
Similar to how customer names synchronize to open orders when they are changed, we would love to see item descriptions have the same behavior. Occasionally, we have a large number of orders that are either in the warehouse or on back order and have the need to change the product description. This could be due to a change from a manufacturer once an item comes in or as simple as some information that is discovered to be wrong or has a typo on there. A prompt when changing the item description in Item File Maintenance asking if we would like…
2 votes -
GL Posting Audit Trail
I suggest to add Audit trail on the user that posts GL Journal Entry. I would add the user to the GLTRXFIL and GLJNLHST. Both have room (21 and 20 characters). We already have the logic to do it in the Inventory Transaction Audit Trail. SOX Controls requires that. Public companies must have it and I see the benefit for non-public companies as well.
3 votes -
F7 to show open and valid production orders to print
F7 to show open and valid production orders to print
It would be helpful to have the ability to “select valid” production order for printing
(Fields #3/#4) instead of always hand typing or selecting a range of production numbers.2 votesplanned · AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) respondedThis feature is planned in Elliott 8.6.
-
Reduction in data on a transfer ticket
When printing out transfer tickets is it possible for the accounting system to take into account the quantity of a component part
Already in the production bin such that it does not show/or that it is noted on transfer ticket briefly.1 vote -
Void AP Check with Vendor Number Filter Option
When user perform void AP check (AP -> Processing -> Void Checks After Posting,) it currently prompt for the followings parameters:
1. Cash Account No
2. Starting Check No
3. Ending Check No
4. Check Void Date
It is suggested that Vendor Number should be added as an additional filter to avoid user making mistake.2 votes -
Add Notes To Export Processor
The ability to export and filter Notes should be added to Export Processor.
4 votesunder review · AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) respondedThis project is declined because to export notes in export processor will result in poor performance because we do not use index in Export Processor. On the other hand, the Report Desk in Elliott 8.6 can be used to print or export notes to CSV or xlsx. So that's a better solution for a generic notes export function.
-
Add the AP Voucher Comment to the Extended (csv) Open Item
Information of the Voucher comment might be valuable. For example a foreign currency amount is entered under the Voucher comment.
3 votes -
Improve Inventory Transaction Audit Trail Report Performance If Selection by Date Range
If user choose to print Inventory Transaction Audit Trail Report for All Items of a single date range, the report can for run a long time as if it is stuck. See attached example.
General speaking, user will get good performance if they select for specific item number range. Running this report on PSQL server directly will be much faster. Also, purge older inventory trx audit trail records will also help to speed up the report. Netcellent recommend keeping inventory trx audit trail database for 3 years of history.
It is suggested that Netcellent should optimize this report's performance even…
2 votes -
Drill down to GL Source when doing GL Account Inquiry
The idea is to save the necessary extra steps that are currently required if user wants to get the full journal of a GL entry. Now the user has exit the inquiry, go to Reports and run a Cross reference report with the Cross reference on the inquiry in order to see the full journal. With tis idea user will able to "scroll" yo the trx and then hit F key to get the drill down to the source. Maybe we should do it only for GL sources.
3 votes -
Change Reset Allocation & On Order to Net Change Adjustment
Currently, the process to reset qty allocation and on order start the process by zero out all item and inventory location qty allocation and on order. Then it start to read the open orders to accumulate the qty allocation and order. Depend on users system, this process can take a few minutes to 10 minutes.
During this period, the system is vulnerable if another user is creating orders to change allocation and on order. That is the reason why we suggest user to run reset allocation and on order at night time through defer processing. However, some users is having…
2 votes
- Don't see your idea?