Browse By Tags

How can we move inventory items to costs on a project taking the item from inventory and allocating it to the project?

Hi, I'm preparing for our annual inventory counts and having a valuation issue. When I run the Item Valuation report as of March 31st for a range of account sets and locations it gives me a total for each location. But when I generate the inventory…

Our fiscal YE is end of Feb, so inventory adjustments are being made. On the 28th, inventory counts on one item (as an example but this isn't a one-off) were at 27, it was counted at 22, and on the 29th when the manager went to put in the adjustment,…

We brought in some shelving - they are in inventory at a cost of $5. Now we have to send some of these out to get painted - the painting is going to cost $2/shelf. What is the best practice to bring these items back in at $7/shelf - but pay the painter…

Does IP Type Code show up in transaction tab for all items during inventory count or does it only show up in the transaction tab if a count was made towards the item?

I'm trying to close lines on a open purchase order and it says I can't. I tried using the Receipt of Invoice and it will not pull over that purchase order. Does anyone have any ideas?

We have 2 items in our inventory, that show an SO for a negative amount. I cannot find an orders that have negative amounts and no orders that match the quantities. For example, we on hand 110 units of product A with SO of -15 and an available inventory…

I need help! Our small business received a digital grant of $2500 which was deposited in December 2022. We did not make any purchases from this grant until January 2023. My questions:: How do I input this grant into Sage? I know that I have to put…

Sage 2019 app n db on one server. SQL database in use. Users of AR module were complaining of batch posting being slow so a reboot was done. After reboot realized , Ar module completely disappeared. Steps taken: 1. Did a sage full repair yet AR…

Hi, When I do an inventory inquiry, it shows 104 of an item on hand, but we only have 40. I couldn't do an inventory adjustment of -64, because there are less than 64 to distribute. How do I get the inventory that shows on hand in inventory inquiry to…

Hi, We have 4 POs this month that are for inventory. The inventory has been shipped. I need to enter the purchase invoice, but have not received it yet from the supplier. They send them late sometimes. The shipping documents alerting the customer…

Hi! Could someone share a Scrap policy? Or direct me to a website that may have examples. Thank you!

I have a number of old inventory items i would like to clear out but Sage won't allow me to unless I clear the look up data first. However agreeing to this prompt window that pops up does not tell me if the next screen will allow me to choose which inventory…

Hello to all, Have a question regarding Weighted Average Cost and FIFO when returning purchases to vendor 1- Weighted Average Cost we have following purchase: 10 unit @ $20 & 5 unit @ $15 so average cost per unit is $ 18.33 = (10*20)+(5*15)/15 after that…

Hey there I have an issue with an item showing that it is on sales order and its committed but we have no open sales orders with the item nor back orders. I'm also going to mention that we use multi bin and I can see that 7 are set in a warehouse but…

Is it possible to change a linked account on an inventory item that has been created and already has history of purchases/sales. I inadvertently selected the wrong Variance Linked account and am now trying to fix the error.

Is there a way to increase the decimal places on the report for Avg Cost or Last Unit Cost? The reporting for cost, is inaccurate as it rounds to the nearest penny. The value of many products may be based on purchases in hundreds or thounds of an item…

We are producing a custom item for a customer. They will be charged $20,000 for their first order on Net 30 terms...which covers the full run. They will only be taking a portion. The remainder will be on our property and when we ship out any of the balance…

Newbie here. When I go to make an invoice paid that has associated inventory items on the purchase it won't let me change payment to cash so my Bank reconciliation is off by these invoices. So the invoice stays as Pay Later. How do I make these payments…

Has anyone found a way to use Sage Account US to track consumables? I'm specifically looking to track the purchase history and costs for consumable materials involved in our processing, such as polishing compounds, paint, etc. I thought to use the "non…

I'd like to keep track of internal inventory. For example employee gloves that we keep in a stock room. I'd like to have a total of what's in the stock room and then adjust as we buy more or when an employee takes gloves.

We run Sage X3 Update 9 Patch 9. The cost of a product we buy is going negative. This occurs from time to time because the product is a by-product- sometimes the supplier can sell the by-product, but other times they have to pay us to take it. …

I just want to bounce some thoughts around. We're a manufacturing and distribution company. We are trying to take into account how many boxes we use for packing our finished goods. These finished goods are sold to our intercompany via p.o and receipt…

There is a major issue when we enter the serial number on each of the line item at the order. Usually, a product includes several bar codes on the package box, for example, serial number, UPC code, EAN etc. Problem is that BV pops up the serial number…

Description: Internal error. missing posting table entry (1697 PORCPZ1.C). Description: Day End Processing could not process all transactions. Source: 13:17:39 what could be the issue?