Hi:

You will need to use a 4 account for this transaction but before you do give me a call or e-mail me off forum. This is a problem a professional should handle.

Thank you Randy! Would it be possible to have your email address? It's not possible to talk on the phone right now.

Hi,

Have a look at how the universl.sai sample file is set up, and notice the little asterisk beside the account number fields.

- Usually you use a Sales (4xxx), Cost-of-sales (5xxx), and Inventory (1xxx) account. The 'Variance' account should be different from the Cost-of-Goods-Sold account, and is only needed if you allow 'negative inventory'.

- Keep it simple!! Don't set up multiple sets (A, B, C, etc) of inventory accounts unless / until you absolutely need them. (You don't need Lubrication, Electrical, and Brake & Suspension accounts unless you build cars. Multiple accounts are usually only helpful if you have inventory that is completely unrelated - i.e. car parts and home decor).

- Especially during the process of setting up Inventory and Service Items, don't let your inventory system be a data entry prevention system. You can put in the item code that you think is correct, tab, hit escape, add a description, add the sales G/L account, get the customer's money, and move on. (you won't have statistics for 'forced-in' items, so the first year's records will be a bit rough. But they will be better than the last year, and they will improve.

- At least every year, but preferably every month, go through your inventory list and verify that you have it on hand. And go through your shelves to verify that you have it in your list.

All that said, I would recommend that you run through a tutorial and get the help of someone in your area who is experienced in using Sage 50 Canadian with Inventory. It will take less of your time / money, in the long run.