Misc Item and SO module

Hey all,

I'm a recent new Sage 100 user and have experience some problems with misc item charges in SO module. A client is worried that we are not charging the customer on fees in a timely manner.

Whenever a product is approved we must charge them for the fee.

The process begins by creating a SO with parts + misc fee.

We use that SO and process the sample parts. The issue arises when we invoice the parts, the misc item automatically APPEARS and shows the price.

If I delete the line, that line is no longer in that SO.

I'm confused by the logic because in the PO module when I invoiced misc items, I can delete the line if I don't want to charge the item during that time. I can always go back to the PO and that line reappears.

It is not the case with the SO module and invoicing.

Has anyone run into this problem or have a suggested solution?

  • 0

    There are two types of miscellaneous items -- "miscellaneous" and "charge". Sounds like your fees are set up as charges, because those can be deleted off of invoices and then they're gone for good.

    The "miscellaneous" type act more like inventory items. They require you to enter an order quantity and cannot be deleted from an invoice. You can backorder them, though, in which case they show as backordered on the invoice & will remain on the sales order.

  • 0 in reply to Helium

    Hi Helium,

    Thanks for your response! I did not know there were two options for "miscellaneous" items. In the past, they were set up as "miscellaneous" as an inventory item. However, when I was hired, it screwed up our inventory and purchases clearing account. I had revamp the system by not using "miscellaneous" items as inventory and instead went with a "charge" type.

    Do you think it is a setup issue?

    Because on the PO side, our PO is setup up as "misc" charges and when they are received, it is invoiced right after and I'm able to delete that line. When I invoice another line on that PO, that same charge is still there ( it did not delete)!

    However, on the SO side it doesn't work like that.

    I'm at loss of words because I changed the "misc" items as inventory to "misc" charges because it ruined PC account and now it is hard to keep track of charges when they are suppose to be due.

    Does anyone have any other suggestions? 

    I really don't want to go back to the "misc" inventory item as that was the cause of inaccurate numbers on the financial statements.

  • 0 in reply to zazu

    If you want to stick with charges, I think you'll have to either include the charges on the initial invoices or put them on their own sales orders.

    If you switch back to items, I think you just need to change which GL accounts you hit. Maybe have some dedicated accounts rather than hitting your main inventory and COGS accounts. If you were to use the same GL account for all three (sales, COGS, inventory), the net effect on your GL should be exactly the same as when you use that GL for a charge. But this is really a question more for your accountant.

  • 0 in reply to Helium

    Hi Helium,

    Sometimes my response will be slow, depending how busy I am at the office. I appreciate your help!!!!

    I believe a misc charge on a separate sales order is the perfect idea. I will test and review this option. 

  • 0 in reply to Helium

    It sounds like you could really benefit from some time with your Sage partner.  The accounting impacts of different item types are pretty significant.  If you don't know how your partner is, you can reach out to Sage.  Or, for that matter, you can find a new one of your choosing, maybe even close by so they can come onsite.

  • 0 in reply to Helium

    Hi Helium,

    I tested the separate sales order option, and it is the best option for accounting. However, in our CS department it won't work because they can't "track" our SO to our customer PO; which I think is bs.

    It's such a shame because this method is fluid and creates less work on the book side.

    I'm at loss of words.