|
Size: 4418
Comment:
|
Size: 5073
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 35: | Line 35: |
| We will modify the way costs are calculated on model stock items. Currently, the cost on the model stock item comes directly off the stock record. We will change this to make the cost on the model stock item to be the sum of the costs of the serial stock item that reference the model stock item. We will assume that the first serial stock items refer to the first instance of a matching model stock item. We will keep track of which model stock items have been accounted for, to avoid the problem of having the wrong costs stored on the item. | |
| Line 37: | Line 36: |
| To be continued ... | We will modify the way costs are calculated on model stock items. Currently, the cost on the model stock item comes directly off the stock record. We will change this to make the cost on the model stock item to be the sum of the costs of the serial stock item that reference the model stock item. We will assume that the first serial stock items refer to the first instance of a matching model stock item. We will keep track of which model stock items have been accounted for, to avoid the problem of having the wrong costs stored on the transaction line. We will also provide a new category option that will allow you to specify the way rebates are calculated. The default would be the current way. The new way that rebates are calculated would be as follows: If there is no rebate 1 on the transaction: . Rebate 1 = cost of the serial stock item . Rebate 2 = Transaction Rebate 2 If there is a rebate 1 on the transaction, then . Rebate 1 = Transaction Rebate 1 - cost of the serial item . Rebate 2 = Transaction Rebate 1 - Rebate 1. ||'''Task'''||'''Time (hrs)'''|| ||Programming - Rebates||2|| ||Programming - Costs||3|| ||Testing||2|| ||Quote and Documentation||1|| ||'''Total'''||'''8'''|| |
Debtor Sundry Invoices Generated by Rebates
Debtor Sundry Invoices for rebates can be generated via two methods(a few other conditions must also be met):
By [:PhonePlans:mobile phone plans]; and
- By stock items that have rebates specified on their records. (Release 9 only)
Rebates from Plans
Debtor sundry invoices are currently generated in posting by [:PhonePlans:mobile phone plans] which have rebates specified.
The rebate generating routine is started when posting detects a serial stock item (e.g an IMEI). It then proceeds to get the Model stock code that is associated with this serial item. Once it has the model stock code, it will appened the code with the plan that was chosen during the sale. This resulting code is then looked up in the stock file. For example, if a 3310 was sold on plan 7, the resulting code would be 331007 (check out the PhonePlans page for more info).
If a match is found, 3 debtor sundry invoices may be generated, depending whether or not the required rebate is present. The rebates are:
If the plan stock record has a non zero value in the rebate 1 field, a sundry invoice will be generated on the first supplier on the plan record. The sundry invoice will only be generated if the supplier code can also be found in the debtor records. The first supplier stock code on the serial stock item will also be used for the reference on the sundry invoice. It is usually the same as the serial stock code.
If the plan stock record has a non zero value in the rebate 2 field, a sundry invoice will be generated on the second supplier on the plan record. The sundry invoice will only be generated if the supplier code can also be found in the debtor records. The second supplier stock code on the serial stock item will also be used for the reference on the sundry invoice.
The third, and less common, sundry debtor invoice generated from a rebate is based on the current cost field on the serial stock item. If this field contains a non zero value, and if the second supplier on the record can be found in the debtor file, an invoice will be generated. The second supplier stock code on the serial stock item will also be used for the reference on the sundry invoice.
Currently the rebates that are generated are stored before hand during the sale. These rebates are stored on the rebate1 and rebate2 field on the transaction of the model stock item. These values are only currently used for reporting, and play no part in the generation of the sundry debtor invoices.
Rebates from regular items
Sundry Debtor Invoices will be generated for any stock item(other than model stock) which has a rebate on its transaction line. The transaction line rebate is generated normally from the rebates on the stock item. The behaviour is very similar to above.
Rebate1
- The first supplier on the stock record must exist in the debtor file for a rebate to be generated. The first supplier stock code is used as a reference.
Rebate2
- As for rebate1, but using the second supplier and supplier code on the stock record.
Requested Changes
#9991 - 14/08/06
We will modify the way costs are calculated on model stock items. Currently, the cost on the model stock item comes directly off the stock record. We will change this to make the cost on the model stock item to be the sum of the costs of the serial stock item that reference the model stock item. We will assume that the first serial stock items refer to the first instance of a matching model stock item. We will keep track of which model stock items have been accounted for, to avoid the problem of having the wrong costs stored on the transaction line.
We will also provide a new category option that will allow you to specify the way rebates are calculated. The default would be the current way. The new way that rebates are calculated would be as follows:
If there is no rebate 1 on the transaction:
- Rebate 1 = cost of the serial stock item
- Rebate 2 = Transaction Rebate 2
If there is a rebate 1 on the transaction, then
- Rebate 1 = Transaction Rebate 1 - cost of the serial item
- Rebate 2 = Transaction Rebate 1 - Rebate 1.
Task |
Time (hrs) |
Programming - Rebates |
2 |
Programming - Costs |
3 |
Testing |
2 |
Quote and Documentation |
1 |
Total |
8 |
ChangeLog
#9792 - 26/06/06
We will modify posting so that any stock item (other than model stock) with a rebate on the transaction line will generate a sundry debtor invoice. The first supplier(?) on the stock record will be used as above (i.e it must also exist in the debtor file). If a reference is needed we could again use the supplier stock code(?) on the record.
Task |
Time (hrs) |
Programming |
2 |
Testing |
2 |
Quote and Documentation |
2 |
Total |
6 |