I want to enter the invoice date and supplier, but different suppliers have different terms.
How do I get the terms and due dates to auto generate?
I want to enter the invoice date and supplier, but different suppliers have different terms.
How do I get the terms and due dates to auto generate?
You'll need to post a sample workbook showing a mock-up of what you are after.
Screen Shot 2018-01-31 at 1.25.21 pm.png
Eg. RSEA terms are 30 days but Bunnings Trade is 30 days End of Month
I would like the due date to automatically calculate once the supplier is selected.
Thank you
You should have a table of supplier names and payment term for each, then using VLOOKUP to get payment term. Anyway, upload an example spreadsheet please.
Quang PT
Sample Invoice Table.xlsx
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks