Sage 300

My client did an inventory transfer and most items worked fine, but one item only transferred 1479 lbs of the 1488 requested to be transferred. 9 lbs remains outstanding. They have run day end processing, All the other lines show as complete, but that…

Can Alternative Item number supports in IC Assembly?

Hello Team, I try to post the Invoice, but receive the following error message: Invoice Batch Attempt to perform Record Update without security authorization. Could you clarify how to fix this error message? What settings I should do?

Hi All Has a PO transaction processing with Lot Tracking to ask? Is there a method or option to keep the balance quantity of 15 pcs in the PO Receipt as not invoice? 1) PO Receipt posted item with quantity of 25 pcs (with a lot number assigned…

I have a PO Receipt with one item and a quantity of 1. The vendor sent three different partial invoices for this one item. How do I enter these invoices correctly? I set "Fully Invoiced" to no and entered a partial amount on the first invoice. But…

Hi..Can someone tell me how to make a transaction that will post to the Default Cost Expense account that was set under the P/O Setup > G/L Integration? Based on the explanation in guide, manual prorate the additional cost and make changes to the tax…

Hello, Which is the correct procedure of comparing current Inventory value with General ledger? Item valuation by ''Transaction cost'' is matching with GL. But, ''Location details cost'' not matching with GL.

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…

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

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.

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.

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 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…

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…

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…

Hi all, If we are using the standard Sage 300 PO module and segregation of duties are limited whereby a requestors has access to Process a Requisition Entry, Purchase Order Entry, Receipt Entry and Invoice Entry, Credit/Debit Note Entry and Return Entry…

Hi, the option to delete POs in our system is grayed out. I checked the security groups. Can't see an option that would allow for this to happen. We have full access to all PO options. Thank you.