141 results found

1. On-Line Credit card Processing Allow Editing Receipt's Comment

   Currently Elliott defaults on the Credit card receipt "THANK YOU" and on the 2nd line "PLEASE COME AGAIN". User might want to change.
   I suggest to add a field with 3 lines in the Global Setup of the CC Online setup for the required greeting. It can be defaulted to the current greeting but user can change. Also allow to leave blank if user wants to use Laser design.

   •  

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

   This change is complete and will be available in the next Elliott release. See http://support.elliott.com/knowledgebase/articles/1921579-feature-custom-receipt-comments-in-on-line-cred for more information.

2. Extract an indented Bill of Material from Elliott to CSV

   I see that there's a CSV option for single level Bill of Material but not for indented. Is there a way to extract an indented Bill of Material from Elliott to CSV? The output layout will similar as single level Bill of Material but need adding extra columns that includes "Report Line Sequence number" to keep whole report can be restored to original sequence after sorting from different way on spreadsheet. Plus, fields of "Stock Flag", "Control Flag" and "P/M Code.

   3 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

   This change is complete. The feature will be available in version 8.5. See http://support.elliott.com/knowledgebase/articles/1918618-feature-indented-bill-of-material-csv for more information.

3. Removing Line Item With Restricted Attribute On It

   We have never been able to remove a line item off of an order in Order Entry if there's a restricted attribute on that item. For instance, let's say there is an existing order and a restricted attribute has been added to a certain product line, etc. that prevents that customer from ordering it. The order will get thrown on hold at the time of a picking ticket. If we go into that order in Order Entry to delete it, it won't allow us into that line item. The only way to remove it is to take the restricted attribute off of the item or customer, remove the item(s), and then remember to put the attribute back on. It would be nice to be able to remove that line item without going through multiple steps.

   We have never been able to remove a line item off of an order in Order Entry if there's a restricted attribute on that item. For instance, let's say there is an existing order and a restricted attribute has been added to a certain product line, etc. that prevents that customer from ordering it. The order will get thrown on hold at the time of a picking ticket. If we go into that order in Order Entry to delete it, it won't allow us into that line item. The only way to remove it is to take the restricted attribute… more

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

   This change has been completed and will be available in the next Elliott release.

4. Show Item on stock Status if Qty On-Order/Allocated > 0 and Qty On-Hand = 0

   In Stock status Report, if user answer Y to field 8 (Exclude Zero Qty Items), and Qty On-Hand is zero, Item is not on the report, even if Qty Allocated or Qty On-Order are > 0. I suggest to allow user to see these items by adding a prompt on the Stock status screen or adding a Global setup field.

   3 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

   This change has been completed and will be available in version 8.5. See http://support.elliott.com/knowledgebase/articles/1919716-feature-stock-status-reports-add-include-with-al for more information.

5. Ability to mass update tax codes (1,2 and 3) through Mass Change Customer CSV Import Layout

   As sales tax laws are changing, we are having sales tax liability in more and more states. As we need to re-define our tax codes setup and create new codes, it would be helpful if we could mass update the three tax codes using the customer CSV import file. Currently tax codes are not one of the available import fields.

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

   See the following KB article for more detail: http://support.elliott.com/knowledgebase/articles/1911475-feature-add-support-for-customer-tax-codes-to-th

   System is also able to perform auto assigned tax code if auto assign ability is setup.

