Calculate Due Date from G.R. Date

YouTube: How to Calculate Due Date Based on G.R. Date in Sale Bill?

How to Calculate Due Date Based on G.R. Date in Sale Bill?

In this tutorial, we’ll demonstrate how to automatically calculate the due date based on the GR (Goods Receipt) date instead of the invoice date.

---

Access Sales Voucher Configuration:

• Navigate to Sales Voucher Configuration.

• Select the relevant Billing Series.

• Locate the Feature labeled: "Calculate Due Date from GR Date".

  • Enable this option to ensure that payment terms begin from the actual GR date rather than the invoice date.

Let's proceed with this option turned on to understand its practical implications in billing.

• Unlock GR Fields:

  • Go to the Column Locks section.

  • Ensure that the following fields are unlocked:

    • GR Number

    • GR Date

As illustrated above, make sure to activate these specific columns.

• Save the configuration changes.

---

Behavior When Feature is Enabled:

• Open the Sale Bill window.

• Go to the Other Details section.

• Enter the GR details:

  • For example, if today's date is 22nd May, set the GR Date to 15th May.

As illustrated above, both the GR Number and GR Date are now defined.

• Save the sale bill.

---

Verify in Due Aging Report

• Open the Due Aging Analysis Report.

• Observe the Due Date:

  • It is now calculated based on the GR Date as per the configured settings.

As per the configuration, the due date is now derived from the GR Date.

---

Conclusion

By enabling the “Calculate Due Date from GR Date” feature, your payment due calculations become more accurate and aligned with actual goods receipt, ensuring better financial tracking and reporting.