Hello fellow Sagers!
Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
Hi Everyone
A purchase order was received in with a higher unit costs than it was supposed to be
Sales orders were processed and updated
Found mistake did a return of good and re-received at the correct unit costs
How do I now fix the profit margins…
Hello - I know this article shows how to upload your inventory listing ( https://ca-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=220924150010124 ).
But how I update the stock currently on hand as part of the upload? I can't make…
hi here is my question,
i have issue when i open my inventory it is show default by this
,
when i added item code and quantity on hand ,
like this it is show the window, but when it is closed window again automatic gone go back first place…
I use SDK to insert Inventory Adjustment data , the data in Invnetory Adjustment Journal report is correct , but data in Inventory Unit Activity Report is not correct .
if using Support Utinities-integrity check , the data in Inventory Unit Activity…
We have an item that is showing with a quantity of 4 "in shipping" which we can not clear or zero out. There are no open sales orders for that item currently. Also there are no invoices for that item which have not posted. I have checked in the AR module…
Hi,
I'm trying to determine what the best way to track the costs of external processes on inventory items? hoping some folks around here could chime in.
RM=RAW MATERIAL
AS=ASSEMBLY
FG=FINISHED GOOD
EXAMPLE:
1. 10 x Widgets item number (RMWIDGET1…
When entering a P.O. for Vendor/Supplier and it is an inventory item, does it remove from Inventory when processing that order?
Or does it remove when it has been invoiced.
Our current process for inventory stock is done the following ways:
-Sales…
Currently I have a one line GL entered inventory balance, but want to change it from a one line item to units. This is inventory that has not been tracked over the years, but I want to start drawing it down through internal allocations to various jobs…
I'm trying to import the Unit Cost field among others for Inventory adjustments via the COM Interface. For some reason this one field likes to remain at 0.00 even when making a positive adjustment with a value greater than 0.00.
Here is an example of…
We are a factory using Sage 50 Quantum. We use average cost and quantities were not negative. I managed to set the correct quantities and values of the inventory by using the inventory module, by first resetting the value to 0 in the module and then adding…
I have a role that only prints blank work orders when ever WOT printing is processed. Header detail of the crystal report appears but all fields and details are blank.
Im holding the Role Maintenance of a working role side by side with the non-working…
I'm trying to understand exactly what is in the the PPV amounts (and how calculated) on our Sage income statement so we understand the information reported, if the manual JE's are correct,a and if we need to change our processes.
We have two GL accounts…
I've working on year end inventory adjustments. Is there another way to correct our inventory other than by doing individual inventory adjustments for each item? Is there an option where you can just enter the current inventory amount instead of doing…
Hi Everyone,
I am currently working for a company where they have not been utilizing the inventory module correctly- we are using Sage 50 Quantum Accounting. Currently we have all of our inventory (raw Materials, packaging and FG in Sage. We are only…
I am trying to assign a serial number that shows it is on hand, but when I try to assign it to the sales order, it is not available? How do I correct this? Sage 100 v.2017 v 5.40.1.0
Any suggestions on how to correct this would be appreciated.
Client issue: Current inventory item has zero quantity and negative value. Need to end up with positive quantity and positive value. Also have items with quantity but negative value. I have tried inventory adjustments - but getting wonky numbers. Been…
Inventory sub ledger out of balance to GL. Sub ledger is higher than GL. Is there a way to post a one time entry to the Inv GL to bring into balance. Over 4000 items so no idea what is the issue.
Thanks
I realize this question may be very similar to others, I did look around though the forums... the answers to me didn't seem like they were what I was looking for, but I'm not an accountant in any stretch and started using Sage 3 weeks ago so please bear…
To start off, we are on Sage 100c Advanced v2018.2
How can we append an original Lot # when transferring qty from 1 whs to another?
Create PO for Qty = 100,000.
ROG the full Qty 100,000 to an offsite warehouse ("OFF") with Lot # 12345.
When when…
I was wondering if any one has done this type report
I did a custom crystal report that i'm able to see specific item code, but for some reason when i'm running the report those item codes that doesn't have any transaction history is not showing and…
In Sage 100c Advanced 2016, Updated a completion step of Work Order. Some items posted to scrap with all the cost and some items posted to inventory with no cost. Somehow the cost was all posted to scrap. Now if we complete other steps in the Work Order…
Greetings everyone,
I'm new to the community and have been lurking for a bit on subjects that I'm unaware of. I decided to register and stick to the community.
Welcome!
Before my time, some of the books were a complete mess. We are slowly correcting…
