Browse By Tags

  • Customer Ledger by Date

    Many of my customers receive recurring services, and often pay before the invoice is even issued. In the aged report, this creates a deposit line on the date of payment and then an applied amount after the invoice. Customers find the report impossible…
  • A/R Reports for a selected time period, including closed and inactive clients

    Is there a way to generate an accounts receivable report for a time period that includes matters that are closed or inactive?
  • Recording Payment with a discount

    When recording a payment and applying a discount, the message "remaining balance must not be less than zero" pops up on occasion. I know it is most likely a partial cent that isn't seen on screen but it is quite frustrating to have client accounts open…
  • Invoicing part orders that have a full payment allocated

    Hi All, We receive orders through our website, and the sales orders are entered and the payment recorded under the tick box "Record Payment with order" However, this has caused issues because we part despatch orders, and you cannot generate part invoices…
  • Integrity Summary inconsistencies A/R Prepayment account, Vacation pay, and Deposit Acct.

    Hi there, Our sage has multiple data inconsistencies due to high turnover in the office and having office staff attempt the bookkeeping. Due to this, i'd assume many incorrect entries have been made to cause so many inconsistencies. TOTAL DEBITS Data…
  • Make "One payment per Invoice" an option on the supplier record

    We have an issue where some suppliers included on the payment proposal need to be paid with one check for every invoice and some don't. It seems like the only option available for this is on the payment proposal ("one item/payment" check box), but this…
  • Recording sales

    Learn how to issue invoices and record money received in the 'Record Your Sales' support hub. Topics include: Quick entries Sales invoices Quotes and estimates Credit notes Matching invoices to payments and credits Selling overseas Visit…
  • Intercompany for payments

    in the same way that a sales invoice generates a purchase invoice in the reciprocal company, a payment issued should generate a payment received in the reciprocal company.
  • Paying invoice that has inventory

    Newbie here. When I go to make an invoice paid that has associated inventory items on the purchase it won't let me change payment to cash so my Bank reconciliation is off by these invoices. So the invoice stays as Pay Later. How do I make these payments…
  • Credit card journal entry

    Our employee bought parts with a company credit card. I need to add a journal entry manually for it which should be this I believe: Credit the Credit Card. Debit the expense account. Where it gets tricky is that I need this tied to the invoice…
  • Invoices are not settling when Payment Receipt Posted with full invoice Value. V7P9

    Invoices are not settling when Payment Receipt Posted. When user get POST the payment Receipt with full value of Invoice system not clearing the Invoices and Showing again for the payment & customer Statement. This issue we are experiencing from past…
  • How to solve ‘Accounting destination’ error while creating payments in Sage X3

    Hi all, I got the issue of Accounting destination error while creating payment receiving from an open item, we are in Sage X3 V12 Does anyone here know how to solve it? Thanks for any advice,
  • BSI : Add an option that the manual entry has a comment field that is also visible in the journal entry

    Some clients wish to enter a comment when allocation a payment manually (using "Manual entry" in the Advanced Bank Statement Import). It is possible to add a reference filed here, however this comment is not visible in the resulting journal entry. It…
  • Sales Order Entry / Totals Tab / PaymentObj

    I believe the Deposit Payment Type on the Totals panel and other data reside in PaymentObj. What table is associated with this object? Where/how can I find the data?
  • register manual checks

    Hi, I have a script to add manualChecks to Sage100. It works. I want to register the checks through in the code. I tried to do it with the code I used to register invoices: invoice.nSelectBatch(batch); invoice.nSetPostingDate("20270531"); invoice…
  • Add option in function advanced bank statement import to record manual payment and split the amount on several accounts in one journal entry

    When recording a manual payment in the advanced bank statement import and splitting the total amount on several accounts, X3 creates a single journal entry for every amount. This means that the amount on the bank account is no longer displayed as one…
  • How to Link a Payment Code to the Bank Reconciliation

    We are starting to do EFT(s) to process some payments. I usually create a batch of invoices and then create a payment batch, In the past they have all been to cheques so I select criteria and then process the cheques. Once posted they will appear in my…
  • Recording payments made

    There are a number of alternative mehods of recording money paid out by your organisation, find out which options are the best fit for you, read more >
  • Recording money received and money paid out

    There are several ways of recording money coming into and out of your organisation in Sage 50cloud Accounts. The following Knowledgebase articles give an overview of the different ways of recording these transactions in your software. Recording money…
  • Generate Encrypted Files to Banks

    We can generate 'txt' files for bank payments. Is there any way we can generate encrypted files for the bank from Sage X3. Any suggestions or option to achieve the requirements.
  • Adjustment & Void button for Credit Card Payments

    Sage should add an adjustment & void button for credit card payments like there are for checks instead of having to do journal entries to reverse entries. Thank you
  • HELP! Can I edit or delete a posted receipt in Purchase Order

    I receipted my purchase order and posted it in Sage 300 but I did not put the correct amount down and hence I cannot Invoice it. Is there a way for me to edit or delete the the receipt for the purchase order. Please help me ASAP. Thank you.
  • Add "Formula" field in Payment proposal function for additional user-defined filters!

    Add a formula field in Payment proposal function to help with adding user-defined formulas. For example, run Payment proposal based on Supplier categories, or Supplier Stat group 1 to 5, etc. Re, Victor
  • Namibia: FNB ENCR Payment File

    A new bank file for online banking Enterprise has been made available for download. Ensure that your directory is on Release 5.5a before downloading the patch file. The zip file contains the report files and information document. Please click here to…
  • A Factor per Company, or per BP

    A Factor set with a Factoring type at « Recourse » has to be linked to a Payment Bank. This is mandatory field, and is linked to a Company and Site code. There is a lack of set-up concerning the Factor, it should be possible to configure it by company…