Forum Discussion

Experienced User

3 years ago

Inventory not being reduced after sale

i generated a sales invoice but when we had fulll stock take count, inventory has discrepancy and found out this transaction inventory was not deducted in and not shown in the item register list..

what possiblity could happened? i searched the forum here and there's someone who had same issue in 2019 but the solution shows only that the issue was raised to higher level that MYOB specialist called them and fixed the issue. No explanation on how to fix it and what cause it , human error or software glitch..

please help. thank u

Mike_James
3 years ago
Hi Agspec4 , one thing to try is editing the invoice, add a full stop to the journal memo, then click OK. This re-records the invoice, and the stock may then reduce.

Carolinadg
MYOB Staff
3 years ago
Hey Agspec4 ,

I am keen to know how the sale was entered into AR. Was this manually entered? or was it imported? or did you hit the API directly?

Cheers,

Carolina
Mike_James
Ultimate Partner
3 years ago
Hi Agspec4 , one thing to try is editing the invoice, add a full stop to the journal memo, then click OK. This re-records the invoice, and the stock may then reduce.
- Agspec4
  Experienced User
  3 years ago
  Hi Mike_James
  
  A million thanks to u🙏
  it works . Stock is deducted 👍🏻😊
  - Mike_James
    Ultimate Partner
    3 years ago
    Hi Agspec4 , glad it worked. You must now check whether there are any other invoices affected. Use the Sales Item detail report, run for this month to start with, and customise it to show the gross margin percent. (Remove unwanted columns). Save as a custom report once it is set up correctly.
    
    Affected invoices for inventoried items will show a 100% gross margin, while other invoices for the same product will display a normal margin.
    
    Any affected invoice needs to be corrected. by opening/editing/re-posting.
    
    If you do find any more, then run the report for a previous month and review that. I'd be interested to know what you find.
    
    For cases where the volume of such invoices is high, we (Datawise) have a scripted solution.