Browse By Tags

  • outstanding stock items report

    Hi, New here so please go gentle. I am tying to run a pre-set report "Sales order quantities to dispatch by stock code" . This report seems to run but includes quantities on quotes as well as Sales Orders? I then run a filter on the Sales Orders…

  • Sage 200 Professional - Project Issuing of Stock - Cost Methods

    Currently, if you issue stock (regardless of the costing method used for that item), if you had to return some of that stock from the project, that stock's cost price will represent the average cost of the item. This can cause discrepancies if you were…

  • Amend Batch Number by Location / Split Batches

    In the Amend Batch/Serial No feature, you can filter batch numbers by location, but changing the batch number applies to all locations where that batch exists. For example we have item GIN which is in stock at SHOP (qty 100) and WAREHOUSE (qty 100)…

  • Stock bought individually sold in packs

    Hi We buy items in from our supplier individually (which is on the purchase order) but sell them in packs of 10 or 100. They are purchased as individual items and are received into stock as individuals when the purchase order is received. But we sell…

  • When Confirming Goods on a POP Return, can we be able to ‘choose’ which stock is returned to the Supplier. [Currently only possible if the stock item is made traceable and Actual costing method is used.]

    With Purchase Order Processing it is quite common for the stock to be invoiced before receiving it, therefore in this type of example once the stock is received it becomes part of the overall stock system. If a mistake has been made, or some goods are…

  • Part numbers specific to a customer?

    Hi We want to be able to show our own part number as well as the customers part number on the invoice. However, different customers have different part numbers for the same item. Is there a way to link a part number to a specific customer? e.g. if…

  • Make warehouse balances bigger within View Stock Item Balances screen. (or allow to be changed)

    Within the stock item balances screen the warehouse balances section is very small and the bin section is very big. For us this is quite annoying as we have up to 11 warehouses and very rarely more than 5 bin locations for each stock item. It would…

  • Improve Bin Location Management

    The way Sage 200 currently handles bins is on a Warehouse, Stock Item Level. Therefore to add an item to a Bin, this is configured based on the 'Warehouse Item' there is therefore no forced consistency between multiple items and across the warehouse on…

  • Endpoints relating to dbo.StockItemPeriodBalance

    Unfortunately in the current Sage 200 Professional API there doesn't appear to be an endpoint that would provide an approximation of the data stored in dbo.StockItemPeriodBalance. Altough these tables have great data within them. One example,of Period…

  • Further Identifier on nominal accounts to help with screen selections

    I come across this regularly when implementing new sites that when it's a new nominal structure the staff don't tend to know the codes immediately and click on the drop downs be it in any of the available screens and get presented with the full nominal…

  • Stock movement

    Is there a straight forward way of removing items from stock which are being given as FOC samples to customers? I want to be sure that I am capturing the cost as a 'sample' and not as 'materials' COS. Thanks! Best Katie

  • BOM - An option for Automatic Product Creation from the BOM - for non-stock items.

    FormerMember
    FormerMember
    An option where the BOM data can be used to Automatically build sale items if stock reaches zero when allocated, if the checkbox is ticked etc. Example; We sell a tool - 1" Stone Chisel - 8 in Stock This is made from; a Chisel Blank (CB1) from…

  • Sales orders, stock and deposit invoices

    Hi everyone So we use Sales Orders to keep track of stock movements and invoice our customers for products. We are charging staged payments (i.e 25% deposit, 25% when stock delivered etc..), and in the past we have always just raised an invoice for…

  • stock control sending products back to suppliers with a returns note and also takes items out of stock

    stock control sending products back to suppliers with a returns note and also takes items out of stock can this be done on sage 50 accounts professional with click of a product, only away I see is to write item off and then make a letter head returns…

  • Adjustments out for products

    Hi ! If there is n adjustment to a product to remove a quantity from the product record, is this reflected in the P&L? What are the journals? We do adjustments to reflect use of cleaning products in that we use in our office and dont sell, if…

*Community Hub is the new name for Sage City