6. Import Shipment Tracking Number to Elliott through CSV File

   It has been suggested that Elliott should support importing of shipment tracking number for sales order through CSV File. The CSV file should contain the following fields:
   Order# String Sample 123456 (pad leading zero if numeric)
   Package# String Sample 1
   Tracking# String Sample 1Z92752E0300860395
   Weight String Sample 1.00
   Freight Amount String Sample 15.23
   Ship Via String Sample UPS Ground
   Ship Date/Time String Sample 8/23/2017 1:00:00PM
   Reference String Sample 123456789

   Not all fields need to be provided. Only the Order# and Tracking# is necessary. If the Package# is not provided, then it is assume 1. If the weight is not provided, then it won't be written to note, same for freight. If Ship Via is not provided, then we look up the ship via description of the order. If Ship Date/Time not provided, we use the current system date/time. Reference is to update Note Subject. It can be blank.

   We need to prevent duplicate note. Therefore, if there are multiple records for the same sales order, then we may need to add 1 second to time until no duplicate value.

   The import screen shall prompt for:
   CSV File Pathy & Name:
   Does Import File Has A Header Row?
   Note Type: (Blank Allow)
   The above value will be saved and used for the next session default.

   It has been suggested that Elliott should support importing of shipment tracking number for sales order through CSV File. The CSV file should contain the following fields:
   Order# String Sample 123456 (pad leading zero if numeric)
   Package# String Sample 1
   Tracking# String Sample 1Z92752E0300860395
   Weight String Sample 1.00
   Freight Amount String Sample 15.23
   Ship Via String Sample UPS Ground
   Ship Date/Time String Sample 8/23/2017 1:00:00PM
   Reference String Sample 123456789

   Not all fields need to be provided. Only the Order# and Tracking# is necessary. If the Package# is not provided, then it is assume 1. If the weight is not provided,… more

   3 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

   This feature will be released in the next 8.5 update.

7. Create an Event to Print Duplicate Invoice

   We have the event to Print invoice. There is no event to Print Duplicate Invoice which is a different program and the recommended method when using Post Office. I think we should have the Event for Print Duplicate Invoice as well.

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

   This change has been completed. It will available in the next Elliott general release.

8. Attribute screen - allow keyboard entry in date fields.

   Attribute screen - allow keyboard entry in date fields.

   Currently, user must choose date from calendar/date picker control. Would like to see ability to simply enter date via keyboard input.

   4 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

   This feature had been implemented in Elliott 8.6.

9. Date of Last Manufacture listed on Costed Bill of Material Report

   It would be helpful if the Costed Bill of Material Report for a manufactured, stocked item included the date last manufactured.

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

   This change was completed on 3/14/19 and will be available in the next Elliott general release after this date. See http://support.elliott.com/knowledgebase/articles/1904896-feature-added-csv-file-creation-to-print-costed for more information.

10. Cancelled PO Line Printing

    When printing a PO with cancelled line or lines, the presentation is misleading and might cause an error on the vendor side. As we know Elliott print Cncl literal on cancelled lines but shows the quantity and the line total amount. The lines are not added to the total but I don't think its is enough, After cancelling the line, user cant even access field 19 and enter a comment. I think that the qty should be presented as 0 and the total line as zero. This is an old Macola behavior that we lived with and maybe it is time to change. If I am not correct the explanation was that we want to show the vendor what was originally on the line. The risk of the vendor sending a cancelled line, doesn't justify it.

    When printing a PO with cancelled line or lines, the presentation is misleading and might cause an error on the vendor side. As we know Elliott print Cncl literal on cancelled lines but shows the quantity and the line total amount. The lines are not added to the total but I don't think its is enough, After cancelling the line, user cant even access field 19 and enter a comment. I think that the qty should be presented as 0 and the total line as zero. This is an old Macola behavior that we lived with and maybe it is… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

    This change has been completed and will be available in version 8.5. See http://support.elliott.com/knowledgebase/articles/1921090-feature-print-warning-msg-for-cancelled-po-line for more information.

11. Order Import - add an option to move a GOOD file to a folder

    When doing Order Import, Netcellent introduced new flags, 26 and 27 that handles the move of a file with errors to a different folder, this is a good feature. For good files. Elliott deletes the import file. My understanding from a conversation with Mark is that this logic of NOT archiving the import file is because of the assumption that the file already created in an EDI system and exists there. But if the import is NOT from EDI (maybe the partner created it in the required format), forcing the user to save it in 2 places is an extra step. I suggest to add 2 flags, "Move good files to a folder?" and the folder location. If user answer N to the first question continue to delete the file, but user will be able to save the import file. There is a point of the file name (in case the same file name is used), so adding a date-time stamp to the file name will prevent overriding previous files. Thanks.

    When doing Order Import, Netcellent introduced new flags, 26 and 27 that handles the move of a file with errors to a different folder, this is a good feature. For good files. Elliott deletes the import file. My understanding from a conversation with Mark is that this logic of NOT archiving the import file is because of the assumption that the file already created in an EDI system and exists there. But if the import is NOT from EDI (maybe the partner created it in the required format), forcing the user to save it in 2 places is an extra… more

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

    This feature is available in Elliott version 8.29.212. See http://support.elliott.com/knowledgebase/articles/1896151-feature-move-successful-order-import-files-to-se for more information.

