• Error during AP Payment Import

    Hi all, While importing AP Payment, I encounter this error "The bank code and bank currency combination does not match that of the batch". However, the batch is still imported with all (total = 3) of the entries. I do not understand what does…
  • GL Batch Posting Error: Period 1 in fiscal year 2024 is locked for General Ledger in Common Services' Fiscal Calendar.

    Hi There, I am new in a company and Sage 300 premium. July is our period 1 for the new fiscal year 2024. There is no accountant in the company in July, hence nothing posted in GL in July. When I posted AP source entries from GL batch listing, this is…
  • Sage 300 AR Credit Card Receipt - can't post

    I have an AR receipt entry with a cc charge that has been settled but the receipt entry will not post. The charge was applied to two invoices. Before the batch was posted, another entry was made to those two invoices with a credit note applied to them…
  • 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 previously…
  • 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…
  • 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…
  • 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
  • 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 when she…
  • 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?
  • Force Zero Quantity in A/R Invoice

    Sage 300 2019 PU 5 How to force a zero quantity in A/R Invoice using item detail type where the Invoice has an Extended Amount >0? Using summary detail type is not an option because there are other Items to be loaded on the same Invoice. Using Quantity…
  • Why I export and import batch payment batch list as payment amout is double.

    Why I export and import batch payment batch list as payment amount from older batch payment amount is double payment amount but in detail is not double double all entries in misc.payment. I inqured excel template is the same as old template. or…
  • System error. Call to lnkCommitTrans failed [227]

    Hi Am getting this error when adding or posting an AR Invoice batch in Sage 300. System error. Call to lnkCommitTrans failed [227] I recently did a database move using the dump and load. Now my AR batches dont want to post. What could be the…
  • A/R invoice reversal

    A number of invoices were added in may however some of the may invoice dates were dated Jan so it ended up in Jan. The invoices were reversed in the general ledger since there were already posted. when the ages trial balance was run for the customers…
  • Vender Ledger

    my predecessor & I are preparing for my 1st YE. We were looking for a Vendor Ledger and can't seem to find where it could be located. Can anyone point me in the right direction? Please & Thank you...
  • Error while posting invoice generated from PO module

    Hello, While posting an invoice generated by the PO module, i'm receiving an error message in AP module. The error is not clear and is generic. "Error occurred during posting batch(es)". The receipt entry went through without any issues and I can see…
  • How to enter TD1 in payroll

    We're stuck on how to enter a new TD1. We have the basic amount ($12069) and the employee filled out $10150 for Tuition amount. If we put the amount $10150 as TD1 - Tuition and Edu in Sage 300, is the amount on "TD1-Total Tax Credit" in Sage (12069+10150…
  • Prevent Duplicate Invoices Across Companies

    FormerMember
    FormerMember
    I already have the default setting that prevents an invoice from being entered twice, but is there a way to extend this to prevent duplicates across all companies in our system? Almost all of the bills that come to my office are addressed to 1 company…
  • People posting to invalid GL accounts

    Is there a way to prevent people from posting to invalid GL accounts from the subledgers? When people are in AP coding invoices or in Credit Cards they are creating accounts that do not exist in GL resulting in several reclasses each month. Is there a…
  • Bank Reconciliation Out of Balance

    I reconciled on 4/30/18 and all was good. Then i realized a bank transfer was entered twice, so i entered a transaction going the opposite way to clear one of them out. When i reconcile the statement for 5/3 and select both of the transactions it shows…
  • REVERSING CLEARED PAYMENTS IN A/P

    FormerMember
    FormerMember
    I'm not sure why we can reverse A/R payments and not A/P payments? I have had situations where we have prepaid items and then for whatever reason the funds were returned to us at a later date after I have reconciled the account. Then I have to do a debit…
  • Multiple Year Ends in same Fiscal Year

    Does anyone know of a fast way of closing a general ledger in the middle of a fiscal year. We have a client that was purchase and they have to do a deemed year end. I know we could just do a journal entry to close but I just wanted to inquire is there…
  • Order Completed status: Included vs Not Included

    Can anyone tell me more about the difference between Complete/Incomplete orders with an Included / Not Included status? The incomplete changes to complete when an order is posted, but I am not sure what the difference is between the Included and Not Included…