ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Loyalty Points direct injection into database


#1

Loyalty Points in V11 are generated against invoice. This is a good control mechanism as well. There are no financial entries passed when points are generated. We are moving a client from their legacy system onto ERPNext. Client has many customers with valid loyalty points.

We cannot transfer customer loyalty points for legacy system onto ERPNext as there is no sales invoice. Generating back dated invoice is not practical.

What we thought of doing is to inject the points directly into database. This would be a quick backend solution.

Need help in understanding how this can be achieved. Anyone who has been able to inject any data might be able to guide here.

Other solution was to stop the invoice validation rule till all points are uploaded. This is actually more risky than points injection.

Any other practical Idea would be most welcome.