12. Support eContact Integrity Check for POAUDHDR

    I ran eContact Integrity Check (SYCNTCHK) and find out that the utility does not support POAUDHDR. See attached screen. I suggest to support this table with eContact Integrity Check.

    •  

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

    This change is complete and will be available in the next Elliott release.

13. Import To Remove An Attribute

    Currently we have the ability to do a mass add or update via the Attribute Import, but I'm not aware of a way to mass remove an attribute from customers, items, etc. through Elliott. Is it possible to add that feature to the Attribute Import module?

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

    This change has been completed and will be available in the next Elliott release. See http://support.elliott.com/knowledgebase/articles/1894678-feature-allow-mass-delete-of-attribute-records for more information.

14. Allow to use wild card file name and multiple path when attaching documents in Elliott Post Office

    Elliott allows to use a variable on the Attach... field when sending a Post Office email. For example the variable InvNo will automatically attach a document with the invoice number as the file name. This is NICE. I suggest to allow multiple path in case the documents are in different folders and to allow wildcard. So instead of $InvNo$.pdf I can define $InvNo$.. For example if the invoice number is 123456, Elliott will attach 123456.DOC, 123456A.PDF etc. In addition user should be able to define different path so it can be something like M:\ELLIOTT8\DOC1\$InvNo$., M:\ELLIOTT8\DOC2\$InvNo$.,M:\ELLIOTT8\DOC3\$InvNo$.. In this example, Elliott will attache any document that has the invoice number as the first characters in the file name. If the multiple path is complicated, I think that one path is acceptable.

    Elliott allows to use a variable on the Attach... field when sending a Post Office email. For example the variable InvNo will automatically attach a document with the invoice number as the file name. This is NICE. I suggest to allow multiple path in case the documents are in different folders and to allow wildcard. So instead of $InvNo$.pdf I can define $InvNo$.. For example if the invoice number is 123456, Elliott will attach 123456.DOC, 123456A.PDF etc. In addition user should be able to define different path so it can be something like M:\ELLIOTT8\DOC1\$InvNo$., M:\ELLIOTT8\DOC2\$InvNo$.… more

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

    Project completed and available in the current Elliott release. See KB article:  https://support.elliott.com/knowledgebase/articles/2001877-feature-use-wildcards-and-multiple-paths-in-email

15. Remembering Default for Aging Report

    We would like to know if it would be possible to "remember" the parameter for the Aging Report field 1 to either D or S, instead of having to change the parameter every time. We always run the aging report by detail and the default always comes up as an S for Summary.

    •  

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

    The change is complete and will be available in the next Elliott release. See http://support.elliott.com/knowledgebase/articles/1888642-feature-aging-reports-store-detail-or-summary for more information.

16. Inventory Transaction Inquiry Drill Down to Material WO should show added/changed transactions

    Currently if an item is added to a material work order at the time of receipt thru production transaction processing the drill down from stock-status-inquiry does not display the item that was added. Instead it seems to display the work order as it was originally created. Inventory transaction audit report displays the correct transaction.

    •  

    •  

    •  

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

    This change has been completed. A new F7=Material Used option will be available from the Material Work Order Inquiry screen. This feature will be available in the next Elliott release.

17. Printing a proforma invoice

    Is there a way of printing a proforma invoice in another currency and being able to send it in postoffice?

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

    This project is already completed.

