• OE INvoices Posted but have a status "Document shipped not costed"

    HI I have OE invoices posted , Dayend run without any error but no AR invoices were created. I checked in the database these invoices have a document status document shipped not costed. How can I make these transactions to be available for dayend…
  • project job costing overtime

    What is the most common way of tracking OT on projects using timecards? When the PJC timecard is entered there is only one default hourly rate for the employee. When the timecard is sent to payroll the OT is calculated accordingly. How can we capture…
  • OE debit note print

    Hello, is there a way to print a debit note from OE? Ty.
  • O/E Order Entry quote under wrong customer number

    We entered 72 quotes in order entry under the wrong customer number. Can I go into OEORDH and change the customer number before we change them to active orders?
  • OE Order Entry incorrect prepayment

    Someone entered an incorrect prepayment amount on an OE Entry order. Then they deleted the prepayment receipt from AR and went back and posted the correct prepayment amount. Now the order shows both prepayment amounts added together. What is the best…
  • Cancelling an order leaving the ordered quantity as originally entered

    Hello, we need to be able to flag an order as cancelled but still see what the customer had originally ordered. Is this possible? Thanks.
  • Employee Number XXXX is not assigned to the Project

    A User is not able to add or capture a Timesheet in Sage 300 PJC and the system returns the error: " Employee Number 'XXXX' is not assigned to the Project ".
  • PJC-AP invoices costs and taxes

    Looking for a suggestion on how to handle taxes in AP invoices for PJC. Client currently has some invoices that have 2 taxes charged (federal and provincial). They provincial tax portion is non-recoverable and they want to charge it back on the project…
  • How do I get the inventory counts for items to update when they are received in the Purchase Order module?

    I recently joined a company using Sage 300, and I've been trying to get their system working. In the past, they used generic item numbers on purchase orders (i.e. BATHHARDWARE1), so their inventory counts were useless because many items shared the same…
  • Charge on Delivery - Invoice Term

    Hello, Could someone please clarify what 'Charge on Delivery' payment term actually means. I posted some invoices today and ran a cheque payment batch and the invoices that had this term did not show up in the cheque run ? Usually cheques with other…
  • What is the use of Unit Cost Column in I/C Kitting Items Screen?

    What is the use of Unit Cost Column in I/C Kitting Items Screen? For me it always remains empty.
  • GL detail transactions listing

    Hi, Can we export the GL transactions listing to Excel? We check under File, but there is no Export options. Thanks!
  • Changing tax group on PO

    Hello, I asked this question before, but cannot seem to find the answer. Once a PO is posted (not received), can we change the Tax Group? If yes, how? Thanks!
  • Best practice for cancelling an order

    What is the best way to cancel an order? I thought the users could just go in and zero out all quantities, mark each line complete, and make a note as to the reason for cancelling. But it still shows up on Order Action (even tho quantities are zero) and…
  • Processing of O/E Shipments while location is inactive

    Hi team, I am running Sage 300 version 2021. During our stock take process we usually inactive a location that we are busy with stock take. Is it correct that Sage 300 still allows processing of Shipment from that location while it is inactive and…
  • Validate PO Receipt when no qty receipt or qty Cancel

    Hi All I Have case in PO Receipt. For Example I have PO have 5 items In PO Receipt, user search the PO number, but forgot input qty Receipt or Quantity Cancel, so after post that Receipt number don't have the detail. Can We setting when PO Receipt…
  • How do you fix a partial inventory transfer?

    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?

    Can Alternative Item number supports in IC Assembly?
  • Error message when post Invoices: Invoice Batch Attempt to perform Record Update without security authorization.

    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?
  • Cost in OEINVD table

    Hi, Where does Sage pull the information for this field? Thanks.
  • Troubleshooting Average Cost Errors

    Hello, I noticed that a lot of my items have average costs that are way higher than the Most Recent or Last Cost. I know that I can make an inventory adjustment to bring it in line, but I'm wondering where I would look to troubleshoot why they are all…
  • Cannot uncheck the 'Fully Invoiced' for PO Invoice with partial quantity with Lot Tracking.

    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…
  • Multiple Invoices for one item in one PO Receipt

    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…
  • Posting to Default Cost Expense Account under P/O G/L Integration

    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…
  • Item Valuation Doesn't match with General Ledger

    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.