• How to post accrued revenue in Sage? - year end adjusting entry

    I am trying to make year end adjusting journal and post accrued Revenue but have very hard time to figure out how I can debit my revenue to account 1200 ( Account Receivable); the last one is not available in combobox of "Select Account"
  • Item Valuation Report showing zero for all Costing (Actual , Most Recent , and Standard) but Location got qty on Hand

    Hi Guys I am running Item Valuation Report In Sage 300 where all Costing (Actual, Most Recent, and Standard) is coming up zero, however, my Location got qty on Hand. I remember we made a few transfers in IC from one location to another. Can anyone…
  • 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…
  • 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…
  • 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…
  • Revenue Recognition

    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…
  • Adjust a BOM during a transaction

    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…
  • Additional lines in OE invoice

    Hi, Is there a way to add lines to an invoice that is being created from an order receipt? Thanks.
  • OE invoice amount is different in form that on screen

    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…
  • Automated posting of I/C adjustments

    Hello, we have a process where we import an number of IC adjustments. After the import they have to be posted manually one by one. Can this posting be done in a more automated way? Thanks.
  • pre-auth credit card order entry

    I have a customer where re - pre-auth CC is showing as 0.00 on receipt batch I suspect this is because original pre-auth was expired the flow is 1. make an order 2. pre-auth CC 3. change the order by adding to it 4. wants to pre-auth again…
  • INVOICING

    My client is in the business of selling a product whose Volume is affected by Temperature. They would want to Invoice a different Quantity than they Shipped out. e.g. Order Quantity - 200, Ship Out - 190 & Invoice - 200. This is happening okay but…
  • IC Shipment Quantity Issue

    An IC shipment was created where the operator accidently removed 51,138,686,093 units from stock. The Shipment appears to have posted but when trying to open the shipment we get a Code: 3.3550.0 Source: IC0630 error. Can I go into the ICSHED table end…
  • SAGE 300 2019 ERROR the field [bkenth].[totfuncamt] contains more decimals than the currency code [AED/INR etc] allows

    While Applying a Prepayment to AP Invoices or Reversing any Payment entry/ Bank Deposits the system is giving this error. The Decimal points are already 2 in the currency master. while creating new transactions it is accepting but while applying it or…
  • How to correct wrong exchange rate in PO Receipt

    In PO receipt a wrong exchange rate was entered, Invoice is not yet booked but still PO Receipt Rate screen won't allow to modify the rates. What's the best way to correct the rate?
  • Offline App for Stocktaking

    Hi We have had multiple clients request an app that they can use to walk around the warehouse and do a stock take without pruchasing a full blown Warehouse System. Has any one implemented anything simple or developed one. Stacey
  • How do I transfer cost from one job to another when original cost was entered through a/p?

    Prior to understanding how PJC/Purchase Orders worked, many costs were entered directly in A/P. I now have some unused materials that need to be transferred to a different job, but the PJC adjustment is not an option. How do I do this?
  • AP adjustment posting error question/ help

    Hi, I am getting a posting error after posting the following AP adjustment... r The error is: The applied amount exceeds the job distributions current balance of document 144832 for vendor WINEMAN.' Any ideas? Thanks Dan
  • 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…
  • Changing Stocking Unit of Measure

    Is there anything we should look out for when we change the stocking unit of measure? We some items that have a couple of conversion factors and the items are used in BOMs. To be careful should I issue out all the inventory, change the stocking unit…
  • QTYSHNOCST field NOT zero and day end has been run

    Client has issue that appeared when comparing the IC Location Details screen to the Service Manager Location Details screen. The Quantity On Hand for an item did not agree. The IC Location Detail screen had a lower quantity that I understand was a result…
  • Physical Inventory with Serial numbers

    How could we do a physical inventory with serial numbers? When I did some tests, I had to indicated the serial number of the missing items which is a nonsense since we don't know which Items are missing! Is there someone knows how to do it?
  • Credit note with a restocking fee

    We have come across a situation where we had to return a job related item to the vendor and that process went smoothly. Issue being there is a restocking fee that needs to be expensed to a different GL account on the credit note we are trying to apply…
  • PJC overhead costs not reversing

    I have a client that did a job related PO Receipt It was in error they reversed with a PO Return against the job related PO Receipt costs got reversed out but not overhead besides data repair is there anyway to correct overhead only Sage 300…