• Missing batch AR batch

    A customer reports that an AR batch is missing and didn't hit the customer records. They said it hit everything else. Is there a way to recover this batch assuming that the batch did affect IC, GL, and OE? I am still gathering info since it could be…
  • What is required to get OE Invoices to show in AR Receipt batch

    I'm trying to mark that payment was received for one of today's OE Invoices I've run I/C Periodic processing > Day End Processing, but the invoice does not yet show in A/R Receipt Batch Entry when looking up the customer. Is there an additional process…
  • PO Invoice posting error 'missing POR' Attempt to perform record Delete without security

    Hi Everyone Does anyone has a solution for the error for posting PO Invoice with the following message missing POR (1979 POINVM1.C) Audit Log Attempt to perform Delete Record without security....
  • Can unshipped lines be omitted from Shipment and Invoice tables

    Can Sage300 order entry be prevented from copying the unshipped lines of an order onto the shipment and thence to the invoice tables, while still retaining backorder quantities on the orders? We have a situation where each order includes many products…
  • Order Entry - Changing the Invoice Date After Posting

    I have a client that run some sophisticated daily transaction reports from Order Entry Invoices. Occasionally, an order in invoiced a date or two late and it throws off the reporting. Is there an easy way to change the invoice date. I do not need to change…
  • Sage 300 2018 PU4 PJC Performance

    FormerMember
    FormerMember
    Anybody have any idea about the Sage 300 2018 PU4 PJC Performance? Sage300 v6.0 performance is fine but slow after upgraded to v6.5 PU4 (Sage 2018). The PJC UI always become “Not Responding” (But NOT hang). The result will come out 5-10 mins for each…
  • Inventory Items - Last Sales Date

    Where can I find the last date of sale for particular item or items?
  • PO Credit note issue

    One of our user receipted a Purchase Order and invoiced it with an incorrect rate. A credit note was passed to the invoice. what is the correct procedure to invoice this again from PO side? Priti
  • Order Entry

    How many maximum lines can be entered in an OE Invoice? We have a document that should have more than 300 line items. Is this possible? Priti
  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…
  • Identifying Unposted AR Transactions.

    Is there any other way besides looking at the ARUNPSTH table to identify unposted AR Transactions? Is it possible for transactions to disappear from the ARUNPSTH table without a post being done?
  • Sales Invoices Report

    Hi, I am trying to make a Crystal Report that shows all the invoices and credit memos in Order Entry. Right now, I tried using OEINVH, but I don't see Credit Memos. Is there a way I can make a Sales Report that shows All Invoices with Credit memos…
  • Invoice Returned Receipts

    Hello, Kindly help me to resolve a PO Invoice Process Clarification in Sage 300 ERP 2016 version. What I did was, 1. Post PO Receipt 2. Return all quantities of above PO Receipt 3. Do the day-end process Then-after the returned receipt…
  • Change payment terms for vendors

    Hi all, I would like to enquire how can I change the payment terms for a vendor if my invoice for the vendor is already posted? I realised my invoices for some vendors have wrong payment terms and now my aging report is wrong.. So, is it possible…
  • Reports which shows non invoiced shipments

    Hi There, Is there a way to get reports that shows us only non-invoiced shipments?
  • Credit Note does not change QTY shipped, Ordered and backorder

    Hi, We have a situation where orders need to be partially shipped from an order entry. A credit note was passed on one line item. This however did not change the quantity ordered, qty shipped to date and back ordered quantity. initial order 100…
  • Office 365 and sending e-mails from Sage 300 AR

    Client just upgraded to Sage 300 version 2016 and Office 365. They send invoices from AR (they don't have PrintBoss) and are getting the annoying message "a program is trying to send a message on their behalf...." where they have to click Allow for each…
  • Stock take and data entry

    Hi Support, It is normal procedure to freeze all inventory transactions before generating the worksheet. Our month end inventory reconciliation last for up to two weeks. Is it possible to still post order entry invoices for the new month? What will…
  • A/R Invoice Posting Errors

    Hi, Have this error message in A/R Invoice Posting Errors: Invalid Input. Document currency (EUR) does not match customer currency (USD) Any idea? thanks for your help.
  • Order Entry invoice

    We are using sage 300 ERP 6.0 PU 2. Since this morning when invoice is printed, the print form becomes non responsive. It does not close automatically and needs to be closed from task manager. Kindly assist.
  • OE invoices not showing prepayments

    If I enter an order in OE and enter a prepayment and post the order, when I later invoice the order the prepayment is not shown against the invoice, but only on the right hand side of the invoice totals as an order prepayment. If I enter the prepayment…
  • How to link PJC to AR

    I'm to build a report based on project that lists all the invoices associated with that project - does anyone know what links I can use?