COGS on returns incorrect?

I seem to be missing something - Weve noticed our electrical department was showing a very low PM, which surprised me greatly. Upon doing more research, it seems that when a return is made at the register, it subtracts the sale, but adds to the cost of goods - In other words, every time an item is returned, our cost of goods sold goes up just as much as when we make a sale. Our inventory levels are correct, as it adds it back into the inventory, but the COGS that shows on detailed sales reports and gets returned to Quickbooks is totally wrong.

I hope I am just missing something here, or have an option set wrong, but can anyone help with this? And can we get accurate COGS for this year to date?

Reply to
Tad L
Loading thread data ...

interesting..

Are you returning items cold, or are you returning them as a Recall Transaction for Return, or both ways?

Reply to
root

We are returning them "cold" - we have 2 reasons to return items, wrong item/resellable, which goes back into inventory, or broken/damaged, which goes in to our off-line inventory. We are trying to then transfer out of offline to create "return POs" for each vendor.

We do far too many sales of far too many small items > interesting..

Reply to
Tad L

To each their own. There is no wrong technique. I was just curious for troubleshooting reasons.

If it was only reoprting wrong COGS when doing a certain way, I was going to confirm and have our cashiers avoid that technique. I am curious about this.

Thank you!

Reply to
root

'cold' or otherwise, I think this needs to be brought to MS' attention as a potential bug.

No matter the process, if a transaction is completed with a negative line item the sales and cost should both be handled properly throughout the entire system. If the problem is accurately described, MS needs to fix it ASAP.

Tom

"root" wrote:

Reply to
Terrible Tom

I just tried this a couple different ways and the numbers look fine to me. What report are you running to get COGS? I used the Register Analysis report under Manager, Utilities, Crystal Reports. This should be the same data pushed to QuickBooks if you use the QB interface. What version of RMS are you running?

Mark S.

"Tad L" wrote:

Reply to
Mark S

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.