Inventory not connecting to sales or purchases

SOLVED

Been using for several years but did not install the inventory module until yesterday.  Sales and purchases are not connecting to the inventory module.  Anybody know how to turn that function on?

  • 0

    If an item has an inventory cost when you sell it, the cost is allocated to the COGS you have set up for that item.

    If there is no cost on the item, no accounting is done, because there is nothing to do.  The quantity is subtracted when you sell the item.

    Quantities on hand for 'Service' items are not tracked.  There are only sales statistics.

    Could you post more detail on what you're seeing, and when?

  • 0 in reply to RandyW

    What we are trying to do is keep track of actual count of items (not everything we inventory is buy/sell and we are only prepared to track the buy/sell items at the moment.  We therefore do not want each purchase/sale of an inventory items we wish to track to go directly to an asset account or a cost of goods account.  The system will not let us leave the account blank nor will it let us choose the expense or revenue account that we would like to have affected by the transactions (as they are not asset accounts)  Our actual asset inventory account is controlled by a journal entry once each month so we do not want it touched on individual transactions but would like a group of products inventory cards to be be added to or subtracted from and we would like to use the price sheet components as well as the profitability of sales numbers.  Any suggestions

  • 0 in reply to admin101
    verified answer

    admin101 said:
     Our actual asset inventory account is controlled by a journal entry once each month so we do not want it touched on individual transactions

    Well... that's not how Sage 50 works.   It's an online transaction processing system, there's no way to 'save up' all the journal entries into one almighty batch at month end.

    admin101 said:
    but would like a group of products inventory cards to be be added to or subtracted from

    Again, Sage 50 does a complete journal entry for each sale.  The selling prices and costs are calculated and recorded line by line, then costs and selling amounts are summed by G/L number and separately recorded in the G/L.  (and of course the sales taxes are tallied as well)

    admin101 said:
    and we would like to use the price sheet components as well as the profitability of sales numbers.

    You could keep track of the prices by setting up everything as a 'service item', but not the quantity.   

    The profitability of sales numbers come from the line detail on individual sales transactions, so without that detail data going in, no summary report will come out.

  • 0 in reply to RandyW

    Thanks Randy.  Well it WAS a good idea.  If we could have overridden the linked asset account to a revenue account for sales and an expense account for purchases it would have probably served us well.  Alas, back to the stone tablet and chisel for the buy/sell portion of our inventory.  Your input was much appreciated.