Question: Null Values In The Purchasing Table

Null Values In The Purchasing Table

There are lots of null values (without purchase_id) saved in sma_purchase_items with out creating a purchasing order in sma_purchases. Due to this fields in sma_costing is showing wrong valu

AH

Amila Hettiarachchi

Asked
There are lots of null values (without purchase_id) saved in sma_purchase_items with out creating a purchasing order in sma_purchases. Due to this fields in sma_costing is showing wrong values. Can you please correct this.
  • EH

    Einnlleinhatt Ha

    Answered
    Did you enable "Over Selling" ? If yes then its because of that there is null value in purchase_id
  • MS

    Mian Saleem

    Answered
    Hello,

    Each product would have 1 record without purchase_id & transfer_id, this is used for overselling and adjustments.

    The costing issue might be different. Please let me know the steps to reproduce it.

    Thank you
  • AH

    Amila Hettiarachchi

    Answered
    I have enabled the over selling option. But how the cost of some product get - figures
  • MS

    Mian Saleem

    Answered
    Hello,

    Are you using the latest version?

    Please check the accounting method in system settings. If you need to know how they work, please refer to documentation.pdf

    Thank you
  • AH

    Amila Hettiarachchi

    Answered
    I ma working on the latest version
  • MS

    Mian Saleem

    Answered
    You can refer to your accounting method in the documentation.pdf Thank you
  • Login to Reply