Sage 300

Hello, 6 weeks ago we changed the payables clearing account in all of our IC account sets to a brand new account. We see debit entries to the account but no credits. Has anyone experienced this? Ty.

In the order entry a user can capture and Order and flag it as onheld and post to an Account that has exceeded credit. Then a user with Credit Approval rights can log in to Sage and approve Credit Limit and remove the onhold flag and post. with this the…

Hi I created "Revenue Recognition", but i noticed that our job related invoices and time cards entries and receipts -Revenues- from our customers (projects) haven't shown up on the revenue recognition sheet for open contracts. What is wrong? how can…

My SAGE 300 is setup the way every time we enter receipt it will update vendor cost in Vendor Details. In general this is fine but lately we experiencing problem where PO’s are delivered after 3-4 moths and price is changing frequently, so old PO will…

Hello, Which table(s) do we need to use to link GL entries in GLJED back to the transactions in the subledgers? Ty.

Is there a way to adjust a BOM during a transaction. My client has a BOM that can use substitute materials. We are creating versions of the BOM for normal customizations, like using 50% of one material and 50% of the other, but they can make many versions…

Hello, We are getting this message in OE invoicing. The message indicates to use the email tab on the company profile screen to send a test email. Can anyone indicate where that option is please? Ty.

Hi, Is there a way to add lines to an invoice that is being created from an order receipt? Thanks.

Hi, We have allowance discount in an order. We used a negative quantity with a positive amount to reflect it. After the order was shipped, we were informed that the amount of the discount had changed. We changed it in the invoice entry screen, and…

Hello, We have product sales that are being posted to different revenue/COGS accounts than the ones defined in their categories. Has anyone have this happen? Thank you.

Hi I recall receiving this error on an old version of sage 2012. We had to run a hotfix to fix Now on 2019 PU2 we have the same - customer uses FIFO costing Please advise how to fix IC is set to run dayend on posting

Hello, I know we can create a PO from Sales Order, but is there a way to create a Purchase Requisition from a Sales Order? Thank you, Helen

Hi, Last month our GL and valuation report balanced. This month is off by a large amount. How can we pull the transactions in IC that updated (or not) the GL? Our GL report shows PO receipts, IC shipments, IC transfers and IC adjustments. These adjustments…

Hi all.. May I know how to handle or is there any work around to create multiple invoices against one shipment in Sage300? For example, 1 shipment from 2 orders, and there are 2 items in this shipment from each order. Need to bill the customer separately…

Hi, we have an IC-AD transaction in our GL that we need to track to the original inventory transaction. How can we accomplish this? Thanks.

We have an issue where in Order Entry when we enter an optional field and the Ship-To location is changed it wipes out the optional field. Is there any way to stop this from happening? Sage 300 2019 Windows Server 2019

Our ustomers pay first based on a quotation/order done in OE. We capture the receipt as a prepayment. We thn generate an invoice then match it to a prepayment later. This has become so cumbersome that sometimes we miss to do invoices and we have a lot…

Hi, We have a user setup for full access to all modules of the application. When the user logs in just some options are displayed. Has anyone experienced this before? Thanks.

Hi, we have a PO with one line that has been completely received. The PO still shows a type of "active". How can we flag them as complete? Ty.

Users realize after posting that the order has errors such as the wrong customer number. OE screen does not allow you to change the customer number on the order. How do we close or cancel the order so it does not remain open? We do not want to generate…

Hi We have a client who is running Sage 300 2021 Pu2. They recently upgraded and are experiencing issues with Inventory control and Lot Tracking. Posting here as advance warning to other BPs intending to upgrade. MAKE SURE YOU TEST TO SEE IF YOU ARE…

Sage 300 v2017 PU8 - When adding a prepayment to an existing order it allows me to save the prepayment but when I post the Order I get the error message 'Posted Prepayments. Record Already Exists.' 'If modifying an existing order you must reenter…

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…

Is there any way to have qty committed to order and have 0 value in back-order? We are trying to manage our back-orders but it doesn't make sense to put qty committed, same as back-order qty if stock is available? ideally we would like to commit to stock…

Hello, in our issuances option in Autosimply we have a few orders that when we try pulling the line items they don't pull any. Has anyone any suggestions on how to clear them out? This does not prevent us from processing actual manufacturing orders…