Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
What is the best method to print item labels after it is received in receipt entry? I am using serialized inventory and I was expecting a prompt to appear after I clicked 'Post' to ask if I wanted to print labels, but I didn't see one. Are people just…
Hi,
I am trying to fetch product prices and product inventory, but couldn't find any which does the job. So, can you suggest me the suitable endpoints to fetch Item price and Item inventory?
Hi Support,
One of our clients has an issue with day end processing in IC. The day end stops at a particular order. This has started happening after a power failure. I have performed DB verify and DB dump but it did not fix the issue.
Sage 2012…
I'm a new user of Sage 300 I wanna Update my physical inventory because he's different with what I have on hand, so when is connect to the POS (Orion POS) I'm using the data are different to what I have on hand sometimes I can't even sell some Items.…
When running the inventory on-hand intelligence report I see that one item at one location is showing a quantity onhand as twice as much as it should be. The costs are also showing up at twice the correct amount. Any idea of what is happening. We look…
Hi all,
I hope you are all well.
We have experienced in the following scenario on one stock item during Order Entry:
Qty on hand = 0
Qty Committed = -3
Qty Available = 3
Negative inventory is never allowed.
Could anyone shed some light on…
Hi,
My report opens in Crystal but not in Sage - it tries to open, there is a quick glimpse (flashes on the screen) of it opening and then nothing. No error message. I tried creating reports from different tables - all with the same result.
Any…
Client has a few items with really far out Average costs. Supposed to be $1 and shows $950 Average cost. The MRC is good and last cost is good.
Is there a way to fix the average cost? There was an adjustment done a few months back that was in error…
I have a client who did a PO receipt two weeks ago of a serialized item, with 2,980,000 serial numbers on one line. This week, they're trying to ship that item with 600,000 of those serials. Day-end runs for 12 hours then crashes. Right now on SQL profiler…
Who wrote or currently owns the program 'autoassemblybyinvoicerange'.
You run the program from the desktop after invoicing but before Day-End. It automatically assembles the bom's on the range of invoices. Saves a boat load of manual assemblies in IC…
We recently did a physical count in inventory and most of the items did a both update (quantity and cost), but two items did quantity only updates. How do we make sure that all items are doing a both update?
I designed a report based on ICITEM,ICREORD and ICILOC that gives reorder quantities and some calculated columns for a parameterized input of location and item segment (from segment and to segment). These are dynamic parameters.
The report DOES NOT…
I am trying to create a report that pulls all OE sales by month and includes standard cost, average cost, most recent cost, last cost, alt cost 1 and alt cost 2.
I can't seem to find which table or view has all of these costs. It looks like they are…
We have noticed that the CompanyID field in the GLJED table does not tie up with the actual company AUDTORG field.
The bulk of the record have the correct company ID, however many have either blanks or random company ID's
I have checked this at several…
Our client is working on Sage 300 2014 PU3.
When doing the Physical Inventory Reconciliation it gave an error that states "There is insufficient quantity available to adjust item XXX at location XXX".
When checking the specific item via Item Location…
Hi there,
in Ops Inquiry IC Item Inquiry (in Location tab) the Most recent Costing Unit does not update with the Average Unit Cost. The Source App is P/O
Issue occurred with one item only.
Any idea there.
Hi Support,
It is normal procedure to freeze all inventory transactions before generating the worksheet. Our month end inventory reconciliation last for up to two weeks. Is it possible to still post order entry invoices for the new month? What will…
Sage 300 ERP 2014 Advanced Edition
Dear Support,
The order of the serial transactions within the I/C Serial Number Inquiry looks sorted by DAYENDSEQ and ENTRYSEQ. However, the transactions initiated by I/C Module all are given the DAYENDSEQ = -1.…
We running SAGE 300 ERP and we have a problem with Qty in Bin Location not matching IC Qty.
How do I get SAGE to automatically sync the Bin and IC Qty?
Doing each transaction manually takes way to long.
Thanks
I want to create an intelligence report that only shows inventory items where the quantity on hand is less than the minimum level. I do not see how I can add a comparison in the filter area against another field. Can this be done? I have also tried to…
Sage 300 v2014
I have a situation where there is a gap in the I/C Adjustment Numbering and therefore can no longer drill down on their details from the I/C Adjustment Function. However, all postings to GL are correct and I/C Stock Transactions report…