18. Item Generic Search to Show Item Quantity Greater than Zero Only

    It is suggested that in item generic search, we have the option to show item quantity per global setup. It is suggested that, we need to allow user to press a flag that only show those item quantity is greater than zero so customer service rep can focus on those item that we have on-stock.

    Currently, the bottom line of the item generic search can as following:
    Up, Dn, PgDn, PgUp, F4=Detail
    Up, Dn, PgDn, PgUp, RETURN To Select
    Up, Dn, PgDn, PgUp, F4=Detail F5=Wish List
    Up, Dn, PgDn, PgUp, F1/F2=Next/Prev Loc F3=Setup F4=Detail
    Up Dn PgUp/Dn F1/F2=Next/Prev Loc F3=Setup F4-Detail F5=Wish

    We can modify to allow F7 key which is a toggle key to display between showing Qty > 0 only, or show all items. See below:
    Up, Dn, PgDn, PgUp, F4=Detail, F7=Qty>0
    Up, Dn, PgDn, PgUp, F4=Detail, F7=QtyAll
    Up, Dn, PgDn, PgUp, RETURN To Select,F7=Qty>0
    Up, Dn, PgDn, PgUp, RETURN To Select,F7=QtyAll
    Up, Dn, PgDn, PgUp, F4=Detail, F5=Wish List, F7=Qty>0
    Up, Dn, PgDn, PgUp, F4=Detail, F5=Wish List, F7=QtyAll
    Up,Dn,PD,PU,F1/F2=Next/Prev Loc,F3=Setup,F4=Detail,F7=Qty>0
    Up,Dn,PD,PU,F1/F2=Next/Prev Loc,F3=Setup,F4=Detail,F7=QtyAll
    F1/F2=Next/Prev Loc,F3=Setup,F4-Detail,F5=Wish,F7=Qty>0
    F1/F2=Next/Prev Loc,F3=Setup,F4-Detail,F5=Wish,F7=QtyAll

    The F7 key will only be available if the Global Setup -> Dist -> I/M Global Control, field "4. Item Generic Search With Avail/Excess Qty" = "Y".

    The Qty to filter depend on whether we are displaying Item Qty Avail, Location Qty Avail, or Excess Qty (which is base on another Global Setup Flag).

    Special logic need to considerate when user press F5, there may not be any item qualify to display in some situation, and the program still need to handle it gracefully (maybe reverse the toggle key back after showing no item to display, because it obviously make no sense to display no item in generic search screen). Also, the search show base on the current pointer of item, not a starting over search when F5 key is pressed.

    It is suggested that in item generic search, we have the option to show item quantity per global setup. It is suggested that, we need to allow user to press a flag that only show those item quantity is greater than zero so customer service rep can focus on those item that we have on-stock.

    Currently, the bottom line of the item generic search can as following:
    Up, Dn, PgDn, PgUp, F4=Detail
    Up, Dn, PgDn, PgUp, RETURN To Select
    Up, Dn, PgDn, PgUp, F4=Detail F5=Wish List
    Up, Dn, PgDn, PgUp, F1/F2=Next/Prev Loc F3=Setup F4=Detail
    Up Dn PgUp/Dn F1/F2=Next/Prev Loc F3=Setup… more

    •  

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

    The project is completed and will be in the next release.

