• AR Document Inquiry not behaving

    V2020 PU8

    For Admin AR Document inquiry works fine.  For another user and even a new user I made when I click on entry field it says Entry 1 does not exist     

    A/R Receipt Entry - well it does exist and I can go into batch and entry on Receipt Batch List…

  • On Journal Entry, Rate value is different from the other item line

    Hi all,

    my customer is making a journal entry when this happen. Please refer to the Rate column and the cell value in red rectangle. The value of the rates on this column are prefill accordingly. But the value for the last item line is different from…

  • Reverse AR Miscellaneous Receipt - GL additional line with no GL Account and amount

    Why is there a extra line in the generated GL Journal with no GL Account number and amount from the posted Reverse Transactions?

    Original posted AR Miscellaneous Receipt with no Customer ID.

    The generated GL Journal entry cannot be posted.

  • Bank Reconciliation: Quick Clear Function

    Hey SageCity Members, 

    I am using bank rec for the first time in Sage 300 2021 Premium.  However, we noticed that some of the transactions in the bank rec doesn't have transaction numbers. 

       

    When we try to use quick clear for range of withdrawals to clear…

  • AR adjustment batch and bank

    We are processing credit card refunds in SAGE 300 by entering Customer account credit in adjustments. Everything is fine but those adjustments are not affecting Bank in Bank services so Bank balance in Bank services and GL do not match. We are doing bank…

  • Vendor Number Change causing a Payment error in bank services and corrupting data

    We have a client running Sage 2022 PU 1.  They consistently use the Vendor number change program to combine or change Vendors.  When this is done before bank reconciliation, they get a payment not found message when they try to post their Bank Reconciliation…

  • Bank Reconciliation posting error: Requested payment was cleared previously

    We have been working with a customer who has had some issues with their bank rec.  We have worked through their issues and are at the point where we are ready to post the reconciliation and we have received this error:

    Requested payment was cleared pr…

  • exchange rounding account is not defined for account set

    Client is trying to reverse a payment in bank services, They are getting "Exchange Rounding Account is not defined for Account Set...

    Problem is, client is not using multi-currency and there is no option to even add an exchange rounding account…

  • 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

  • A/R deposit shows Not Posted in bank rec

    We have a client running Sage 300 v2021.5.  They have an A/R Receipt batch that was posted in A/R, but in Bank Services bank rec screen, it shows as ‘Not Posted’. 

    Because of this status, they cannot clear the deposit in their bank rec.

    Has…

  • Cash receipts short pays

    Hi, we frequently get small short pays from our customers for different reasons. How can we enter them at the time of doing the receipt entry? Is it possible to select the GL account to use? Ty.

  • 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…

  • Changing a Payroll Earnings Code Frequency

    Can I go into the database and change a Payroll Earning/Deductions code frequency? Will it cause integrity errors if I do?

    Sage 300 2019

  • overflow. maximum entry has been generated for batch

    I have a client whose  Accounts receivable batches have not been posting to GL as there was a post in progress batch. I resolved the batch - closed period but when the next batch is posted, the system is processing all the hanging batches and then throw…

  • AP discount - force it while creating payment batch

    Hello, is there any way to force an AP discount (ie: 2% 10/net30) while entering a payment batch, without changing the system date? Thanks.

  • UK MTD for AP invoices posted in currencies except GBP

    HI,

    I am setting up a UK company that needs to submit VAT MTD returns. Does the Sage 300 MTD module that comes with v2022 work with other currencies besides GBP? I am posting some AP EUR invoices and it seems that the VAT Return icon reports these as…

  • AP system generated payment batch limitation

    Is there a workaround or third-party solution for the limitation with AP system-generated payment batches being limited to only one at a time?

  • Uploading excel journal entries into sage 300

    I'm new to Sage as well as this forum.

    can i automate an entry that is both reoccurring and reversing each period?

    How easy is it to upload excel journal entries into sage300?

  • Reverse revenue recognition in PJC

    Hi All,

    Can I reverse revenue recognition in PJC? The contract use Billing and Cost accounting method and the Project type is Fixed Price.

  • AP automation solutions

    Hi, does anybody have a recommendation for this? Ty.

  • Bank Entries doubling up

    In Sage 300 version 2020, I have seen in the last 2 days, bank entries doubling up.  A entry was done as a withdrawal for 200 and it shows in the bank rec. as 400.00 , and an $100.00 entry was showing as a 200.00 entry on the reconciliation tab.  When we…

  • PO invoice reversal

    Hello,

    Is there a way to unmatch a PO invoice already posted without going doing a credit note? More specifically, the person match an AP invoice in PO invoice in PO module by error.

    Thanks,

    Helen

  • PJC Module - Accounting method

    Where do i see the accounting entries of AP and AR transactions for a project configured as "completed project' in PJC accounting method?

    For example, i create a new project in the contract maintenance and set the accounting method as 'completed…

  • WO adjustments showing no amount in AR aging

    Good morning,

    During our migration to Sage300 the consulting group left a number of WO with blank amounts in our aging report. How can we get rid of them?

    Ty.