• 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…
  • AP Suppliers Refund

    Hello, i want to know what the exact process of recording suppliers refunds if we issue a cheque to supplier in advance and then supplier return a part amount from the cheque value?
  • 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…
  • AP and Job Distribution

    How do I correct where the retentioin amount was entered to the discount instead of the retention on the job distribution line when entering an AP invoice. This invoice has been paid. I need to correct the amount paid show in the job too. Thanks.
  • 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…
  • Accounts Payable

    I am looking for a work around to void a check in my current accounting period, that pays something in a previous closed accounting period so far back the accounting period can not be opened. What is my JE or work around to void check or to reinstate…
  • 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.
  • AP batch upload behavior problem in Sage 300 Premium 2016

    Hi, a customer is using Sage 300 Premium 2016 and they were wondering if it is possible to modify a behavior for AP batch upload. Currently when they upload a batch CSV if there is a problem with a particular AP invoice entry the upload will error out…
  • 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…
  • Can I process AP batches in October if September AP isn't closed yet without affecting each other?

    Is it possible to process an AP batch in October if the previous month (September) isn't closed yet? Would processing in October affect the September AP?
  • 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?
  • A/P Invoice Distribution (Coding) Change

    Hi, I would like to correct a previously entered invoice. The coding of the invoice is incorrect however I don't want to actually reverse the cheque, I just want to change the coding. Normally, I would do a JE to correct it however I would like to follow…
  • 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…
  • Intermittent issue - PO Invoice from multiple receipts,splits into multiple invoices in AP

    Intermittent. Job related PO Invoice for multiple receipts entered using drop down, the invoice appears to be OK but after day end the AP Invoices are split by receipt number with the same Inv#. This creates an Error batch in AP. V 2017 -PU6; cannot replicate…
  • 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…