Browse By Tags

  • How do US merchants handle their ecommerce taxes when creating orders

    Hi all, I have been stuck with a problem for a while and would be happy to pay for someone's time to help me come to grips with the issue. The background: I am developing an integration between Sage 300 and ecommerce sales channels like Shopify…
  • Pay now button on invoice sent by email

    Hello community, On SAGE 300, there is a way to have a "PAY NOW" button directly on the invoices sent as pdf to customer by email. Then when the customer click on it, he got redirected to a secured web portal transiting between Sage money and third…
  • Why does Sage 300 not seem to convert the unit weight when clearly using a UOM that is different than the stocking UOM?

    Sage 300 OE module has 3 units of measure per line. A pricing UOM, invoice UOM and costing UOM. However it does not have a weight UOM, so it is taking the unit weight (which is for the default stocking unit of measure, and not using the conversion factor…
  • Warning in quote/order entry if the cost is higher than the sell price on a line item or total

    Hello, I was wondering if there was a warning or notification that would pop up in the event a sell price is lower than a cost on a line item or total in a quote or order entry? Maybe something that comes up after a line is entered, before any quote…
  • 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…
  • How to do data filtering in macro VBA?

    Hi all, how do I do data filtering in macro? Lets say I want to filter by invoice number in OE0520
  • Delete Order Entry Transaction, along with its Shipment and Invoice

    Hi All, so one of my customer have done a wrong OE transaction, shipment, and invoice. They apply the wrong unit price, and this happen to a lot of transactions (4 days transaction) Is it possible to delete it, and delete it in a bulk? Thank you…
  • Sage300 Order Entry - maximum number of lines per invoice

    Does anyone know if there is a maximum number of shipments that can be on a single invoice, or maximum number of lines on a shipment.?
  • Sage 300 2019 - OE Committed Qty allowed even when there is no Qty Available

    My client is using Sage 300 2019 PU4. Allow Negative Inventory Level in IC setup is NOT selected. Some users are able enter the Qty Committed for an item for example, ‘N0006’ and insert and carry on with the order onto the next order line without…
  • ORDER ENTRY - PO NO. FIELD FORCES CAPITAL LETTERS

    FormerMember
    FormerMember
    Is there a way to disable the forcing of capital letters in the PO no. field within order entry? We have a partner who sends us PO numbers that contain both capital and lowercase letters. When we transmit through EDI back to them the information is…
  • Salesperson Code change restriction

    Hello, I need help restricting certain users from being able to alter the salesperson code on the O/E Order Entry level. I have found out how to restrict users from changing this on the A/R Customer level but cannot sort out where to make the change…
  • SAGE 300 SHIPMENT REVERSALS IN ORDER ENTRY MODULE

    Hi Guys, Is there a way of reversing a shipment that was done for wrong quoted items before the invoicing? The client does not want to create an invoice and then raise a credit not due to challenges with the tax man. Any help will be appreciated…
  • Order Entry Copy with Optional Fields

    How do you copy an Order in Order Entry and have the Optional Fields also copy? It appears to me that you may add them, but that must be manually done. Is there a way to automatically have them come across?
  • Qty committed to sale

    Hi Support, We have a client who used to use VM Service manager. which was linked to inventory and order entry. they have identified some items that have Qty committed to sale because of VM service manager. the items are old and need to be written…
  • 2018 PU1 very slow

    After upgrading client to 2018 users keep complaining of slow system. the following have already been tried with limited effect 1. only one path statement using DNS name 2. Increased cpu to 8 core xion 3.1 processors (both app and DB server) …
  • Flag old quotes as "Completed" for each line item

    FormerMember
    FormerMember
    Is there a way to set each line item in a quote as "completed"? I can do this with regular orders by zeroing out the quantities and then double clicking on "Completed" to change from "No" to "Yes". The reason for doing this is to keep the original record…
  • Delete an order item without user confirmation

    Hi, I'm developing an Order Entry macro, by using "AccpacOE1100UICtrl" object. This macro should be able to add an item and delete the item if the user selects a certain ship-to location. I'm able to add the item, but when deleting the item, the…
  • Finding Missed Preauth in Order Entry

    When the terms are credit card all orders in order entry should be pre authorized. Is there a way to find orders that should have a pre authorization and do not?
  • miscellaneous freight charges

    How do I see the activity for miscellaneous freight charges in order entry? The only report I see just lists the set-up information for miscellaneous charges.
  • How to process a drop ship in Sage 300 ERP

    What is proper way to process a drop ship in Sage 300 ERP? I was told from their support that you process that in Purchase Order, but how do you bill the customer without deducting from the Inventory Control module? What would be the proper steps…
  • Order Entry error - record already exists

    Hello, I am getting this error while trying to post an order entry: I tried entering a couple new orders and keep getting this error. I've never had this issue before; the order no. is set as ***NEW*** and I type in the Customer #, enter the PO information…
  • Back Dating an Invoice

    In the order entry, can you change an invoice date before creating?
  • Invoicing error

    Hello, I completed five order entries and generated the invoices for each; turns out I invoiced the wrong customers (the end users instead of the parent). None of the invoices have been mailed out; before going through the credit process cancelling…
  • Post OE SH Invoice

    Dear all i wrote a macro in order entry module the macro doing order entry and ship all when post the OE transaction in Macro its make OE, invoice and shipment automatically but the problem sometimes its make order entry only i must restart the server…
  • OEAUDD Table LINENUM field error

    - Client is on V6.0 - we have written a report that will pick up the optional fields from the OEINVDO table using the OEAUDD as the source as we require the fields from this table. - in the INVDD & INVDO table the LINENUM field increments as 32 /…