Jump to content

S n C

  • Posts

  • Joined

  • Last visited

Posts posted by S n C

  1. 10 hours ago, pyz01 said:

    Yes- the export of information via the csv format works wonderfully.  The problem is - the information of how much is spent with each supplier is still not available.  The journal only records the account that was charged.  If you have several vendors who you buy from and the journal is for Cost of Good sold -- you can see how much was charged to the account in total -- but you cannot determine which vendor it was from since that information is not captured in the journal.  Elk's suggestion is best - this is a simple thing and should be included in the software - and therefore a suggestion has been made to the developers.  Realistically - this simplistic report should not be difficult to make.   To get the information now - requires you to record each purchase in Excel - which is what I was doing before I started using the software.   To me, (and I could be wrong) it is an essential report that should be included. 

    Tab Purchases......

    Select Reports Payments of Accounts Payable.....then save file format CSV

    Develop using excel formulas as desired

  2. On 9/17/2021 at 10:26 AM, Socratease said:

    I have exported my customer list as a csv file when I go to import transaction as the directions state it will not import the csv file "no selection has been made" "Please assign at least one header to the file"  What am I doing wrong???

    Format error or data conversion error in database. Try using the modernCSV app

  3. On 9/23/2021 at 4:41 PM, Sarika said:


    I wanted to know how can we undo a bank reconciliation which we have done previous month ago since we need to add new transaction or edit.

    Its saying:

    Bank statement date cannot be earlier than reconciled date

    Please if someone can help as it's very urgent.




    The last date of reconciliation cannot be changed, but the new statement balance will be change if there are additional transactions or edits

  4. 13 hours ago, Yestin said:

    Thank Fred for your reply.

    Even after clicking on edit, the balance field still remains restricted to edit. I have already enter many transaction in the accout. So deleting will not suit me.

    Anyway if I am unable then one adjustment entry will work but it will look weird on statement.






    Use notepad ++, usually I use this if there is a problem that cannot be solved .... I'll give an example later.

  5. 6 hours ago, DannR said:

    Great workaround!!, in any case, NCH Software formally takes suggestions or feedback about our products through the form at http://www.nch.com.au/suggestions/

    Could be nice to send this kind of feedback.

    I don't think so. This happened when I wanted to switch to busy accounting software, but Busywin 21 was told to change the regional settings. So from that I feel I have to make changes to EA as well.

  6. On 2/20/2021 at 12:01 AM, r2d2r01 said:

    Very bad simple expression parser.
    It appears you can set a constant value but cannot use or do reference to it in other expression simple, only a function (roundup, ..)
    A -> expr simple -> 1000 => OK
    B -> expr simple -> 500 => OK
    C -> expr simple -> A-B => KO -> unrecognized field ERROR
    C -> expr simple -> A-1 => KO -> unrecognized field ERROR
    C -> expr simple -> Field5-1 => OK due to type of field5


  7. Simple Expression: This allows user to perform arithmetic operations. The allowed operators are +, -, *, and / for addition, subtraction, multiplication and division respectively. E.g., Field1 + Field2 gives you sum of existing fields Field1 and Field2.

    I have problem the custom reports, especially on the Simple Expression type fields, which allow the user to perform arithmetic operations. In fact, the name of the field I made was very simple, without symbols or special characters
    Information that appears
     "Unable to substitute the expression. Unrecognized field name(s) detected

  8. On 4/1/2021 at 6:14 AM, ZipTech said:

    Is this possible?

    It seems the reports show the Sales Taxes Collected based on everything that you have invoiced.

    I wanted to know how to see only the Sales Taxes Collected total based on paid invoices only.


    This cannot be done, because the payment that has been received will reduce the receivables based on the issued invoice. Here you can only see the difference between taxes collected and taxes payable. It is possible to do it manually to find out with the help of Excel through a journal stored in a CSV file

  9. non invoiced cash sales are transactions that occur directly, by inputting sales items using the cash payment system. If you only fill in the journal, then what is recorded is the transaction value and does not reduce the stock of goods. So if there is a sales transaction process that cannot be inputted directly (delayed by manual recording, collected first and then recorded) it can still be done on the next day, but just change the date in the journal according to the date of the transaction. This is better, because by recording non-invoiced cash sales, it can reduce the stock of goods that have been sold.

  10. Try using a custom report. Maybe a little help, so show what you want needed.


    But there are difficulties that have not been resolved here

  11. Can view, save, and print separate journal files but can't get all of them in one file .... This is confusing ... because if you can print separate journal files, of course you can print the entire chart of accounts on the accounts tab (All Accounts).

  12. Corky6458 used express invoicing and was always able to email invoices right from there. So in my opinion, he already understands how to arrange email invoice delivery. So I tried to help with the main problem that happened as well as helping other colleagues with problems that often occur here

  13. 7 hours ago, r2d2r01 said:

    Through EA ? ;)

    Yup. can you help create a custom report

    I have problem the custom reports, especially on the Simple Expression type fields, which allow the user to perform arithmetic operations. In fact, the name of the field I made was very simple, without symbols or special characters
    Information that appears
     "Unable to substitute the expression. Unrecognized field name(s) detected.

  • Create New...