FrontAccounting forum — How to add Item's Old Sales Price and New Sales Price?

Re: How to add Item's Old Sales Price and New Sales Price?

null@example.com (apmuthu) — Sat, 07 Mar 2015 12:37:46 +0000

Edit your CoA sql file in a code editor like NotePad++ and set the encoding to "Encode in UTF-8 without BOM". See attachment. Then fill in the "?" with the appropriate symbols and use them in FA.

Re: How to add Item's Old Sales Price and New Sales Price?

null@example.com (Abnahi0) — Fri, 06 Mar 2015 10:21:47 +0000

Another would be a search and replace of such known entities in the most affected fields or in the db_escape function itself. This is also the reason why the currency symbols stand as "?" in the CoA sqls.???

Join online Testking security+ certification and testking to pass exam istqb certification in first try. Our best quality and Northwestern University guide you well for real exam.

Re: How to add Item's Old Sales Price and New Sales Price?

null@example.com (apmuthu) — Sun, 22 Feb 2015 03:45:16 +0000

You can leverage the Non Field DB Data functionality for this purpose but will have to manually update the old price in the item's long_description field with something like "OldPrice#31.23" as part of it in a space separated manner.

Alternatively, you can have a new price history table and make an extension for it in FA.

Extending the core FA tables will render upgrades untenable and make it only manually upgradeable.

Re: How to add Item's Old Sales Price and New Sales Price?

null@example.com (towerfour) — Sat, 21 Feb 2015 10:14:53 +0000

Thanks for your reply.
I need to add Old price (Just show the result data from 0_price table) data into Direct invoice after "Price before Tax" column.

Please check the images
http://awesomescreenshot.com/0a64ghmla3
http://awesomescreenshot.com/0364ghmt7c

I tried sales_order_ui.inc page but no luck.

Thanks and Regards
Towerfour

Re: How to add Item's Old Sales Price and New Sales Price?

null@example.com (apmuthu) — Tue, 17 Feb 2015 13:22:45 +0000

FA does not have PriceList history but sales price history can be culled out from the invoices. You will have to manually store the old price value in the long_description field of the item in stock_master table.

How to add Item's Old Sales Price and New Sales Price?

null@example.com (towerfour) — Tue, 17 Feb 2015 10:12:00 +0000

I'm using FA. Works good. In my requirement, I need to add an item's old sales price last sales price and New sales price and it should be visible while i am adding Direct Invoice.
Is there any other simple way to do this requirement?

Thanks
Selva