- This topic has 12 replies, 2 voices, and was last updated 3 years, 5 months ago by .
Custom Purchase Order
You must be logged in to reply to this topic.
Hello, does anyone know how to customize the purchase order form, like adding the company logo for example?
Thanks! How can I make it the default report when I print a purchase order?
Please get an upgrade. You can print from the main PO listing screen.
I noticed that despite Windows Currency Settings being correct for my country, the totals for the Purchase Order are in $
You can remove the prefix.
Or use format(…,’C’) for your local currency you set up in Windows Control panel. More details here: https://database.guide/how-to-format-numbers-as-currency-in-sql-server-t-sql/
More on this, I need the EXTCOST field on this report to be after discount ie. ItemCost less the discount % * Qty
Thanks
Please use this in special field:
format((ItemCost-DiscountAmount+ExtraAmount)*QtyOrdered,’C’)
Because of this (C for currency): format(ā¦,āCā)
Use this instead (2 for 2 decimal point):
convert(numeric(11,2),(ItemCost-DiscountAmount+ExtraAmount)*QtyOrdered)
You must be logged in to reply to this topic.