There are Multiple Price lists for various customers, example wholesale , wholesale max , Agent along with the normal standard selling price list -
I need for special customers to see what price they have got along side the standard rate ,
eg. for agents the selling price is lower for all items and stored in agent price list , when i print the invoice , i want it to show the actual price (standard price) and the price i am giving him .
i have created a custom print format from the builder and put price list rate along with rate -
but i want somehow for the price list rate to fetch the standard price list no matter what price list is put only in the print format .
1 . somehow create a custom field in items table as standard price , and then just add it in the print format using the print builder .
but i dont know how to fetch the standard price of that item in that field
this is the easiest solution i can come up with –
how would one achieve it , or if there is any alternate better solution to acheive it ,