Question: report daily paiements type

report daily paiements type

Hi, in my country, I need to have the paiemente type daily (report); ie: the amount of cash, cheque, credit card, ... like you have in the "close register" function; therefore I expected to

DH

Dominique HUGO

Asked
Hi,

in my country, I need to have the paiemente type daily (report); ie: the amount of cash, cheque, credit card, ... like you have in the "close register" function; therefore I expected to use the sma_payments table; unfortunatly, this table doesn't have the warehouse_id field ! how can I achieve that ?

thanks in advance,
Domi.
  • MS

    Mian Saleem

    Answered
    Hello,

    Payments are attached to sales/purchases. You will need to join the sales table to get the `warehouse_id`

    Thank you
  • DH

    Dominique HUGO

    Answered
    Ok thanks Mian.

    Domi.
  • Login to Reply