Monday, October 29, 2018

Transactions> Sales> View Sales order> Billing tab> Schedule subtab> Number of Schedules is more what has been set up.

Problem:
Transactions> Sales> View Sales order> Billing tab> Schedule subtab> Number of Schedules is more than what has been set up.

Symptoms:
1. Billing schedule set up:
---Navigate to Lists> Accounting> Billing Schedule
Recurrence Frequency = Start of Period
In Arrears = No
Initial amount = 0
Recurrence Count = 12

2. Sales order:
Date = 8/3/2011
Start date = 9/1/2011
End date = 8/1/2012
Billing Schedule = 12 months

3. Items:
Item 1 = 500
---With billing schedule
Item 2 = 0
---Without billing schedule

Subtotal = 500
Tax = 15
Total = 51

4. No shipping method
On the sales order navigate to the Billing tab> Schedule subtab
It will show the following amounts
:

8/19/2011 = 0.00
9/1/2011 = 41.67
10/1/2011 = 41.67
11/1/2011 = 41.67
12/1/2011 = 41.67
1/1/2012 = 41.67
2/1/2012 = 41.67
3/1/2012 = 41.67
4/1/2012 = 41.67
5/1/2012 = 41.67
6/1/2012 = 41.67
7/1/2012 = 41.67
8/1/2012 = 41.63
Total = 500

Resolution:
1. The additional billing schedule dated 8/19/2011 is for the line items without billing schedule.
2. The reason why it is showing as 0 is because the amount of the item without billing schedules is 0.
3. The item with a billing schedule will follow the start date of the billing schedule but for the item without the schedule it will still use the date of the Sales order.

No comments:

Post a Comment