Calanze Gowtham
New Member
Hi,
Please fine enclosed Trail file for your reference. Let me explain in brief about the file.
Whenever we raise purchase order we will enter the data in PO details sheet.
Whenever we receive Proforma invoice (advance payment) from vendor, we will enter details in Proforma sheet and Payment advice sheet to process the payment.
Whenever we receive Invoice from vendor we will enter details in Invoice sheet and Payment advice sheet to process the payment.
The colored columns in the sheet PO details, Invoice and Proforma consists formula which is already protected so that others cannot edit or delete the formula. The password is 44.
In Non colored columns, We have to enter data manually.I want this non colored columns should be locked whenever data is entered and saved.
Statement sheet is Pivot table based on the sheet payment advice.
Format sheet is fully formulated. After entering Serial number and date rest of the things will be filled automatically. We will take printout and produce to ACC dept to process the payment.
Please fine enclosed Trail file for your reference. Let me explain in brief about the file.
Whenever we raise purchase order we will enter the data in PO details sheet.
Whenever we receive Proforma invoice (advance payment) from vendor, we will enter details in Proforma sheet and Payment advice sheet to process the payment.
Whenever we receive Invoice from vendor we will enter details in Invoice sheet and Payment advice sheet to process the payment.
The colored columns in the sheet PO details, Invoice and Proforma consists formula which is already protected so that others cannot edit or delete the formula. The password is 44.
In Non colored columns, We have to enter data manually.I want this non colored columns should be locked whenever data is entered and saved.
Statement sheet is Pivot table based on the sheet payment advice.
Format sheet is fully formulated. After entering Serial number and date rest of the things will be filled automatically. We will take printout and produce to ACC dept to process the payment.