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):

1. By [:PhonePlans:mobile phone plans]; and

2. 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.

If however, the Category File Maintainence (caaad) option, Use Item Cost for Rebate 1, for the serial stock item is set to Y, the first two rebates are calculated slightly differently:

• Rebate 1 will always be the cost of the serial stock item

• Rebate 2 depends on whether or not the plan had a regular Rebate 1 specified

  • If Rebate 1 is specified, then Rebate 2 = Orignal Rebate 1 - Cost of serial stock item

  • If Rebate 1 is not specifed, then Rebate 2 remains unmodified

• 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. The cost on the model stock item is the sum of the costs of the serial stock items that reference the model stock item. We will assume that serial stock items refer to the first instance of a matching model stock item. Once again, the costs on the model stock items are used for reporting, and do not affect the calculation of the rebates.

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.

Anchor(requestedchanges)

Requested Changes

# ? - 31/08/06

Changes will be made to the way rebates are currently stored, and to the way debtor sundry invoices are generated. Model Stock items will remain the same, with all the rebates associated with their respective imeis being accumlated onto the line.

Imei's will now also have the correct rebates stored onto their transaction lines in POS. Any Kit Components that are associated with this particular Imei will be scanned for rebates. Rebate 1 will be stored on the component line, and accumlated into the header. Rebate 2 will either be accumlated onto the Imei line if the rebate 2 supplier matches, or kept on the component line seperately. The header and model stock line will be updated to reflect this.

During posting, we will use the values stored on the transaction lines, as opposed to loading it off the stock record, to generate the debtor sundry invoices.

For reporting, we will need to ensure that imei lines are treated as if there is no rebate on them.

Also, we will change rebate calculation so that rebate 2 is never lost. It will just have additional things added to it. Eg Instead of making rebate 2 = Rebate 1 - cost of serial stock, it will be rebate 2 += Rebate 1 - cost of serial stock item

Also the category option should be used off the plan

ChangeLog

#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:

• Rebate 1 = cost of the serial stock item
• Rebate 2 = Nominal Rebate 2

If there is a rebate 1, then

• Rebate 1 = cost of the serial item
• Rebate 2 = Nominal Rebate 1 - cost of the serial item.

#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.

CategoryAllphones