• Calculation issues in exchange rate: AP Payment

    Making an AP Payment Entry to a foreign vendor in AUD. FJD is the local currency We are converting AUD 21,640 at a rate of 0.6620 per FJD The amount should be FJD 32,688.82 Sage300 calculated FJD 32,689.238 Is this because the decimal places are set…
  • Navigating between GL, AP and AR

    I am wondering if it is possible to navigate directly between the A/P ledger or A/R ledger and the General Ledger. For example, if I'm looking at an A/P transaction in the A/P ledger, is there a quick way to navigate to the resulting G/L posting? And…
  • #ofDetail Lines printing Cheques

    when I adjust the MaxDetails formula field in the APCHK01 crystal rpt for printing cheques it does not move the total of the net paid up. I have the section set to print at the bottom of the page. If I click that off the total will print directly below…
  • GL Transaction and AP vendor Transaction report totals do not match

    How can I filter both of reports to match the total. GL Transaction and AP vendor Transaction report totals do not match for same month.
  • Invoice Batch List behavior

    Good morning! Our accounts payable clerk has reported an odd behavior in a single company when she enters a record into a batch using the Invoice Batch List. Clicking the 'Add' button does not progress to the next blank record. Instead, the button changes…
  • Load Sample Data and Errors Open/Load View AP0220 and AP0222 - Closing UI due to failure activate Sage 300 data sources [A/P Vendors]. No problem other data just sample !!!

    Hi everyone, I have Sage 300 2022 in my laptop last Update and I get this error when trying to open Vendors. Similar errors with its related AR views ven opening Cusromers. Apparentlky its an issue related to Vendor Contacts (Customer Contacts) but…
  • 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…
  • AP Pre-Cheque Register cutting off information

    We have a customer running Sage 300 2019 , Product update 1 in a client server environment. The AP Pre-cheque Register, when it has more than 1 entry , does not display the first entry completely, it only has a line and the total, so it is not possible…
  • 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.
  • 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.
  • Checks were voided when trying to reprinting checks in AP Sage300

    The first time printing checks it did a print to file and did not print the physical checks. I went into reprint checks, I input the check range that should have printed but did not change the starting check number, so it voided the first range of checks…
  • "Description: Bank <BANKCODE> is not set up to use currency <CUR>.

    Getting this error when trying to delete an open batch. Any help is appreciated!
  • correcting payment made to wrong vendor. check was printed but not mailed

    An payment entry was made to the wrong vendor in AP. Check was printed but not mailed. Need to removed this check from Vendor A and enter the invoice and pay it under Vendor B I do see a selection called Reverse Transactions under Bank Recon. However…
  • A/P Importing Error - G/L account cannot be blank

    I am trying to import an A/P batch into Sage, I'm using the template downloaded from an already existing batch. The issue is when I select the file (Excel 200 format) and click OK an error window pops up with the G/L account cannot be blank message. …
  • Aged Payables Report - Functional Currency Issue

    I am trying to print the aged payables report in functional currency as at March 31. The problem is, that its showing some documents with dates after March 31, just because those documents were applied against prepayments with dates before March 31. This…
  • Vendors Single File CSV import with multiple contacts activated

    Hi all, Have a customer that imports new vendors monthly with a Single CSV file created from another system. When I try to import after upgrading there is a new table for Vendor_Contact_Selection because multiple contacts have been activated. The Status…
  • Subcontract adjustments

    I have a subcontractor who is supposed to provide materials & labor. Due to financial problems, he has charged materials to one of my supplier accounts. What is the best way to adjust the subcontract? Change order? Send subcontractor a bill?
  • Unable to find Prepayment in Reverse Transactions

    Hi, A user has entered a Prepayment in AP for a vendor. Now, they want to reverse it but it cannot be found in Bank Services -> Reverse Transactions. The prepayment in visible in the vendor activity and also has a balance. What could possibly be…
  • Revalue specific AP PrePayment

    Hi, Is it possible to Revalue a specific AP PrePayment? One PrePayment was posted with a wrong exchange rate. Now, the client wants to revalue this PrePayment so that the GL values are correct. Appreciate your input. Regards, Ubaidullah Nubar…
  • EFT solution that supports web screens

    Hi, We have a Sage 300 financial client that wants to move entirely to the web. Has anyone seen a web screen solution for EFT? We know that Orchid EFT isn't available in the web screens and isn't moving across soon. Thanks for any suggestions. William…
  • AP Paid Status Incorrect

    FormerMember
    FormerMember
    How can an invoice show a status of 'Fully Paid' but the distribution line (there is only one distribution line) show a status of 'Open'? The invoice is NOT paid, and shows in the Select for Payment screen. How can the 'Fully Paid' status be corrected…
  • Check numbers are skipped in a check run

    Check numbers skips when printing a check run in sage 2018 Update 4. This does not happen all the time but is a random event.
  • How to reverse a credit card payment that has been posted

    Hi, Could someone please help with a payment that was posted to a wrong vendor through the credit card. The payment had to be applied to a different vendor. Is there a way that I could unapply the payment to that vendor and apply it to a different…
  • 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…
  • Saving AP-GL Integration settings

    Hi, How can I save/export the GL Integration settings in AP so I can restore/import the settings to another company? Thanks & Regards, Ubaidullah Nubar.