Skip to main content

 

I am trying to figure out the connections between the manual supplier invoice and the payment method but cannot figure out where/how the payment method and payment address information is saved for each supplier invoice.

 

Can anyone help?

 

thanks

Via RMB on the header of the Supplier Invoice you can enter the Supplier Invoice Installment Plan and Discounts. There you can connect a Payment Method to the Invoice:

 

 

 


Hi @smelanson ,

 

Payment method and payment address information for an invoice can be found in installment plan and discount option. You can view it by RMB on the header of the invoice and choosing that option. You can choose the payment method and address from the list in that popup.

 

However, this list will consists of the payment methods and addresses you have set under the particular supplier. You can view that in supplier>payment>payment method. I hope this information will be helpful.

 

Kind Regards,

Kalpa.


Hi @smelanson ,

@Kalpa Veranga mentioned in the above comment, you can refer below for your easy reference.

Thanks & regards,

Amalith


Hi,

 

In addition to the above info, just to keep you updated…

 

At Supplier > Payment tab level, you can use the “Use Default Payment Method for Installments” checkbox to get the default payment method added to Installments.

Further, as indicated in the other image below, the payment methods can be defined at Payment Term level as well.

 

Best regards,

Gayathrie

IFS Global Support

 


Thanks @Georgios Schmidt but I’m trying to find the table where the payment method/address information is stored on the invoice. 

Man_supp_invoice = Invoice header

Man_supp_invoice_item =  invoice detail

posting_proposal_tab = posting proposal information

 

what table can I see the payment address information for each invoice record?

 

thanks

 

 


you can select in database the payment_plan_tab:

 

select *

form Payment_Plan_Tab

where company = XXX

and identity = ' YYY'  

and INVOICE_ID = ‘ZZZ’;

 

 

To find the invoice_id you have to check first in invoice_tab for the particular invoice

 


Thanks very much @Georgios Schmidt that was exactly what I was looking for.

 

Have a great day!

Shelley