19. Prevent Duplicate Invoice Number in Elliott

    We will introduce a Order Invoice Cross Reference File to be introduced in Elliott 8.3. The file structure is as below:
    Order# Primary key
    Invoice# Primary Key, Alternate Key-1 (Allow Duplicate)
    Status Primary Key, Alternate Key-1
    Date Stamp Primary Key, Alternate Key-2 (Allow Duplicate)
    Time Stamp Primary Key, Alternate Key-2
    Sequence No Primary Key, Alternate Key-2
    Date Pick
    Date Selected
    Invoice Date
    Ship Via
    Invoice Amount
    Freight Amount
    Misc. Charge Amount
    Sales Tax Amount 1
    Sales Tax Amount 2
    Sales Tax Amount 3
    Payment Amount
    User ID
    Filler

    This file is to be updated at time of invoice printing as soon as the order record is rewrite. Keep in mind the first rewrite is to update the status from "S" to "N". Once user answer "Yes" to printed OK, there will be a second rewrite, which will change the status from "N" to "X". If user answer "No", then the second rewrite will change the status from "N" to "S". If user choose to void the invoice later on through the "Void Invoice" function, we will change the status from "X" to "S" as well. Once the invoice is posted, we need to update the status field to "Z". So the "Status" field could have value of "S", "N", "X" and "Z". We keep the record for "S" because an actual invoice hard copy was created. If user question why there's a hard copy invoice, but there's no record in Elliott, it could be because they answer "N", or it could be because they void the invoice. So having a table that show a record as soon as the invoice copy is printed will give us the ability to perform auditing better down the road.

    The primary key will show all the invoices had ever printed for this order.

    The Alternate Key-1 will show if this invoice had been printed. If yes, and the status is "N", "X" or "Z", then it will be problem. We should assign the next invoice number and check duplicate again. We will repeat this process until it is not duplicate and reflect ARCTLFIL for starting invoice number accordingly. The checking of duplicate invoice number should check CPINVHDR as well.

    The Alternate Key-2 is designed to show each batch of invoice printing (Date Stamp + Time Stamp). The Sequence No is to establish the sequence of printing within the batch.

    Because an order can be invoiced multiple times, so the following fields in the order should be saved with this file for better auditing:
    Date Pick
    Date Selected
    Invoice Date
    Ship Via
    Invoice Amount
    Freight Amount
    Misc. Charge Amount
    Sales Tax Amount 1
    Sales Tax Amount 2
    Sales Tax Amount 3
    Payment Amount

    At this moment, we only utilize this file to check duplicate invoice number during invoice printing. This feature does not apply to invoice history invoice printing, and pick up pending invoice printing.

    We may choose to support other functions in the future including: (1) Show all invoices for the order (including the not posted or abandon invoices); (2) Use it as invoice log. The difference with the existing CSV invoice log is that this one does not require user to turn on. Also, this one is an index file so we can provide the log with Elliott user interface.

    We will introduce a Order Invoice Cross Reference File to be introduced in Elliott 8.3. The file structure is as below:
    Order# Primary key
    Invoice# Primary Key, Alternate Key-1 (Allow Duplicate)
    Status Primary Key, Alternate Key-1
    Date Stamp Primary Key, Alternate Key-2 (Allow Duplicate)
    Time Stamp Primary Key, Alternate Key-2
    Sequence No Primary Key, Alternate Key-2
    Date Pick
    Date Selected
    Invoice Date
    Ship Via
    Invoice Amount
    Freight Amount
    Misc. Charge Amount
    Sales Tax Amount 1
    Sales Tax Amount 2
    Sales Tax Amount 3
    Payment Amount
    User ID
    Filler

    This file is to be updated at time of invoice printing as… more

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    4 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

    This change has been completed. It will be available in Elliott version 8.5.

20. Balance Sheet Net Income from Last Year - Fix Temporary Year End Out of Balance Issue

    For users who do temporary year end, from the time of temporary year end to the final year end, the General Ledger Balance Sheet will be out of balance.

    This is because the Balance Sheet Net Income (BSNI) only calculate the number from this year once you do a temporary year end. In the mean time, the detail transaction for last year is still there because final year end is not done.

    It has been suggested, that we can introduce another financial statement layout code:
    LYNI = Last Year Net Income
    This is similar to BSNI. But LYNI only reflect last year data. It will only have value after the temporary year end, before the final year end. If the value is zero, then do not print this line on the balance sheet at all. If you should include this code on your balance sheet (presume before BSNI) then your balance sheet will be in balance even after the temporary year end. Let us know if you think this is a good idea for you.

    For users who do temporary year end, from the time of temporary year end to the final year end, the General Ledger Balance Sheet will be out of balance.

    This is because the Balance Sheet Net Income (BSNI) only calculate the number from this year once you do a temporary year end. In the mean time, the detail transaction for last year is still there because final year end is not done.

    It has been suggested, that we can introduce another financial statement layout code:
    LYNI = Last Year Net Income
    This is similar to BSNI. But LYNI only reflect… more

    •  

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  AdminEdward M. Kwang - NETcellent System, Inc. (CEO / Founder, NETcellent Systems, Inc.) responded

    This change has been completed. It will be available in Elliott version 8.5.