• Can you reconcile E-Statements with Fifth Third Direct Bank that is different from Fifth Third Bank

    Hi,

    I have a client that would like to Reconcile E-Statements with Fifth Third Direct not Fifth Third Bank and they cannot. Does anyone no if Fifth Third Direct is supported?

    Thanks for all you do

  • Customer number change and National Accounts

    Client has a request to change the customer id but the customers belong to a national account.  Reason for the change is that the customers are changing affiliations and client built in national account identifiers in the customer number.  Most of the customers…

  • Accounts Payables discount not posting a Journal

    I have a client who's vendor is giving out some accessories with a 100% discount in a certain month. On Purchase order, the client is capturing  this accessories with the previous cost but discounting it at 100%.

    The challenge is and I stand corrected…

  • Bank Services Error

    So I posted a transaction in Bank Services (deposit) in January - it was the wrong amount (posted say $150 when it was only $100) - so I went in and reversed it and reposted the transaction with the correct amount. No big deal right? well now my boss…

  • Automatic Shipping and invoice Order Entry

    Here is our scenario. We give a customer a qoutation  in Order entry. The customer then goes to the cashier to pay or payonline. Then the receipt is taken back to our sales team to ship and create invoice. Isnt there away that at the time of paying the…

  • AR Adjustments

    How do you remove a posted adjustment in AR.  I had a xact that I adjusted incorrectly, entered the correct adjustment but left with an adjustment that is essentially hanging.  I can't adjust the adjustment because the document's balance is 0.  Any…

  • Mass Apply Documents

    Sage 300

    Any solutions that can Auto-Apply mass open documents for all Customers in the A/R?

    Credits (Open Receipts, CN etc) against Debits (Invoices, DN etc)  using a certain criteria e.g. Date etc

  • Sending Both A/R Invoice and Statement in the Same Email

    Sage 300 Cloud

    How possible is it to send both A/R Invoice and Statement in the same Email communication as separate attachments.

  • Timeout while sending A/R Invoices/Statements via Email

    Sage 300 2019 PU7

    While sending A/R Invoices/Statements via Email, the system sends some e.g. 50-90 and returns the Error below;

    "Description: Mail delivery failed. Use the Email tab on the Company profile screen to send a test email and confirm that…

  • Statetement designer - not updating current year figures

    Hello, 

    I am trying to run a an IS through the statement designer function in Sage 300 ACCPAC. August would be period 1 of FY2022, however when I select this period, all the figures that come back are 0. If I select period 12 FY2021, everything runs as…

  • Period locks change on upgrade to 2021

    I just upgraded a customer from Sage 300 2018 to Sage 300 2021.  After upgrading they pointed out that many of their "Locked" periods were now unlocked.

    In their old database in the CSFSCST table there are NO lock records for 2020, 2018 and 2016…

  • Sage 300 FR formula

    Hi there,

    I would like to create a budget report breakdown by month in columns side by side, what FR formula should I use for each column?

    Thanks,

    Zia

  • A/R Prepayments Payment Plan

    Customer Receipts are posted in the A/R as Prepayments because there is no Invoice.

    There is a plan on when and how much the Customer should pay.

    How can this Plan be managed in Sage 300 without raising an Invoice?

    An invoice is raised at the end when…

  • Currency Rate

    Hello Team,

    To receive the currency rate I use the following endpoint -> CSCurrencyRates

    The response has the following structure:

     {
                        "ToCurrency""CAD",
                        "RateType""AV",
                        "FromCurrency""AUD"…
  • FINANCIAL REPORTS IN DETAILS

    I have chart of accounts with two segments i.e MAIN & MAIN SUB

    1234 Repair and maintenance

    1234-01 Repair and Maintenance - HQ

    1234-02 Repair and Maintenance - TZ

    1234-03 Repair and Maintenance - ZM

     

    On printing financial reports only Main Accounts…

  • Tax Services Setup for Irish Entity

    Good day,

    Sage 300 2021 PU2

    I have a new Irish entity to setup which will be my first time setting up an Irish/European entity.  In looking at the VAT/Tax reporting requirements I was wondering if there were any samples out there of the Tax Services configuration…

  • Internal Error: field [25] of [AP68AOBP] is not a string field.-when using Vendor Number Change

    We have a client running 200 2021 with Product update 1.  On the machine that is the main one (server), they get the above message when posting a combine Vendor request using Vendor Number Change.

    Anyone have any sugeestions as to how to proceed.

  • Multicurrency with Multiple Entities in Single Sage 300 Database

    A company wishes to setup Sage 300 for their operations in 4 different countries, 4 different currencies all reporting back to a single currency.    There are two options

    Option 1:  4 different Sage 300 Databases

    Option 2:  1 Sage 300 database with a entity…

  • Moving some transactions from a Customer to another in A/R

    Sage 300 2019 PU7

    How can we move some posted transactions (Invoices, Debit/Credit Notes, Receipts etc) between Customers in Accounts Receivable.

    Break the Account move some and leave the rest.

    Without creating Debit/Credit notes.

  • Cannot export customers

    I have a client, where for a couple of companies, I cannot export the customer or ship-to records.  When I attempt to export my customers, the screen that shows the records, the first record should be customers, but it only shows a "-".  If I…

  • Box 52 Pension Adjustment not showing up on the T4

    We have 2 deductions set up for Pension.  One is for the Employee contribution, and one for the employer portion.  Both are set to 5% (Percentage of Base).  The employee portion is set to go to box 20 and 52, and the employer is set to go to 52 only.  They…

  • Payroll Transaction history and the ROE

    We have a client that noticed that the entries she is doing in history to update hours for employees are not being reflected in box 15C of the ROE.  They are using the latest payroll tax updates and running version 2020.

  • Can't add lines in AR invoice in Webscreens

    I have a client using Web Screens (V6.6) 1 of many users can't insert lines on an AR invoice in some companies.
    She can in one company, but can't in others. - I have checked permissions - all the same,
    I have tried logged in as ADMIN, and can't…

  • how to reverse a credit note on A/R

    hello,

    i would like to reverse a credit note done on a previous month. how can i do that?

    thanks

    eblim

  • Contract/Billings Module

    I have added a contract in the Contract Module and it has been approved.  But when I go into the Billings module, it is not listed as an active contract.  What step am I missing?