Forum Discussion

Agspec4's avatar
Agspec4
Experienced User
3 years ago
Solved

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's avatar
    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.

4 Replies

Sort By
Replies have been turned off for this discussion
  • Carolinadg's avatar
    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's avatar
    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's avatar
      Agspec4
      Experienced User
      3 years ago

      Hi Mike_James 


      A million thanks to u🙏
      it works . Stock is deducted 👍🏻😊

      • Mike_James's avatar
        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.