Rebates

Debtor Sundry Invoices Generated by Rebates

Debtor sundry invoices are currently generated in posting by 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.

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.

Proposed Changes

#9792

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